Mysql Enterprise Thread Pool
Mysql enterprise edition comes with enterprise thread pool, implemented using server plugin. By default mysql handles statements using one thread per client connection, which is fine for a small number of clients but as more clients connect to server and execute statements, the performance degrades. Greater is the number of threads, greater parallelism is obtained. Sometimes greater parallelism can create bottlenecks on servers. The disadvantages of unwanted parallelism are:- Too many threads make CPU cache almost useless in highly parallel workloads. Thread pool limits the thread executing in parallel to minimize the cpu cache footprint. With too many threads executing in parallel, context switching overhead is high. This presents a challenge to the operating system scheduler. The thread pool controls the number of active threads to keep the parallelism within the MySQL server at a level that it can handle. Too many transactions executing in parallel increas...