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 <greenl...@gmail.com>: > 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 <robe...@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 <vvaintr...@gmail.com>: >> >>> >>> >>> On Tue, Nov 10, 2015 at 6:47 PM, Roberto Spadim <robe...@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 <robe...@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 >> >> > -- 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
