Re: Bulk Insert

[Peter Brawley]

Multiple inserts per statement are faster than single inserts. Load Data is faster than Insert. But Load Data is can be 20 times faster to a MyISAM table than to an InnoDB table. So it's complicated.

See https://nbsoftsolutions.com/blog/optimizing-innodb-bulk-insert for useful notes on optimising InnoDB bulk inserts

See https://dba.stackexchange.com/questions/31752/mysql-load-data-infile-slows-by-80-after-a-few-gigs-of-input-with-innodb-engine for a discussion of optimising Load Data with InnoDB

See https://www.slideshare.net/billkarwin/load-data-fast for a recent slideshow on optimising Load Data

See http://www.speedemy.com/17-key-mysql-config-file-settings-mysql-5-7-proof/ for good sugestions on tuning InnoDB.



Edited 1 time(s). Last edit at 06/11/2017 01:47PM by Peter Brawley.