tables provide information about server status variables. Their
contents correspond to the information produced by the
VARIABLES statements (see
Section 18.104.22.168, “SHOW VARIABLES Syntax”).
VARIABLE_VALUE column for each of these
tables is defined as
Previously, this column had the data type
was changed in MySQL 5.1.19 to
VARCHAR(20480) and in 5.1.31 to
VARCHAR(1024) to make these tables
consistent with the
tables, whose definitions were changed in those versions (see
Section 20.8, “The INFORMATION_SCHEMA GLOBAL_STATUS and SESSION_STATUS Tables”).
For variables with very long values that are not completely
SELECT as a
workaround. For example: