Tag - Adaptive Hash Index in InnoDB

Is Adaptive Hash Index in InnoDB right for my workload?

This blog post will discuss what the Adaptive Hash Index in InnoDB is used for, and whether it is a good fit for your workload.
Adaptive Hash Index (AHI) is one of the least understood features in InnoDB. In theory, it magically determines when it is worth supplementing InnoDB B-Tree-based indexes with fast hash lookup […]

Read more