Home » MySQL Isolation levels

MySQL Isolation levels

  • by

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

Leave a Reply

Your email address will not be published.