Debian Codegraph @

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

raw
1 #
2 # Normal Case
3 #
4 set global innodb_limit_optimistic_insert_debug = 2;
5 CREATE TABLE t1 (a INT);
6 INSERT INTO t1 VALUES (10), (20), (30), (40), (50), (60), (70), (80), (90), (100);
7 SELECT COUNT(*) FROM t1;
8 COUNT(*)
9 10
10 CHECK TABLE t1;
11 Table Op Msg_type Msg_text
12 test.t1 check status OK
13 DROP TABLE t1;
14 set global innodb_limit_optimistic_insert_debug = 0;
15 #
16 # Error test case where we run out of resources while spawning threads and the worker threads exit
17 #
18 call mtr.add_suppression("\\[Warning\\] .* Resource not available to create threads for parallel scan. Falling back to single thread mode.");
19 set global innodb_limit_optimistic_insert_debug = 2;
20 set debug="+d,innodb_pread_thread_OOR";
21 CREATE TABLE t1 (a INT);
22 INSERT INTO t1 VALUES (10), (20), (30), (40), (50), (60), (70), (80), (90), (100);
23 SELECT COUNT(*) FROM t1;
24 COUNT(*)
25 10
26 CHECK TABLE t1;
27 Table Op Msg_type Msg_text
28 test.t1 check status OK
29 DROP TABLE t1;
30 set global innodb_limit_optimistic_insert_debug = 0;
31 set debug="-d,innodb_pread_thread_OOR";