[ERROR] Native table 'performance_schema'.'table name' has the wrong structure

报错信息：

1. 2016-02-15 10:12:24 9692[ERROR]Native table'performance_schema'.'events_stages_current'has the wrong structure
   
2. 2016-02-15 10:12:24 9692[ERROR]Native table'performance_schema'.'events_stages_history'has the wrong structure
   
3. 2016-02-15 10:12:24 9692[ERROR]Native table'performance_schema'.'events_stages_history_long'has the wrong structure
   
4. 2016-02-15 10:12:24 9692[ERROR]Native table'performance_schema'.'events_stages_summary_by_thread_by_event_name'has the wrong structure
   
5. 2016-02-15 10:12:24 9692[ERROR]Native table'performance_schema'.'events_stages_summary_by_account_by_event_name'has the wrong structure
   
6. 2016-02-15 10:12:24 9692[ERROR]Native table'performance_schema'.'events_stages_summary_by_user_by_event_name'has the wrong structure
   
7. 2016-02-15 10:12:24 9692[ERROR]Native table'performance_schema'.'events_stages_summary_by_host_by_event_name'has the wrong structure
   
8. 2016-02-15 10:12:24 9692[ERROR]Native table'performance_schema'.'events_stages_summary_global_by_event_name'has the wrong structure
   
9. 2016-02-15 10:12:24 9692[ERROR]Native table'performance_schema'.'events_statements_current'has the wrong structure
   
10. 2016-02-15 10:12:24 9692[ERROR]Native table'performance_schema'.'events_statements_history'has the wrong structure
    
11. 2016-02-15 10:12:24 9692[ERROR]Native table'performance_schema'.'events_statements_history_long'has the wrong structure
    
12. 2016-02-15 10:12:24 9692[ERROR]Native table'performance_schema'.'events_statements_summary_by_thread_by_event_name'has the wrong structure
    
13. 2016-02-15 10:12:24 9692[ERROR]Native table'performance_schema'.'events_statements_summary_by_account_by_event_name'has the wrong structure
    
14. 2016-02-15 10:12:24 9692[ERROR]Native table'performance_schema'.'events_statements_summary_by_user_by_event_name'has the wrong structure
    
15. 2016-02-15 10:12:24 9692[ERROR]Native table'performance_schema'.'events_statements_summary_by_host_by_event_name'has the wrong structure
    
16. 2016-02-15 10:12:24 9692[ERROR]Native table'performance_schema'.'events_statements_summary_global_by_event_name'has the wrong structure
    
17. 2016-02-15 10:12:24 9692[ERROR]Native table'performance_schema'.'events_statements_summary_by_digest'has the wrong structure
    
18. 2016-02-15 10:12:24 9692[ERROR]Native table'performance_schema'.'users'has the wrong structure
    
19. 2016-02-15 10:12:24 9692[ERROR]Native table'performance_schema'.'accounts'has the wrong structure
    
20. 2016-02-15 10:12:24 9692[ERROR]Native table'performance_schema'.'hosts'has the wrong structure
    
21. 2016-02-15 10:12:24 9692[ERROR]Native table'performance_schema'.'socket_instances'has the wrong structure
    
22. 2016-02-15 10:12:24 9692[ERROR]Native table'performance_schema'.'socket_summary_by_instance'has the wrong structure
    
23. 2016-02-15 10:12:24 9692[ERROR]Native table'performance_schema'.'socket_summary_by_event_name'has the wrong structure
    
24. 2016-02-15 10:12:24 9692[ERROR]Native table'performance_schema'.'session_connect_attrs'has the wrong structure
    
25. 2016-02-15 10:12:24 9692[ERROR]Native table'performance_schema'.'session_account_connect_attrs'has the wrong structure

解决办法：
mysql_upgrade -h localhost -uroot -p
需要注意的是 mysql_upgrade 会调用  mysqlcheck 方法，期间会锁表对于大表可能执行的时间会很长。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/21210507/viewspace-1989009/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/21210507/viewspace-1989009/