BestHub
Sign in
Tagged articles

Adaptive Hash Index

8 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 IndexIndexingInnoDB
0 likes · 27 min read
Understanding the Construction Process of Adaptive Hash Index (AHI) in MySQL 8.0.32
Shepherd Advanced Notes
Shepherd Advanced Notes
Mar 22, 2023 · Databases

Mastering MySQL Indexes: Advanced Concepts and Practical Tips

This article provides a comprehensive deep‑dive into MySQL indexing, covering the definition, pros and cons, differences between clustered and non‑clustered indexes, InnoDB vs MyISAM implementations, B+Tree structure, capacity calculations, adaptive hash indexes, index pushdown optimization, and how to interpret EXPLAIN output to verify index usage.

Adaptive Hash IndexB+TreeClustered Index
0 likes · 18 min read
Mastering MySQL Indexes: Advanced Concepts and Practical Tips
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 IndexIndexingInnoDB
0 likes · 15 min read
Understanding InnoDB Adaptive Hash Index (AHI) Mechanism