Storage Engines & Data Structures
How databases store and retrieve data — B+ trees, LSM trees, heap files, InnoDB vs MyISAM, WAL, and buffer pools.
2 docs tagged with "innodb"
View all tagsWhy You Deadlock Touching Only 1 Row: Gap Locks & The 3 Access Paths of WHERE
Deep dive into MySQL InnoDB storage engine locking mechanics: why two users updating distinct draft carts trigger Deadlock 1213, decoding the 3 access paths of a WHERE clause, and why READ COMMITTED won't save you.