Information Schema GLOBAL_VARIABLES and SESSION_VARIABLES Tables
You are viewing an old version of this article. View
the current version here.
The Information Schema GLOBAL_VARIABLES and SESSION_VARIABLES tables stores a record of all system variables and their global and session values respectively. This is the same information as displayed by the SHOW VARIABLES commands SHOW GLOBAL VARIABLES and SHOW SESSION VARIABLES.
It contains the following columns:
| Column | Description |
|---|---|
VARIABLE_NAME | System variable name. |
VARIABLE_VALUE | Global or session value. |
Example
SELECT * FROM information_schema.GLOBAL_VARIABLES ORDER BY VARIABLE_NAME\G *************************** 1. row ***************************** VARIABLE_NAME: ARIA_BLOCK_SIZE VARIABLE_VALUE: 8192 *************************** 2. row ***************************** VARIABLE_NAME: ARIA_CHECKPOINT_LOG_ACTIVITY VARIABLE_VALUE: 1048576 *************************** 3. row ***************************** VARIABLE_NAME: ARIA_CHECKPOINT_INTERVAL VARIABLE_VALUE: 30 ... *************************** 455. row *************************** VARIABLE_NAME: VERSION_COMPILE_MACHINE VARIABLE_VALUE: x86_64 *************************** 456. row *************************** VARIABLE_NAME: VERSION_COMPILE_OS VARIABLE_VALUE: debian-linux-gnu *************************** 457. row *************************** VARIABLE_NAME: WAIT_TIMEOUT VARIABLE_VALUE: 600
Comments
Comments loading...
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
