Debian Codegraph @

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

raw
1 #
2 # Bug#15923864 (Bug#67718):
3 # INNODB DRASTICALLY UNDER-FILLS PAGES IN CERTAIN CONDITIONS
4 #
5 CREATE TABLE t1 (a BIGINT PRIMARY KEY, b VARCHAR(4096)) ENGINE=InnoDB;
6 INSERT INTO t1 VALUES (0, REPEAT('a', 4096));
7 INSERT INTO t1 VALUES (1000, REPEAT('a', 4096));
8 INSERT INTO t1 VALUES (1001, REPEAT('a', 4096));
9 INSERT INTO t1 VALUES (1002, REPEAT('a', 4096));
10 INSERT INTO t1 VALUES (1, REPEAT('a', 4096));
11 INSERT INTO t1 VALUES (2, REPEAT('a', 4096));
12 SELECT page_number, number_records
13 FROM information_schema.innodb_sys_tablespaces s1,
14 information_schema.innodb_buffer_page s2
15 WHERE s1.space = s2.space AND name = 'test/t1'
16 AND page_type = "INDEX" ORDER BY page_number;
17 page_number number_records
18 3 2
19 4 3
20 5 3
21 INSERT INTO t1 VALUES (999, REPEAT('a', 4096));
22 SELECT page_number, number_records
23 FROM information_schema.innodb_sys_tablespaces s1,
24 information_schema.innodb_buffer_page s2
25 WHERE s1.space = s2.space AND name = 'test/t1'
26 AND page_type = "INDEX" ORDER BY page_number;
27 page_number number_records
28 3 3
29 4 3
30 5 3
31 6 1
32 INSERT INTO t1 VALUES (998, REPEAT('a', 4096));
33 SELECT page_number, number_records
34 FROM information_schema.innodb_sys_tablespaces s1,
35 information_schema.innodb_buffer_page s2
36 WHERE s1.space = s2.space AND name = 'test/t1'
37 AND page_type = "INDEX" ORDER BY page_number;
38 page_number number_records
39 3 3
40 4 3
41 5 3
42 6 2
43 INSERT INTO t1 VALUES (997, REPEAT('a', 4096));
44 SELECT page_number, number_records
45 FROM information_schema.innodb_sys_tablespaces s1,
46 information_schema.innodb_buffer_page s2
47 WHERE s1.space = s2.space AND name = 'test/t1'
48 AND page_type = "INDEX" ORDER BY page_number;
49 page_number number_records
50 3 3
51 4 3
52 5 3
53 6 3
54 DROP TABLE t1;