mysql - 为什么 MySQL GTID 不支持临时表

Question

我从 MySQL 读取 documentation

CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE statements are not supported inside transactions when using GTIDs (that is, when the server was started with the --enforce-gtid-consistency option). It is possible to use these statements with GTIDs enabled, but only outside of any transaction, and only with autocommit=1

并且非常困惑为什么启用 GTID 时事务内部不支持创建/删除临时表，有人可以更详细地解释一下吗？谢谢!

Answer 1

启用 GTID 时，最有可能与复制相关的原因有很多。您始终可以在事务中创建普通表。在创建之前删除该表如果存在。它的工作方式与临时表相同。