Fast LOAD DATA INFILE with MySQL

fastload.sql

SET FOREIGN_KEY_CHECKS = 0;
SET UNIQUE_CHECKS = 0;
SET SESSION tx_isolation='READ-UNCOMMITTED';
SET sql_log_bin = 0;
#LOAD DATA LOCAL INFILE....
SET UNIQUE_CHECKS = 1;
SET FOREIGN_KEY_CHECKS = 1;
SET SESSION tx_isolation='READ-REPEATABLE';

From http://stackoverflow.com/a/39251799/4074148

Additional infos : http://derwiki.tumblr.com/post/24490758395/loading-half-a-billion-rows-into-mysql