Not the answer you need?
Register and ask your own question!

PMM 1.8.1 Client Install broke MySQL Performance_Schema Table

ctmrocks2435ctmrocks2435 ContributorCurrent User Role Supporter
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.

Comments

  • Michael CoburnMichael Coburn Principal Architect, Percona Percona Staff Role
    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)
    
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.