maria-discuss team mailing list archive

[Justin Swanhart <greenlion@xxxxxxxxx>]

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@xxxxxxxxxxxxx>
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@xxxxxxxxx>:
>
>>
>>
>> On Tue, Nov 10, 2015 at 6:47 PM, Roberto Spadim <roberto@xxxxxxxxxxxxx>
>> 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@xxxxxxxxxxxxxxxxxxx
>>> 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@xxxxxxxxxxxxx>
>> 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@xxxxxxxxxxxxxxxxxxx
>>> 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@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help   : https://help.launchpad.net/ListHelp
>
>