MySQL Forums
Forum List  »  MyISAM

Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes)
Posted by: Scott Nemes
Date: January 24, 2013 10:59AM

Did you dump and reload all of your data for the upgrade, or did you just replace the binaries?

Have you tried re-adding the indexes to see if you get the same result after it recreates the indexes? If not, I would try that first.

If you have already done that, then I would try running a REPAIR TABLE on it (make sure you have a functional backup first in case it goes sideways).

Also are you using the same options files (my.cnf)? If not, please provide a diff for reference if the issue persists (make sure to mask any hosts / usernames / passwords).

--
Scott Nemes
MySQL DBA

http://www.linkedin.com/in/scottnemes
http://www.twitter.com/ScottNemes



Edited 1 time(s). Last edit at 01/24/2013 11:00AM by Scott Nemes.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes)
1742
January 24, 2013 10:59AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.