BestHub
Sign in
Tagged articles
7 articles
Page 1 of 1
Sanyou's Java Diary
Sanyou's Java Diary
Jun 9, 2025 · Databases

Inside InnoDB: How Buffer Pool, Change Buffer, and Adaptive Hash Index Boost MySQL Performance

This article explores the inner workings of InnoDB's architecture—including the Buffer Pool, Change Buffer, Adaptive Hash Index, and Log Buffer—detailing their designs, configuration parameters, performance impacts, and best‑practice recommendations for high‑throughput MySQL deployments.

Adaptive Hash IndexChange BufferDatabase Architecture
0 likes · 15 min read
Inside InnoDB: How Buffer Pool, Change Buffer, and Adaptive Hash Index Boost MySQL Performance
Aikesheng Open Source Community
Aikesheng Open Source Community
Aug 2, 2023 · Databases

Understanding the Construction Process of Adaptive Hash Index (AHI) in MySQL 8.0.32

This article explains why MySQL's Adaptive Hash Index (AHI) can cause slow TRUNCATE operations, describes its benefits, and provides a detailed step‑by‑step walkthrough of the AHI construction process—including index counting, construction‑info counting, data‑page counting, and the final hash‑index building—using MySQL 8.0.32 source code examples.

Adaptive Hash IndexDatabase OptimizationInnoDB
0 likes · 27 min read
Understanding the Construction Process of Adaptive Hash Index (AHI) in MySQL 8.0.32
Aikesheng Open Source Community
Aikesheng Open Source Community
Nov 14, 2022 · Databases

Performance Impact of Dropping Large Tables in MySQL 5.7 and 8.0: Bug Analysis and Mitigation

This article investigates a historical MySQL bug where dropping large tables with a sizable buffer pool and Adaptive Hash Index (AHI) can cause severe latency, presents test configurations for 5.7.29 and 8.0.28, compares AHI‑on/off results, shows stack traces, and explains the lazy‑delete fix introduced in 8.0.23.

Adaptive Hash Indexbuffer poolbug
0 likes · 24 min read
Performance Impact of Dropping Large Tables in MySQL 5.7 and 8.0: Bug Analysis and Mitigation
ITPUB
ITPUB
Nov 23, 2020 · Databases

Eliminating InnoDB Adaptive Hash Index Lock Contention for Faster Queries

The article examines the hidden lock‑contention issue in InnoDB’s Adaptive Hash Index (AHI) observed during high‑concurrency sysbench runs, explains why multiple threads block on the AHI hash table’s exclusive lock, and presents a lightweight fallback optimization that checks the lock before building AHI, reducing lock wait time and stabilizing QPS performance.

Adaptive Hash IndexDatabase InternalsInnoDB
0 likes · 9 min read
Eliminating InnoDB Adaptive Hash Index Lock Contention for Faster Queries
Architect
Architect
Mar 3, 2016 · Databases

Understanding InnoDB Adaptive Hash Index (AHI) Mechanism

This article explains how InnoDB's Adaptive Hash Index works, covering its initialization, information gathering, index and block statistics updates, page‑level hash construction, usage conditions, maintenance procedures, shortcut query mode, and monitoring via performance metrics.

Adaptive Hash IndexDatabase OptimizationInnoDB
0 likes · 15 min read
Understanding InnoDB Adaptive Hash Index (AHI) Mechanism