SHOW GLOBAL STATUS
Show global SingleStoreDB 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 SingleStoreDB node (see Node Requirements for SingleStoreDB Commands).
See the Permission Matrix for the required permission.
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)