mysql当前读和一致性读_[MySQL] 一致性读分析

MySQL MVCC

MySQL InnoDB存储引起实现的是基于多版本的并发控制协议---MVCC(Multi-Version Concurrency Control)，基于锁的并发控制，Lock-Based Concurrency Control。

一致性读，又称快照读，读取的是undo中已提交的数据，可能是数据的历史版本，no-locking，所以是非阻塞的读取操作。

A consistent read means that InnoDB uses multi-versioning to present to a query a snapshot of the database at a point in time. The query sees the changes made by transactions that committed before that point of time, and no changes made by later or uncommitted transactions. The exception to this rule is that the query sees the changes made by earlier statements within the same transaction.

那么一致性读(快照读)和当前读有什么区别呢?

snapshot read:

读取记录的可见版本(有可能是历史版本), no-locking

no-locking reads: 简单的select语句

select..

current read:

读取的是记录的最新版本, 加锁保证事务隔离性

locking-reads: 特殊操作, 插入/更新/删除操作

select .. for update

select ... in shar