Showing entries 1 to 1
Displaying posts with tag: adaptive hash (reset)
Dec
12
2007
InnoDB?s Adaptive Hash
Posted by The Pythian Group on Wed 12 Dec 2007 18:04 UTC
Tags:

MySQL’s manual page for InnoDB’s adaptive hash states: If a table fits almost entirely in main memory, the fastest way to perform queries on it is to use hash indexes. InnoDB has a mechanism that monitors index searches made to the indexes defined for a table. If InnoDB notices that queries could benefit building a [...]

Showing entries 1 to 1