add CONCURRENT to faster a little bit. USE adb; LOAD DATA CONCURRENT INFILE '/path/to/afile' IGNORE INTO TABLE atable;