System Status
The SHOW STATUS, SHOW GLOBAL STATUS, and SHOW SESSION STATUS commands return the following standard 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. |
|
| 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. |
|