SHOW SESSION STATUS
Show SingleStore DB server status information for a session.
Syntax
SHOW SESSION STATUS [LIKE 'pattern' | WHERE expr]
Remarks
pattern
- SQL LIKE clauseexpr
- SQL WHERE clauseThis command can be run on any SingleStore DB node (see Node Requirements for SingleStore DB Commands).
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)