24.3.11 The INFORMATION_SCHEMA GLOBAL_VARIABLES and SESSION_VARIABLES Tables (original) (raw)

24.3.11 The INFORMATION_SCHEMA GLOBAL_VARIABLES and SESSION_VARIABLES Tables

Note

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 in Section 5.1.7, “Server System Variables”.

Note

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”.

The GLOBAL_VARIABLES andSESSION_VARIABLES tables provide information about server status variables. Their contents correspond to the information produced by theSHOW GLOBAL VARIABLES andSHOW SESSION VARIABLES statements (seeSection 13.7.5.39, “SHOW VARIABLES Statement”).

Notes

• The VARIABLE_VALUE column for each of these tables is defined as VARCHAR(1024). For variables with very long values that are not completely displayed, use SELECT as a workaround. For example:

SELECT @@GLOBAL.innodb_data_file_path;