Cianplan

Level 2: Data · L2.4 Transactions & isolation

Isolation levels and anomalies

Match dirty reads, lost updates and write skew to isolation levels.

14 min · Pro

What you take away

  • Each isolation level is defined by which anomalies it permits, not by how 'safe' it feels.

And 3 more inside the class, in Pro.

How the class is laid out

  1. The problem
  2. The simple version
  3. The five anomalies
  4. Which level permits what
  5. What to actually do
  6. Check your understanding