MySQL 5.7 Reference Manual Including MySQL NDB Cluster 7.5 and NDB Cluster 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”.
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 are removed in
MySQL 8.0. For advice on migrating away from the
INFORMATION_SCHEMA tables to the Performance
Schema tables, see
Section 24.20, “Migrating to Performance Schema System and Status Variable Tables”.
The GLOBAL_VARIABLES and
SESSION_VARIABLES tables provide
information about server status variables. Their contents
correspond to the information produced by the
SHOW GLOBAL
VARIABLES and
SHOW SESSION
VARIABLES statements (see
Section 13.7.5.39, “SHOW VARIABLES Statement”).
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;