MySQL Forums
Forum List  »  Performance

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
475
December 07, 2016 10:22AM
Re: Recent Upgrade from MySQL 5.1 to 5.5
341
December 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.