Why Big Tech Chooses RC Over MySQL’s Default RR Isolation Level

This article explains the differences between MySQL’s default REPEATABLE READ (RR) and READ COMMITTED (RC) isolation levels, why large internet firms switch to RC, the mechanics of master‑slave replication, the three binlog formats, and how gap locks affect consistency and performance.

BinlogIsolation LevelMySQL

0 likes · 10 min read

Why Big Tech Chooses RC Over MySQL’s Default RR Isolation Level

Selected Java Interview Questions

Sep 17, 2020 · Databases

Understanding MySQL Gap Locks and Next‑Key Locks with Practical Examples

This article explains how InnoDB implements row locks, gap locks, and next‑key locks to prevent phantom reads, describes how the lock ranges are determined, and demonstrates their effects through multiple transaction scenarios with detailed SQL code examples.

Gap LockInnoDBMySQL

0 likes · 11 min read

Understanding MySQL Gap Locks and Next‑Key Locks with Practical Examples