SHOW SESSION STATUS
On this page
Show SingleStore server status information for a session.
Syntax
SHOW SESSION STATUS
[LIKE 'pattern' | WHERE expr]Remarks
-
pattern- SQL LIKE clause -
expr- SQL WHERE clause -
This command can be run on any SingleStore node (see Node Requirements for SingleStore Commands).
-
See the Permission Matrix for the required permission.
Output
See System Status.
Example
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)Last modified: January 11, 2023