Which isolation levels use MVCC in MySQL?

I read Transaction Isolation Levels in MySQL documentation. Then, only READ COMMITTED and REPEATABLE READ talk about snapshot as shown below:

  • READ COMMITTED
    Each consistent read, even within the same transaction, sets and reads its own fresh snapshot. ...
  • REPEATABLE READ
    This is the default isolation level for InnoDB. Consistent reads within the same transaction read the snapshot established by the first read. ...

snapshot
A representation of data at a particular time, which remains the same even as changes are committed by other transactions. Used by certain isolation levels to allow consistent reads.

So, do only READ COMMITTED and REPEATABLE READ use MVCC(Multiversion concurrency control)?

What about READ UNCOMMITTED and SERIALIZABLE?

Upvotes: 1

Views: 613

Answers (1)

Bill Karwin
Bill Karwin

Reputation: 562398

All transaction isolation levels in InnoDB use MVCC.

Upvotes: 0

Related Questions