Debian Codegraph @

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

raw
1 #####################################################################
2 # 1. Prepare
3 #####################################################################
4 # Create a normal table
5 CREATE TABLE t1(
6 class INT,
7 id INT,
8 title VARCHAR(100),
9 PRIMARY KEY(class)
10 ) ENGINE=InnoDB;
11 # Create a partition table
12 CREATE TABLE t2(
13 class INT,
14 id INT,
15 title VARCHAR(100),
16 PRIMARY KEY(class)
17 ) ENGINE=InnoDB
18 PARTITION BY RANGE(class) (
19 PARTITION p0 VALUES LESS THAN (5000),
20 PARTITION p1 VALUES LESS THAN (10000),
21 PARTITION p2 VALUES LESS THAN (15000));
22 # Create a procedure to insert data
23 CREATE PROCEDURE populate_t1_t2()
24 BEGIN
25 DECLARE i int DEFAULT 1;
26 START TRANSACTION;
27 WHILE (i <= 1000) DO
28 INSERT INTO t1 VALUES (i, i, CONCAT('a', i));
29 INSERT INTO t2 VALUES (i, i, CONCAT('a', i));
30 SET i = i + 1;
31 END WHILE;
32 COMMIT;
33 END |
34 # Create a procedure to repeat execute 'select count(*) from partition table'
35 CREATE PROCEDURE select_count_partition_table()
36 BEGIN
37 DECLARE i int DEFAULT 1;
38 WHILE (i <= 256) DO
39 SELECT COUNT(*) FROM t2;
40 SET i = i + 1;
41 END WHILE;
42 END |
43 # Load data
44 CALL populate_t1_t2();
45 #####################################################################
46 # 2. Repeat sql 'select count(*) from t2;' for 256 times.
47 #####################################################################
48 SET SESSION innodb_parallel_read_threads = 1;
49 CALL select_count_partition_table();
50 #######################################################################
51 # 3. Parallel read will degrade to single thread read before this patch
52 #######################################################################
53 SET SESSION innodb_parallel_read_threads = 16;
54 SET GLOBAL DEBUG="+d,ib_die_if_not_parallel_read";
55 SELECT COUNT(*) FROM t1;
56 COUNT(*)
57 1000
58 SELECT COUNT(*) FROM t2;
59 COUNT(*)
60 1000
61 SET GLOBAL DEBUG="-d,ib_die_if_not_parallel_read";
62 #####################################################################
63 # 4. Cleanup
64 #####################################################################
65 DROP PROCEDURE populate_t1_t2;
66 DROP PROCEDURE select_count_partition_table;
67 DROP TABLE t1;
68 DROP TABLE t2;