The Information Schema GLOBAL_STATUS
and SESSION_STATUS
tables store a record of all status variables and their global and session values respectively. This is the same information as displayed by the SHOW STATUS
commands SHOW GLOBAL STATUS
and SHOW SESSION STATUS
.
They contain the following columns:
Column | Description |
---|---|
VARIABLE_NAME |
Status variable name. |
VARIABLE_VALUE |
Global or session value. |
SELECT * FROM information_schema.GLOBAL_STATUS; +-----------------------------------------------+--------------------+ | VARIABLE_NAME | VARIABLE_VALUE | +-----------------------------------------------+--------------------+ ... | BINLOG_SNAPSHOT_FILE | mariadb-bin.000208 | | BINLOG_SNAPSHOT_POSITION | 369 | ... | THREADS_CONNECTED | 1 | | THREADS_CREATED | 1 | | THREADS_RUNNING | 1 | | UPTIME | 57358 | | UPTIME_SINCE_FLUSH_STATUS | 57358 | +-----------------------------------------------+--------------------+
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/information-schema-global_status-and-session_status-tables/