SHOW GLOBAL STATUS
On this page
Show global SingleStoreDB server status information.
Syntax
SHOW GLOBAL STATUS[LIKE 'pattern' | WHERE expr]
Remarks
-
pattern
- SQL LIKE clause -
expr
- SQL WHERE clause -
This 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)
Last modified: January 17, 2023