SHOW STATUS EXTENDED
On this page
Shows SingleStore server status information with detailed SingleStore-specific memory and performance statistics.
The values returned by SHOW STATUS EXTENDED
, unless otherwise stated in the table, are applicable since server startup and are reset when the server is restarted.
Syntax
SHOW STATUS [EXTENDED]
Remarks
-
Use
SHOW_
for basic SingleStore server status information.STATUS -
This command can be run on any SingleStore node (see Node Requirements for SingleStore Commands).
-
See the Permission Matrix for the required permission.
Output
Variables Returned by SHOW STATUS and Their Values
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 cluster based on the license. |
used_ |
The amount of memory capacity existent in the cluster. |
|
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’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. It also measures memory used for compiled table code modules that are in active use. |
|
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 cluster. |
|
Alloc_ |
Bytes allocated for result set protocol objects. |
|
Alloc_ |
Tracks the memory stored inside all rowstore tables. |
|
Alloc_ number = (16, 24, 32, 40, 48,. |
The variable allocator is split into buckets with different allocation sizes. |
|
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. |
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: August 22, 2024