CODEWITHSUNDEEP
mysqlinserttransactionscommit
Jader Dias
Jader Dias

Reputation: 90495

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?

Upvotes: 3

Views: 1400

Answers (2)

Dancrumb
Dancrumb

Reputation: 27539

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.

Upvotes: 4

a1ex07
a1ex07

Reputation: 37364

Insert delayed don't work with engines that support transactions

Upvotes: 1

Related Questions