Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes)

[Scott Nemes]

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.