57 lines
2.0 KiB
Plaintext
57 lines
2.0 KiB
Plaintext
SET GLOBAL innodb_buffer_pool_dump_pct=100;
|
|
CREATE TABLE ib_bp_test
|
|
(a INT AUTO_INCREMENT, b VARCHAR(64), c TEXT, PRIMARY KEY (a), KEY (b, c(128)))
|
|
ENGINE=INNODB;
|
|
SELECT COUNT(*) FROM information_schema.innodb_buffer_page_lru
|
|
WHERE table_name LIKE '%ib_bp_test%';
|
|
COUNT(*)
|
|
2
|
|
SELECT COUNT(*) FROM information_schema.innodb_buffer_page_lru
|
|
WHERE table_name LIKE '%ib_bp_test%';
|
|
COUNT(*)
|
|
355
|
|
# restart
|
|
SELECT variable_value
|
|
FROM performance_schema.global_status
|
|
WHERE LOWER(variable_name) = 'innodb_buffer_pool_load_status';
|
|
variable_value
|
|
Buffer pool load completed or still running
|
|
SELECT COUNT(*) FROM information_schema.innodb_buffer_page_lru
|
|
WHERE table_name LIKE '%ib_bp_test%';
|
|
COUNT(*)
|
|
0
|
|
call mtr.add_suppression("Error parsing");
|
|
# restart
|
|
# Re-write some valid pages to the dump file, make sure the space
|
|
# should be valid but all the page no should be out of bound of the file
|
|
# restart
|
|
SELECT variable_value
|
|
FROM performance_schema.global_status
|
|
WHERE LOWER(variable_name) = 'innodb_buffer_pool_load_status';
|
|
variable_value
|
|
Buffer pool load completed or still running
|
|
DROP TABLE ib_bp_test;
|
|
SET GLOBAL innodb_buffer_pool_dump_pct=default;
|
|
#
|
|
# Bug#22016556 INNODB LOOKS FOR BUFFER POOL FILE NAME IN '/' IF
|
|
# INNODB_DATA_HOME_DIR IS EMPTY
|
|
#
|
|
# restart: --innodb-data-home-dir= --innodb_data_file_path=MYSQL_TMP_DIR/datadir1/ibdata:16M:autoextend --datadir=MYSQLD_DATADIR1 --innodb_log_file_size=15M --innodb_log_files_in_group=2
|
|
CREATE TABLE t1 (a int) ENGINE=innodb;
|
|
INSERT INTO t1 VALUES (1), (2), (3);
|
|
SET GLOBAL innodb_buffer_pool_dump_now=ON;
|
|
SELECT variable_value
|
|
FROM performance_schema.global_status
|
|
WHERE LOWER(variable_name) = 'innodb_buffer_pool_dump_status';
|
|
variable_value
|
|
Buffer pool(s) dump completed at TIMESTAMP_NOW
|
|
SET GLOBAL innodb_buffer_pool_load_now = ON;
|
|
SELECT variable_value
|
|
FROM performance_schema.global_status
|
|
WHERE LOWER(variable_name) = 'innodb_buffer_pool_load_status';
|
|
variable_value
|
|
Buffer pool load completed or still running
|
|
DROP TABLE t1;
|
|
DROP DATABASE test;
|
|
# restart
|