mySQL 错误 3167 – The ‘INFORMATION_SCHEMA.GLOBAL_STATUS’ feature is disabled; see the document

  • Post author:
  • Post category:mysql



错误如下:

[Batch Job] Batch Job 121_test_bak start

————— 2020-01-15 16:31:39 —————

[BAK] Backup schema information_schema start

[BAK] Getting tables

[BAK] Getting views

[BAK] Getting functions

[BAK] Getting events

[BAK] Getting data info

[ERR] 3167 – The ‘INFORMATION_SCHEMA.GLOBAL_STATUS’ feature is disabled; see the documentation for ‘show_compatibility_56’

[ERR] Failed on server service run begin options!

[BAK] Finished – Unsuccessfully


原因:

从mysql5.7.6开始information_schema.global_status已经开始被舍弃,为了兼容性,此时需要打开 show_compatibility_56


解决办法:

mysql>  show variables like '%show_compatibility_56%';  # 查看show_compatibility_56%的开关
+-----------------------+-------+
| Variable_name         | Value |
+-----------------------+-------+
| show_compatibility_56 | OFF   |
+-----------------------+-------+
1 row in set (0.01 sec)
mysql> set global show_compatibility_56=on;  # 打开show_compatibility_56的开关
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.01 sec)



版权声明:本文为ShiMengRan107原创文章,遵循 CC 4.0 BY-SA 版权协议,转载请附上原文出处链接和本声明。