Configuration Description
- MySQL uses one thread per connection by default. To enable the thread pool feature, set thread_handling to pool-of-threads. For details, see thread_handling.
- After a thread pool is configured, you are advised to retain the default values of the parameters (except thread_handling) 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.
- For scenarios with long query connections, read-only operations, or mixed read and write operations, you are advised to configure a small number of thread groups. For details, see Setting thread_pool_size to a Small Value.
Parent topic: How to Use