patternsqlMinor
INFORMATION_SCHEMA.GLOBAL_VARIABLES alternative in 5.7? More info about show_compatibility_56
Viewed 0 times
infoalternativeshow_compatibility_56moreinformation_schemaglobal_variablesabout
Problem
mysql> SELECT * FROM GLOBAL_VARIABLES;
ERROR 3167 (HY000): The 'INFORMATION_SCHEMA.GLOBAL_VARIABLES' feature is disabled; see the documentation for 'show_compatibility_56'
mysql> SELECT VERSION();
+-----------+
| VERSION() |
+-----------+
| 5.7.10 |
+-----------+
1 row in set (0.00 sec)
mysql> show global variables;
ERROR 1146 (42S02): Table 'performance_schema.global_variables' doesn't existI googled that and found links to tocker.ca which seems down.
$ curl http://www.tocker.ca/2015/08/18/a-followup-on-show_compatibility_56.html
404 Not Found
Not Found
The requested URL /2015/08/18/a-followup-on-show_compatibility_56.html was not found on this server.
Where do I see what settings/variables have changed from default one (in my setup)?
Any background about this change?
Solution
You need to enable the
See the documentation for details:
The Performance Schema is disabled by default. To enable it, start the
server with the performance_schema variable enabled. For example, use
these lines in your my.cnf file:
*Please check updated syntax from mysql website
Migrating to Performance Schema System and Status Variable Table has all the information you'd ever need on the matter.
PERFORMANCE_SCHEMA.See the documentation for details:
The Performance Schema is disabled by default. To enable it, start the
server with the performance_schema variable enabled. For example, use
these lines in your my.cnf file:
[mysqld]
performance_schema=ON*Please check updated syntax from mysql website
Migrating to Performance Schema System and Status Variable Table has all the information you'd ever need on the matter.
Code Snippets
[mysqld]
performance_schema=ONContext
StackExchange Database Administrators Q#125164, answer score: 3
Revisions (0)
No revisions yet.