The
GLOBAL_VARIABLES
and
SESSION_VARIABLES
tables provide information about server status variables. Their
contents correspond to the information produced by the
SHOW GLOBAL
VARIABLES
and
SHOW SESSION
VARIABLES
statements (see
Section 12.4.5.41, “SHOW VARIABLES
Syntax”).
INFORMATION_SCHEMA
Name |
SHOW
Name |
Remarks |
VARIABLE_NAME | Variable_name | |
VARIABLE_VALUE | Value |
Notes:
The
GLOBAL_VARIABLES
and
SESSION_VARIABLES
tables were added in MySQL 5.1.12.
Beginning with MySQL 5.1.19, the
VARIABLE_VALUE
column for each of these
tables is defined as VARCHAR(20480)
.
Previously, this column had the data type
LONGTEXT
; this
was changed in order to make these tables consistent with the
GLOBAL_STATUS
and
SESSION_STATUS
tables, whose definitions had been changed in that version
(see Section 20.24, “The INFORMATION_SCHEMA GLOBAL_STATUS
and
SESSION_STATUS
Tables”).
User Comments
Add your own comment.