SHOW GLOBAL STATUS
Show global SingleStore DB server status information.
Syntax
SHOW GLOBAL STATUS [LIKE 'pattern' | WHERE expr]
Remarks
pattern
- SQL LIKE clauseexpr
- SQL WHERE clauseThis command can be run on any SingleStore DB node (see Node Requirements for SingleStore DB Commands).
Output
See System Status.
Example
SHOW GLOBAL STATUS; +-------------------------------------+---------+ | Variable_name | Value | +-------------------------------------+---------+ | Aborted_clients | 0 | | Aborted_connects | 0 | | Bytes_received | 2242 | | Bytes_sent | 15412 | | Connections | 11 | | Max_used_connections | 2 | | Queries | 75 | | Questions | 75 | | Threads_connected | 2 | | Threads_created | 10 | | Threads_running | 1 | | Uptime | 11143 | | Seconds_until_expiration | 2539344 | | Query_compilations | 0 | | Query_compilation_failures | 0 | | GCed_versions_last_sweep | 0 | | Average_garbage_collection_duration | 0 ms | | Total_server_memory | 81.6 MB | | Alloc_variable_cached_buffers | 0.0 MB | +-------------------------------------+---------+ 19 rows in set (0.00 sec)