Debian Codegraph @

mysql-test/suite/maria/maria-preload.result

raw
1 drop table if exists t1, t2;
2 set global aria_checkpoint_interval=0;
3 create temporary table initial
4 select variable_name,variable_value from
5 information_schema.global_status where variable_name like "Aria_pagecache_reads";
6 create table t1 (
7 a int not null auto_increment,
8 b char(16) not null,
9 primary key (a),
10 key (b)
11 ) engine=aria row_format=dynamic;
12 create table t2(
13 a int not null auto_increment,
14 b char(16) not null,
15 primary key (a),
16 key (b)
17 ) engine=aria row_format=dynamic;
18 insert into t1(b) values
19 ('test0'),
20 ('test1'),
21 ('test2'),
22 ('test3'),
23 ('test4'),
24 ('test5'),
25 ('test6'),
26 ('test7');
27 insert into t2(b) select b from t1;
28 insert into t1(b) select b from t2;
29 insert into t2(b) select b from t1;
30 insert into t1(b) select b from t2;
31 insert into t2(b) select b from t1;
32 insert into t1(b) select b from t2;
33 insert into t2(b) select b from t1;
34 insert into t1(b) select b from t2;
35 insert into t2(b) select b from t1;
36 insert into t1(b) select b from t2;
37 insert into t2(b) select b from t1;
38 insert into t1(b) select b from t2;
39 insert into t2(b) select b from t1;
40 insert into t1(b) select b from t2;
41 insert into t2(b) select b from t1;
42 insert into t1(b) select b from t2;
43 insert into t2(b) select b from t1;
44 insert into t1(b) select b from t2;
45 select count(*) from t1;
46 count(*)
47 33448
48 select count(*) from t2;
49 count(*)
50 20672
51 flush tables;
52 flush status;
53 select g.variable_name,g.variable_value-i.variable_value from information_schema.global_status as g,initial as i where g.variable_name like "Aria_pagecache_read%" and g.variable_name=i.variable_name order by g.variable_name desc;
54 variable_name g.variable_value-i.variable_value
55 ARIA_PAGECACHE_READS 2
56 select count(*) from t1 where b = 'test1';
57 count(*)
58 4181
59 select g.variable_name,g.variable_value-i.variable_value from information_schema.global_status as g,initial as i where g.variable_name like "Aria_pagecache_read%" and g.variable_name=i.variable_name order by g.variable_name desc;
60 variable_name g.variable_value-i.variable_value
61 ARIA_PAGECACHE_READS 11
62 select count(*) from t1 where b = 'test1';
63 count(*)
64 4181
65 select g.variable_name,g.variable_value-i.variable_value from information_schema.global_status as g,initial as i where g.variable_name like "Aria_pagecache_read%" and g.variable_name=i.variable_name order by g.variable_name desc;
66 variable_name g.variable_value-i.variable_value
67 ARIA_PAGECACHE_READS 11
68 flush tables;
69 flush status;
70 select @@preload_buffer_size;
71 @@preload_buffer_size
72 32768
73 load index into cache t1;
74 Table Op Msg_type Msg_text
75 test.t1 preload_keys status OK
76 select g.variable_name,g.variable_value-i.variable_value from information_schema.global_status as g,initial as i where g.variable_name like "Aria_pagecache_read%" and g.variable_name=i.variable_name order by g.variable_name desc;
77 variable_name g.variable_value-i.variable_value
78 ARIA_PAGECACHE_READS 107
79 select count(*) from t1 where b = 'test1';
80 count(*)
81 4181
82 select g.variable_name,g.variable_value-i.variable_value from information_schema.global_status as g,initial as i where g.variable_name like "Aria_pagecache_read%" and g.variable_name=i.variable_name order by g.variable_name desc;
83 variable_name g.variable_value-i.variable_value
84 ARIA_PAGECACHE_READS 107
85 flush tables;
86 flush status;
87 select g.variable_name,g.variable_value-i.variable_value from information_schema.global_status as g,initial as i where g.variable_name like "Aria_pagecache_read%" and g.variable_name=i.variable_name order by g.variable_name desc;
88 variable_name g.variable_value-i.variable_value
89 ARIA_PAGECACHE_READS 107
90 set session preload_buffer_size=256*1024;
91 select @@preload_buffer_size;
92 @@preload_buffer_size
93 262144
94 load index into cache t1 ignore leaves;
95 Table Op Msg_type Msg_text
96 test.t1 preload_keys status OK
97 select g.variable_name,g.variable_value-i.variable_value from information_schema.global_status as g,initial as i where g.variable_name like "Aria_pagecache_read%" and g.variable_name=i.variable_name order by g.variable_name desc;
98 variable_name g.variable_value-i.variable_value
99 ARIA_PAGECACHE_READS 203
100 select count(*) from t1 where b = 'test1';
101 count(*)
102 4181
103 select g.variable_name,g.variable_value-i.variable_value from information_schema.global_status as g,initial as i where g.variable_name like "Aria_pagecache_read%" and g.variable_name=i.variable_name order by g.variable_name desc;
104 variable_name g.variable_value-i.variable_value
105 ARIA_PAGECACHE_READS 211
106 flush tables;
107 flush status;
108 select g.variable_name,g.variable_value-i.variable_value from information_schema.global_status as g,initial as i where g.variable_name like "Aria_pagecache_read%" and g.variable_name=i.variable_name order by g.variable_name desc;
109 variable_name g.variable_value-i.variable_value
110 ARIA_PAGECACHE_READS 211
111 set session preload_buffer_size=1*1024;
112 select @@preload_buffer_size;
113 @@preload_buffer_size
114 1024
115 load index into cache t1, t2 key (primary,b) ignore leaves;
116 Table Op Msg_type Msg_text
117 test.t1 preload_keys status OK
118 test.t2 preload_keys status OK
119 select g.variable_name,g.variable_value-i.variable_value from information_schema.global_status as g,initial as i where g.variable_name like "Aria_pagecache_read%" and g.variable_name=i.variable_name order by g.variable_name desc;
120 variable_name g.variable_value-i.variable_value
121 ARIA_PAGECACHE_READS 364
122 select count(*) from t1 where b = 'test1';
123 count(*)
124 4181
125 select count(*) from t2 where b = 'test1';
126 count(*)
127 2584
128 select g.variable_name,g.variable_value-i.variable_value from information_schema.global_status as g,initial as i where g.variable_name like "Aria_pagecache_read%" and g.variable_name=i.variable_name order by g.variable_name desc;
129 variable_name g.variable_value-i.variable_value
130 ARIA_PAGECACHE_READS 369
131 flush tables;
132 flush status;
133 select g.variable_name,g.variable_value-i.variable_value from information_schema.global_status as g,initial as i where g.variable_name like "Aria_pagecache_read%" and g.variable_name=i.variable_name order by g.variable_name desc;
134 variable_name g.variable_value-i.variable_value
135 ARIA_PAGECACHE_READS 369
136 load index into cache t3, t2 key (primary,b) ;
137 Table Op Msg_type Msg_text
138 test.t3 preload_keys Error Table 'test.t3' doesn't exist
139 test.t3 preload_keys status Operation failed
140 test.t2 preload_keys status OK
141 select g.variable_name,g.variable_value-i.variable_value from information_schema.global_status as g,initial as i where g.variable_name like "Aria_pagecache_read%" and g.variable_name=i.variable_name order by g.variable_name desc;
142 variable_name g.variable_value-i.variable_value
143 ARIA_PAGECACHE_READS 426
144 flush tables;
145 flush status;
146 select g.variable_name,g.variable_value-i.variable_value from information_schema.global_status as g,initial as i where g.variable_name like "Aria_pagecache_read%" and g.variable_name=i.variable_name order by g.variable_name desc;
147 variable_name g.variable_value-i.variable_value
148 ARIA_PAGECACHE_READS 426
149 load index into cache t3 key (b), t2 key (c) ;
150 Table Op Msg_type Msg_text
151 test.t3 preload_keys Error Table 'test.t3' doesn't exist
152 test.t3 preload_keys status Operation failed
153 test.t2 preload_keys Error Key 'c' doesn't exist in table 't2'
154 test.t2 preload_keys status Operation failed
155 select g.variable_name,g.variable_value-i.variable_value from information_schema.global_status as g,initial as i where g.variable_name like "Aria_pagecache_read%" and g.variable_name=i.variable_name order by g.variable_name desc;
156 variable_name g.variable_value-i.variable_value
157 ARIA_PAGECACHE_READS 426
158 drop table t1, t2;
159 drop temporary table initial;
160 show status like "key_read%";
161 Variable_name Value
162 Key_read_requests 0
163 Key_reads 0