SHOW [GLOBAL | SESSION] STATUS [LIKE 'pattern
' | WHEREexpr
]
SHOW STATUS
provides server
status information. This information also can be obtained using
the mysqladmin extended-status command. The
LIKE
clause, if present, indicates
which variable names to match. The WHERE
clause can be given to select rows using more general
conditions, as discussed in Section 19.30, “Extensions to SHOW
Statements”.
This statement does not require any privilege. It requires only
the ability to connect to the server.
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.7, “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 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 |
+--------------------+----------+
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
. The scope for each status variable
is listed at Section 5.1.7, “Server Status Variables”.
Each invocation of the SHOW
STATUS
statement uses an internal temporary table and
increments the global
Created_tmp_tables
value.
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 http://www.mysql.com/products/enterprise/advisors.html.
User Comments
Add your own comment.