What happens when using MySQL Insert Delayed insid

Question

Does the inserts are finished with the transaction commit? Or they can be finished later?

Answer 1

Per the MySQL Documentation:

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

None of these engines support transactions, so there's no conflict in functionality here.

I would imagine that you will find that support of delayed inserts and transactions will be mutually exclusive.

Answer 2

Insert delayed don't work with engines that support transactions