MySQL Forums
Forum List  »  MyISAM

Advanced Search
New Topic

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

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes)
4286
Ben Wallach
January 23, 2013 06:44PM
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes)
1938
Scott Nemes
January 24, 2013 10:59AM
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes)
2246
Ben Wallach
January 24, 2013 12:16PM
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes)
1797
Scott Nemes
January 24, 2013 01:41PM
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes)
1799
Ben Wallach
January 24, 2013 02:29PM
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes)
1711
Scott Nemes
January 24, 2013 03:14PM
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes)
2004
Ben Wallach
January 24, 2013 03:36PM
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes)
1933
Scott Nemes
January 24, 2013 03:44PM
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes)
2039
Ben Wallach
January 25, 2013 09:28AM
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes)
1881
Scott Nemes
January 25, 2013 09:51AM
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes)
2087
Rick James
January 26, 2013 12:40AM
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes)
1909
Ben Wallach
January 26, 2013 09:57AM
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes)
2083
Rick James
January 26, 2013 01:35PM
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes)
1823
Scott Nemes
January 26, 2013 02:25PM
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes)
2196
Ben Wallach
January 26, 2013 03:36PM
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes)
1793
Rick James
January 26, 2013 06:02PM
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes)
2044
Ben Wallach
January 26, 2013 07:18PM
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes)
1956
Rick James
January 26, 2013 09:33PM
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes)
1700
Ben Wallach
January 27, 2013 11:01AM
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes)
1839
Scott Nemes
January 27, 2013 12:44PM
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes)
1822
Ben Wallach
January 27, 2013 03:40PM
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes)
1750
Ben Wallach
January 28, 2013 11:13AM
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes)
1696
Ben Wallach
February 01, 2013 03:35PM
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes)
1795
Scott Nemes
February 01, 2013 03:37PM


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.