How to solve the problem of mysql error reporting [ERROR] Native table & # 039 performance schemas error reporting 039;
This article mainly talks about "how to solve the problem of mysql error reporting [ERROR] Native table 'performance_schema'". Interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Now let the editor take you to learn "how to solve the problem of mysql's error report [ERROR] Native table 'performance_schema'"!
Error message:
2016-02-15 10:12:24 9692 [ERROR] Native table'performance_schema'.'events_stages_current'has the wrong structure
2016-02-15 10:12:24 9692 [ERROR] Native table'performance_schema'.'events_stages_history'has the wrong structure
2016-02-15 10:12:24 9692 [ERROR] Native table'performance_schema'.'events_stages_history_long'has the wrong structure
2016-02-15 10:12:24 9692 [ERROR] Native table'performance_schema'.'events_stages_summary_by_thread_by_event_name'has the wrong structure
2016-02-15 10:12:24 9692 [ERROR] Native table'performance_schema'.'events_stages_summary_by_account_by_event_name'has the wrong structure
2016-02-15 10:12:24 9692 [ERROR] Native table'performance_schema'.'events_stages_summary_by_user_by_event_name'has the wrong structure
2016-02-15 10:12:24 9692 [ERROR] Native table'performance_schema'.'events_stages_summary_by_host_by_event_name'has the wrong structure
2016-02-15 10:12:24 9692 [ERROR] Native table'performance_schema'.'events_stages_summary_global_by_event_name'has the wrong structure
2016-02-15 10:12:24 9692 [ERROR] Native table'performance_schema'.'events_statements_current'has the wrong structure
2016-02-15 10:12:24 9692 [ERROR] Native table'performance_schema'.'events_statements_history'has the wrong structure
2016-02-15 10:12:24 9692 [ERROR] Native table'performance_schema'.'events_statements_history_long'has the wrong structure
2016-02-15 10:12:24 9692 [ERROR] Native table'performance_schema'.'events_statements_summary_by_thread_by_event_name'has the wrong structure
2016-02-15 10:12:24 9692 [ERROR] Native table'performance_schema'.'events_statements_summary_by_account_by_event_name'has the wrong structure
2016-02-15 10:12:24 9692 [ERROR] Native table'performance_schema'.'events_statements_summary_by_user_by_event_name'has the wrong structure
2016-02-15 10:12:24 9692 [ERROR] Native table'performance_schema'.'events_statements_summary_by_host_by_event_name'has the wrong structure
2016-02-15 10:12:24 9692 [ERROR] Native table'performance_schema'.'events_statements_summary_global_by_event_name'has the wrong structure
2016-02-15 10:12:24 9692 [ERROR] Native table'performance_schema'.'events_statements_summary_by_digest'has the wrong structure
2016-02-15 10:12:24 9692 [ERROR] Native table'performance_schema'.'users'has the wrong structure
2016-02-15 10:12:24 9692 [ERROR] Native table'performance_schema'.'accounts'has the wrong structure
2016-02-15 10:12:24 9692 [ERROR] Native table'performance_schema'.'hosts'has the wrong structure
2016-02-15 10:12:24 9692 [ERROR] Native table'performance_schema'.'socket_instances'has the wrong structure
2016-02-15 10:12:24 9692 [ERROR] Native table'performance_schema'.'socket_summary_by_instance'has the wrong structure
2016-02-15 10:12:24 9692 [ERROR] Native table'performance_schema'.'socket_summary_by_event_name'has the wrong structure
2016-02-15 10:12:24 9692 [ERROR] Native table'performance_schema'.'session_connect_attrs'has the wrong structure
2016-02-15 10:12:24 9692 [ERROR] Native table'performance_schema'.'session_account_connect_attrs'has the wrong structure
Solution:
Mysql_upgrade-h localhost-uroot-p
It is important to note that mysql_upgrade calls the mysqlcheck method, during which the table may be locked for a long time for large tables.
At this point, I believe you have a deeper understanding of "how to solve the mysql error report [ERROR] Native table 'performance_schema' problem". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!
