EVOLUTION-MANAGER

Edit File: cache_index.rdiff

--- 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 <CACHE_NAME>.key_buffer_size=128*1024; CACHE INDEX t1 INDEX (a), t2 IN <CACHE_NAME>; 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 <CACHE_NAME>.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 <CACHE_NAME>.key_cache_age_threshold = 100, <CACHE_NAME>.key_cache_block_size = 512, <CACHE_NAME>.key_cache_division_limit = 1, <CACHE_NAME>.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_<CACHE_NAME>.key_buffer_size=128*1024; CACHE INDEX t1 IN new_<CACHE_NAME>; 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=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>; CACHE INDEX t1 IN <CACHE_NAME>; 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 <INT_COLUMN>, b <CHAR_COLUMN>, @@ -59,11 +59,11 @@ ) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>; CACHE INDEX t1 IN <CACHE_NAME>; 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 <CACHE_NAME>.key_buffer_size=0; SET GLOBAL new_<CACHE_NAME>.key_buffer_size=0;