MySQL Forums
Forum List  »  MyISAM

Advanced Search
New Topic

Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes)
Posted by: Ben Wallach
Date: January 26, 2013 03:36PM

Thanks Scott/Rick.

yes, we are using RAID-1 on old and new setup.
One other observation is that during the heavy writes we observe the following via the iotop utility:
I/O
----------------------------
old hardware:
root ~12.00% [jbd2/sda4-8]

new hardware
root 99.99% [jbd2/sda4-8]

My understanding is this root process has to do with the Linux filesystem journaling. I dont know enough about this though.

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)
4835
Ben Wallach
January 23, 2013 06:44PM
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes)
2195
Scott Nemes
January 24, 2013 10:59AM
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes)
2405
Ben Wallach
January 24, 2013 12:16PM
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes)
1968
Scott Nemes
January 24, 2013 01:41PM
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes)
2214
Ben Wallach
January 24, 2013 02:29PM
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes)
1870
Scott Nemes
January 24, 2013 03:14PM
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes)
2231
Ben Wallach
January 24, 2013 03:36PM
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes)
2525
Scott Nemes
January 24, 2013 03:44PM
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes)
2198
Ben Wallach
January 25, 2013 09:28AM
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes)
2336
Scott Nemes
January 25, 2013 09:51AM
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes)
2660
Rick James
January 26, 2013 12:40AM
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes)
2112
Ben Wallach
January 26, 2013 09:57AM
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes)
2290
Rick James
January 26, 2013 01:35PM
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes)
2263
Scott Nemes
January 26, 2013 02:25PM
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes)
2384
Ben Wallach
January 26, 2013 03:36PM
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes)
2174
Rick James
January 26, 2013 06:02PM
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes)
2594
Ben Wallach
January 26, 2013 07:18PM
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes)
2226
Rick James
January 26, 2013 09:33PM
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes)
2267
Ben Wallach
January 27, 2013 11:01AM
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes)
2136
Scott Nemes
January 27, 2013 12:44PM
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes)
1996
Ben Wallach
January 27, 2013 03:40PM
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes)
2121
Ben Wallach
January 28, 2013 11:13AM
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes)
1903
Ben Wallach
February 01, 2013 03:35PM
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes)
2216
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.