MySQL - INSERT DELAYED <- deprecated What now?

According to the MySQL 5.5. Documentation

INSERT DELAYED works only with MyISAM, MEMORY, ARCHIVE, and BLACKHOLE tables. For engines that do not support DELAYED, an error occurs.

You could downgrade to MySQL 5.5 (Of course, I am joking). I have three suggestions. Please look into them.

SUGGESTION #1

You could setup MySQL Replication and perform the following

  • Bulk insert into a table on the Master whose storage engine is BLACKHOLE.
  • The same table on the Slave would be InnoDB. Perform your SELECTs on the Slave
  • See my 3.5-year-old post How to do something like UPDATE DELAYED in MySQL

SUGGESTION #2

Tuning the InnoDB Environment to handle faster writes. Please see my 4.5-year-old posts How to use insert delay with the InnoDB engine and use less connection for insert statements? and Mysql load from infile stuck waiting on hard drive

SUGGESTION #3

Customize the bulk insert to use extended inserts that load a fixed number of rows at a time like a mysqldump does.