Rate This Document
Findability
Accuracy
Completeness
Readability

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.