MySQL Forums :: Performance :: Recent Upgrade from MySQL 5.1 to 5.5


Advanced Search

Re: Recent Upgrade from MySQL 5.1 to 5.5
Posted by: Peter Brawley ()
Date: December 14, 2016 08:56AM

> They say that INNODB can't handle LOAD DATA IN's very well

With big loads, MyISAM can be 20+ times faster. There are workarounds but not complete remedies, so if big loads are necessary, consider a MyISAM staging table.

Options: ReplyQuote


Subject Views Written By Posted
Recent Upgrade from MySQL 5.1 to 5.5 335 Alex Titley 12/07/2016 10:22AM
Re: Recent Upgrade from MySQL 5.1 to 5.5 202 Edwin Desouza 12/07/2016 08:47PM
Re: Recent Upgrade from MySQL 5.1 to 5.5 162 Alex Titley 12/08/2016 05:07AM
Re: Recent Upgrade from MySQL 5.1 to 5.5 170 Rick James 12/12/2016 02:08PM
Re: Recent Upgrade from MySQL 5.1 to 5.5 213 Alex Titley 12/14/2016 07:27AM
Re: Recent Upgrade from MySQL 5.1 to 5.5 244 Peter Brawley 12/14/2016 08:56AM


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.