- Documentation Library
- Table of Contents
- MySQL 6.0 Reference Manual
- MySQL 5.1 Reference Manual
- MySQL 5.0 Reference Manual
- MySQL 3.23/4.0/4.1 Manual
- Table of Contents
- 12.5.4 SHOW Syntax
- 12.5.4.1 SHOW CHARACTER SET Syntax
- 12.5.4.2 SHOW COLLATION Syntax
- 12.5.4.3 SHOW COLUMNS Syntax
- 12.5.4.4 SHOW CREATE DATABASE Syntax
- 12.5.4.5 SHOW CREATE TABLE Syntax
- 12.5.4.6 SHOW DATABASES Syntax
- 12.5.4.7 SHOW ENGINE Syntax
- 12.5.4.8 SHOW ENGINES Syntax
- 12.5.4.9 SHOW ERRORS Syntax
- 12.5.4.10 SHOW GRANTS Syntax
- 12.5.4.11 SHOW INDEX Syntax
- 12.5.4.12 SHOW INNODB STATUS Syntax
- 12.5.4.13 SHOW LOGS Syntax
- 12.5.4.14 SHOW OPEN TABLES Syntax
- 12.5.4.15 SHOW PRIVILEGES Syntax
- 12.5.4.16 SHOW PROCESSLIST Syntax
- 12.5.4.17 SHOW STATUS Syntax
- 12.5.4.18 SHOW TABLE STATUS Syntax
- 12.5.4.19 SHOW TABLES Syntax
- 12.5.4.20 SHOW VARIABLES Syntax
- 12.5.4.21 SHOW WARNINGS Syntax
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 names and values may be different for your server. The meaning of each variable is given in Section 5.1.6, “Status Variables”.
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 rows for those variables with names 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 |
+--------------------+----------+
MySQL Enterprise. Status variables provide valuable clues to the state of your servers. For expert interpretation of the information provided by status variables, subscribe to the MySQL Enterprise Monitor. For more information, see advisors.html.
User Comments
Add your own comment.