问题描述:
mysql>show global status; 提示以下信息:
ERROR 1146 (42S02) : Table 'performance_schema.gloabl_status' doesn't exit;
解决方案:
这是因为版本高的mysql中show_compatibility_56的默认值为OFF,不让用户访问
GLOBAL_STATUS或者GLOBAL_VARIABLES等表,官方的说法是以后的版本将要
使用Performance Schema Status Variable Tables表格将在意后的版本中逐渐替代老的
The INFORMATION_SCHEMA GLOBAL_STATUS表格
下表是show_compatibility_56在各版本中的默认值:
Introduced | 5.7.6 | ||
Deprecated | 5.7.6 | ||
Command-Line Format | --show_compatibility_56[={OFF|ON}] | ||
System Variable | Name | show_compatibility_56 | |
Variable Scope | Global | ||
Dynamic Variable | Yes | ||
Permitted Values (<= 5.7.7) | Type | boolean | |
Default | ON | ||
Permitted Values (>= 5.7.8) | Type | boolean | |
Default | OFF |
官网的解释:
http://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_show_compatibility_56