maria-developers team mailing list archive

["Vladislav Vaintroub" <wlad@xxxxxxxxxxxxxxxx>]

> -----Original Message-----
> From: Michael Widenius [mailto:monty@xxxxxxxxxxxx]
> Sent: Dienstag, 27. Dezember 2011 11:42
> To: Vladislav Vaintroub
> Cc: maria-developers@xxxxxxxxxxxxxxxxxxx; serg@xxxxxxxxxxxx; Kristian
> Nielsen; elena@xxxxxxxxxxxx
> 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