Debian Codegraph @

mysql-test/suite/storage_engine/cache_index.result

raw
1 DROP TABLE IF EXISTS t1, t2;
2 CREATE TABLE t1 (a <INT_COLUMN>,
3 b <CHAR_COLUMN>,
4 <CUSTOM_INDEX> (a)
5 ) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>;
6 CREATE TABLE t2 (a <INT_COLUMN>,
7 b <CHAR_COLUMN>,
8 <CUSTOM_INDEX> (b)
9 ) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>;
10 CACHE INDEX t1 INDEX (a), t2 IN <CACHE_NAME>;
11 ERROR HY000: Unknown key cache '<CACHE_NAME>'
12 SET GLOBAL <CACHE_NAME>.key_buffer_size=128*1024;
13 CACHE INDEX t1 INDEX (a), t2 IN <CACHE_NAME>;
14 Table Op Msg_type Msg_text
15 test.t1 assign_to_keycache status OK
16 test.t2 assign_to_keycache status OK
17 LOAD INDEX INTO CACHE t1, t2;
18 Table Op Msg_type Msg_text
19 test.t1 preload_keys status OK
20 test.t2 preload_keys status OK
21 INSERT INTO t1 (a,b) VALUES (3,'c'),(4,'d');
22 SET GLOBAL <CACHE_NAME>.key_buffer_size=8*1024;
23 LOAD INDEX INTO CACHE t1, t2 IGNORE LEAVES;
24 Table Op Msg_type Msg_text
25 test.t1 preload_keys status OK
26 test.t2 preload_keys status OK
27 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;
28 INSERT INTO t1 (a,b) VALUES (5,'e'),(6,'f');
29 LOAD INDEX INTO CACHE t1;
30 Table Op Msg_type Msg_text
31 test.t1 preload_keys status OK
32 SET GLOBAL new_<CACHE_NAME>.key_buffer_size=128*1024;
33 CACHE INDEX t1 IN new_<CACHE_NAME>;
34 Table Op Msg_type Msg_text
35 test.t1 assign_to_keycache status OK
36 INSERT INTO t1 (a,b) VALUES (7,'g'),(8,'h');
37 LOAD INDEX INTO CACHE t1 IGNORE LEAVES;
38 Table Op Msg_type Msg_text
39 test.t1 preload_keys status OK
40 INSERT INTO t1 (a,b) VALUES (9,'i');
41 DROP TABLE t2;
42 DROP TABLE t1;
43 CREATE TABLE t1 (a <INT_COLUMN>,
44 b <CHAR_COLUMN>,
45 <CUSTOM_INDEX> (a),
46 <CUSTOM_INDEX> (b)
47 ) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>;
48 CACHE INDEX t1 IN <CACHE_NAME>;
49 Table Op Msg_type Msg_text
50 test.t1 assign_to_keycache status OK
51 INSERT INTO t1 (a,b) VALUES (1,'a'),(2,'b');
52 LOAD INDEX INTO CACHE t1;
53 Table Op Msg_type Msg_text
54 test.t1 preload_keys status OK
55 DROP TABLE t1;
56 CREATE TABLE t1 (a <INT_COLUMN>,
57 b <CHAR_COLUMN>,
58 <CUSTOM_INDEX> a_b (a,b)
59 ) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>;
60 CACHE INDEX t1 IN <CACHE_NAME>;
61 Table Op Msg_type Msg_text
62 test.t1 assign_to_keycache status OK
63 INSERT INTO t1 (a,b) VALUES (1,'a'),(2,'b');
64 LOAD INDEX INTO CACHE t1;
65 Table Op Msg_type Msg_text
66 test.t1 preload_keys status OK
67 DROP TABLE t1;
68 SET GLOBAL <CACHE_NAME>.key_buffer_size=0;
69 SET GLOBAL new_<CACHE_NAME>.key_buffer_size=0;