Documentation Home
MySQL 5.7 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 35.1Mb
PDF (A4) - 35.2Mb
Man Pages (TGZ) - 256.4Kb
Man Pages (Zip) - 361.2Kb
Info (Gzip) - 3.4Mb
Info (Zip) - 3.4Mb
Excerpts from this Manual

MySQL 5.7 Reference Manual  / ...  / INFORMATION_SCHEMA Tables  / INFORMATION_SCHEMA General Tables  /  The INFORMATION_SCHEMA GLOBAL_STATUS and SESSION_STATUS Tables

24.3.10 The INFORMATION_SCHEMA GLOBAL_STATUS and SESSION_STATUS 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 inSection 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”.

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

  • TheVARIABLE_VALUE column for each of these tables is defined asVARCHAR(1024).