bulk_insert_buffer_size and InnoDB
Yes, you are correct. I wrote about this before: How can I optimize this mySQL table that will need to hold 5+ million rows?

WHen it comes to bulk loading InnoDB tables, one of the most frequently ignored settings to disable is innodb_doublewrite.

InnoDB Architecture



Please note the double write buffer inside the system tablespace file ibdata1. Every time a 16K page is written to an InnoDB table or transaction log, the page is written to the double wrote buffer first. All you need to do is disable it, load your data, and reenable it.

STEP 01 : Disable Fast Shutdown

mysql -uroot -p... -ANe"SET GLOBAL innodb_fast_shutdown = 0"


STEP 02 : Restart mysql without the double write buffer

service mysql restart --innodb-doublewrite=0


STEP 03 : Load the InnoDB data

STEP 04 : Restart mysql

service mysql restart


CAVEAT

You can disable the foreign key checks and the unique checks as well. Any standard mysqldump will do that for you already.