(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