Page 1 of 1

Table performance_schema has the wrong structure

Posted: Mon Dec 14, 2020 6:09 am
by wjstarck
I get these errors in the mysql error logs:

Code: Select all

201214  8:06:14 [ERROR] Native table 'performance_schema'.'events_waits_current' has the wrong structure
201214  8:06:14 [ERROR] Native table 'performance_schema'.'events_waits_history' has the wrong structure
201214  8:06:14 [ERROR] Native table 'performance_schema'.'events_waits_history_long' has the wrong structure
201214  8:06:14 [ERROR] Native table 'performance_schema'.'setup_consumers' has the wrong structure
201214  8:06:14 [ERROR] Native table 'performance_schema'.'setup_instruments' has the wrong structure
201214  8:06:14 [ERROR] Native table 'performance_schema'.'setup_timers' has the wrong structure
201214  8:06:14 [ERROR] Native table 'performance_schema'.'performance_timers' has the wrong structure
201214  8:06:14 [ERROR] Native table 'performance_schema'.'threads' has the wrong structure
201214  8:06:14 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_thread_by_event_name' has the wrong structure
201214  8:06:14 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_instance' has the wrong structure
201214  8:06:14 [ERROR] Native table 'performance_schema'.'events_waits_summary_global_by_event_name' has the wrong structure
201214  8:06:14 [ERROR] Native table 'performance_schema'.'file_summary_by_event_name' has the wrong structure
201214  8:06:14 [ERROR] Native table 'performance_schema'.'file_summary_by_instance' has the wrong structure
201214  8:06:14 [ERROR] Native table 'performance_schema'.'mutex_instances' has the wrong structure
201214  8:06:14 [ERROR] Native table 'performance_schema'.'rwlock_instances' has the wrong structure
201214  8:06:14 [ERROR] Native table 'performance_schema'.'cond_instances' has the wrong structure
201214  8:06:14 [ERROR] Native table 'performance_schema'.'file_instances' has the wrong structure
I tried repairing the mysql tables and reinstalling mysql (5.5) but I still get the error. Should I be worried?

Re: Table performance_schema has the wrong structure

Posted: Mon Dec 14, 2020 6:13 am
by wjstarck
Well NVM. Running

Code: Select all

$ mysql_upgrade -u root -p
Has made the error go away

Re: Table performance_schema has the wrong structure

Posted: Mon Dec 14, 2020 7:18 am
by jordansparks
I was going to suggest that you might install mysql 5.6. Still sounds like it might be related to that.