MySQL的SQL语句 - 数据库管理语句 - 其他管理语句 - CACHE INDEX 语句

CACHE INDEX {
      tbl_index_list [, tbl_index_list] ...
    | tbl_name PARTITION (partition_list)
  }
  IN key_cache_name


tbl_index_list:
  tbl_name [{INDEX|KEY} (index_name[, index_name] ...)]


partition_list: {
    partition_name[, partition_name] ...
  | ALL
}
复制

mysql> CACHE INDEX t1, t2, t3 IN hot_cache;
+---------+--------------------+----------+----------+
| Table   | Op                 | Msg_type | Msg_text |
+---------+--------------------+----------+----------+
| test.t1 | assign_to_keycache | status   | OK       |
| test.t2 | assign_to_keycache | status   | OK       |
| test.t3 | assign_to_keycache | status   | OK       |
+---------+--------------------+----------+----------+
复制

SET GLOBAL keycache1.key_buffer_size=128*1024;
复制

mysql> CACHE INDEX t1 IN non_existent_cache;
ERROR 1284 (HY000): Unknown key cache 'non_existent_cache'
复制

CREATE TABLE pt (c1 INT, c2 VARCHAR(50), INDEX i(c1))
    ENGINE=MyISAM
    PARTITION BY HASH(c1)
    PARTITIONS 4;


SET GLOBAL kc_fast.key_buffer_size = 128 * 1024;
SET GLOBAL kc_slow.key_buffer_size = 128 * 1024;


CACHE INDEX pt PARTITION (p0) IN kc_fast;
CACHE INDEX pt PARTITION (p1, p3) IN kc_slow;
复制

CACHE INDEX pt PARTITION (ALL) IN kc_all;


CACHE INDEX pt IN kc_all;
复制

BINLOG 'str'
复制