Outdated Version
You are viewing an older version of this section. View current production version.
SHOW STATUS EXTENDED
Show MemSQL server status information with detailed MemSQL-specific memory and performance statistics.
SHOW STATUS EXTENDED
Notes
- Use
SHOW_STATUSinstead for basic MemSQL server status information. - This command can be run on any MemSQL node (see Node Requirements for MemSQL Commands).
Output
See System Status
Example
memsql> SHOW STATUS EXTENDED;
+-------------------------------------+--------------------------------------------------------------+
| Variable_name | Value |
+-------------------------------------+--------------------------------------------------------------+
| Aborted_clients | 0 |
| Aborted_connects | 0 |
| Bytes_received | 202 |
| Bytes_sent | 2556 |
| Connections | 11 |
| Max_used_connections | 2 |
| Queries | 78 |
| Questions | 6 |
| Threads_connected | 2 |
| Threads_created | 10 |
| Threads_running | 1 |
| Uptime | 11381 |
| Data_directory | /var/lib/memsql/data |
| Plancache_directory | /var/lib/memsql/plancache |
| Seconds_until_expiration | 2539106 |
| Query_compilations | 0 |
| Query_compilation_failures | 0 |
| GCed_versions_last_sweep | 0 |
| Average_garbage_collection_duration | 0 ms |
| Total_server_memory | 81.6 MB |
| Buffer_manager_memory | 7.4 (+7.4) MB |
| Buffer_manager_cached_memory | 1.0 (+1.0) MB |
| Buffer_manager_unrecycled_memory | 0.0 MB |
| Alloc_malloc_arena | 14.3 (+14.3) MB |
| Alloc_malloc_mmap | -1978.8 (-1978.8) MB |
| Alloc_skiplist_tower | 2.2 (+2.2) MB |
| Alloc_variable | 0.4 (+0.4) MB |
| Alloc_table_primary | 1.2 (+1.2) MB |
| Alloc_deleted_version | 0.4 (+0.4) MB |
| Alloc_internal_key_node | 1.5 (+1.5) MB |
| Alloc_hash_buckets | 9.9 (+9.9) MB |
| Alloc_table_metadata_cache | 0.1 (+0.1) MB |
| Alloc_databases_list_entry | 0.4 (+0.4) MB |
| Alloc_durability_large | 64.4 (+64.4) MB |
| Alloc_security | 0.1 (+0.1) MB |
| Alloc_log_replay | 0.0 MB |
| Alloc_table_memory | 15.6 (+15.6) MB |
| 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_cached_buffers | 0.0 MB |
| Alloc_variable_allocated | 0.0 MB |
| Successful_read_queries | 0 |
| Successful_write_queries | 0 |
| Failed_read_queries | 0 |
| Failed_write_queries | 0 |
| Rows_returned_by_reads | 0 |
| Rows_affected_by_writes | 0 |
| Execution_time_of_reads | 0 ms |
| Execution_time_of_write | 0 ms |
| Transaction_buffer_wait_time | 0 ms |
| Transaction_log_flush_wait_time | 0 ms |
| Row_lock_wait_time | 0 ms |
+-------------------------------------+--------------------------------------------------------------+
53 rows in set (0.00 sec)
