content_image/710420.jpg content_image/710423.jpg
examining the difference between the Connections  and Threads_created  status variables, you can see how efficient the thread cache is. For details, see Section 5.1.10, “Server Status Variables” . 

The default value is based on the following formula, capped to a limit of 100: 

8 + (max_connections / 100) 

## • thread_handling 

<img src='content_image/710420.jpg'>

The thread-handling model used by the server for connection threads. The permissible values are no- threads  (the server uses a single thread to handle one connection), one-thread-per-connection (the server uses one thread to handle each client connection), and loaded-dynamically  (set by the thread pool plugin when it initializes). no-threads  is useful for debugging under Linux; see Section 5.9, “Debugging MySQL” . 

## • thread_pool_algorithm 

<img src='content_image/710423.jpg'>

This variable controls which algorithm the thread pool plugin uses: 

•A value of 0 (the default) uses a conservative low-concurrency algorithm which is most well tested and is known to produce very good results. 

