(mysql.info.gz) LOAD INDEX
Info Catalog
(mysql.info.gz) KILL
(mysql.info.gz) Other administrative SQL
(mysql.info.gz) RESET
13.5.5.4 `LOAD INDEX INTO CACHE' Syntax
.......................................
LOAD INDEX INTO CACHE
TBL_INDEX_LIST [, TBL_INDEX_LIST] ...
TBL_INDEX_LIST:
TBL_NAME
[[INDEX|KEY] (INDEX_NAME[, INDEX_NAME] ...)]
[IGNORE LEAVES]
The `LOAD INDEX INTO CACHE' statement preloads a table index into the
key cache to which it has been assigned by an explicit `CACHE INDEX'
statement, or into the default key cache otherwise. `LOAD INDEX INTO
CACHE' is used only for `MyISAM' tables.
The `IGNORE LEAVES' modifier causes only blocks for the non-leaf nodes
of the index to be preloaded.
The following statement preloads nodes (index blocks) of indexes of the
tables `t1' and `t2':
mysql> LOAD INDEX INTO CACHE t1, t2 IGNORE LEAVES;
+---------+--------------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+---------+--------------+----------+----------+
| test.t1 | preload_keys | status | OK |
| test.t2 | preload_keys | status | OK |
+---------+--------------+----------+----------+
This statement preloads all index blocks from `t1'. It preloads only
blocks for the non-leaf nodes from `t2'.
The syntax of `LOAD INDEX INTO CACHE' allows you to specify that only
particular indexes from a table should be preloaded. However, the
current implementation preloads all the table's indexes into the cache,
so there is no reason to specify anything other than the table name.
`LOAD INDEX INTO CACHE' was added in MySQL 4.1.1.
Info Catalog
(mysql.info.gz) KILL
(mysql.info.gz) Other administrative SQL
(mysql.info.gz) RESET
automatically generated byinfo2html