foreigh_key_checksfor the duration of the bulk insert helps performance significantly.
log_binfor the duration of the Load Data process cuts execution time by 20-25%. Is that safe? All transactions involved are already documented in the Load Data input file, so if the server isn't a replication master, you can probably live without the redundancy of duplicating every command to the binary log, and just save the input file as an external record of the operation.To do it before MySQL version 5.6, you had to unset
log_binin my.cnf/ini and restart the server, and of course reverse that with another server reset afterwards. Since 5.6, it's a dynamic variable:
set session sql_log_bin=0;