maria-discuss team mailing list archive

[Roberto Spadim <roberto@xxxxxxxxxxxxx>]

hm nice, but check my "problem"
with one thread per connection, i can think about an estimation with
max_connections
with thread pool, what i could do? use the same max_connections or use
another variable (thread size?), considering that i have a limit of threads
running (i'm thinking that this one is better, right?)

2015-11-11 0:49 GMT-02:00 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
>>
>>
>


-- 
Roberto Spadim
SPAEmpresarial - Software ERP
Eng. Automação e Controle