SHOW STATUS EXTENDED
On this page
Shows SingleStore Helios server status information with detailed SingleStore Helios-specific memory and performance statistics.
Syntax
SHOW STATUS [EXTENDED]
Remarks
-
Use
SHOW_
for basic SingleStore Helios server status information.STATUS -
See the Permission Matrix for the required permission.
Output
Variables Returned by SHOW STATUS
Name |
Value |
Definition |
---|---|---|
Aborted_ |
0 |
The number of aborted connections caused by the client dying without closing the connection properly. |
Aborted_ |
0 |
The number of failed attempts to connect to the server. |
Alloc_ |
Tracks memory allocated for variable length columns inside rowstore tables, or for other variable length memory allocations inside query execution larger than 128KB. |
|
Bytes_ |
202 |
The total number of bytes received from all clients. |
Bytes_ |
2556 |
The number of bytes sent to clients. |
Connections |
11 |
The number of successful or non-successful connection attempts to the server. |
Max_ |
2 |
The maximum number of simultaneous connections the server has seen since it started. |
Queries |
78 |
The number of statements the server has executed, including statements from clients and statements within stored programs. |
Questions |
6 |
The number of statements the server has executed, excluding statements within stored programs. |
Threads_ |
2 |
Number of kernel threads currently idle waiting for queries. |
Threads_ |
2 |
The number of connections currently open. |
Threads_ |
10 |
The number of threads created to handle connections. |
Threads_ |
1 |
The number of threads that are currently active. |
Uptime |
11381 |
The amount of time, in seconds, that the server has been up. |
aggregator_ |
A unique identifier for each aggregator. |
|
Seconds_ |
2539106 |
Seconds until expiration |
License_ |
The license key. |
|
License_ |
|
|
Maximum_ |
18446744073709551615 MB |
The allowed memory capacity in the workspace based on the license. |
used_ |
The amount of memory capacity existent in the workspace. |
|
Query_ |
0 |
Number of query compilations. |
Query_ |
0 |
Number of query compilation failures. |
GCed_ |
0 |
Number of versioned nodes reclaimed during the last iteration of the garbage collector. |
Average_ |
0 ms |
Average duration of garbage collection, in milliseconds. |
Total_ |
81. |
Tracks the node’s overall memory use. |
Alloc_ |
17. |
The memory allocated by threads for thread stacks on this node. |
Malloc_ |
364. |
Tracks memory that is allocated directly from the Linux operating system and managed by the C runtime allocators. |
malloc_ |
68815. |
The total memory ever allocated by glibc malloc. |
Alloc_ |
0. |
The number of unused 128K memory buffers cached by the variable allocator. |
Ssl_ |
0 |
Returns the number of start renegotiations in server mode. |
Ssl_ |
0 |
Returns the number of started SSL/TLS handshakes in server mode. |
Ssl_ |
0 |
Returns the number of successfully retrieved sessions from the external session cache in server mode. |
Ssl_ |
0 |
Returns the number of started SSL/TLS handshakes in client mode. |
Ssl_ |
0 |
Returns the number of start renegotiations in client mode. |
Ssl_ |
18446744073709551615 |
Returns the verification depth limit currently set in CTX. |
Ssl_ |
0 |
Returns the verification mode currently set in CTX. |
Ssl_ |
0 |
Returns the default timeout value assigned to SSL_ |
Ssl_ |
0 |
Returns the number of successfully established SSL/TLS sessions in server mode. |
Ssl_ |
0 |
Returns the number of successfully established SSL/TLS sessions in client mode. |
Ssl_ |
0 |
Returns the number of successfully reused sessions. |
Ssl_ |
0 |
Returns the number of sessions proposed by clients that were not found in the internal session cache in server mode. |
Ssl_ |
0 |
Returns the number of sessions that were removed because the maximum session cache size was exceeded. |
Ssl_ |
20480 |
Returns the currently valid session cache size. |
Ssl_ |
0 |
Returns the number of sessions proposed by clients and either found in the internal or external session cache in server mode, but that were invalid due to timeout. |
Ssl_ |
0 |
Returns |
Ssl_ |
0 |
Returns the current number of sessions in the internal session cache. |
Ssl_ |
0 |
Returns the verification depth limit currently set in SSL for this connection. |
Ssl_ |
0 |
Returns the verification mode currently set in SSL for this connection. |
Ssl_ |
Returns the name of the cipher being used for the current connection. |
|
Ssl_ |
Returns a pointer to the name of the SSL_ |
|
Ssl_ |
Returns the name of the protocol used for the connection SSL. |
|
Ssl_ |
SERVER |
Returns the cache mode currently being used. |
Additional Variables Returned by SHOW STATUS EXTENDED
Name |
Value |
Definition |
---|---|---|
Threads_ |
5 |
Background threads managed by the query scheduler, i. |
Threads_ |
0 |
The number of idle connections not associated with threads. |
Ready_ |
0 |
The number of connections with pending queries not associated with threads. |
Idle_ |
0 |
The number of connections in the idle queue. |
Context_ |
57 |
The number of times any thread has switched connections because it deemed a connection idle. |
Context_ |
0 |
The number of times the scheduler tried to switch connections but failed. |
Workload_ |
0 |
The number of queries being delayed due to workload management on this aggregator. |
Workload_ |
0 |
The number of queries currently running on this aggregator. |
Workload_ |
0 |
The number of threads currently running per leaf due to queries originating from this aggregator. |
Workload_ |
0 |
The number of connections per leaf allocated to queries originating from this aggregator. |
Columnstore_ |
0 |
The number of queued concurrent columnstore writes. |
Columnstore_ |
0 |
The number of running columnstore writes inserting into the in-memory segment. |
Columnstore_ |
0 |
The maximum number of queries that can run concurrently. |
Columnstore_ |
0 |
The number of segments estimated to be created based on the amount of data in the in-memory segment. |
Columnstore_ |
0. |
The estimated amount of memory used by the in-memory segments. |
Auto_ |
0 |
The time remaining until the automatic rebalance triggered by an auto-attach operation will occur. |
Data_ |
/var/lib/memsql/data |
The directory containing snapshots, transaction logs, and columnstore blob files. |
Plancache_ |
/var/lib/memsql/plancache |
Directory path for the plancache directory, which contains compiled plans used for codegen. |
Transaction_ |
var/lib/memsql/master-3306/data/logs |
Always the logs subfolder of |
Segments_ |
var/lib/memsql/master-3306/data/columns |
Always the columns subfolder of |
Snapshots_ |
var/lib/memsql/master-3306/data/snapshots |
Always the snapshots subfolder of |
threads_ |
0 |
The number of threads currently blocked because the disk is full. |
Malloc_ |
323. |
The memory allocated to caching transaction objects. |
Buffer_ |
7. |
Tracks memory that is allocated by the Buffer Manager for SingleStore Helios’s built-in memory allocators. |
Buffer_ |
1. |
Tracks memory that was allocated by the Buffer Manager but is now cached and not in use. |
Buffer_ |
0. |
Number of buffers ready to be recycled which have not yet been reclaimed. |
Alloc_ |
Tracks the memory used by the towers for skiplist indexes. |
|
Alloc_ |
Tracks the memory allocated for variable-length columns inside rowstore tables, or for other variable-length memory allocations inside query execution. |
|
Alloc_ |
|
Memory usage for autostats on columnstore tables. |
Alloc_ |
Tracks the memory used for on-row data for rowstore tables and also the in-memory segment of columnstore tables. |
|
Alloc_ |
Memory used to mark rows as deleted in rowstore tables. |
|
Alloc_ |
Bytes used for |
|
Alloc_ |
Memory used for |
|
Alloc_ |
Bytes used for table entries used by DDL. |
|
Alloc_ |
This variable measures the bytes allocated to unit images, which contain metadata and bytecode necessary to execute an individual plan. |
|
Alloc_ |
Bytes allocated to thunks. |
|
Alloc_ |
Bytes attributed to mapping . |
|
Alloc_ |
This variable is used to track the memory allocated by the dynamic object loader for code, table code objects and globals specific to each compiled unit or plan. |
|
Alloc_ |
Bytes used for database entries used by DDL. |
|
Alloc_ |
Bytes allocated for plan objects within the plancache. |
|
Alloc_ |
Memory used for running queries on the node. |
|
Alloc_ |
Tracks memory used to allocate transaction buffers to group commit rows to disk, as well as temporary buffers to write backups or take snapshots. |
|
alloc_ |
Bytes allocated for outgoing connections to other nodes in the workspace. |
|
Alloc_ |
Bytes allocated for result set protocol objects. |
|
Alloc_ |
Tracks the memory stored inside all rowstore tables. |
|
Alloc_ |
||
Alloc_ |
||
Alloc_ |
||
Alloc_ |
||
Alloc_ |
||
Alloc_ |
||
Alloc_ |
||
Alloc_ |
||
Alloc_ |
||
Alloc_ |
||
Alloc_ |
||
Alloc_ |
||
Alloc_ |
||
Alloc_ |
||
Alloc_ |
||
Alloc_ |
||
Alloc_ |
||
Alloc_ |
Memory currently active from the variable length allocator. |
|
Successful_ |
0 |
Number of read queries which have successfully run since server startup. |
Successful_ |
0 |
Number of write queries which have successfully run since server startup. |
Failed_ |
0 |
Number of read queries which have failed since server startup. |
Failed_ |
0 |
Number of write queries which have failed since server startup. |
Rows_ |
0 |
Number of rows returned by read queries since server startup. |
Rows_ |
0 |
Number of rows affected by write queries since server startup. |
Execution_ |
0 ms |
Total wall-time of all read queries since server startup. |
Execution_ |
0 ms |
Total wall-time of all writer queries since server startup. |
Transaction_ |
0 ms |
Provides a view into transaction buffer log performance. |
Transaction_ |
0 ms |
Cumulative amount of time commits have been waiting to flush to disk or across the network, if the database is running with sync durability or sync replication. |
Row_ |
0 ms |
Cumulative amount of time spent waiting on row locks by any write query. |
Free_ |
Max 16 MB |
Size of cached free buffers, which tracks how much memory in the IO pool is currently not in use. |
Total_ |
Max 16 MB |
Total size of all buffers allocated by the IO pool for that partition, including buffers currently in use and free buffers in |
Gv_ |
Represents the current timestamp of the server's logical clock. |
|
Effective_ |
Memory allocated (in MBs) used to cache query object code images, as derived from |
Subset Allocators
Some allocators are aggregates of several other allocators.
Allocator |
Subset Allocators |
---|---|
Alloc_ |
Alloc_ |
Alloc_ |
|
Alloc_ |
|
Alloc_ |
|
Alloc_ |
|
Alloc_ |
|
Alloc_ |
|
Alloc_ |
|
Total_ |
Alloc_ |
Malloc_ |
|
Buffer_ |
|
Total_ |
|
Alloc_ |
|
Alloc_ |
|
Alloc_ |
|
Alloc_ |
|
Alloc_ |
|
Alloc_ |
Last modified: May 16, 2024