MySQL: Improving LOAD DATA Performance

This is for InnoDB.

First, the following settings help:

innodb_buffer_pool_size = 4096M innodb_doublewrite = 0 log-bin = 0 innodb_support_xa = 0 innodb_log_file_size = 256M innodb_flush_log_at_trx_commit = 0

The other thing is to minimize the creation of indexes during loading. They can be created later if necessary.

Reference: http://stackoverflow.com/questions/5020998/how-to-speed-up-a-data-loading-into-innodb-load-data-infile