Webmaster2020.com

Posted: **Mon Nov 16, 2015 7:12 pm**

I get the following error messages in my log file '/var/log/mysql/mysqld.err '

2015-11-16 20:07:12 28575 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_account_by_event_name' has the wrong structure
2015-11-16 20:07:12 28575 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_user_by_event_name' has the wrong structure
2015-11-16 20:07:12 28575 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_host_by_event_name' has the wrong structure
2015-11-16 20:07:12 28575 [ERROR] Native table 'performance_schema'.'events_stages_summary_global_by_event_name' has the wrong structure
2015-11-16 20:07:12 28575 [ERROR] Native table 'performance_schema'.'events_statements_current' has the wrong structure
2015-11-16 20:07:12 28575 [ERROR] Native table 'performance_schema'.'events_statements_history' has the wrong structure
2015-11-16 20:07:12 28575 [ERROR] Native table 'performance_schema'.'events_statements_history_long' has the wrong structure
2015-11-16 20:07:12 28575 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_thread_by_event_name' has the wrong structure
2015-11-16 20:07:12 28575 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_account_by_event_name' has the wrong structure
2015-11-16 20:07:12 28575 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_user_by_event_name' has the wrong structure
2015-11-16 20:07:12 28575 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_host_by_event_name' has the wrong structure
2015-11-16 20:07:12 28575 [ERROR] Native table 'performance_schema'.'events_statements_summary_global_by_event_name' has the wrong structure
2015-11-16 20:07:12 28575 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_digest' has the wrong structure

What i it and what can I do about it?

Posted: **Mon Nov 16, 2015 8:08 pm**

Well there is something wrong with your database.
Could be File system that is corrupted, or an upgrade of mysql that went wrong.

I suggest you first do a backup of your databases.

and you can try the following command:

Code: Select all

sudo mysql_upgrade -u root -p

If you recently upgrade your MYSQL server,
it can cause the "wrong structure error".
The command should solve it.

Webmaster2020.com

'events_stages_history' has the wrong structure

'events_stages_history' has the wrong structure

Re: 'events_stages_history' has the wrong structure