MySQL in a Nutshell

Name

LOAD INDEX INTO CACHE

Synopsis

LOAD INDEX INTO CACHE

  table [[INDEX|KEY] (index[,  . . . )] [IGNORE LEAVES]

  [,  . . . ]

Use this statement to preload a table’s index into a given key cache for a MyISAM table. Although one or more indexes may be specified in a comma-separated list in parentheses, all indexes for the table will be loaded into the cache. This will change in future versions of MySQL. The keywords INDEX and KEY are interchangeable and are not necessary. 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       |
+----------------------+--------------+----------+----------+