InnoDB是否实现真正的可序列化隔离

InnoDB是否实现真正的可序列化隔离

本文介绍了MySQL / InnoDB是否实现真正的可序列化隔离?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

尚不清楚是否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.

推荐答案

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

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

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

08-11 04:14