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_debug.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 number_pages_get FROM information_schema.innodb_buffer_pool_stats INTO ret;
25 RETURN ret;
26 END~~
27 DELIMITER ;~~
28
29 # Stop threads from interfering in the test
30 SET GLOBAL innodb_purge_stop_now = ON;
31 SET GLOBAL innodb_dict_stats_disabled_debug = ON;
32 SET GLOBAL innodb_checkpoint_disabled = ON;
33
34 --echo #
35 --echo # Create a table with one record in it and start an RR transaction
36 --echo #
37 CREATE TABLE t1 (a INT, b INT, c INT, PRIMARY KEY(a,b), KEY (b,c));
38 BEGIN;
39 SELECT * FROM t1;
40
41 --echo #
42 --echo # Create 100 newer record versions in con2 and con3
43 --echo #
44 connect (con2, localhost, root,,);
45 connection con2;
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 --send CALL insert_n(51, 100);
52
53 connection con2;
54 reap;
55 connection con3;
56 reap;
57 INSERT INTO t1 VALUES (1, 2, 1) ON DUPLICATE KEY UPDATE c = NULL;
58
59 connection default;
60
61 --echo #
62 --echo # Connect to default and record how many pages were accessed
63 --echo # when selecting the record using the secondary key.
64 --echo #
65 SET @num_pages_1 = num_pages_get();
66 SELECT * FROM t1 force index (b);
67 SET @num_pages_2= num_pages_get();
68
69 SELECT @num_pages_2 - @num_pages_1 < 500;
70
71 --echo #
72 --echo # Commit and show the final record.
73 --echo #
74 SELECT * FROM t1;
75 SELECT * FROM t1 force index (b);
76 COMMIT;
77 SELECT * FROM t1 force index (b);
78 SELECT * FROM t1;
79 CHECK TABLE t1;
80
81 --echo #
82 --echo # Cleanup
83 --echo #
84 disconnect con2;
85 disconnect con3;
86 DROP TABLE t1;
87 DROP PROCEDURE insert_n;
88 DROP FUNCTION num_pages_get;
89 # Restore values
90 SET GLOBAL innodb_purge_stop_now = default;
91 # Force the purge thread to run
92 SET GLOBAL innodb_purge_run_now = ON;
93 SET GLOBAL innodb_dict_stats_disabled_debug = default;
94 SET GLOBAL innodb_checkpoint_disabled = default;
95