Table performance_schema has the wrong structure

For complex topics that regular users would not be interested in. For power users and database administrators.
Post Reply
User avatar
wjstarck
Posts: 935
Joined: Tue Jul 31, 2007 7:18 am
Location: Keller, TX
Contact:

Table performance_schema has the wrong structure

Post by wjstarck » Mon Dec 14, 2020 6:09 am

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?
Cheers,

Bill Starck, DDS
Big Idea Software, LLC
Developer, EASy(Electronic Anesthesia System) for Open Dental
817-807-1709
TX, USA

User avatar
wjstarck
Posts: 935
Joined: Tue Jul 31, 2007 7:18 am
Location: Keller, TX
Contact:

Re: Table performance_schema has the wrong structure

Post by wjstarck » Mon Dec 14, 2020 6:13 am

Well NVM. Running

Code: Select all

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

Bill Starck, DDS
Big Idea Software, LLC
Developer, EASy(Electronic Anesthesia System) for Open Dental
817-807-1709
TX, USA

User avatar
jordansparks
Site Admin
Posts: 5739
Joined: Sun Jun 17, 2007 3:59 pm
Location: Salem, Oregon
Contact:

Re: Table performance_schema has the wrong structure

Post by jordansparks » Mon Dec 14, 2020 7:18 am

I was going to suggest that you might install mysql 5.6. Still sounds like it might be related to that.
Jordan Sparks, DMD
http://www.opendental.com

Post Reply