What is isolation?

Learn how transactions see each other.

Isolation controls how concurrent transactions affect each other. Four levels exist.

SET TRANSACTION ISOLATION LEVEL READ COMMITTED;

Mid-level isolation.

What is isolation? — details

Low level is fast but risky, high level is safe but slow. Choosing the right balance is key.

Most databases default to READ COMMITTED; for critical operations such as money transfers a higher level is chosen deliberately.

Set the isolation level to READ COMMITTED.

Show example solution

SET TRANSACTION ISOLATION LEVEL READ COMMITTED;

Add SET TRANSACTION

____ ISOLATION LEVEL READ COMMITTED;

Show answer

SET TRANSACTION ISOLATION LEVEL READ COMMITTED;