7

I've just been looking at the MySQL doc's https://dev.mysql.com/doc/refman/5.7/en/insert-delayed.html

I was intending to use an INSERT DELAYED, but I see that this has been deprecated.

I still need this functionality for compatibility with some PHP code that is handling some very large data transfers. I'm quite happy to update my PHP but I have no idea how to achieve the same functionality now.

How would we achieve the same outcome as traditional INSERT DELAYED now that it's deprecated?

TolMera
  • 233
  • 2
  • 6

2 Answers2

6

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

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.

Community
  • 1
RolandoMySQLDBA
  • 185,223
  • 33
  • 326
  • 536
1

I take your question to mean, that you need to defer work until after a given period of time.

In these circumstances, I would use a queue and defer my queue job for the required time.

As an example https://laravel.com/docs/5.3/queues#delayed-dispatching

Though from the docs "queued to be inserted when the table is not in use by any other thread" is not achievable as is via this method, you would need to implement this functionality in your job if it is required.

64k
  • 157
  • 8