The value of theshow_compatibility_56
system 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”.
Information available from the tables described here is also available from the Performance Schema. TheINFORMATION_SCHEMA
tables are deprecated in preference to the Performance Schema tables and are removed in MySQL 8.0. For advice on migrating away from theINFORMATION_SCHEMA
tables to the Performance Schema tables, seeSection 25.20, “Migrating to Performance Schema System and Status Variable Tables”.
TheGLOBAL_STATUS
andSESSION_STATUS
tables provide information about server status variables. Their contents correspond to the information produced by theSHOW GLOBAL STATUS
andSHOW SESSION STATUS
statements (seeSection 13.7.5.35, “SHOW STATUS Statement”).
Notes
The
VARIABLE_VALUE
column for each of these tables is defined asVARCHAR(1024)
.