HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

INFORMATION_SCHEMA.GLOBAL_VARIABLES alternative in 5.7? More info about show_compatibility_56

Submitted by: @import:stackexchange-dba··
0
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 exist


I 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 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=ON

Context

StackExchange Database Administrators Q#125164, answer score: 3

Revisions (0)

No revisions yet.