Rate This Document
Findability
Accuracy
Completeness
Readability

Configuration Description

MySQL uses one thread per connection by default. To enable the thread pool feature, install the thread pool plugin. The plugin takes effect by either setting the configuration file or installation through MySQL commands. For details, see Thread Pool Plugin Usage Example. After a thread pool is configured, you are advised to retain the default values of the parameters listed in Parameters in OLTP scenarios. You can adjust the value of thread_pool_size to optimize the peak performance. For details, see thread_pool_size.

MySQL parameters are also called system variables, which are used to set service functions and performance of MySQL. For details, see the official MySQL document Server System Variables.