MySQL EventID 10 Errors

[shvercer]

I keep on getting these SQL errors that are registering in the Event Logs. Is there any way to fix this issue to make them stop appearing?

Error Log Snapshot:
-----------------------
Level Date and Time Source Event ID Task Category
Error 4/17/2012 2:11:21 PM MySQL 100 None "Native table 'performance_schema'.'setup_timers' has the wrong structure

For more information, see Help and Support Center at http://www.mysql.com. "
Error 4/17/2012 2:11:21 PM MySQL 100 None "Native table 'performance_schema'.'setup_instruments' has the wrong structure

For more information, see Help and Support Center at http://www.mysql.com. "
Error 4/17/2012 2:11:21 PM MySQL 100 None "Native table 'performance_schema'.'threads' has the wrong structure

For more information, see Help and Support Center at http://www.mysql.com. "
Error 4/17/2012 2:11:21 PM MySQL 100 None "Native table 'performance_schema'.'performance_timers' has the wrong structure

For more information, see Help and Support Center at http://www.mysql.com. "
Error 4/17/2012 2:11:21 PM MySQL 100 None "Native table 'performance_schema'.'events_waits_history' has the wrong structure

For more information, see Help and Support Center at http://www.mysql.com. "
Error 4/17/2012 2:11:21 PM MySQL 100 None "Native table 'performance_schema'.'events_waits_current' has the wrong structure

For more information, see Help and Support Center at http://www.mysql.com. "
Error 4/17/2012 2:11:21 PM MySQL 100 None "Native table 'performance_schema'.'setup_consumers' has the wrong structure

For more information, see Help and Support Center at http://www.mysql.com. "
Error 4/17/2012 2:11:21 PM MySQL 100 None "Native table 'performance_schema'.'events_waits_history_long' has the wrong structure

For more information, see Help and Support Center at http://www.mysql.com. "
Error 4/17/2012 2:11:21 PM MySQL 100 None "Native table 'performance_schema'.'events_waits_summary_by_thread_by_event_name' has the wrong structure

For more information, see Help and Support Center at http://www.mysql.com. "
Error 4/17/2012 2:11:21 PM MySQL 100 None "Native table 'performance_schema'.'rwlock_instances' has the wrong structure

For more information, see Help and Support Center at http://www.mysql.com. "
Error 4/17/2012 2:11:21 PM MySQL 100 None "Native table 'performance_schema'.'mutex_instances' has the wrong structure

For more information, see Help and Support Center at http://www.mysql.com. "
Error 4/17/2012 2:11:21 PM MySQL 100 None "Native table 'performance_schema'.'file_instances' has the wrong structure

For more information, see Help and Support Center at http://www.mysql.com. "
Error 4/17/2012 2:11:21 PM MySQL 100 None "Native table 'performance_schema'.'cond_instances' has the wrong structure

For more information, see Help and Support Center at http://www.mysql.com. "
Error 4/17/2012 2:11:21 PM MySQL 100 None "Native table 'performance_schema'.'events_waits_summary_global_by_event_name' has the wrong structure

For more information, see Help and Support Center at http://www.mysql.com. "
Error 4/17/2012 2:11:21 PM MySQL 100 None "Native table 'performance_schema'.'events_waits_summary_by_instance' has the wrong structure

For more information, see Help and Support Center at http://www.mysql.com. "
Error 4/17/2012 2:11:21 PM MySQL 100 None "Native table 'performance_schema'.'file_summary_by_instance' has the wrong structure

For more information, see Help and Support Center at http://www.mysql.com. "
Error 4/17/2012 2:11:21 PM MySQL 100 None "Native table 'performance_schema'.'file_summary_by_event_name' has the wrong structure

For more information, see Help and Support Center at http://www.mysql.com. "
---------------------------------------------------------------------------------------------------

Regards

[jordansparks]

Yes. First, verify that you are using MySQL 5.5, not 5.0. If you are not using 5.5, do not continue with the instructions below.

Download our installer.
http://www.opendental.com/trial.html
Right click, run as Admin. Ensure that all the paths are correct in that window. Take your time to do this right, especially if you are not familiar with our installer.
Uncheck all boxes along the left except MySQL 5.5 grant tables. Click Install.

[shvercer]

I've started over with a fresh installation on Windows Server 2008 R2 and left all the settings on default and I'm still getting the same error. I assume that the MySQL that came as part of the Trial Version is the correct one. The errors still appear like before.

[jsalmon]

This is a known bug to MySQL, they suggest running mysql_upgrade (which is located in the bin folder of the installation path of MySQL). Just run that exe in cmd and the errors should stop occurring.

[jordansparks]

It looks like there's a possibility that it's due to the grant tables that we distribute as part of our installer. We will be researching this immediately.

[jordansparks]

Ok, we got it figured out. Performance schema is something that we just don't use. The error messages are just on startup of MySQL. They are harmless can can be ignored. If they really bother you, you can run mysql_upgrade. We will be posting instructions in our manual within about a week.

[joshuab]

Noticed the same errors while troubleshooting some performance issues (OD 12.1.16.0). They do appear to only be during mysql start. Glad to know they're harmless - will ignore (and not run the upgrade).

[Justin Shafer]

Sony Markose is still crashing..I am going to completely reinstall OD and MySQL... Then restore the DB..

Good to delete c:\programdata\mysql after the uninstall, but before the new install of mysql...

That is where all those tables are stored.

Updating to 5.5.26.. So far so good...

The errors are gone when you restart the service... Time to cross fingers.

[Justin Shafer]

Aww his server was just crashing... Optiplex 980 with a Kernel Power event.. I thought it was just OD crashing when entering notes from a Workstation....

Did a bios upgrade... Everything else is updated...

Cross fingers...

[Justin Shafer]

So far so good.. I guess the bios upgrade helped.. Good.