What happens when using MySQL Insert Delayed inside a transaction?

Question

Are transaction commit inserts completed? Or can they be finished later?

Answer 1

In the MySQL documentation :

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

None of these engines support transactions, so there are no conflicts.

I would suggest that you find that support for deferred inserts and transactions will be mutually exclusive.

Answer 2

,