MySQL Variables thread_pool_prio_kickup_timer 数据库 参数变量解释及正确配置使用
本站中文解释
MySQL参数变量 thread_pool_prio_kickup_timer 用于控制客户端优先级升级。
它是一个非负值，默认值为30，单位为秒。它指定了一个客户端线程池优先级轮换计时器，并将执行优先级下降的客户端循环转移到更低的优先级组中。
要设置该参数，可以在 MySQL 配置文件中执行以下操作：
[mysqld]
thread_pool_prio_kickup_timer=60; # This sets the kickup timer to 60 seconds.
也可以通过 SET 命令来动态设置 thread_pool_prio_kickup_timer，例如：
SET GLOBAL thread_pool_prio_kickup_timer =60; #This sets the kickup timer to 60 seconds.
官方英文解释
thread_pool_prio_kickup_timer
| Command-Line Format | --thread-pool-prio-kickup-timer=# |
|---|---|
| System Variable | thread_pool_prio_kickup_timer |
| Scope | Global |
| Dynamic | Yes |
| Type | Integer |
| Default Value | 1000 |
| Minimum Value | 0 |
| Maximum Value | 4294967294 |
| Unit | milliseconds |
This variable affects statements waiting for execution in the
low-priority queue. The value is the number of milliseconds
before a waiting statement is moved to the high-priority
queue. The default is 1000 (1 second).
This variable is available only if the thread pool plugin is
enabled. See Section 5.5.3, “MySQL Enterprise Thread Pool”.
