Tencent Database Technology

Feb 2, 2018 · Databases

In-Depth Exploration of InnoDB Bulk Index Build

This article provides a comprehensive technical overview of InnoDB's bulk index build feature introduced in MySQL 5.7, detailing its design, fast index build phases, bottom‑up construction, dirty‑page flushing, compressed‑table handling, fill‑factor configuration, and potential future optimizations.