MySQL 5.6 Release Notes
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 13.7.5.40, “SHOW VARIABLES Statement”).
Notes
The
VARIABLE_VALUE
column for each of these tables is defined asVARCHAR(1024)
. For variables with very long values that are not completely displayed, useSELECT
as a workaround. For example:SELECT @@GLOBAL.innodb_data_file_path;