The MySQL adaptive hash index
The adaptive hash index helps to improve performance of the already-fast B-tree lookups
When COMMIT is the slowest query, it means your storage is slow.
Let’s look at an example.