thread_pool_connection_balance

Support CLI: Yes

Support configuration file: Yes

Support dynamic modification: Yes

Scope: global

Parameter type: bool

Default value: OFF

Possible values: OFF and ON

This variable is used to enable or disable the connection quantity balancing function. When this function is disabled, the group_id of the thread group to which the connection belongs is determined based on the polling method. When this function is enabled, the system checks the connection quantity balancing status after SQL statements are executed. If the number of connections in the thread group to which the current connection belongs exceeds the average number of connections in a thread group, the system migrates connections to a thread group whose number of connections is less than the average number. This approach will ensure that the difference between the number of connections in each thread group does not exceed 1, maximizing the overall thread group performance.