Oracle 5.0, Reference Manual

Page: 536 / 3232

Server Status Variables
516
Variable Name Variable Type Variable Scope
timed_mutexes
[501] boolean
GLOBAL
timestamp
[501] numeric
SESSION
tmp_table_size
[501] numeric
GLOBAL
|
SESSION
transaction_alloc_block_size
[502] numeric
GLOBAL
|
SESSION
transaction_prealloc_size
[503] numeric
GLOBAL
|
SESSION
tx_isolation
[504] enumeration
GLOBAL
|
SESSION
unique_checks
[504] boolean
SESSION
updatable_views_with_limit
[504] boolean
GLOBAL
|
SESSION
wait_timeout
[506] numeric
GLOBAL
|
SESSION
5.1.6. Server Status Variables
The server maintains many status variables that provide information about its operation. You can view
these variables and their values by using the
SHOW [GLOBAL | SESSION] STATUS
statement (see
Section 13.7.5.32, “
SHOW STATUS
Syntax” ). The optional
GLOBAL
keyword aggregates the values over
all connections, and
SESSION
shows the values for the current connection.
mysql> SHOW GLOBAL 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_files | 3 |
| Created_tmp_tables | 2 |
...
| Threads_created | 217 |
| Threads_running | 88 |
| Uptime | 1389872 |
+-----------------------------------+------------+
Note
Before MySQL 5.0.2,
SHOW STATUS
returned global status values. Because the
default as of 5.0.2 is to return session values, this is incompatible with previous
versions. To issue a
SHOW STATUS
statement that will retrieve global status
values for all versions of MySQL, write it like this:
SHOW /*!50002 GLOBAL */ STATUS;
Many status variables are reset to 0 by the
FLUSH STATUS
statement.
The following table lists all available server status variables:
Table 5.4. Status Variable Summary
Variable Name Variable Type Variable Scope
Aborted_clients
[523] numeric
GLOBAL
Aborted_connects
[523] numeric
GLOBAL
Binlog_cache_disk_use
[523] numeric
GLOBAL
Binlog_cache_use
[523] numeric
GLOBAL
Bytes_received
[523] numeric
GLOBAL
|
SESSION