maria-discuss team mailing list archive

[Roberto Spadim <roberto@xxxxxxxxxxxxx>]

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