我要评分
获取效率
正确性
完整性
易理解

New Status Variables

Status variables provide information about the MySQL server operation, which can be used for MySQL management and optimization. Two status variables are added: threadpool_idle_threads and threadpool_threads.

For details about status variables, see the official MySQL document Server Status Variables.

Table 1 describes the new status variables. Example of querying status variables:

1
show status like "%Threadpool_idle_threads%";
Table 1 New status variables

New Status Variable

Variable Type

Variable Scope

Description

threadpool_idle_threads

Numeric

Global

This variable displays the total number of idle threads in a thread pool.

threadpool_threads

Numeric

Global

This variable displays the total number of threads in a thread pool.