Example of Cache Index Mysql Statement:
CACHE INDEX t1 IN non_existent_cache;
CACHE INDEX t1, t2, t3 IN hot_cache;
Example of Mysql Cache Index
CACHE INDEX
tbl_index_list [, tbl_index_list] ...
IN key_cache_name
tbl_index_list:
tbl_name [[INDEX|KEY] (index_name[, index_name] ...)]