Status
Description
The SHOW STATUS command provides a name value pair of various Internal counters. There is a GLOBAL and SESSION scope however this is not always accurate. See The confusion over global and session status as an example.
Syntax
MySQL/MariaDB
mysql> SHOW GLOBAL STATUS;
$ mysqladmin extended-status
Drizzle
drizzle> SHOW GLOBAL STATUS;
Example
mysql> SHOW GLOBAL STATUS; +-----------------------------------+-------------+ | Variable_name | Value | +-----------------------------------+-------------+ | Aborted_clients | 14 | | Aborted_connects | 6643 | | Binlog_cache_disk_use | 0 | | Binlog_cache_use | 0 | | Bytes_received | 3391390273 | | Bytes_sent | 75674019234 | | Com_select | 17776121 | | Com_insert | 39198 | | Com_update | 1083418 | | Com_delete | 13064 | | Connections | 2007015 | | Created_tmp_disk_tables | 3394 | | Created_tmp_tables | 1082085 | | Handler_read_first | 44 | | Handler_read_key | 89813281 | | Handler_read_next | 7837949399 | | Innodb_buffer_pool_pages_data | 89947 | | Innodb_buffer_pool_pages_free | 0 | | Innodb_buffer_pool_read_requests | 5765943290 | | Innodb_buffer_pool_reads | 13988503 | | Innodb_rows_read | 7953909408 | | Open_tables | 128 | | Queries | 22365812 | | Questions | 22365800 | | Threads_connected | 4 | | Threads_running | 1 | | Uptime | 1495498 | +-----------------------------------+-------------+