Debian Codegraph @

mysql-test/suite/innodb_zip/r/atomic_truncate_table_scale_1.result

raw
1 set innodb_strict_mode=OFF;
2 create procedure populate()
3 begin
4 declare i int default 1;
5 while (i <= 5000) do
6 insert into t1 values (i, 'a', 'b');
7 insert into t2 values (i, 'a', 'b');
8 insert into t3 values (i, 'a', 'b');
9 set i = i + 1;
10 end while;
11 end|
12 create procedure populate_small()
13 begin
14 declare i int default 10001;
15 while (i <= 12000) do
16 insert into t1 values (i, 'c', 'd');
17 insert into t2 values (i, 'a', 'b');
18 insert into t3 values (i, 'a', 'b');
19 set i = i + 1;
20 end while;
21 end|
22 set global innodb_file_per_table = 1;
23 create table tNUMBER
24 (i int, cNUMBER char(NUMBER), cNUMBER char(NUMBER),
25 index cNUMBER_idx(cNUMBER))
26 engine=innodb row_format=compact
27 key_block_size=NUMBER;
28 Warnings:
29 Warning NUMBER InnoDB: ignoring KEY_BLOCK_SIZE=NUMBER as ROW_FORMAT is not COMPRESSED.
30 create table t2
31 (i int, c1 char(100), c2 char(100),
32 index c1_idx(c1))
33 engine=innodb row_format=compact
34 key_block_size=16;
35 Warnings:
36 Warning 1478 InnoDB: ignoring KEY_BLOCK_SIZE=16 as ROW_FORMAT is not COMPRESSED.
37 create temporary table t3
38 (i int, c1 char(100), c2 char(100),
39 index c1_idx(c1))
40 engine=innodb row_format=compact
41 key_block_size=16;
42 Warnings:
43 Warning 1478 InnoDB: KEY_BLOCK_SIZE is ignored for TEMPORARY TABLE.
44 select count(*) from t1;
45 count(*)
46 0
47 select count(*) from t2;
48 count(*)
49 0
50 select count(*) from t3;
51 count(*)
52 0
53 begin;
54 call populate();
55 commit;
56 select count(*) from t1;
57 count(*)
58 5000
59 select count(*) from t2;
60 count(*)
61 5000
62 select count(*) from t3;
63 count(*)
64 5000
65 truncate table t1;
66 select count(*) from t1;
67 count(*)
68 0
69 select count(*) from t2;
70 count(*)
71 5000
72 select count(*) from t3;
73 count(*)
74 5000
75 call populate_small();
76 select count(*) from t1;
77 count(*)
78 2000
79 select count(*) from t2;
80 count(*)
81 7000
82 select count(*) from t3;
83 count(*)
84 7000
85 truncate table t2;
86 # WL#7811/WL#7743/WL#7141 TODO: Remove the warnings!
87 truncate table t3;
88 select count(*) from t1;
89 count(*)
90 2000
91 select count(*) from t2;
92 count(*)
93 0
94 select count(*) from t3;
95 count(*)
96 0
97 call populate_small();
98 select count(*) from t1;
99 count(*)
100 4000
101 select count(*) from t2;
102 count(*)
103 2000
104 select count(*) from t3;
105 count(*)
106 2000
107 drop table t1;
108 drop table t2;
109 drop table t3;
110 drop procedure populate;
111 drop procedure populate_small;
112 set global innodb_file_per_table = 1;
113 set innodb_strict_mode=OFF;
114 create procedure populate()
115 begin
116 declare i int default 1;
117 while (i <= 5000) do
118 insert into t1 values (i, 'a', 'b');
119 insert into t2 values (i, 'a', 'b');
120 insert into t3 values (i, 'a', 'b');
121 set i = i + 1;
122 end while;
123 end|
124 create procedure populate_small()
125 begin
126 declare i int default 10001;
127 while (i <= 12000) do
128 insert into t1 values (i, 'c', 'd');
129 insert into t2 values (i, 'a', 'b');
130 insert into t3 values (i, 'a', 'b');
131 set i = i + 1;
132 end while;
133 end|
134 set global innodb_file_per_table = 1;
135 create table tNUMBER
136 (i int, cNUMBER char(NUMBER), cNUMBER char(NUMBER),
137 index cNUMBER_idx(cNUMBER))
138 engine=innodb row_format=compressed
139 key_block_size=NUMBER;
140 create table t2
141 (i int, c1 char(100), c2 char(100),
142 index c1_idx(c1))
143 engine=innodb row_format=compressed
144 key_block_size=16;
145 create temporary table t3
146 (i int, c1 char(100), c2 char(100),
147 index c1_idx(c1))
148 engine=innodb row_format=compressed
149 key_block_size=16;
150 Warnings:
151 Warning 1478 InnoDB: KEY_BLOCK_SIZE is ignored for TEMPORARY TABLE.
152 Warning 1478 InnoDB: ROW_FORMAT=COMPRESSED is ignored for TEMPORARY TABLE.
153 Warning 1478 InnoDB: assuming ROW_FORMAT=DYNAMIC.
154 select count(*) from t1;
155 count(*)
156 0
157 select count(*) from t2;
158 count(*)
159 0
160 select count(*) from t3;
161 count(*)
162 0
163 begin;
164 call populate();
165 commit;
166 select count(*) from t1;
167 count(*)
168 5000
169 select count(*) from t2;
170 count(*)
171 5000
172 select count(*) from t3;
173 count(*)
174 5000
175 truncate table t1;
176 select count(*) from t1;
177 count(*)
178 0
179 select count(*) from t2;
180 count(*)
181 5000
182 select count(*) from t3;
183 count(*)
184 5000
185 call populate_small();
186 select count(*) from t1;
187 count(*)
188 2000
189 select count(*) from t2;
190 count(*)
191 7000
192 select count(*) from t3;
193 count(*)
194 7000
195 truncate table t2;
196 # WL#7811/WL#7743/WL#7141 TODO: Remove the warnings!
197 truncate table t3;
198 select count(*) from t1;
199 count(*)
200 2000
201 select count(*) from t2;
202 count(*)
203 0
204 select count(*) from t3;
205 count(*)
206 0
207 call populate_small();
208 select count(*) from t1;
209 count(*)
210 4000
211 select count(*) from t2;
212 count(*)
213 2000
214 select count(*) from t3;
215 count(*)
216 2000
217 drop table t1;
218 drop table t2;
219 drop table t3;
220 drop procedure populate;
221 drop procedure populate_small;
222 set global innodb_file_per_table = 1;
223 set innodb_strict_mode=OFF;
224 create procedure populate()
225 begin
226 declare i int default 1;
227 while (i <= 5000) do
228 insert into t1 values (i, 'a', 'b');
229 insert into t2 values (i, 'a', 'b');
230 insert into t3 values (i, 'a', 'b');
231 set i = i + 1;
232 end while;
233 end|
234 create procedure populate_small()
235 begin
236 declare i int default 10001;
237 while (i <= 12000) do
238 insert into t1 values (i, 'c', 'd');
239 insert into t2 values (i, 'a', 'b');
240 insert into t3 values (i, 'a', 'b');
241 set i = i + 1;
242 end while;
243 end|
244 set global innodb_file_per_table = 0;
245 create table tNUMBER
246 (i int, cNUMBER char(NUMBER), cNUMBER char(NUMBER),
247 index cNUMBER_idx(cNUMBER))
248 engine=innodb row_format=compact
249 key_block_size=NUMBER;
250 Warnings:
251 Warning NUMBER InnoDB: KEY_BLOCK_SIZE requires innodb_file_per_table.
252 Warning NUMBER InnoDB: ignoring KEY_BLOCK_SIZE=NUMBER.
253 create table t2
254 (i int, c1 char(100), c2 char(100),
255 index c1_idx(c1))
256 engine=innodb row_format=compact
257 key_block_size=16;
258 Warnings:
259 Warning 1478 InnoDB: KEY_BLOCK_SIZE requires innodb_file_per_table.
260 Warning 1478 InnoDB: ignoring KEY_BLOCK_SIZE=16.
261 create temporary table t3
262 (i int, c1 char(100), c2 char(100),
263 index c1_idx(c1))
264 engine=innodb row_format=compact
265 key_block_size=16;
266 Warnings:
267 Warning 1478 InnoDB: KEY_BLOCK_SIZE is ignored for TEMPORARY TABLE.
268 select count(*) from t1;
269 count(*)
270 0
271 select count(*) from t2;
272 count(*)
273 0
274 select count(*) from t3;
275 count(*)
276 0
277 begin;
278 call populate();
279 commit;
280 select count(*) from t1;
281 count(*)
282 5000
283 select count(*) from t2;
284 count(*)
285 5000
286 select count(*) from t3;
287 count(*)
288 5000
289 truncate table t1;
290 select count(*) from t1;
291 count(*)
292 0
293 select count(*) from t2;
294 count(*)
295 5000
296 select count(*) from t3;
297 count(*)
298 5000
299 call populate_small();
300 select count(*) from t1;
301 count(*)
302 2000
303 select count(*) from t2;
304 count(*)
305 7000
306 select count(*) from t3;
307 count(*)
308 7000
309 truncate table t2;
310 # WL#7811/WL#7743/WL#7141 TODO: Remove the warnings!
311 truncate table t3;
312 select count(*) from t1;
313 count(*)
314 2000
315 select count(*) from t2;
316 count(*)
317 0
318 select count(*) from t3;
319 count(*)
320 0
321 call populate_small();
322 select count(*) from t1;
323 count(*)
324 4000
325 select count(*) from t2;
326 count(*)
327 2000
328 select count(*) from t3;
329 count(*)
330 2000
331 drop table t1;
332 drop table t2;
333 drop table t3;
334 drop procedure populate;
335 drop procedure populate_small;
336 set global innodb_file_per_table = 1;