在事务中使用MySQL Insert Delayed会发生什么？ [英] 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?

推荐答案

每个 MySQL文档：

INSERT DELAYED仅适用于MyISAM，MEMORY，ARCHIVE和（自MySQL 5.1.19起）BLACKHOLE表。对于不支持DELAYED的引擎，会发生错误。

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.

这篇关于在事务中使用MySQL Insert Delayed会发生什么？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！