Articles, deep dives, and notes from the engineering community.
Master ACID transactions, Multi-Version Concurrency Control (MVCC), undo/redo logs, row locks, gap locks, and deadlock elimination in MySQL 9 strict mode.
By Md. Harun-Or-Roshid
Master MySQL 9 InnoDB internals: clustered vs secondary B+Tree indexes, composite key leftmost prefix rules, page splitting, and EXPLAIN ANALYZE profiling.