MogiePete/zabbix-galera-template

The 'INFORMATION_SCHEMA.GLOBAL_STATUS' feature is disabled; see the documentation for 'show_compatibility_56'

Closed this issue · 2 comments

ignaqui commented

Hi,

I have Percona 5.7 mysql. When I tried to enable the variable, here is the messages I received:

"select VARIABLE_VALUE from information_schema.GLOBAL_STATUS where VARIABLE_NAME = 'wsrep_cluster_size';" | HOME=/var/lib/zabbix mysql -N ERROR 3167 (HY000) at line 1: The 'INFORMATION_SCHEMA.GLOBAL_STATUS' feature is disabled; see the documentation for 'show_compatibility_56'

So I had to add these parameters to galera config file:
show_compatibility_56 = ON performance_schema

Is this the best approach though?

MogiePete commented

It is a requirement when using MySQL 5.7 due to the way Oracle is migrating from information_schema to performance_schema.

We utilize MariaDB 10.1 and 10.2 thus we do not encounter this issue as it a MySQL variable for indicating status of certain compatibility traits between MySQL 5.6 and MySQL 5.7.

https://mariadb.com/kb/en/library/system-variable-differences-between-mariadb-102-and-mysql-57/

anton-kyrylenko commented

I use syntax like UserParameter=galera.wsrep_repl_data_bytes[*],echo "SHOW GLOBAL STATUS LIKE 'wsrep_repl_data_bytes';" |HOME=~zabbix mysql -ss | awk '{print $$2}' instead show_compatibility_56 option

  • 👍1