SHOW GLOBAL STATUS

Show global SingleStore Helios server status information.

Syntax

SHOW GLOBAL STATUS
[LIKE 'pattern' | WHERE expr]

Remarks

  • pattern - SQL LIKE clause

  • expr - SQL WHERE clause

  • 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

Was this article helpful?