Quickly inserting millions of rows with MySQL/InnoDB 0

Posted by sjs
on Thursday, April 26

A project I’m working on has datasets with millions of rows. Several times per week several million new rows are added. The rows are added all at once, not accumulated over a period of use. Inserts need to be fast.

I won’t go over why I chose InnoDB over MyISAM apart from saying that data is important. MyISAM is the faster of the two with default settings, but InnoDB required some tweaking for me to see similar performance. For my application the performance I achieved is adequate.

Continue reading...