Product Solutions Support
Try MemSQL

SHOW STATUS EXTENDED

Shows MemSQL server status information with detailed MemSQL-specific memory and performance statistics.

Syntax

SHOW STATUS [EXTENDED]

Remarks

Output

Variables Returned by SHOW STATUS

Name Value Definition
Aborted_clients 0 The number of aborted connections caused by the client dying without closing the connection properly.
Aborted_connects 0 The number of failed attempts to connect to the server.
Bytes_received 202 The total number of bytes received from all clients.
Bytes_sent 2556 The number of bytes sent to clients.
Connections 11 The number of successful or non-successful connection attempts to the server.
Max_used_connections 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_cached 2 Number of kernel threads currently idle waiting for queries.
Threads_connected 2 The number of connections currently open.
Threads_created 10 The number of threads created to handle connections.
Threads_running 1 The number of threads that are currently active.
Uptime 11381 The amount of time, in seconds, that the server has been up.
aggregator_id A unique identifier for each aggregator. This is allocated by the master aggregator the first time a child aggregator connects.
Seconds_until_expiration 2539106 Seconds until expiration
license_key The license key. Not present in secure mode.
license_type Community or Enterprise depending on the license key. Not present in secure mode.
maximum_cluster_capacity 18446744073709551615 MB The allowed memory capacity in the cluster based on the license. Only on the master aggregator.
used_cluster_capacity The amount of memory capacity existent in the cluster. Only on the master aggregator.
Query_compilations 0 Number of query compilations.
Query_compilation_failures 0 Number of query compilation failures.
GCed_versions_last_sweep 0 Number of versioned nodes recliamed during the last iteration of the garbage collector.
Average_garbage_collection_duration 0 ms Average duration of garbage collection, in milliseconds.
Total_server_memory 81.6 MB Tracks the server’s overall memory use. Will not surpass the maximum_memory system variable.
alloc_thread_stacks 17.0 MB The memory allocated by threads for thread stacks on this node.
malloc_active_memory 364.1 MB The amount of memory MemSQL is using, allocated by glibc malloc.
malloc_cumulative_memory 68815.7 (+0.3) MB The total memory ever allocated by glibc malloc.
Alloc_variable_cached_buffers 0.4 MB The number of unused 128K memory buffers cached by the variable allocator.
Ssl_accept_renegotiates   0 Returns the number of start renegotiations in server mode.
Ssl_accepts     0          Returns the number of started SSL/TLS handshakes in server mode.
Ssl_callback_cache_hits   0 Returns the number of successfully retrieved sessions from the external session cache in server mode.
Ssl_client_connects   0    Returns the number of started SSL/TLS handshakes in client mode.
Ssl_connect_renegotiates  0 Returns the number of start renegotiations in client mode.
Ssl_ctx_verify_depth      18446744073709551615 Returns the verification depth limit currently set in CTX. If no limit has been set, -1 is returned and the default value is used.
Ssl_ctx_verify_mode       0 Returns the verification mode currently set in CTX.
Ssl_default_timeout       0 Returns the default timeout value assigned to SSL_SESSION objects negotiated for the protocol valid for SSL.
Ssl_finished_accepts      0 Returns the number of successfully established SSL/TLS sessions in server mode.
Ssl_finished_connects     0 Returns the number of successfully established SSL/TLS sessions in client mode.
Ssl_session_cache_hits    0 Returns the number of successfully reused sessions.
Ssl_session_cache_misses  0 Returns the number of sessions proposed by clients that were not found in the internal session cache in server mode.
Ssl_session_cache_overflows 0 Returns the number of sessions that were removed because the maximum session cache size was exceeded.
Ssl_session_cache_size    20480 Returns the currently valid session cache size.
Ssl_session_cache_timeout 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_sessions_reused       0 Returns 0 or 1 depending on whether a reused session was negotiated during the handshake.
Ssl_used_session_cache_entries 0 Returns the current number of sessions in the internal session cache.
Ssl_verify_depth          0 Returns the verification depth limit currently set in SSL for this connection. If no limit has been set, -1 is returned and the default value is used.
Ssl_verify_mode           0 Returns the verification mode currently set in SSL for this connection.
Ssl_cipher                Returns the name of the cipher being used for the current connection.
Ssl_cipher_list           Returns a pointer to the name of the SSL_CIPHER listed for SSL with priority.
Ssl_version               Returns the name of the protocol used for the connection SSL.
Ssl_session_cache_mode    SERVER Returns the cache mode currently being used.

Additional Variables Returned by SHOW STATUS EXTENDED

Name Value Definition
threads_background 5 Background threads managed by the query scheduler, i.e. replication master queries and the scheduler thread.
threads_idle 0 The number of idle connections not associated with threads.
ready_queue 0 The number of connections with pending queries not associated with threads.
idle_queue 0 The number of connections in the idle queue. This is a subset of threads_idle.
context_switches 57 The number of times any thread has switched connections because it deemed a connection idle.
context_switch_misses 0 The number of times the scheduler tried to switch connections but failed.
workload_management_queued_queries 0 The number of queries being delayed due to workload management on this aggregator.
workload_management_active_queries 0 The number of queries currently running on this aggregator.
workload_management_active_threads 0 The number of threads currently running per leaf due to queries originating from this aggregator.
workload_management_active_connections 0 The number of connections per leaf allocated to queries originating from this aggregator.
auto_attach_remaining_seconds 0 The time remaining until the automatic rebalance triggered by an auto-attach operation will occur. Only applies to aggregators.
Data_directory /var/lib/memsql/data The directory containing snapshots, transaction logs, and columnstore blob files.
Plancache_directory /var/lib/memsql/plancache Directory path for the plancache directory, which contains compiled plans used for codegen.
transaction_logs_directory var/lib/memsql/master-3306/data/logs Always the logs subfolder of datadir. This is where transaction logs are stored.
segments_directory var/lib/memsql/master-3306/data/columns Always the columns subfolder of datadir. This is where columnstore blobs are stored.
snapshots_directory var/lib/memsql/master-3306/data/snapshots Always the snapshots subfolder of datadir. This is where snapshot files live.
threads_waiting_for_disk_space 0 The number of threads currently blocked because the disk is full.
malloc_transaction_cached_memory 323.3 MB The memory allocated to caching transaction objects.
Buffer_manager_memory 7.4 (+7.4) MB Tracks memory that is allocated by the Buffer Manager for MemSQL’s built-in memory allocators.
Buffer_manager_cached_memory 1.0 (+1.0) MB Tracks memory that was allocated by the Buffer Manager but is now cached and not in use.
Buffer_manager_unrecycled_memory 0.0 MB Number of buffers ready to be recycled which have not yet been reclaimed.
Alloc_skiplist_tower 2.2 (+2.2) MB Tracks memory used by the towers for skiplist indexes.
Alloc_variable 0.4 (+0.4) MB Tracks memory allocated for variable length columns inside rowstore tables, or for other variable length memory allocations inside query execution.
Alloc_table_primary 1.2 (+1.2) MB Tracks memory used for on-row data for rowstore tables.
Alloc_deleted_version 0.4 (+0.4) MB Memory used to mark rows as deleted in rowstore tables.
Alloc_internal_key_node 1.5 (+1.5) MB Bytes used for HASH index buckets.
Alloc_hash_buckets 9.9 (+9.9) MB Memory used for HASH index buckets.
Alloc_table_metadata_cache 0.1 (+0.1) MB Bytes used for table entries used by DDL.
alloc_unit_images 2.6 MB Bytes allocated to unit images. These contain metadata and bytecode necessary to execute an individual plan.
alloc_unit_ifn_thunks 0.2 MB Bytes allocated to thunks. These are stub functions assembled by the interpreter to obey the x64 ABI.
alloc_object_code_images 1.2 MB Bytes attributed to mapping .mo files into memory.
alloc_compiled_unit_sections 0.7 MB Bytes allocated by the dynamic object loader for code and globals specific to each plan.
Alloc_databases_list_entry 0.4 (+0.4) MB Bytes used for database entries used by DDL.
alloc_plan_cache 0.1 MB Bytes allocated for plan objects within the plancache.
Alloc_durability_large 64.4 (+64.4) MB 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_client_connection 1.5 MB Bytes allocated for outgoing connections to other nodes in the cluster.
alloc_protocol_packet 1.1 MB Bytes allocated for result set protocol objects.
Alloc_table_memory 15.6 (+15.6) MB Tracks the memory stored inside all rowstore tables.
Alloc_variable_bucket_16 allocs:12 alloc_MB:0.0 buffer_MB:0.1 cached_buffer_MB:0.0
Alloc_variable_bucket_24 allocs:20 alloc_MB:0.0 buffer_MB:0.1 cached_buffer_MB:0.0
Alloc_variable_bucket_32 allocs:5 alloc_MB:0.0 buffer_MB:0.1 cached_buffer_MB:0.0
Alloc_variable_bucket_40 allocs:116 alloc_MB:0.0 buffer_MB:0.2 cached_buffer_MB:0.1
Alloc_variable_bucket_48 allocs:49 alloc_MB:0.0 buffer_MB:0.2 cached_buffer_MB:0.1
Alloc_variable_bucket_56 allocs:10 alloc_MB:0.0 buffer_MB:0.1 cached_buffer_MB:0.0
Alloc_variable_bucket_64 allocs:5 alloc_MB:0.0 buffer_MB:0.1 cached_buffer_MB:0.0
Alloc_variable_bucket_72 allocs:6 alloc_MB:0.0 buffer_MB:0.1 cached_buffer_MB:0.0
Alloc_variable_bucket_80 allocs:9 alloc_MB:0.0 buffer_MB:0.1 cached_buffer_MB:0.0
Alloc_variable_bucket_88 allocs:24 alloc_MB:0.0 buffer_MB:0.1 cached_buffer_MB:0.0
Alloc_variable_bucket_104 allocs:37 alloc_MB:0.0 buffer_MB:0.1 cached_buffer_MB:0.0
Alloc_variable_bucket_128 allocs:10 alloc_MB:0.0 buffer_MB:0.1 cached_buffer_MB:0.0
Alloc_variable_bucket_480 allocs:4 alloc_MB:0.0 buffer_MB:0.1 cached_buffer_MB:0.0
Alloc_variable_bucket_1168 allocs:1 alloc_MB:0.0 buffer_MB:0.1 cached_buffer_MB:0.0
Alloc_variable_bucket_3528 allocs:1 alloc_MB:0.0 buffer_MB:0.1 cached_buffer_MB:0.0
Alloc_variable_bucket_4504 allocs:0 alloc_MB:0.0 buffer_MB:0.1 cached_buffer_MB:0.1
Alloc_variable_bucket_5680 allocs:1 alloc_MB:0.0 buffer_MB:0.1 cached_buffer_MB:0.0
Alloc_variable_allocated 0.0 MB Memory currently active from the variable length allocator.
Successful_read_queries 0 Number of read queries which have successfully run since server startup.
Successful_write_queries 0 Number of write queries which have successfully run since server startup.
Failed_read_queries 0 Number of read queries which have failed since server startup.
Failed_write_queries 0 Number of write queries which have failed since server startup.
Rows_returned_by_reads 0 Number of rows returned by read queries since server startup.
Rows_affected_by_writes 0 Number of rows affected by write queries since server startup.
Execution_time_of_reads 0 ms Total wall-time of all read queries since server startup.
Execution_time_of_write 0 ms Total wall-time of all writer queries since server startup.
Transaction_buffer_wait_time 0 ms Provides a view into transaction buffer log performance. For more information, see the Using Durability and Recovery topic.
Transaction_log_flush_wait_time 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. For async, the value of Transaction_log_flush_wait_time should always be 0.
Row_lock_wait_time 0 ms Cumulative amount of time spent waiting on row locks by any write query.
Was this article useful?