Important
The SingleStore 9.1 release candidate (RC) is available now. It will be promoted to general availability (GA) soon and at that time it will be renamed to SingleStore 10.
In the interim, SingleStore 9.1 RC can be used to preview, evaluate, and provide feedback on the new and upcoming features in SingleStore 10, while SingleStore 9.0 is recommended for production workloads.
SHOW GLOBAL STATUS
On this page
The SHOW GLOBAL STATUS command shows global SingleStore 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 SingleStore node (see Node Requirements for SingleStore 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: