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 03:14PM

Interesting.

My only other thought currently is that you may be maxing out your memory with the increased my.cnf allocations and indexes which could result in swapping and slow disk speeds. So I would check to see if you are maxing out memory, and if you are using more I/O.

On a related note, have you thought about migrating your remaining MyISAM tables to InnoDB? You'd likely get even better performance than before, so something to think about if possible.

--
Scott Nemes
MySQL DBA

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes)
1569
January 24, 2013 03:14PM


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.