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

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)