Debian Codegraph @

mysql-test/suite/innodb/r/innodb_buffer_pool_load.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 # restart
14 SELECT variable_value
15 FROM performance_schema.global_status
16 WHERE LOWER(variable_name) = 'innodb_buffer_pool_load_status';
17 variable_value
18 Buffer pool load completed or still running
19 SELECT COUNT(*) FROM information_schema.innodb_buffer_page_lru
20 WHERE table_name LIKE '%ib_bp_test%';
21 COUNT(*)
22 0
23 call mtr.add_suppression("Error parsing");
24 # restart
25 # Re-write some valid pages to the dump file, make sure the space
26 # should be valid but all the page no should be out of bound of the file
27 # restart
28 SELECT variable_value
29 FROM performance_schema.global_status
30 WHERE LOWER(variable_name) = 'innodb_buffer_pool_load_status';
31 variable_value
32 Buffer pool load completed or still running
33 DROP TABLE ib_bp_test;
34 SET GLOBAL innodb_buffer_pool_dump_pct=default;
35 #
36 # Bug#22016556 INNODB LOOKS FOR BUFFER POOL FILE NAME IN '/' IF
37 # INNODB_DATA_HOME_DIR IS EMPTY
38 #
39 # restart: --innodb-data-home-dir= --innodb_data_file_path=MYSQL_TMP_DIR/datadir1/ibdata:16M:autoextend --datadir=MYSQLD_DATADIR1 --innodb_redo_log_capacity=30M
40 CREATE TABLE t1 (a int) ENGINE=innodb;
41 INSERT INTO t1 VALUES (1), (2), (3);
42 SET GLOBAL innodb_buffer_pool_dump_now=ON;
43 SELECT variable_value
44 FROM performance_schema.global_status
45 WHERE LOWER(variable_name) = 'innodb_buffer_pool_dump_status';
46 variable_value
47 Buffer pool(s) dump completed at TIMESTAMP_NOW
48 SET GLOBAL innodb_buffer_pool_load_now = ON;
49 SELECT variable_value
50 FROM performance_schema.global_status
51 WHERE LOWER(variable_name) = 'innodb_buffer_pool_load_status';
52 variable_value
53 Buffer pool load completed or still running
54 DROP TABLE t1;
55 DROP DATABASE test;
56 # restart