System Status
On this page
The SHOW STATUS, SHOW GLOBAL STATUS, and SHOW SESSION STATUS commands return the following standard settings.
A more detailed description for some of the settings is available in SHOW STATUS EXTENDED.
|
Name |
Description |
Example Setting |
|---|---|---|
|
|
Number of aborted clients. |
|
|
|
Number of aborted connections. |
|
|
|
Number of bytes received. |
|
|
|
Number of bytes sent. |
|
|
|
Number of connections. |
|
|
|
Maximum used connections. |
|
|
|
Number of queries. |
|
|
|
Number of questions. |
|
|
|
Number of threads connected. |
|
|
|
Number of threads created. |
|
|
|
Number of threads running. |
|
|
|
Uptime in seconds. |
|
|
|
Number of seconds until expiration. |
|
|
|
Number of query compilations. |
|
|
|
Number of query compilations failures. |
|
|
|
GCed versions last sweep. |
|
|
|
Average duration of garbage collection. |
|
|
|
Total server memory. |
|
|
|
Allocated variable cached buffers. |
|
The SHOW STATUS EXTENDED command returns the following settings.
|
Name |
Description |
Example Setting |
|---|---|---|
|
|
Number of aborted clients. |
|
|
|
Number of aborted connections. |
|
|
|
Number of bytes received. |
|
|
|
Number of bytes sent. |
|
|
|
Number of connections. |
|
|
|
Maximum used connections. |
|
|
|
Number of queries. |
|
|
|
Number of questions. |
|
|
|
Number of threads connected. |
|
|
|
Number of threads created. |
|
|
|
Number of threads running. |
|
|
|
Uptime in seconds. |
|
|
|
Data directory path. |
|
|
|
Plancache directory path. |
|
|
|
Number of seconds until expiration. |
|
|
|
Number of query compilations. |
|
|
|
Number of query compilations failures. |
|
|
|
GCed versions last sweep. |
|
|
|
Average duration of garbage collection. |
|
|
|
Total server memory. |
|
|
|
Total buffer manager memory. |
|
|
|
Total manager cached memory. |
|
|
|
Total buffer manager unrecycled memory. |
|
|
|
Allocated malloc arena. |
|
|
|
Allocated malloc mmap. |
|
|
|
Allocated skiplist tower. |
|
|
|
Allocated variable. |
|
|
|
Allocated table primary. |
|
|
|
Allocated deleted version. |
|
|
|
Allocated internal key node. |
|
|
|
Allocated hash buckets |
|
|
|
Allocated table metadata cache. |
|
|
|
Allocated databases list entry. |
|
|
|
Allocated durability large. |
|
|
|
Allocated security. |
|
|
|
Allocated log replay. |
|
|
|
Allocated table memory. |
|
|
|
Allocated variable bucket 16. |
|
|
|
Allocated variable bucket 24. |
|
|
|
Allocated variable bucket 32. |
|
|
|
Allocated variable cached buffers. |
|
|
|
Allocated variable allocated. |
|
|
|
Number of successful read queries. |
|
|
|
Number of successful write queries. |
|
|
|
Number of failed read queries. |
|
|
|
Number of failed write queries. |
|
|
|
Number of rows affected by reads. |
|
|
|
Number of rows affected by writes. |
|
|
|
Execution time of reads. |
|
|
|
Execution time of write. |
|
|
|
Transaction buffer wait time. |
|
|
|
Transaction log flush wait time. |
|
|
|
Row lock wait time. |
|
Commands for System Status
Last modified: March 14, 2024