--- cache_index.result 2013-01-22 22:05:05.246633000 +0400 +++ cache_index.reject 2013-01-23 02:50:13.468083137 +0400 @@ -12,31 +12,31 @@ SET GLOBAL .key_buffer_size=128*1024; CACHE INDEX t1 INDEX (a), t2 IN ; Table Op Msg_type Msg_text -test.t1 assign_to_keycache status OK -test.t2 assign_to_keycache status OK +test.t1 assign_to_keycache note The storage engine for the table doesn't support assign_to_keycache +test.t2 assign_to_keycache note The storage engine for the table doesn't support assign_to_keycache LOAD INDEX INTO CACHE t1, t2; Table Op Msg_type Msg_text -test.t1 preload_keys status OK -test.t2 preload_keys status OK +test.t1 preload_keys note The storage engine for the table doesn't support preload_keys +test.t2 preload_keys note The storage engine for the table doesn't support preload_keys INSERT INTO t1 (a,b) VALUES (3,'c'),(4,'d'); SET GLOBAL .key_buffer_size=8*1024; 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 +test.t1 preload_keys note The storage engine for the table doesn't support preload_keys +test.t2 preload_keys note The storage engine for the table doesn't support preload_keys SET GLOBAL .key_cache_age_threshold = 100, .key_cache_block_size = 512, .key_cache_division_limit = 1, .key_cache_segments=2; INSERT INTO t1 (a,b) VALUES (5,'e'),(6,'f'); LOAD INDEX INTO CACHE t1; Table Op Msg_type Msg_text -test.t1 preload_keys status OK +test.t1 preload_keys note The storage engine for the table doesn't support preload_keys SET GLOBAL new_.key_buffer_size=128*1024; CACHE INDEX t1 IN new_; Table Op Msg_type Msg_text -test.t1 assign_to_keycache status OK +test.t1 assign_to_keycache note The storage engine for the table doesn't support assign_to_keycache INSERT INTO t1 (a,b) VALUES (7,'g'),(8,'h'); LOAD INDEX INTO CACHE t1 IGNORE LEAVES; Table Op Msg_type Msg_text -test.t1 preload_keys status OK +test.t1 preload_keys note The storage engine for the table doesn't support preload_keys INSERT INTO t1 (a,b) VALUES (9,'i'); DROP TABLE t2; DROP TABLE t1; @@ -47,11 +47,11 @@ ) ENGINE= ; CACHE INDEX t1 IN ; Table Op Msg_type Msg_text -test.t1 assign_to_keycache status OK +test.t1 assign_to_keycache note The storage engine for the table doesn't support assign_to_keycache INSERT INTO t1 (a,b) VALUES (1,'a'),(2,'b'); LOAD INDEX INTO CACHE t1; Table Op Msg_type Msg_text -test.t1 preload_keys status OK +test.t1 preload_keys note The storage engine for the table doesn't support preload_keys DROP TABLE t1; CREATE TABLE t1 (a , b , @@ -59,11 +59,11 @@ ) ENGINE= ; CACHE INDEX t1 IN ; Table Op Msg_type Msg_text -test.t1 assign_to_keycache status OK +test.t1 assign_to_keycache note The storage engine for the table doesn't support assign_to_keycache INSERT INTO t1 (a,b) VALUES (1,'a'),(2,'b'); LOAD INDEX INTO CACHE t1; Table Op Msg_type Msg_text -test.t1 preload_keys status OK +test.t1 preload_keys note The storage engine for the table doesn't support preload_keys DROP TABLE t1; SET GLOBAL .key_buffer_size=0; SET GLOBAL new_.key_buffer_size=0;