Show Status in MySQL

Posted by admin

May 6, 2008

SHOW STATUS [LIKE ‘pattern’]

SHOW STATUS provides server status information. This information also can be obtained using
the mysqladmin extended-status command.

Partial output is shown here. The list of variables and their values may be different for your
server. The meaning of each variable is given in the MySQL Administrator’s Guide.

mysql> SHOW STATUS;
+————————–+————+
| Variable_name | Value |
+————————–+————+
| Aborted_clients | 0 |
| Aborted_connects | 0 |
| Bytes_received | 155372598 |
| Bytes_sent | 1176560426 |
| Connections | 30023 |
| Created_tmp_disk_tables | 0 |
| Created_tmp_tables | 8340 |
| Created_tmp_files | 60 |
…
| Open_tables | 1 |
| Open_files | 2 |
| Open_streams | 0 |
| Opened_tables | 44600 |
| Questions | 2026873 |
…
| Table_locks_immediate | 1920382 |
| Table_locks_waited | 0 |
| Threads_cached | 0 |
| Threads_created | 30022 |
| Threads_connected | 1 |
| Threads_running | 1 |
| Uptime | 80380 |
+————————–+————+

With a LIKE clause, the statement displays only those variables that match the pattern:

mysql> SHOW STATUS LIKE ‘Key%’;
+——————–+———-+
| Variable_name | Value |
+——————–+———-+
| Key_blocks_used | 14955 |
| Key_read_requests | 96854827 |
| Key_reads | 162040 |
| Key_write_requests | 7589728 |
| Key_writes | 3813196 |
+——————–+———-+

Share and Enjoy: These icons link to social bookmarking sites where readers can share and discover new web pages.