Xueersi Online School Tech Team
Oct 16, 2020 · Databases
Deep Dive into MySQL InnoDB Record Lookup and Deletion Process
This article explains how MySQL InnoDB locates and deletes a specific row by describing the buffer‑pool lookup, B‑tree page traversal, page‑directory binary search, linear record scan, the compact physical record format, and the handling of signed integers and next‑record offsets, with GDB debugging examples.
Compact Row FormatDatabase InternalsInnoDB
0 likes · 25 min read