> -----Original Message----- > From: Michael Widenius [mailto:[email protected]] > Sent: Dienstag, 27. Dezember 2011 11:42 > To: Vladislav Vaintroub > Cc: [email protected]; [email protected]; Kristian > Nielsen; [email protected] > 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 _______________________________________________ Mailing list: https://launchpad.net/~maria-developers Post to : [email protected] Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp
