MySQL 5.7 Release Notes
Note
The value of theshow_compatibility_56system variable affects the information available from the tables described here. For details, see the description of that variable inSection 5.1.7, “Server System Variables”.
Note
Information available from the tables described here is also available from the Performance Schema. TheINFORMATION_SCHEMAtables are deprecated in preference to the Performance Schema tables and are removed in MySQL 8.0. For advice on migrating away from theINFORMATION_SCHEMAtables to the Performance Schema tables, seeSection 25.20, “Migrating to Performance Schema System and Status Variable Tables”.
TheGLOBAL_STATUSandSESSION_STATUStables provide information about server status variables. Their contents correspond to the information produced by theSHOW GLOBAL STATUSandSHOW SESSION STATUSstatements (seeSection 13.7.5.35, “SHOW STATUS Statement”).
Notes
The
VARIABLE_VALUEcolumn for each of these tables is defined asVARCHAR(1024).