Debian Codegraph @

mysql-test/suite/innodb/r/innodb_open_file_hang.result

raw
1 SELECT @@innodb_thread_concurrency, @@innodb_open_files;
2 @@innodb_thread_concurrency @@innodb_open_files
3 10 40
4 # Create more tables than open file limit (which is 40) to fill up the
5 # LRU list.
6 CREATE TABLE g0(id INT PRIMARY KEY) ENGINE=INNODB;
7 CREATE TABLE g1(id INT PRIMARY KEY) ENGINE=INNODB;
8 CREATE TABLE g2(id INT PRIMARY KEY) ENGINE=INNODB;
9 CREATE TABLE g3(id INT PRIMARY KEY) ENGINE=INNODB;
10 CREATE TABLE g4(id INT PRIMARY KEY) ENGINE=INNODB;
11 CREATE TABLE g5(id INT PRIMARY KEY) ENGINE=INNODB;
12 CREATE TABLE g6(id INT PRIMARY KEY) ENGINE=INNODB;
13 CREATE TABLE g7(id INT PRIMARY KEY) ENGINE=INNODB;
14 CREATE TABLE g8(id INT PRIMARY KEY) ENGINE=INNODB;
15 CREATE TABLE g9(id INT PRIMARY KEY) ENGINE=INNODB;
16 CREATE TABLE g10(id INT PRIMARY KEY) ENGINE=INNODB;
17 CREATE TABLE g11(id INT PRIMARY KEY) ENGINE=INNODB;
18 CREATE TABLE g12(id INT PRIMARY KEY) ENGINE=INNODB;
19 CREATE TABLE g13(id INT PRIMARY KEY) ENGINE=INNODB;
20 CREATE TABLE g14(id INT PRIMARY KEY) ENGINE=INNODB;
21 CREATE TABLE g15(id INT PRIMARY KEY) ENGINE=INNODB;
22 CREATE TABLE g16(id INT PRIMARY KEY) ENGINE=INNODB;
23 CREATE TABLE g17(id INT PRIMARY KEY) ENGINE=INNODB;
24 CREATE TABLE g18(id INT PRIMARY KEY) ENGINE=INNODB;
25 CREATE TABLE g19(id INT PRIMARY KEY) ENGINE=INNODB;
26 CREATE TABLE g20(id INT PRIMARY KEY) ENGINE=INNODB;
27 CREATE TABLE g21(id INT PRIMARY KEY) ENGINE=INNODB;
28 CREATE TABLE g22(id INT PRIMARY KEY) ENGINE=INNODB;
29 CREATE TABLE g23(id INT PRIMARY KEY) ENGINE=INNODB;
30 CREATE TABLE g24(id INT PRIMARY KEY) ENGINE=INNODB;
31 CREATE TABLE g25(id INT PRIMARY KEY) ENGINE=INNODB;
32 CREATE TABLE g26(id INT PRIMARY KEY) ENGINE=INNODB;
33 CREATE TABLE g27(id INT PRIMARY KEY) ENGINE=INNODB;
34 CREATE TABLE g28(id INT PRIMARY KEY) ENGINE=INNODB;
35 CREATE TABLE g29(id INT PRIMARY KEY) ENGINE=INNODB;
36 CREATE TABLE g30(id INT PRIMARY KEY) ENGINE=INNODB;
37 CREATE TABLE g31(id INT PRIMARY KEY) ENGINE=INNODB;
38 CREATE TABLE g32(id INT PRIMARY KEY) ENGINE=INNODB;
39 CREATE TABLE g33(id INT PRIMARY KEY) ENGINE=INNODB;
40 CREATE TABLE g34(id INT PRIMARY KEY) ENGINE=INNODB;
41 CREATE TABLE g35(id INT PRIMARY KEY) ENGINE=INNODB;
42 CREATE TABLE g36(id INT PRIMARY KEY) ENGINE=INNODB;
43 CREATE TABLE g37(id INT PRIMARY KEY) ENGINE=INNODB;
44 CREATE TABLE g38(id INT PRIMARY KEY) ENGINE=INNODB;
45 CREATE TABLE g39(id INT PRIMARY KEY) ENGINE=INNODB;
46 CREATE TABLE g40(id INT PRIMARY KEY) ENGINE=INNODB;
47 CREATE TABLE g41(id INT PRIMARY KEY) ENGINE=INNODB;
48 CREATE TABLE g42(id INT PRIMARY KEY) ENGINE=INNODB;
49 CREATE TABLE g43(id INT PRIMARY KEY) ENGINE=INNODB;
50 CREATE TABLE g44(id INT PRIMARY KEY) ENGINE=INNODB;
51 CREATE TABLE g45(id INT PRIMARY KEY) ENGINE=INNODB;
52 CREATE TABLE g46(id INT PRIMARY KEY) ENGINE=INNODB;
53 CREATE TABLE g47(id INT PRIMARY KEY) ENGINE=INNODB;
54 CREATE TABLE g48(id INT PRIMARY KEY) ENGINE=INNODB;
55 CREATE TABLE g49(id INT PRIMARY KEY) ENGINE=INNODB;
56 # Open 110 connections and create a temporary table
57 # for each connection.
58 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
59 INSERT INTO t1 VALUES (1);
60 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
61 INSERT INTO t1 VALUES (1);
62 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
63 INSERT INTO t1 VALUES (1);
64 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
65 INSERT INTO t1 VALUES (1);
66 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
67 INSERT INTO t1 VALUES (1);
68 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
69 INSERT INTO t1 VALUES (1);
70 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
71 INSERT INTO t1 VALUES (1);
72 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
73 INSERT INTO t1 VALUES (1);
74 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
75 INSERT INTO t1 VALUES (1);
76 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
77 INSERT INTO t1 VALUES (1);
78 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
79 INSERT INTO t1 VALUES (1);
80 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
81 INSERT INTO t1 VALUES (1);
82 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
83 INSERT INTO t1 VALUES (1);
84 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
85 INSERT INTO t1 VALUES (1);
86 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
87 INSERT INTO t1 VALUES (1);
88 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
89 INSERT INTO t1 VALUES (1);
90 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
91 INSERT INTO t1 VALUES (1);
92 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
93 INSERT INTO t1 VALUES (1);
94 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
95 INSERT INTO t1 VALUES (1);
96 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
97 INSERT INTO t1 VALUES (1);
98 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
99 INSERT INTO t1 VALUES (1);
100 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
101 INSERT INTO t1 VALUES (1);
102 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
103 INSERT INTO t1 VALUES (1);
104 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
105 INSERT INTO t1 VALUES (1);
106 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
107 INSERT INTO t1 VALUES (1);
108 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
109 INSERT INTO t1 VALUES (1);
110 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
111 INSERT INTO t1 VALUES (1);
112 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
113 INSERT INTO t1 VALUES (1);
114 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
115 INSERT INTO t1 VALUES (1);
116 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
117 INSERT INTO t1 VALUES (1);
118 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
119 INSERT INTO t1 VALUES (1);
120 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
121 INSERT INTO t1 VALUES (1);
122 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
123 INSERT INTO t1 VALUES (1);
124 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
125 INSERT INTO t1 VALUES (1);
126 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
127 INSERT INTO t1 VALUES (1);
128 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
129 INSERT INTO t1 VALUES (1);
130 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
131 INSERT INTO t1 VALUES (1);
132 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
133 INSERT INTO t1 VALUES (1);
134 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
135 INSERT INTO t1 VALUES (1);
136 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
137 INSERT INTO t1 VALUES (1);
138 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
139 INSERT INTO t1 VALUES (1);
140 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
141 INSERT INTO t1 VALUES (1);
142 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
143 INSERT INTO t1 VALUES (1);
144 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
145 INSERT INTO t1 VALUES (1);
146 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
147 INSERT INTO t1 VALUES (1);
148 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
149 INSERT INTO t1 VALUES (1);
150 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
151 INSERT INTO t1 VALUES (1);
152 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
153 INSERT INTO t1 VALUES (1);
154 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
155 INSERT INTO t1 VALUES (1);
156 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
157 INSERT INTO t1 VALUES (1);
158 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
159 INSERT INTO t1 VALUES (1);
160 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
161 INSERT INTO t1 VALUES (1);
162 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
163 INSERT INTO t1 VALUES (1);
164 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
165 INSERT INTO t1 VALUES (1);
166 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
167 INSERT INTO t1 VALUES (1);
168 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
169 INSERT INTO t1 VALUES (1);
170 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
171 INSERT INTO t1 VALUES (1);
172 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
173 INSERT INTO t1 VALUES (1);
174 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
175 INSERT INTO t1 VALUES (1);
176 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
177 INSERT INTO t1 VALUES (1);
178 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
179 INSERT INTO t1 VALUES (1);
180 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
181 INSERT INTO t1 VALUES (1);
182 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
183 INSERT INTO t1 VALUES (1);
184 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
185 INSERT INTO t1 VALUES (1);
186 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
187 INSERT INTO t1 VALUES (1);
188 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
189 INSERT INTO t1 VALUES (1);
190 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
191 INSERT INTO t1 VALUES (1);
192 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
193 INSERT INTO t1 VALUES (1);
194 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
195 INSERT INTO t1 VALUES (1);
196 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
197 INSERT INTO t1 VALUES (1);
198 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
199 INSERT INTO t1 VALUES (1);
200 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
201 INSERT INTO t1 VALUES (1);
202 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
203 INSERT INTO t1 VALUES (1);
204 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
205 INSERT INTO t1 VALUES (1);
206 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
207 INSERT INTO t1 VALUES (1);
208 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
209 INSERT INTO t1 VALUES (1);
210 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
211 INSERT INTO t1 VALUES (1);
212 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
213 INSERT INTO t1 VALUES (1);
214 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
215 INSERT INTO t1 VALUES (1);
216 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
217 INSERT INTO t1 VALUES (1);
218 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
219 INSERT INTO t1 VALUES (1);
220 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
221 INSERT INTO t1 VALUES (1);
222 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
223 INSERT INTO t1 VALUES (1);
224 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
225 INSERT INTO t1 VALUES (1);
226 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
227 INSERT INTO t1 VALUES (1);
228 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
229 INSERT INTO t1 VALUES (1);
230 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
231 INSERT INTO t1 VALUES (1);
232 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
233 INSERT INTO t1 VALUES (1);
234 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
235 INSERT INTO t1 VALUES (1);
236 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
237 INSERT INTO t1 VALUES (1);
238 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
239 INSERT INTO t1 VALUES (1);
240 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
241 INSERT INTO t1 VALUES (1);
242 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
243 INSERT INTO t1 VALUES (1);
244 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
245 INSERT INTO t1 VALUES (1);
246 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
247 INSERT INTO t1 VALUES (1);
248 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
249 INSERT INTO t1 VALUES (1);
250 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
251 INSERT INTO t1 VALUES (1);
252 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
253 INSERT INTO t1 VALUES (1);
254 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
255 INSERT INTO t1 VALUES (1);
256 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
257 INSERT INTO t1 VALUES (1);
258 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
259 INSERT INTO t1 VALUES (1);
260 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
261 INSERT INTO t1 VALUES (1);
262 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
263 INSERT INTO t1 VALUES (1);
264 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
265 INSERT INTO t1 VALUES (1);
266 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
267 INSERT INTO t1 VALUES (1);
268 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
269 INSERT INTO t1 VALUES (1);
270 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
271 INSERT INTO t1 VALUES (1);
272 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
273 INSERT INTO t1 VALUES (1);
274 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
275 INSERT INTO t1 VALUES (1);
276 CREATE TEMPORARY TABLE t1(id INT PRIMARY KEY) ENGINE=INNODB;
277 INSERT INTO t1 VALUES (1);
278 # Insert rows in tables using multiple connections.
279 INSERT INTO g0 VALUE (0);
280 INSERT INTO g0 VALUE (1);
281 INSERT INTO g0 VALUE (2);
282 INSERT INTO g0 VALUE (3);
283 INSERT INTO g0 VALUE (4);
284 INSERT INTO g0 VALUE (5);
285 INSERT INTO g0 VALUE (6);
286 INSERT INTO g0 VALUE (7);
287 INSERT INTO g0 VALUE (8);
288 INSERT INTO g0 VALUE (9);
289 INSERT INTO g0 VALUE (10);
290 INSERT INTO g0 VALUE (11);
291 INSERT INTO g0 VALUE (12);
292 INSERT INTO g0 VALUE (13);
293 INSERT INTO g0 VALUE (14);
294 INSERT INTO g0 VALUE (15);
295 INSERT INTO g0 VALUE (16);
296 INSERT INTO g0 VALUE (17);
297 INSERT INTO g0 VALUE (18);
298 INSERT INTO g0 VALUE (19);
299 INSERT INTO g0 VALUE (20);
300 INSERT INTO g0 VALUE (21);
301 INSERT INTO g0 VALUE (22);
302 INSERT INTO g0 VALUE (23);
303 INSERT INTO g0 VALUE (24);
304 INSERT INTO g0 VALUE (25);
305 INSERT INTO g0 VALUE (26);
306 INSERT INTO g0 VALUE (27);
307 INSERT INTO g0 VALUE (28);
308 INSERT INTO g0 VALUE (29);
309 INSERT INTO g0 VALUE (30);
310 INSERT INTO g0 VALUE (31);
311 INSERT INTO g0 VALUE (32);
312 INSERT INTO g0 VALUE (33);
313 INSERT INTO g0 VALUE (34);
314 INSERT INTO g0 VALUE (35);
315 INSERT INTO g0 VALUE (36);
316 INSERT INTO g0 VALUE (37);
317 INSERT INTO g0 VALUE (38);
318 INSERT INTO g0 VALUE (39);
319 INSERT INTO g0 VALUE (40);
320 INSERT INTO g0 VALUE (41);
321 INSERT INTO g0 VALUE (42);
322 INSERT INTO g0 VALUE (43);
323 INSERT INTO g0 VALUE (44);
324 INSERT INTO g0 VALUE (45);
325 INSERT INTO g0 VALUE (46);
326 INSERT INTO g0 VALUE (47);
327 INSERT INTO g0 VALUE (48);
328 INSERT INTO g0 VALUE (49);
329 INSERT INTO g0 VALUE (50);
330 INSERT INTO g0 VALUE (51);
331 INSERT INTO g0 VALUE (52);
332 INSERT INTO g0 VALUE (53);
333 INSERT INTO g0 VALUE (54);
334 INSERT INTO g0 VALUE (55);
335 INSERT INTO g0 VALUE (56);
336 INSERT INTO g0 VALUE (57);
337 INSERT INTO g0 VALUE (58);
338 INSERT INTO g0 VALUE (59);
339 INSERT INTO g0 VALUE (60);
340 INSERT INTO g0 VALUE (61);
341 INSERT INTO g0 VALUE (62);
342 INSERT INTO g0 VALUE (63);
343 INSERT INTO g0 VALUE (64);
344 INSERT INTO g0 VALUE (65);
345 INSERT INTO g0 VALUE (66);
346 INSERT INTO g0 VALUE (67);
347 INSERT INTO g0 VALUE (68);
348 INSERT INTO g0 VALUE (69);
349 INSERT INTO g0 VALUE (70);
350 INSERT INTO g0 VALUE (71);
351 INSERT INTO g0 VALUE (72);
352 INSERT INTO g0 VALUE (73);
353 INSERT INTO g0 VALUE (74);
354 INSERT INTO g0 VALUE (75);
355 INSERT INTO g0 VALUE (76);
356 INSERT INTO g0 VALUE (77);
357 INSERT INTO g0 VALUE (78);
358 INSERT INTO g0 VALUE (79);
359 INSERT INTO g0 VALUE (80);
360 INSERT INTO g0 VALUE (81);
361 INSERT INTO g0 VALUE (82);
362 INSERT INTO g0 VALUE (83);
363 INSERT INTO g0 VALUE (84);
364 INSERT INTO g0 VALUE (85);
365 INSERT INTO g0 VALUE (86);
366 INSERT INTO g0 VALUE (87);
367 INSERT INTO g0 VALUE (88);
368 INSERT INTO g0 VALUE (89);
369 INSERT INTO g0 VALUE (90);
370 INSERT INTO g0 VALUE (91);
371 INSERT INTO g0 VALUE (92);
372 INSERT INTO g0 VALUE (93);
373 INSERT INTO g0 VALUE (94);
374 INSERT INTO g0 VALUE (95);
375 INSERT INTO g0 VALUE (96);
376 INSERT INTO g0 VALUE (97);
377 INSERT INTO g0 VALUE (98);
378 INSERT INTO g0 VALUE (99);
379 INSERT INTO g0 VALUE (100);
380 INSERT INTO g0 VALUE (101);
381 INSERT INTO g0 VALUE (102);
382 INSERT INTO g0 VALUE (103);
383 INSERT INTO g0 VALUE (104);
384 INSERT INTO g0 VALUE (105);
385 INSERT INTO g0 VALUE (106);
386 INSERT INTO g0 VALUE (107);
387 INSERT INTO g0 VALUE (108);
388 INSERT INTO g0 VALUE (109);
389 # Wait for the connections to finish inserting rows.
390 # Cleanup.
391 # Disconnect the connections.
392 CREATE TABLE connections_done(id INT PRIMARY KEY);
393 # Drop all the tables
394 DROP TABLE connections_done;
395 DROP TABLE g0;
396 DROP TABLE g1;
397 DROP TABLE g2;
398 DROP TABLE g3;
399 DROP TABLE g4;
400 DROP TABLE g5;
401 DROP TABLE g6;
402 DROP TABLE g7;
403 DROP TABLE g8;
404 DROP TABLE g9;
405 DROP TABLE g10;
406 DROP TABLE g11;
407 DROP TABLE g12;
408 DROP TABLE g13;
409 DROP TABLE g14;
410 DROP TABLE g15;
411 DROP TABLE g16;
412 DROP TABLE g17;
413 DROP TABLE g18;
414 DROP TABLE g19;
415 DROP TABLE g20;
416 DROP TABLE g21;
417 DROP TABLE g22;
418 DROP TABLE g23;
419 DROP TABLE g24;
420 DROP TABLE g25;
421 DROP TABLE g26;
422 DROP TABLE g27;
423 DROP TABLE g28;
424 DROP TABLE g29;
425 DROP TABLE g30;
426 DROP TABLE g31;
427 DROP TABLE g32;
428 DROP TABLE g33;
429 DROP TABLE g34;
430 DROP TABLE g35;
431 DROP TABLE g36;
432 DROP TABLE g37;
433 DROP TABLE g38;
434 DROP TABLE g39;
435 DROP TABLE g40;
436 DROP TABLE g41;
437 DROP TABLE g42;
438 DROP TABLE g43;
439 DROP TABLE g44;
440 DROP TABLE g45;
441 DROP TABLE g46;
442 DROP TABLE g47;
443 DROP TABLE g48;
444 DROP TABLE g49;