Name
LOAD INDEX INTO CACHE
Synopsis
LOAD INDEX INTO CACHEtable
[[INDEX|KEY] (index
[, ...)] [IGNORE LEAVES] [, ...]
Use this statement to preload a table’s index into a given
key cache for a MyISAM table. The syntax allows one or more indexes to
be specified in a comma-separated list in parentheses, in order to
preload just the specified indexes, but presently MySQL simply loads
all the indexes for the table into the cache. The keywords
INDEX
and KEY
are
interchangeable and optional; they do not affect the results. The
IGNORE LEAVES
clause instructs MySQL not to preload
leaf nodes of the index. Here is an example of how you can use this
statement:
LOAD INDEX INTO CACHE workreq; +----------------------+--------------+----------+----------+ | Table | Op | Msg_type | Msg_text | +----------------------+--------------+----------+----------+ | workrequests.workreq | preload_keys | status | OK | +----------------------+--------------+----------+----------+
Get MySQL in a Nutshell, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.