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

SHOW SESSION STATUS

Show MemSQL server status information for a session.

Syntax

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

Remarks

Output

See System Status.

Example

memsql> SHOW SESSION STATUS;
+-------------------------------------+-----------------+
| Variable_name                       | Value           |
+-------------------------------------+-----------------+
| Aborted_clients                     | 0               |
| Aborted_connects                    | 0               |
| Bytes_received                      | 125             |
| Bytes_sent                          | 234             |
| Connections                         | 10              |
| Max_used_connections                | 2               |
| Queries                             | 71              |
| Questions                           | 2               |
| Threads_connected                   | 2               |
| Threads_created                     | 9               |
| Threads_running                     | 1               |
| Uptime                              | 10958           |
| Seconds_until_expiration            | 2539529         |
| Query_compilations                  | 0               |
| Query_compilation_failures          | 0               |
| GCed_versions_last_sweep            | 0               |
| Average_garbage_collection_duration | 0 ms            |
| Total_server_memory                 | 81.6 (+81.6) MB |
| Alloc_variable_cached_buffers       | 0.0 MB          |
+-------------------------------------+-----------------+
19 rows in set (0.00 sec)