Debian Codegraph @

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

raw
1 SET GLOBAL innodb_buffer_pool_dump_pct=100;
2 CREATE TABLE ib_bp_test
3 (a INT AUTO_INCREMENT, b VARCHAR(64), c TEXT, PRIMARY KEY (a), KEY (b, c(128)))
4 ENGINE=INNODB;
5 SELECT PAGE_NUMBER FROM information_schema.innodb_buffer_page_lru
6 WHERE table_name = '`test`.`ib_bp_test`';
7 PAGE_NUMBER
8 3
9 4
10 SELECT SPACE INTO @space FROM information_schema.innodb_buffer_page_lru
11 WHERE table_name = '`test`.`ib_bp_test`' AND PAGE_NUMBER=3;
12 INSERT INTO ib_bp_test
13 SELECT NULL, REPEAT('b', 64), REPEAT('c', 256) FROM seq_1_to_16382;
14 SELECT COUNT(*) FROM information_schema.innodb_buffer_page_lru
15 WHERE table_name = '`test`.`ib_bp_test`';
16 COUNT(*)
17 596
18 SET GLOBAL innodb_buffer_pool_dump_now = ON;
19 SET GLOBAL innodb_fast_shutdown=0;
20 # restart
21 SELECT PAGE_NUMBER FROM information_schema.innodb_buffer_page_lru
22 WHERE table_name = '`test`.`ib_bp_test`';
23 PAGE_NUMBER
24 select count(*) from ib_bp_test LIMIT 0;
25 count(*)
26 select variable_value into @innodb_async_reads_total_count_before
27 from information_schema.global_status
28 where variable_name='innodb_async_reads_total_count';
29 SET GLOBAL innodb_buffer_pool_load_now = ON;
30 SELECT variable_value
31 FROM information_schema.global_status
32 WHERE LOWER(variable_name) = 'innodb_buffer_pool_load_status';
33 variable_value
34 Buffer pool(s) load completed at TIMESTAMP_NOW
35 select (cast(variable_value as unsigned) >
36 cast(@innodb_async_reads_total_count_before as unsigned))
37 as async_reads_grow
38 from information_schema.global_status where variable_name='innodb_async_reads_total_count';
39 async_reads_grow
40 1
41 SELECT COUNT(*) FROM information_schema.innodb_buffer_page_lru
42 WHERE table_name = '`test`.`ib_bp_test`';
43 COUNT(*)
44 596
45 call mtr.add_suppression("InnoDB: Error parsing");
46 SET GLOBAL innodb_buffer_pool_load_now = ON;
47 # Re-write some valid pages to the dump file, make sure the space
48 # should be valid but all the page no should be out of bound of the file
49 # restart
50 SET GLOBAL innodb_buffer_pool_load_now = ON;
51 SELECT variable_value
52 FROM information_schema.global_status
53 WHERE LOWER(variable_name) = 'innodb_buffer_pool_load_status';
54 variable_value
55 Buffer pool(s) load completed at TIMESTAMP_NOW
56 DROP TABLE ib_bp_test;
57 SET GLOBAL innodb_buffer_pool_dump_pct=default;
58 #
59 # Bug#21371070 [ERROR] INNODB: CANNOT ALLOCATE 0 BYTES: SUCCESS
60 #
61 SET GLOBAL innodb_buffer_pool_load_now = ON;