As of MySQL 5.7.6, the value of the
variable affects the information available from the tables
described here. For details, see the description of that
variable in Section 5.1.4, “Server System Variables”.
As of MySQL 5.7.6, information available from the tables
described here is also available from the Performance Schema.
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
INFORMATION_SCHEMA tables to the
Performance Schema tables, see
Section 21.17, “Migrating to Performance Schema System and Status Variable Tables”.
tables provide information about server status variables. Their
contents correspond to the information produced by the
VARIABLES statements (see
Section 188.8.131.52, “SHOW VARIABLES Syntax”).
VARIABLE_VALUE column for each of these
tables is defined as
variables with very long values that are not completely
SELECT as a
workaround. For example: