-----Original Message----- From: Michael Widenius [mailto:monty@askmonty.org] Sent: Dienstag, 27. Dezember 2011 11:42 To: Vladislav Vaintroub Cc: maria-developers@lists.launchpad.net; serg@askmonty.org; Kristian Nielsen; elena@askmonty.org Subject: re: Thread pool (request for review)
H Monty,
We should probably not have this as default as the behavior if you have many long running queries with the thread pool will be much worse than with one-thread-per-connection.
We should measure it, but the implementation is such that if one has many long running queries, the performance should not be that much worse. We do start extra threads every now and then, either when queries block (threads have to wait), or if no new queries can be processed. Even if CPUs are loaded 100% with existing long queries, even then new threads will be started (just to ensure queries are processed, even if that is unlikely to improve throughput) Wlad