PMM 1.8.1 Client Install broke MySQL Performance_Schema Table

Percona Monitoring and Management (PMM) PMM 1.x
1

After installing PMM clients on 5 servers in a cluster running Percona XtraDB MySQL Cluster (MySQL 5.7), none of the servers allow any queries against performance schema table. I get the error message “Native table ‘performance_schema’.‘global_variables’ has the wrong structure after PMM”

I have tried a process restart, and running “sudo mysql_upgrade -u root -p”.

This has broken our phpMyAdmin installs, so we can not view any variables on it, as well as made it impossible for anything to get any performance metrics from MySQL other then PMM.

Anyone have any advice? Is this an issue with PMM 1.8.1? It is very concerning if it really did adjust the database structure without informing me of a change.

2

Hi ctmrocks2435

Where did you get this error message from? PMM is designed to be read-only and shouldn’t be modifying table structure. Can you share the commands you ran to install the client?

For reference the table structure should look like this:

mysql> show create table global_variables\G
*************************** 1. row ***************************
Table: global_variables
Create Table: CREATE TABLE `global_variables` (
`VARIABLE_NAME` varchar(64) NOT NULL,
`VARIABLE_VALUE` varchar(1024) DEFAULT NULL
) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8
1 row in set (0.11 sec)