The following article explain how to solve “Native table performance_schema has wrong structure”. This is related to Core-Admin event reported
mysql_performance_schema_wrong_structure: in case core-admin agent detects this problem, this event will be reported:
Steps that describe the problem and how to resolve it:
During MySQL installation with MySQL, you might find the following error:
ERROR 1682 (HY000): Native table 'performance_schema'.'session_variables' has the wrong structure
Then try to upgrade mysql server using binaries provided by the mysql server installation:
>> /path/to/mysql/5.7/bin/mysql_upgrade --defaults-file=/root/.mysql_secret-5.7
It should complete without error. That will be indicated by the command. It might happen MySQL server is already upgraded. In such case you will get something like:
This installation of MySQL is already upgraded to 5.7.13, use --force if you still need to run mysql_upgrade
Do not force. It means it was upgraded but for some reason, it was not restarted. Try first to restart before forcing anything.
Restart MySQL server upgraded to make changes to take effect:
>> /etc/init.d/mysql-5.7 restart
After this, try again to run query that was failing with this error.