You are viewing an older version of this section. View current production version.
Join the SingleStore Community Today
Get expert advice, develop skills, and connect with others.

SHOW GLOBAL STATUS

Show global MemSQL server status information.

Syntax

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

Remarks

Output

See System Status.

Example

memsql> 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)