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 COUNT(*) FROM information_schema.innodb_buffer_page_lru
6 WHERE table_name LIKE '%ib_bp_test%';
7 COUNT(*)
8 2
9 SELECT COUNT(*) FROM information_schema.innodb_buffer_page_lru
10 WHERE table_name LIKE '%ib_bp_test%';
11 COUNT(*)
12 {checked_valid}
13 SET GLOBAL innodb_buffer_pool_dump_now = ON;
14 # restart
15 SELECT COUNT(*) FROM information_schema.innodb_buffer_page_lru
16 WHERE table_name LIKE '%ib_bp_test%';
17 COUNT(*)
18 0
19 select count(*) from ib_bp_test where a = 1;
20 count(*)
21 1
22 SET GLOBAL innodb_buffer_pool_load_now = ON;
23 SELECT variable_value
24 FROM performance_schema.global_status
25 WHERE LOWER(variable_name) = 'innodb_buffer_pool_load_status';
26 variable_value
27 Buffer pool(s) load completed at TIMESTAMP_NOW
28 SELECT COUNT(*) FROM information_schema.innodb_buffer_page_lru
29 WHERE table_name LIKE '%ib_bp_test%';
30 COUNT(*)
31 {checked_valid}
32 call mtr.add_suppression("Error parsing");
33 SET GLOBAL innodb_buffer_pool_load_now = ON;
34 # Re-write some valid pages to the dump file, make sure the space
35 # should be valid but all the page no should be out of bound of the file
36 # restart
37 SET GLOBAL innodb_buffer_pool_load_now = ON;
38 SELECT variable_value
39 FROM performance_schema.global_status
40 WHERE LOWER(variable_name) = 'innodb_buffer_pool_load_status';
41 variable_value
42 Buffer pool(s) load completed at TIMESTAMP_NOW
43 DROP TABLE ib_bp_test;
44 SET GLOBAL innodb_buffer_pool_dump_pct=default;
45 #
46 # Bug#21371070 [ERROR] INNODB: CANNOT ALLOCATE 0 BYTES: SUCCESS
47 #
48 SET GLOBAL innodb_buffer_pool_load_now = ON;