Debian Codegraph @

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

raw
1 #
2 # Bug #84958 InnoDB's MVCC has O(N^2) behaviors
3 # https://bugs.mysql.com/bug.php?id=84958
4 #
5 # Set up the test with a procedure and a function.
6 #
7 CREATE PROCEDURE insert_n(start int, end int)
8 BEGIN
9 DECLARE i INT DEFAULT start;
10 WHILE i <= end do
11 INSERT INTO t1 VALUES (1, 2, 3) ON DUPLICATE KEY UPDATE c = i;
12 SET i = i + 1;
13 END WHILE;
14 END~~
15 CREATE FUNCTION num_pages_get()
16 RETURNS INT
17 BEGIN
18 DECLARE ret INT;
19 SELECT number_pages_get FROM information_schema.innodb_buffer_pool_stats INTO ret;
20 RETURN ret;
21 END~~
22 SET GLOBAL innodb_purge_stop_now = ON;
23 SET GLOBAL innodb_dict_stats_disabled_debug = ON;
24 SET GLOBAL innodb_checkpoint_disabled = ON;
25 #
26 # Create a table with one record in it and start an RR transaction
27 #
28 CREATE TABLE t1 (a INT, b INT, c INT, PRIMARY KEY(a,b), KEY (b,c));
29 BEGIN;
30 SELECT * FROM t1;
31 a b c
32 #
33 # Create 100 newer record versions in con2 and con3
34 #
35 INSERT INTO t1 VALUES (1, 2, 3) ON DUPLICATE KEY UPDATE c = NULL;
36 CALL insert_n(1, 50);;
37 CALL insert_n(51, 100);;
38 INSERT INTO t1 VALUES (1, 2, 1) ON DUPLICATE KEY UPDATE c = NULL;
39 #
40 # Connect to default and record how many pages were accessed
41 # when selecting the record using the secondary key.
42 #
43 SET @num_pages_1 = num_pages_get();
44 SELECT * FROM t1 force index (b);
45 a b c
46 SET @num_pages_2= num_pages_get();
47 SELECT @num_pages_2 - @num_pages_1 < 500;
48 @num_pages_2 - @num_pages_1 < 500
49 1
50 #
51 # Commit and show the final record.
52 #
53 SELECT * FROM t1;
54 a b c
55 SELECT * FROM t1 force index (b);
56 a b c
57 COMMIT;
58 SELECT * FROM t1 force index (b);
59 a b c
60 1 2 NULL
61 SELECT * FROM t1;
62 a b c
63 1 2 NULL
64 CHECK TABLE t1;
65 Table Op Msg_type Msg_text
66 test.t1 check status OK
67 #
68 # Cleanup
69 #
70 DROP TABLE t1;
71 DROP PROCEDURE insert_n;
72 DROP FUNCTION num_pages_get;
73 SET GLOBAL innodb_purge_stop_now = default;
74 SET GLOBAL innodb_purge_run_now = ON;
75 SET GLOBAL innodb_dict_stats_disabled_debug = default;
76 SET GLOBAL innodb_checkpoint_disabled = default;