System Status

The SHOW STATUS, SHOW GLOBAL STATUS, and SHOW SESSION STATUS commands return the following standard settings.

Name Description Example Setting
Aborted_clients Number of aborted clients. 0
Aborted_connects Number of aborted connections. 0
Bytes_received Number of bytes received. 202
Bytes_sent Number of bytes sent. 2556
Connections Number of connections. 11
Max_used_connections Maximum used connections. 2
Queries Number of queries. 78
Questions Number of questions. 6
Threads_connected Number of threads connected. 2
Threads_created Number of threads created. 10
Threads_running Number of threads running. 1
Uptime Uptime. 11381
Seconds_until_expiration Number of seconds until expiration. 2539106
Query_compilations Number of query compilations. 0
Query_compilation_failures Number of query compilations failures. 0
GCed_versions_last_sweep GCed versions last sweep. 0
Average_garbage_collection_duration Average duration of garbage collection. 0 ms
Total_server_memory Total server memory. 81.6 MB
Alloc_variable_cached_buffers Allocated variable cached buffers. 0 MB

The SHOW STATUS EXTENDED command returns the following settings.

Name Description Example Setting
Aborted_clients Number of aborted clients. 0
Aborted_connects Number of aborted connections. 0
Bytes_received Number of bytes received. 202
Bytes_sent Number of bytes sent. 2556
Connections Number of connections. 11
Max_used_connections Maximum used connections. 2
Queries Number of queries. 78
Questions Number of questions. 6
Threads_connected Number of threads connected. 2
Threads_created Number of threads created. 10
Threads_running Number of threads running. 1
Uptime Uptime. 11381
Data_directory Data directory path. /var/lib/memsql/data
Plancache_directory Plancache directory path. /var/lib/memsql/plancache
Seconds_until_expiration Number of seconds until expiration. 2539106
Query_compilations Number of query compilations. 0
Query_compilation_failures Number of query compilations failures. 0
GCed_versions_last_sweep GCed versions last sweep. 0
Average_garbage_collection_duration Average duration of garbage collection. 0 ms
Total_server_memory Total server memory. 81.6 MB
Buffer_manager_memory Total buffer manager memory. 7.4 (+7.4) MB
Buffer_manager_cached_memory Total manager cached memory. 1 (+1.0) MB
Buffer_manager_unrecycled_memory Total buffer manager unrecycled memory. 0 MB
Alloc_malloc_arena Allocated malloc arena. 14.3 (+14.3) MB
Alloc_malloc_mmap Allocated malloc mmap. -1978.8 (-1978.8) MB
Alloc_skiplist_tower Allocated skiplist tower. 2.2 (+2.2) MB
Alloc_variable Allocated variable. 0.4 (+0.4) MB
Alloc_table_primary Allocated table primary. 1.2 (+1.2) MB
Alloc_deleted_version Allocated deleted version. 0.4 (+0.4) MB
Alloc_internal_key_node Allocated internal key node. 1.5 (+1.5) MB
Alloc_hash_buckets Allocated hash buckets 9.9 (+9.9) MB
Alloc_table_metadata_cache Allocated table metadata cache. 0.1 (+0.1) MB
Alloc_databases_list_entry Allocated databases list entry. 0.4 (+0.4) MB
Alloc_durability_large Allocated durability large. 64.4 (+64.4) MB
Alloc_security Allocated security. 0.1 (+0.1) MB
Alloc_log_replay Allocated log replay. 0 MB
Alloc_table_memory Allocated table memory. 15.6 (+15.6) MB
Alloc_variable_bucket_16 Allocated variable bucket 16. allocs:12 alloc_MB:0.0 buffer_MB:0.1
Alloc_variable_bucket_24 Allocated variable bucket 24. allocs:20 alloc_MB:0.0 buffer_MB:0.1
Alloc_variable_bucket_32 Allocated variable bucket 32. allocs:5 alloc_MB:0.0 buffer_MB:0.1
Alloc_variable_cached_buffers Allocated variable cached buffers. 0 MB
Alloc_variable_allocated Allocated variable allocated. 0 MB
Successful_read_queries Number of successful read queries. 0
Successful_write_queries Number of successful write queries. 0
Failed_read_queries Number of failed read queries. 0
Failed_write_queries Number of failed write queries. 0
Rows_returned_by_reads Number of rows affected by reads. 0
Rows_affected_by_writes Number of rows affected by writes. 0
Execution_time_of_reads Execution time of reads. 0 ms
Execution_time_of_write Execution time of write. 0 ms
Transaction_buffer_wait_time Transaction buffer wait time. 0 ms
Transaction_log_flush_wait_time Transaction log flush wait time. 0 ms
Row_lock_wait_time Row lock wait time. 0 ms

Commands for System Status

Was this article useful?