SERIALIZABLE

Learn the highest level.

SERIALIZABLE is the highest level. Transactions run as if sequential. All issues are prevented.

SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;

Safest but slowest.

SERIALIZABLE — details

SERIALIZABLE also prevents phantom reads. But locking reduces performance.

Transactions behave as if they ran one after another; on a conflict the database aborts one with an error and the application must retry it.

Set the isolation level to SERIALIZABLE.

Show example solution

SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;

SERIALIZABLE

SET TRANSACTION ISOLATION LEVEL ____

Show answer

SET TRANSACTION ISOLATION LEVEL SERIALIZABLE