Debian Codegraph @

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

raw
1 --echo #
2 --echo # Bug #84958 InnoDB's MVCC has O(N^2) behaviors
3 --echo # https://bugs.mysql.com/bug.php?id=84958
4 --echo #
5 --echo # Set up the test with a procedure and a function.
6 --echo #
7
8 --source include/have_innodb.inc
9
10 DELIMITER ~~;
11 CREATE PROCEDURE insert_n(start int, end int)
12 BEGIN
13 DECLARE i INT DEFAULT start;
14 WHILE i <= end do
15 INSERT INTO t1 VALUES (1, 2, 3) ON DUPLICATE KEY UPDATE c = i;
16 SET i = i + 1;
17 END WHILE;
18 END~~
19
20 CREATE FUNCTION num_pages_get()
21 RETURNS INT
22 BEGIN
23 DECLARE ret INT;
24 SELECT variable_value INTO ret
25 FROM information_schema.global_status
26 WHERE variable_name = 'innodb_buffer_pool_read_requests';
27 RETURN ret;
28 END~~
29 DELIMITER ;~~
30
31 --echo #
32 --echo # Create a table with one record in it and start an RR transaction
33 --echo #
34 CREATE TABLE t1 (a INT, b INT, c INT, PRIMARY KEY(a,b), KEY (b,c))
35 ENGINE=InnoDB STATS_PERSISTENT=0;
36 --source include/wait_all_purged.inc
37 BEGIN;
38 SELECT * FROM t1;
39
40 --echo #
41 --echo # Create 100 newer record versions in con2 and con3
42 --echo #
43 connect (con2, localhost, root,,);
44 connection con2;
45 BEGIN;
46 INSERT INTO t1 VALUES (1, 2, 3) ON DUPLICATE KEY UPDATE c = NULL;
47 --send CALL insert_n(1, 50);
48
49 connect (con3, localhost, root,,);
50 connection con3;
51 BEGIN;
52 --send CALL insert_n(51, 100);
53
54 connection con2;
55 reap;
56 COMMIT;
57 connection con3;
58 reap;
59 INSERT INTO t1 VALUES (1, 2, 1) ON DUPLICATE KEY UPDATE c = NULL;
60 COMMIT;
61
62 connection default;
63
64 --echo #
65 --echo # Connect to default and record how many pages were accessed
66 --echo # when selecting the record using the secondary key.
67 --echo #
68 --let $wait_all_purged=2
69 --source include/wait_all_purged.inc
70 SET @num_pages_1 = num_pages_get();
71 SELECT * FROM t1 force index (b);
72 SET @num_pages_2= num_pages_get();
73
74 SELECT IF(@num_pages_2 - @num_pages_1 < 5000, 'OK', @num_pages_2 - @num_pages_1) num_pages_diff;
75
76 --echo #
77 --echo # Commit and show the final record.
78 --echo #
79 SELECT * FROM t1;
80 SELECT * FROM t1 force index (b);
81 COMMIT;
82 SELECT * FROM t1 force index (b);
83 SELECT * FROM t1;
84 CHECK TABLE t1;
85
86 --echo #
87 --echo # Cleanup
88 --echo #
89 disconnect con2;
90 disconnect con3;
91 DROP TABLE t1;
92 DROP PROCEDURE insert_n;
93 DROP FUNCTION num_pages_get;