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 SET GLOBAL innodb_file_per_table=ON;
6 CREATE TABLE t1 (a BIGINT PRIMARY KEY, b VARCHAR(4096)) ENGINE=InnoDB;
7 INSERT INTO t1 VALUES (0, REPEAT('a', 4096));
8 INSERT INTO t1 VALUES (1000, REPEAT('a', 4096));
9 INSERT INTO t1 VALUES (1001, REPEAT('a', 4096));
10 INSERT INTO t1 VALUES (1002, REPEAT('a', 4096));
11 INSERT INTO t1 VALUES (1, REPEAT('a', 4096));
12 INSERT INTO t1 VALUES (2, REPEAT('a', 4096));
13 SELECT page_number, number_records
14 FROM information_schema.innodb_tablespaces s1,
15 information_schema.innodb_buffer_page s2,
16 information_schema.innodb_tables s3
17 WHERE s1.space = s2.space AND s3.name = 'test/t1'
18 AND page_type = "INDEX" AND s1.space = s3.space
19 ORDER BY page_number;
20 page_number number_records
21 4 2
22 5 3
23 6 3
24 INSERT INTO t1 VALUES (999, REPEAT('a', 4096));
25 SELECT page_number, number_records
26 FROM information_schema.innodb_tablespaces s1,
27 information_schema.innodb_buffer_page s2,
28 information_schema.innodb_tables s3
29 WHERE s1.space = s2.space AND s3.name = 'test/t1'
30 AND page_type = "INDEX" AND s1.space = s3.space
31 ORDER BY page_number;
32 page_number number_records
33 4 3
34 5 3
35 6 3
36 7 1
37 INSERT INTO t1 VALUES (998, REPEAT('a', 4096));
38 SELECT page_number, number_records
39 FROM information_schema.innodb_tablespaces s1,
40 information_schema.innodb_buffer_page s2,
41 information_schema.innodb_tables s3
42 WHERE s1.space = s2.space AND s3.name = 'test/t1'
43 AND page_type = "INDEX" AND s1.space = s3.space
44 ORDER BY page_number;
45 page_number number_records
46 4 3
47 5 3
48 6 3
49 7 2
50 INSERT INTO t1 VALUES (997, REPEAT('a', 4096));
51 SELECT page_number, number_records
52 FROM information_schema.innodb_tablespaces s1,
53 information_schema.innodb_buffer_page s2,
54 information_schema.innodb_tables s3
55 WHERE s1.space = s2.space AND s3.name = 'test/t1'
56 AND page_type = "INDEX" AND s1.space = s3.space
57 ORDER BY page_number;
58 page_number number_records
59 4 3
60 5 3
61 6 3
62 7 3
63 DROP TABLE t1;