Important
The SingleStore 9.1 release candidate (RC) is available now. It will be promoted to general availability (GA) soon and at that time it will be renamed to SingleStore 10.
In the interim, SingleStore 9.1 RC can be used to preview, evaluate, and provide feedback on the new and upcoming features in SingleStore 10, while SingleStore 9.0 is recommended for production workloads.
SHOW SESSION STATUS
On this page
The SHOW SESSION STATUS command shows 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: