MySQL Forums
Forum List  »  Performance

Advanced Search
New Topic

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.

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


Subject
Views
Written By
Posted
Recent Upgrade from MySQL 5.1 to 5.5
2370
Alex Titley
December 07, 2016 10:22AM
Re: Recent Upgrade from MySQL 5.1 to 5.5
1070
Edwin Desouza
December 07, 2016 08:47PM
Re: Recent Upgrade from MySQL 5.1 to 5.5
1031
Alex Titley
December 08, 2016 05:07AM
Re: Recent Upgrade from MySQL 5.1 to 5.5
967
Rick James
December 12, 2016 02:08PM
Re: Recent Upgrade from MySQL 5.1 to 5.5
1099
Alex Titley
December 14, 2016 07:27AM
Re: Recent Upgrade from MySQL 5.1 to 5.5
984
Peter Brawley
December 14, 2016 08:56AM


Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.

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.