在sql标准中定义快照隔离级别的rr级别是可以看到别的事务的insert后提交的数据的,但是在mysql中,rr级别是看不到别的事务提交的数据的,这个看不到指的的读操作,从而避免了幻读的出现,mysql中是使用了快照隔离的技术,这个技术是实现了mvcc,针对dml操作,还是有会进行当前读的,这个之前都已经测试过,下面看下快照隔离的定义
snapshot isolation is a guarantee that all reads made in a transaction will see a consistent snapshot of the database (in practice it reads the last committed values that existed at the time it started), and the transaction itself will successfully commit only if no updates it has made conflict with any concurrent updates made since that snapshot.
主要是针对的select,另外oracle中只支持rc,serializable 两中的级别
事务的隔离级别
最新推荐文章于 2019-11-11 13:36:42 发布