Table of Contents
MySQL Isolation levels
Read uncommitted
Read committed
Repeatable Read
Serializable
Read UnCommitted
Pros: Better performance
Cons: No/least isolation, Problem of dirty read
Read committed:
Pros: Better performance than Repeatable read and serializable but degraded performance in comparison to read uncommitted
No Dirty read
Cons: Non Repeatable Read and Phantom read
less isolation than Serializable and Repeatable read
Repeatable Read:
Pros: Better performance than serializable but degraded performance in comparison to read uncommitted and Read Committed
No Dirty read, No Non Repeatable Read
Cons: Phantom read
less isolation than Serializable
Serializable:
Pros: No Phantom read, No Dirty read, No Non Repeatable Read, Most isolation between transactions
Cons: Least performance