Tag Archives: The ‘INFORMATION_SCHEMA.GLOBAL_STATUS’ feature is disabled; see the documentation for …

The ‘INFORMATION_SCHEMA.GLOBAL_STATUS’ feature is disabled; see the documentation for …

—information_schema.global_status has been deprecated since mysql 5.7.6, so you need to turn on show_compatibility_56 for compatibility.

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’

–check the value of show_compatibility_56

mysql> show variables like ‘%show_compatibility_56%’;

+———————–+——-+

| Variable_name | Value |

+———————–+——-+

| show_compatibility_56 | OFF |

+———————–+——-+

1 row in set (0.01 sec)

–open the 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)

In MySQL 5.6, system and status variable information is available from these SHOW statements:

SHOW VARIABLES

SHOW STATUS

And from these INFORMATION_SCHEMA tables:

INFORMATION_SCHEMA.GLOBAL_VARIABLES

INFORMATION_SCHEMA.SESSION_VARIABLES

INFORMATION_SCHEMA.GLOBAL_STATUS

INFORMATION_SCHEMA.SESSION_STATUS

MySQL 5.7

As of MySQL 5.7.6, the Performance Schema includes these tables as new sources of system and status

variable information:

performance_schema.global_variables

performance_schema.session_variables

performance_schema.variables_by_thread

performance_schema.global_status

performance_schema.session_status

performance_schema.status_by_thread

performance_schema.status_by_account

performance_schema.status_by_host

performance_schema.status_by_user