Earlier notes · 2023
MySQL Fundamentals: Data Models, Query Execution, and Row Storage
An edited English edition of the archived study notes, covering relational design, storage engines, SQL execution, and InnoDB records.
MySQL Fundamentals
Earlier notes · 2023
MySQL Indexes: B+ Trees, Composite Keys, and Execution Plans
An edited English edition of the archived indexing notes, from InnoDB pages and composite-key ranges to EXPLAIN and COUNT semantics.