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.

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.