https://dev.mysql.com/doc/refman/5.5/en/optimizing-myisam-bulk-data-loading.html
https://dev.mysql.com/doc/refman/5.5/en/optimizing-innodb-bulk-data-loading.html
START TRANSACTION;
ALTER TABLE tbl_name DISABLE KEYS;
LOAD DATA INFILE 'whatever' INTO TABLE tbl_name;
ALTER TABLE tbl_name ENABLE KEYS;
END TRANSACTION;