(mysql.info) show-status
Info Catalog
(mysql.info) show-processlist
(mysql.info) show
(mysql.info) show-table-status
13.5.4.20 `SHOW STATUS' Syntax
..............................
SHOW [GLOBAL | SESSION] 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
server-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 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 |
+--------------------+----------+
The `GLOBAL' and `SESSION' options are new in MySQL 5.0.2. With the
`GLOBAL' modifier, `SHOW STATUS' displays the status values for all
connections to MySQL. With `SESSION', it displays the status values for
the current connection. If no modifier is present, the default is
`SESSION'. `LOCAL' is a synonym for `SESSION'.
Some status variables have only a global value. For these, you get the
same value for both `GLOBAL' and `SESSION'.
Info Catalog
(mysql.info) show-processlist
(mysql.info) show
(mysql.info) show-table-status
automatically generated byinfo2html