Shulou(Shulou.com)05/31 Report--

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!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.