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%"; |
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. |
Parent topic: How to Use