A curated list of engineering series, deep dives, and notes related to #Phantom Reads.
Master MySQL InnoDB locking mechanics: Record locks, Gap locks, Next-Key locks, and the supremum pseudo-record to prevent phantom reads.