tables provide information about server status variables. Their
contents correspond to the information produced by the
VARIABLES statements (see
Section 126.96.36.199, “SHOW VARIABLES Syntax”).
VARIABLE_VALUEcolumn for each of these tables is defined as
VARCHAR(1024). Previously, this column had the data type
LONGTEXT; this 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
SESSION_STATUStables, 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 displayed, use
SELECTas a workaround. For example: