24.10 The INFORMATION_SCHEMA GLOBAL_STATUS and SESSION_STATUS Tables
As of MySQL 5.7.6, the value of the
show_compatibility_56 system variable affects the information available from the tables described here. For details, see the description of that variable in Section 5.1.7, “Server System Variables”.
As of MySQL 5.7.6, information available from the tables described here is also available from the Performance Schema. The
INFORMATION_SCHEMA tables are deprecated in preference to the Performance Schema tables and will be removed in a future MySQL release. For advice on migrating away from the
INFORMATION_SCHEMA tables to the Performance Schema tables, see Section 25.20, “Migrating to Performance Schema System and Status Variable Tables”.
SESSION_STATUS tables provide information about server status variables. Their contents correspond to the information produced by the
SHOW GLOBAL STATUS and
SHOW SESSION STATUS statements (see Section 188.8.131.52, “SHOW STATUS Statement”).
VARIABLE_VALUEcolumn for each of these tables is defined as