Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query optimization, and usability that you won’t want to miss.

SHOW GLOBAL STATUS

Show global SingleStore DB server status information.

Syntax

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

Remarks

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)