MySQL Variables thread_pool_high_priority_connection 数据库 参数变量解释及正确配置使用
本站中文解释
thread_pool_high_priority_connection是MySQL的线程池参数，用于设置是否将高优先级连接路由到线程池以改善系统响应速度。如果将其设置为ON，则MySQL将把紧急优先级的连接路由到线程池而不是作为普通连接处理，从而提高系统响应速度。要设置该参数，请使用以下命令：
SET GLOBAL thread_pool_high_priority_connection = ON;
官方英文解释
thread_pool_high_priority_connection
| Command-Line Format | --thread-pool-high-priority-connection=# |
|---|---|
| System Variable | thread_pool_high_priority_connection |
| Scope | Global, Session |
| Dynamic | Yes |
| Type | Integer |
| Default Value | 0 |
| Minimum Value | 0 |
| Maximum Value | 1 |
This variable affects queuing of new statements prior to
execution. If the value is 0 (false, the default), statement
queuing uses both the low-priority and high-priority queues.
If the value is 1 (true), queued statements always go to the
high-priority queue.
This variable is available only if the thread pool plugin is
enabled. See Section 5.5.3, “MySQL Enterprise Thread Pool”.
