Performance Schema Does Not Initialize

[Chris Kimberley]

Hi all,

I'm having issues with the performance schema. It throws errors in the mysql error log when the server starts and ultimately does not load. When I run show engines it is included in my mysql installation. However, a show databases command does not yield the database.

I am running: Server version: 5.5.19-enterprise-commercial-advanced MySQL Enterprise Server - Advanced Edition (Commercial)


Here are the errors:

120524 15:01:02 [ERROR] Native table 'performance_schema'.'events_waits_current' has the wrong structure
120524 15:01:02 [ERROR] Native table 'performance_schema'.'events_waits_history' has the wrong structure
120524 15:01:02 [ERROR] Native table 'performance_schema'.'events_waits_history_long' has the wrong structure
120524 15:01:02 [ERROR] Native table 'performance_schema'.'setup_consumers' has the wrong structure
120524 15:01:02 [ERROR] Native table 'performance_schema'.'setup_instruments' has the wrong structure
120524 15:01:02 [ERROR] Native table 'performance_schema'.'setup_timers' has the wrong structure
120524 15:01:02 [ERROR] Native table 'performance_schema'.'performance_timers' has the wrong structure
120524 15:01:02 [ERROR] Native table 'performance_schema'.'threads' has the wrong structure
120524 15:01:02 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_thread_by_event_name' has the wrong structure
120524 15:01:02 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_instance' has the wrong structure
120524 15:01:02 [ERROR] Native table 'performance_schema'.'events_waits_summary_global_by_event_name' has the wrong structure
120524 15:01:02 [ERROR] Native table 'performance_schema'.'file_summary_by_event_name' has the wrong structure
120524 15:01:02 [ERROR] Native table 'performance_schema'.'file_summary_by_instance' has the wrong structure
120524 15:01:02 [ERROR] Native table 'performance_schema'.'mutex_instances' has the wrong structure
120524 15:01:02 [ERROR] Native table 'performance_schema'.'rwlock_instances' has the wrong structure
120524 15:01:02 [ERROR] Native table 'performance_schema'.'cond_instances' has the wrong structure
120524 15:01:02 [ERROR] Native table 'performance_schema'.'file_instances' has the wrong structure

Can anyone shed some light on this issue?

Thanks,
Chris