I’ve just upgraded a server from Percona Server 5.6.16-64.1 to 5.6.17-66.0 and got the following error in the log for every performance_schema table:
2014-06-12 08:29:14 21012 [ERROR] /usr/sbin/mysqld: Incorrect information in file: './performance_schema/accounts.frm'
2014-06-12 08:29:14 21012 [ERROR] Native table 'performance_schema'.'accounts' has the wrong structure
I ran mysql_upgrade to see if this would solve the issue, which again produced the following error for every performance_schema table:
2014-06-12 08:29:39 21012 [ERROR] /usr/sbin/mysqld: Incorrect information in file: './performance_schema/accounts.frm'
After which, whenever I try and read from a performance_schema table in MySQL I get the following error:
[localhost] (root@performance_schema) > SELECT * FROM accounts LIMIT 1;
ERROR 1682 (HY000): Native table 'performance_schema'.'accounts' has the wrong structure
There were no configuration changes during the upgrade, just a yum update on RHEL 6.5. Has this issue been reproduced at all? I’m not sure how to go about fixing this now, other than a downgrade to Percona Server.