Michael, Thread-pool should be used very carefully.
We tested it and InnoDB hangs in sysbench benchmarks when count of client connection > size of thread-pool. The problem is transaction state. Some connections may do internals locks and after that could not enter to pool, because all slots are busy. I expect you will have the same problem with Maria when it can fully support transactions. Michael Widenius wrote: > Hi! > > Just wanted to inform that I just pushed and extended pool-of-threads > handling to the active MariaDB tree at launchpad. > > http://askmonty.org/wiki/index.php/MariaDB_versus_MySQL#Pool_of_threads_.28limited_sets_of_threads_handling_all_queries.29 > > I plan to during the next few days also add the following patches to > MariaDB: > > http://www.percona.com/mysql/5.0.77-b13/patches/microslow_innodb.patch > http://www.percona.com/mysql/5.0.77-b13/patches/microsec_process.patch > > Regards, > Monty > > _______________________________________________ > Mailing list: https://launchpad.net/~maria-developers > Post to : maria-developers@lists.launchpad.net > Unsubscribe : https://launchpad.net/~maria-developers > More help : https://help.launchpad.net/ListHelp > -- Vadim Tkachenko, CTO Percona Inc. ICQ: 369-510-335, Skype: vadimtk153, Phone +1-888-401-3403 MySQL Performance Blog - http://www.mysqlperformanceblog.com MySQL Consulting http://www.percona.com/ Attend the 2009 Percona Performance Conference April 22-23 - http://conferences.percona.com/ _______________________________________________ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp
