What happens when using MySQL Insert Delayed inside a transaction?

Does the inserts are finished with 开发者_运维技巧the transaction commit? Or they can be finished later?

---

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.

---

Insert delayed don't work with engines that support transactions