Community journal

The latest from the MySQL community

Ideas, releases, practical guides, and perspectives from the people building with MySQL.

Displaying posts with tag: non-repeatable read (reset)

Apr

2011

Understanding InnoDB transaction isolation levels

Posted by Ovais Tariq on Sun 03 Apr 2011 10:28 UTC
Tags:

Replication, innodb, benchmark, transactions, deadlocks, locking, acid, isolation, snapshot, READ-COMMITTED, REPEATABLE-READ, data consistency, row-based, statement-based, consistent read, dirty read, gap-locking, isolation levels, lock in share mode, locking reads, mutex contention, next-key locking, non-repeatable read, phantom reads, read-uncommitted, select for update, serializable, shared locks, MySQL, Performance

Isolation is an important part of ACID properties that guarantee that transactions are processed in a reliable manner. But there are four different levels of isolation available and you have to understand each one of them to be able to select the correct one for your needs. This post intends on explaining the four levels together with their effects on locking and performance.

The latest from the MySQL community

Get Started Contributing

Events

MySQL Showcase

Top Authors

Oracle MySQL Blogs

Vendor Blogs

MySQL Links