AI Briefing#database internals
The latest AI and developer news about #database internals, with the original source and a short summary.
The latest AI and developer news about #database internals, with the original source and a short summary.
This document analyzes the lifecycle of MTR (Mini-Transaction) creation and commit within the InnoDB Redo Log of MySQL 5.7, as well as the concurrency control mechanism via Mutex when recording to the Redo Log Buffer.
WiredTiger removes inter-page links to reduce locking complexity during splits and optimizes performance by mixing arrays and skip lists in leaf pages.
The Kakao Tech Blog provides a detailed analysis of WiredTiger's file structure, including the history store, journal logs, and index metadata, using the wt CLI and bsondump.