TechPlanetScaleabout 2 years ago
The MySQL adaptive hash index
12 min read
MySQL's InnoDB storage engine uses the Adaptive Hash Index (AHI) to speed up B-tree index lookups. The AHI caches frequently accessed index pages in a hash table, reducing the number of B-tree traversals. This optimization works alongside the InnoDB buffer pool to improve query performance.
Level
Hype check
Tap to vote and see what everyone thinks.