# PMM 1.8.1 Client Install broke MySQL Performance\_Schema Table

**URL:** <https://forums.percona.com/t/pmm-1-8-1-client-install-broke-mysql-performance-schema-table/6274>\
**Category:** PMM 1.x\
**Created:** [March 28, 2018, 9:24am UTC](https://forums.percona.com/t/pmm-1-8-1-client-install-broke-mysql-performance-schema-table/6274 "2018-03-28T09:24:51Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![ctmrocks2435](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/ctmrocks2435/32/45_2.png) [@ctmrocks2435](https://forums.percona.com/u/ctmrocks2435)\
**Post date:** [March 28, 2018, 9:24am UTC](https://forums.percona.com/t/pmm-1-8-1-client-install-broke-mysql-performance-schema-table/6274/1 "2018-03-28T09:24:51Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![Michael\_Coburn](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/michael_coburn/32/18_2.png) [@Michael\_Coburn](https://forums.percona.com/u/Michael_Coburn)\
**Post date:** [April 9, 2018, 11:21am UTC](https://forums.percona.com/t/pmm-1-8-1-client-install-broke-mysql-performance-schema-table/6274/2 "2018-04-09T11:21:26Z")

</div>

Hi [ctmrocks2435](https://percona.vanillacommunities.com/profile/x/x/41921)

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:

```auto
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)

```
