System Status
Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
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: November 25, 2024