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.
Showing entries 1 to 1
Apr
03
2011
Posted by Ovais Tariq
on Sun 03 Apr 2011 10:28 UTC
Tags:
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
Showing entries 1 to 1
Search
Top 20 Authors
Dave Stokes (20)Mikael Ronström (16)
Frederic Descamps (14)
Valeriy Kravchuk (10)
Jesper Krogh (9)
Dimitri Kravtchuk (7)
Mark Callaghan (6)
Krunal Lathiya (5)
Alena Subotina (3)
Mirko Ortensi (3)
Vlad Mihalcea (3)
Andrew Grimo (2)
Elshad Agayev (2)
John Scott (2)
Kedar Vaijanapurkar (2)
Keith Larson (2)
Martijn Tonies (2)
MC Brown (2)
Michael McLaughlin (2)
Olivier Dasini (2)
Oracle MySQL Blogs
MySQL Server Team (19)MySQL Support Team (12)
InsideMySQL.com (10)
Oracle's MySQL Blog (8)
MySQL High Availability (6)
MySQL Training Team (2)
MySQL Release Engineering (1)
MySQL Workbench (1)