Hi, 

There is really no formula for predicting MySQL memory size.  There are many factors.  But if your estimate uses max_connections, then use max_connections/threads_in_pool.  That gives you the effective number of queries running at once.  There are some things, like number of temporary tables per connection, that has to use max_connections, because these persist while a connection is not executing SQL in the pool of threads.

On Tue, Nov 10, 2015 at 4:25 PM, Roberto Spadim <roberto@spadim.com.br> wrote:

nice , if i have max_connections = thread_pool_size maybe i'm doing a one thread per connection right?

other doubt.... about the memory use, i remember when mysqld crash there's a memory math formula using max_connections, when using thread pool are there the same memory limit?

2015-11-10 16:04 GMT-02:00 Vladislav Vaintroub <vvaintroub@gmail.com>:

On Tue, Nov 10, 2015 at 6:47 PM, Roberto Spadim <roberto@spadim.com.br> wrote:

i'm with a doubt

if i have a thread pool with 1000 threads and a max_connections with 100 connections

can i have more than 100 clients connected (1000 threads for example)? dos thread pool size limit the max connections, or max connections limite the thread pol size?

 

 

max_connections is the ultimate limit on number of total connections. it does not make sense to have thread pool size larger as the max. number of connections. thread pool size is something that limits number of concurrently running ( executing on CPU rather than waiting) commands. It does not make sense to have it larger than max. connections.

--

Roberto Spadim

_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to     : maria-discuss@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More help   : https://help.launchpad.net/ListHelp

On Tue, Nov 10, 2015 at 6:47 PM, Roberto Spadim <roberto@spadim.com.br> wrote:

i'm with a doubt

if i have a thread pool with 1000 threads and a max_connections with 100 connections

can i have more than 100 clients connected (1000 threads for example)? dos thread pool size limit the max connections, or max connections limite the thread pol size?

--

Roberto Spadim

_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to     : maria-discuss@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More help   : https://help.launchpad.net/ListHelp

--

Roberto Spadim
SPAEmpresarial - Software ERP

Eng. Automação e Controle

_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to     : maria-discuss@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More help   : https://help.launchpad.net/ListHelp