广州葆元健康生物科技有限公司


MySQL Variables thread_pool_high_priority_connection 数据库 参数变量解释及正确配置使用

网络编程 MySQL Variables thread_pool_high_priority_connection 数据库 参数变量解释及正确配置使用 10-15

本站中文解释

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 Variablethread_pool_high_priority_connection
ScopeGlobal, Session
DynamicYes
TypeInteger
Default Value0
Minimum Value0
Maximum Value1

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”.


编辑:广州葆元健康生物科技有限公司

标签:线程,优先级,路由,速度,参数