Re: load index into cache

[Mike Connell]

Hi,

Read the fine print in the manual and found the syntax for individual index loading (cool :).

LOAD INDEX INTO CACHE tbl_index_list [, tbl_index_list] ...

tbl_index_list:
tbl_name [[INDEX|KEY] (index_name[, index_name] ...)] [IGNORE LEAVES]

I did file a feature request #12634 about the leaf nodes being evicted first if the index is
bigger than the cache size.

I also filed a feature request on flush tables (#12635) to be able to evict the leaf nodes or
a particular index. This would be a complement to LOAD INDEX INTO CACHE...
the ability to evict selected items from the cache.

Thanks