Showing entries 1 to 1
Displaying posts with tag: adaptive hash (reset)
InnoDB?s Adaptive Hash

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