views:

101

answers:

2

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

+1  A: 

Insert delayed don't work with engines that support transactions

a1ex07
+2  A: 

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 tables 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.

Dancrumb