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

最新推荐文章于 2025-06-29 09:00:02 发布

图灵农场

最新推荐文章于 2025-06-29 09:00:02 发布

阅读量1.4k

点赞数 3

CC 4.0 BY-SA版权

分类专栏： Mysql相关系统管控相关宇信YUSP笔记

本文链接：https://blog.youkuaiyun.com/itwxming/article/details/97897589

宇信YUSP笔记同时被 3 个专栏收录

18 篇文章

订阅专栏

Mysql相关

7 篇文章

订阅专栏

系统管控相关

1 篇文章

订阅专栏

本文详细介绍了在MySQL5.7.6及更高版本中，因兼容性原因导致INFORMATION_SCHEMA.GLOBAL_STATUS功能被禁用的错误3167。提供了具体的SQL命令，包括如何检查和开启show_compatibility_56变量，以恢复对GLOBAL_STATUS的访问。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

报错：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.youkuaiyun.com/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)