1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
|
#
# Basic test for innodb_buffer_pool_dump_pct
#
-- source include/have_innodb.inc
# Check the default value
SET @orig = @@global.innodb_buffer_pool_dump_pct;
SELECT @orig;
SET GLOBAL innodb_buffer_pool_dump_pct=3;
--echo # Do the dump
--disable_query_log
--disable_result_log
--source innodb_buffer_pool_dump_now_basic.test
--enable_result_log
--enable_query_log
--disable_warnings
SET GLOBAL innodb_buffer_pool_dump_pct=0;
SELECT @@global.innodb_buffer_pool_dump_pct;
SHOW WARNINGS;
SET GLOBAL innodb_buffer_pool_dump_pct=101;
SELECT @@global.innodb_buffer_pool_dump_pct;
SHOW WARNINGS;
--enable_warnings
SET GLOBAL innodb_buffer_pool_dump_pct=@orig;
|