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


Advanced Search

5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes)
Posted by: Ben Wallach ()
Date: January 23, 2013 06:44PM

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

We just upgraded from 5.1 to 5.5. An insert script that used to take ~3 mins to insert ~200k rows into a MyISAM table with 3 indexes now takes ~8 mins! Removing the indexes solves the issue!?

Reads(selects) are fine (faster in 5.5 than 5.1)

Is something different about index behavior or could there be some oddball config parameter that may need to be tweaked?

Thanks in advance for any pointers!


System Info:
-----------
Fedora 17
Mysql 5.5.29-log
16GB RAM
MyISAM Key Buffer = 4GB
MyISAM index size = ~800 MB
MyISAM table size = 4.4 GB

INNODB Buffer Pool = 8GB
INNODB table+index size = ~12GB

Options: ReplyQuote


Subject Views Written By Posted
5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes) 2733 Ben Wallach 01/23/2013 06:44PM
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes) 1345 Scott Nemes 01/24/2013 10:59AM
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes) 1500 Ben Wallach 01/24/2013 12:16PM
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes) 1245 Scott Nemes 01/24/2013 01:41PM
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes) 1226 Ben Wallach 01/24/2013 02:29PM
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes) 1180 Scott Nemes 01/24/2013 03:14PM
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes) 1271 Ben Wallach 01/24/2013 03:36PM
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes) 1289 Scott Nemes 01/24/2013 03:44PM
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes) 1377 Ben Wallach 01/25/2013 09:28AM
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes) 1240 Scott Nemes 01/25/2013 09:51AM
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes) 1381 Rick James 01/26/2013 12:40AM
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes) 1282 Ben Wallach 01/26/2013 09:57AM
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes) 1387 Rick James 01/26/2013 01:35PM
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes) 1266 Scott Nemes 01/26/2013 02:25PM
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes) 1487 Ben Wallach 01/26/2013 03:36PM
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes) 1255 Rick James 01/26/2013 06:02PM
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes) 1378 Ben Wallach 01/26/2013 07:18PM
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes) 1380 Rick James 01/26/2013 09:33PM
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes) 1175 Ben Wallach 01/27/2013 11:01AM
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes) 1246 Scott Nemes 01/27/2013 12:44PM
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes) 1251 Ben Wallach 01/27/2013 03:40PM
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes) 1191 Ben Wallach 01/28/2013 11:13AM
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes) 1260 Ben Wallach 02/01/2013 03:35PM
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes) 1193 Scott Nemes 02/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.