MySQL [ERROR] Native table ' Performance_schema ' case

Environment Introduction:

Use Yum to install a MySQL, because the version does not meet the requirements, the use of RPM uninstall, and the use of RPM installed a version of MySQL.

Error alert:

After MySQL installation, error log errors:

[ERROR] Native table ' Performance_schema '. ' XXXXX ' hasthe wrong structure

Workaround:

At the operating system level, perform Mysql_upgrade

The reason for the error:

The current Performance_schema information is inconsistent with the actual MySQL situation.

Reference:

If You are install MySQL over a previous installation the performance Schema of that is configuredwithout older Ion of the Performanceschema that May is not have all "current tables", Runmysql_upgradeafter starting the server to Ensur E that the Performance_schema databaseexists and all current tables. Then Restart the server.

This column more highlights: http://www.bianceng.cn/database/MySQL/

If you are interested, see: http://dev.mysql.com/doc/refman/5.5/en/performance-schema-build-configuration.html