MySQL / InnoDB是否实现真正的可序列化隔离？ [英] Does MySQL/InnoDB implement true serializable isolation?

问题描述

MySQL文档尚不清楚是否InnoDB引擎实现真正的可序列化隔离 ¹ 或 快照隔离 ，它也常常被混淆为可序列化。是哪一个？

It is not entirely clear from MySQL documentation whether the InnoDB engine implements true serializable isolation¹ or snapshot isolation, which is often confusingly called "serializable" too. Which one is it?

如果MySQL InnoDB没有，那么有没有完全免费的，生产质量的RDBMS可以使用？

If MySQL InnoDB doesn't, are there any completely free, production-quality RDBMS which do?

¹ 其中真正的可序列化隔离表示不仅不存在按照SQL标准的读取异常，而且不存在写入偏斜异常，进一步详细解释此处。

¹ where "true serializable isolation" means the absence of not only read anomalies as per the SQL standard, but also the write skew anomaly, explained in further detail here.

推荐答案

有没有完全免费的，生产质量的RDBMS，可以使用？

are there any completely free, production-quality RDBMS which do?

Postgres支持真正的可序列化隔离从9.1版开始。当然，它同时具有完全免费和生产质量的资格。

Postgres has support for true serializable isolation starting with version 9.1. It certainly qualifies both as "completely free" and "production-quality".

这篇关于MySQL / InnoDB是否实现真正的可序列化隔离？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！