mysql使用mysqlbeat做监控，报错Error 3167: The 'INFORMATION_SCHEMA.GLOBAL_STATUS' feature is disabled;

Dear 丶 2021-11-17 23:44 142阅读 0赞

报错：2019-07-30T19:24:52+08:00 CRIT Running the beat returned an error: Error 3167: The 'INFORMATION\_SCHEMA.GLOBAL\_STATUS' feature is disabled; see the documentation for 'show\_compatibility\_56'  
2019-07-30T19:24:52+08:00 CRIT Start error: Error 3167: The 'INFORMATION\_SCHEMA.GLOBAL\_STATUS' feature is disabled; see the documentation for 'show\_compatibility\_56'

即：Error 3167: The 'INFORMATION\_SCHEMA.GLOBAL\_STATUS' feature is disabled; see the documentation for 'show\_compatibility\_56'

主要用到三条sql:

show variables like '%show_compatibility_56%';
    
    set global show_compatibility_56=on;
    
    select * from information_schema.global_status limit 3;

以下转自：[https://blog.csdn.net/rudygao/article/details/50403107][https_blog.csdn.net_rudygao_article_details_50403107]

### \--从mysql5.7.6开始information\_schema.global\_status已经开始被舍弃，为了兼容性，此时需要打开 show\_compatibility\_56 ###

mysql> select \* from information\_schema.global\_status limit 3;  
ERROR 3167 (HY000): The 'INFORMATION\_SCHEMA.GLOBAL\_STATUS' feature is disabled; see the documentation for 'show\_compatibility\_56'  
   
\--查看show\_compatibility\_56其值  
mysql> show variables like '%show\_compatibility\_56%';  
\+-----------------------+-------+  
| Variable\_name         | Value |  
\+-----------------------+-------+  
| show\_compatibility\_56 | OFF   |  
\+-----------------------+-------+  
1 row in set (0.01 sec)  
   
\--把show\_compatibility\_56打开  
mysql> set global show\_compatibility\_56=on;  
Query OK, 0 rows affected (0.00 sec)  
   
mysql> show variables like '%show\_compatibility\_56%';  
\+-----------------------+-------+  
| Variable\_name         | Value |  
\+-----------------------+-------+  
| show\_compatibility\_56 | ON    |  
\+-----------------------+-------+  
1 row in set (0.00 sec)  
   
mysql> select \* from information\_schema.global\_status limit 3;  
\+-----------------------+----------------+  
| VARIABLE\_NAME         | VARIABLE\_VALUE |  
\+-----------------------+----------------+  
| ABORTED\_CLIENTS       | 0              |  
| ABORTED\_CONNECTS      | 0              |  
| BINLOG\_CACHE\_DISK\_USE | 0              |  
\+-----------------------+----------------+  
3 rows in set, 1 warning (0.00 sec)

[https_blog.csdn.net_rudygao_article_details_50403107]: https://blog.csdn.net/rudygao/article/details/50403107