Debian Codegraph @

mysql-test/suite/innodb/t/parallel_read.test

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