Show global MemSQL 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 MemSQL node (see Node Requirements for MemSQL Commands).

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)

Was this Article Helpful?

Thanks For Your Feedback!