Hacker News new | ask | show | jobs
by nrbafna 4305 days ago
Do you some figures around improvement from changing thread_handling to a pool instead of one per thread?

The queries on my db server, fit the documented use case for this feature - lots of short live queries.

1 comments

The analogy I would use for thread-pool is to insert a waiter in front of the chefs in the kitchen.

It doesn't make sense for all workloads, but I have found thread pool to be useful in cases where application servers can overload database servers (either via misconfigured connection pooling, or no pooling).

An example where it might make less sense: a dedicated worker queue running in N threads connecting to MySQL.