performance - MySQL LOAD DATA INFILE slows by 80% after a few gigs of input with InnoDB engine - Dat
I'm loading a 100GB file via LOAD DATA INFILE. I've had good success with MyISAM, a few hours and done. I'm trying it now using InnoDB. The load starts fast at over 10MB/sec ......