diff options
author | Daniel Black <daniel.black@au.ibm.com> | 2016-12-06 16:39:23 +1100 |
---|---|---|
committer | Daniel Black <daniel@linux.vnet.ibm.com> | 2018-02-22 15:50:50 +1100 |
commit | 9b8d0d9ff997237933891174d15e5797894272c7 (patch) | |
tree | 1f5bcef11a30c98a59a9bbdb2c4f4aea5b788e0e /mysql-test/suite | |
parent | 8440e8fa9815972849c479f94631b436f6ac28f7 (diff) | |
download | mariadb-git-9b8d0d9ff997237933891174d15e5797894272c7.tar.gz |
MDEV-11455: test case for status variable innodb_buffer_pool_load_incomplete
Add innodb debug system variable, innodb_buffer_pool_load_pages_abort, to test
the behaviour of innodb_buffer_pool_load_incomplete.
(innodb_buufer_pool_dump_abort_loads.test)
Diffstat (limited to 'mysql-test/suite')
5 files changed, 253 insertions, 2 deletions
diff --git a/mysql-test/suite/sys_vars/r/innodb_buffer_pool_dump_abort_loads.result b/mysql-test/suite/sys_vars/r/innodb_buffer_pool_dump_abort_loads.result new file mode 100644 index 00000000000..1e2beea707e --- /dev/null +++ b/mysql-test/suite/sys_vars/r/innodb_buffer_pool_dump_abort_loads.result @@ -0,0 +1,95 @@ + +# innodb_buffer_pool_load_incomplete defaults 0 +SELECT variable_name, variable_value +FROM information_schema.global_status +WHERE LOWER(variable_name) = 'innodb_buffer_pool_load_incomplete'; +variable_name variable_value +INNODB_BUFFER_POOL_LOAD_INCOMPLETE OFF + +# populate with data +CREATE TABLE t1 ( +c01 blob, c02 blob, c03 blob, c04 blob, c05 blob, +c06 blob, c07 blob, c08 blob, c09 blob, c10 blob, +c11 blob, c12 blob, c13 blob, c14 blob, c15 blob, +c16 blob, c17 blob, c18 blob, c19 blob, c20 blob, +c21 blob, c22 blob, c23 blob, c24 blob, c25 blob, +c26 blob, c27 blob, c28 blob, c29 blob, c30 blob, +c31 blob, c32 blob, c33 blob, c34 blob, c35 blob, +c36 blob, c37 blob, c38 blob, c39 blob, c40 blob, +c41 blob, c42 blob, c43 blob, c44 blob, c45 blob, +c46 blob, c47 blob, c48 blob, c49 blob, c50 blob, +c51 blob, c52 blob, c53 blob, c54 blob, c55 blob, +c56 blob, c57 blob, c58 blob, c59 blob, c60 blob, +c61 blob, c62 blob, c63 blob, c64 blob +) ROW_FORMAT=dynamic; +SET @a = repeat('a', 16 * 1024); +INSERT INTO t1 VALUES (@a,@a,@a,@a,@a, +@a,@a,@a,@a,@a, +@a,@a,@a,@a,@a, +@a,@a,@a,@a,@a, +@a,@a,@a,@a,@a, +@a,@a,@a,@a,@a, +@a,@a,@a,@a,@a, +@a,@a,@a,@a,@a, +@a,@a,@a,@a,@a, +@a,@a,@a,@a,@a, +@a,@a,@a,@a,@a, +@a,@a,@a,@a,@a, +@a,@a,@a,@a +); +SET GLOBAL innodb_buffer_pool_dump_now=1; + +# Restart server + +# Abort after 16 pages +SET GLOBAL innodb_buffer_pool_load_pages_abort=16, +GLOBAL innodb_buffer_pool_load_now=1, +GLOBAL innodb_buffer_pool_dump_at_shutdown=1; +SELECT variable_name, SUBSTR(variable_value, 1, 38) as VALUE +FROM information_schema.global_status +WHERE LOWER(variable_name) IN ('innodb_buffer_pool_load_incomplete','innodb_buffer_pool_load_status') +ORDER BY variable_name; +variable_name VALUE +INNODB_BUFFER_POOL_LOAD_INCOMPLETE ON +INNODB_BUFFER_POOL_LOAD_STATUS Buffer pool(s) load aborted on request + +# Restart server + +# Load buffer pool +SET GLOBAL innodb_buffer_pool_load_now=1; + +# Should be more than previous as we didn't overwrite our save file +select count(*) > Previous_loaded as Loaded_more from information_schema.INNODB_BUFFER_PAGE WHERE PAGE_TYPE='BLOB' group by PAGE_TYPE;; +Loaded_more +1 + +# Successful, so innodb_buffer_pool_load_incomplete should be FALSE +SELECT variable_name, SUBSTR(variable_value, 1, 33) as VALUE +FROM information_schema.global_status +WHERE LOWER(variable_name) IN ('innodb_buffer_pool_load_incomplete','innodb_buffer_pool_load_status') +ORDER BY variable_name; +variable_name VALUE +INNODB_BUFFER_POOL_LOAD_INCOMPLETE OFF +INNODB_BUFFER_POOL_LOAD_STATUS Buffer pool(s) load completed at + +# innodb_buffer_pool_dump_now=1 should reset the innodb_buffer_pool_load_incomplete status +SET GLOBAL innodb_buffer_pool_dump_now=1; +SELECT variable_name, SUBSTR(variable_value, 1, 33) as VALUE +FROM information_schema.global_status +WHERE LOWER(variable_name) IN ('innodb_buffer_pool_load_incomplete', 'innodb_buffer_pool_dump_status'); +variable_name VALUE +INNODB_BUFFER_POOL_DUMP_STATUS Buffer pool(s) dump completed at +INNODB_BUFFER_POOL_LOAD_INCOMPLETE OFF + +# Restart server + +# Load buffer pool +SET GLOBAL innodb_buffer_pool_load_now=1; + +# Should be same amount +select abs(Previously_dumped - count(*)) <= 2 as Loaded_about_same_size from information_schema.INNODB_BUFFER_PAGE WHERE PAGE_TYPE='BLOB' group by PAGE_TYPE;; +Loaded_about_same_size +1 + +# Clean up +DROP TABLE t1; diff --git a/mysql-test/suite/sys_vars/r/sysvars_innodb.result b/mysql-test/suite/sys_vars/r/sysvars_innodb.result index ac0d4f27aef..ab66efb13d4 100644 --- a/mysql-test/suite/sys_vars/r/sysvars_innodb.result +++ b/mysql-test/suite/sys_vars/r/sysvars_innodb.result @@ -4,7 +4,8 @@ variable_name not in ( 'innodb_disallow_writes', # only available WITH_WSREP 'innodb_numa_interleave', # only available WITH_NUMA 'innodb_sched_priority_cleaner', # linux only -'innodb_use_native_aio') # default value depends on OS +'innodb_use_native_aio', # default value depends on OS +'innodb_buffer_pool_load_pages_abort') # debug build only, and is only for testing order by variable_name; VARIABLE_NAME INNODB_ADAPTIVE_FLUSHING SESSION_VALUE NULL diff --git a/mysql-test/suite/sys_vars/t/innodb_buffer_pool_dump_abort_loads.opt b/mysql-test/suite/sys_vars/t/innodb_buffer_pool_dump_abort_loads.opt new file mode 100644 index 00000000000..787f6ce532d --- /dev/null +++ b/mysql-test/suite/sys_vars/t/innodb_buffer_pool_dump_abort_loads.opt @@ -0,0 +1,5 @@ +--loose-default-storage-engine=innodb +--loose-innodb_buffer_pool_load_at_startup=0 +--loose-innodb_buffer_pool_dump_at_shutdown=0 +--loose-innodb-buffer-pool-size=8M +--loose-innodb-page-size=16k diff --git a/mysql-test/suite/sys_vars/t/innodb_buffer_pool_dump_abort_loads.test b/mysql-test/suite/sys_vars/t/innodb_buffer_pool_dump_abort_loads.test new file mode 100644 index 00000000000..4a4411101e2 --- /dev/null +++ b/mysql-test/suite/sys_vars/t/innodb_buffer_pool_dump_abort_loads.test @@ -0,0 +1,149 @@ +# +# MDEV-11455 - add status variable innodb_buffer_pool_load_abort +# +--source include/have_innodb.inc +--source include/have_debug.inc + +--echo +--echo # innodb_buffer_pool_load_incomplete defaults 0 +SELECT variable_name, variable_value + FROM information_schema.global_status + WHERE LOWER(variable_name) = 'innodb_buffer_pool_load_incomplete'; + +--echo +--echo # populate with data + +CREATE TABLE t1 ( +c01 blob, c02 blob, c03 blob, c04 blob, c05 blob, +c06 blob, c07 blob, c08 blob, c09 blob, c10 blob, +c11 blob, c12 blob, c13 blob, c14 blob, c15 blob, +c16 blob, c17 blob, c18 blob, c19 blob, c20 blob, +c21 blob, c22 blob, c23 blob, c24 blob, c25 blob, +c26 blob, c27 blob, c28 blob, c29 blob, c30 blob, +c31 blob, c32 blob, c33 blob, c34 blob, c35 blob, +c36 blob, c37 blob, c38 blob, c39 blob, c40 blob, +c41 blob, c42 blob, c43 blob, c44 blob, c45 blob, +c46 blob, c47 blob, c48 blob, c49 blob, c50 blob, +c51 blob, c52 blob, c53 blob, c54 blob, c55 blob, +c56 blob, c57 blob, c58 blob, c59 blob, c60 blob, +c61 blob, c62 blob, c63 blob, c64 blob +) ROW_FORMAT=dynamic; + +SET @a = repeat('a', 16 * 1024); +INSERT INTO t1 VALUES (@a,@a,@a,@a,@a, +@a,@a,@a,@a,@a, +@a,@a,@a,@a,@a, +@a,@a,@a,@a,@a, +@a,@a,@a,@a,@a, +@a,@a,@a,@a,@a, +@a,@a,@a,@a,@a, +@a,@a,@a,@a,@a, +@a,@a,@a,@a,@a, +@a,@a,@a,@a,@a, +@a,@a,@a,@a,@a, +@a,@a,@a,@a,@a, +@a,@a,@a,@a +); + +SET GLOBAL innodb_buffer_pool_dump_now=1; +# Wait for for the dump to complete +let $wait_condition = + SELECT SUBSTR(variable_value, 1, 33) = 'Buffer pool(s) dump completed at ' + FROM information_schema.global_status + WHERE LOWER(variable_name) = 'innodb_buffer_pool_dump_status'; +-- source include/wait_condition.inc + +--echo +--echo # Restart server +--source include/restart_mysqld.inc + +--echo +--echo # Abort after 16 pages +SET GLOBAL innodb_buffer_pool_load_pages_abort=16, + GLOBAL innodb_buffer_pool_load_now=1, + GLOBAL innodb_buffer_pool_dump_at_shutdown=1; + +let $wait_condition = + SELECT SUBSTR(variable_value, 1, 19) = 'Buffer pool(s) load' + FROM information_schema.global_status + WHERE LOWER(variable_name) = 'innodb_buffer_pool_load_status'; +-- source include/wait_condition.inc + +SELECT variable_name, SUBSTR(variable_value, 1, 38) as VALUE + FROM information_schema.global_status + WHERE LOWER(variable_name) IN ('innodb_buffer_pool_load_incomplete','innodb_buffer_pool_load_status') + ORDER BY variable_name; + +--let $incomplete=`select count(*) as BLOB_PAGES from information_schema.INNODB_BUFFER_PAGE WHERE PAGE_TYPE='BLOB' group by PAGE_TYPE` + +# Shouldn't dump at shutdown due to innodb_buffer_pool_load_incomplete + +--echo +--echo # Restart server +--source include/restart_mysqld.inc + +--echo +--echo # Load buffer pool +SET GLOBAL innodb_buffer_pool_load_now=1; + +# Wait for for the load to complete +let $wait_condition = + SELECT SUBSTR(variable_value, 1, 33) = 'Buffer pool(s) load completed at ' + FROM information_schema.global_status + WHERE LOWER(variable_name) = 'innodb_buffer_pool_load_status'; +-- source include/wait_condition.inc + +--echo +--echo # Should be more than previous as we didn't overwrite our save file +--replace_result $incomplete Previous_loaded +--eval select count(*) > $incomplete as Loaded_more from information_schema.INNODB_BUFFER_PAGE WHERE PAGE_TYPE='BLOB' group by PAGE_TYPE; + +--echo +--echo # Successful, so innodb_buffer_pool_load_incomplete should be FALSE +SELECT variable_name, SUBSTR(variable_value, 1, 33) as VALUE + FROM information_schema.global_status + WHERE LOWER(variable_name) IN ('innodb_buffer_pool_load_incomplete','innodb_buffer_pool_load_status') + ORDER BY variable_name; + +--echo +--echo # innodb_buffer_pool_dump_now=1 should reset the innodb_buffer_pool_load_incomplete status + +SET GLOBAL innodb_buffer_pool_dump_now=1; +# Wait for for the dump to complete +let $wait_condition = + SELECT SUBSTR(variable_value, 1, 33) = 'Buffer pool(s) dump completed at ' + FROM information_schema.global_status + WHERE LOWER(variable_name) = 'innodb_buffer_pool_dump_status'; +-- source include/wait_condition.inc + +SELECT variable_name, SUBSTR(variable_value, 1, 33) as VALUE + FROM information_schema.global_status + WHERE LOWER(variable_name) IN ('innodb_buffer_pool_load_incomplete', 'innodb_buffer_pool_dump_status'); + +--let $fulldump=`select count(*) as BLOB_PAGES from information_schema.INNODB_BUFFER_PAGE WHERE PAGE_TYPE='BLOB' group by PAGE_TYPE` + +--echo +--echo # Restart server +--source include/restart_mysqld.inc + +--echo +--echo # Load buffer pool +SET GLOBAL innodb_buffer_pool_load_now=1; + +# Wait for for the load to complete +let $wait_condition = + SELECT SUBSTR(variable_value, 1, 33) = 'Buffer pool(s) load completed at ' + FROM information_schema.global_status + WHERE LOWER(variable_name) = 'innodb_buffer_pool_load_status'; +-- source include/wait_condition.inc + +--echo +--echo # Should be same amount +--replace_result $fulldump Previously_dumped +--eval select abs($fulldump - count(*)) <= 2 as Loaded_about_same_size from information_schema.INNODB_BUFFER_PAGE WHERE PAGE_TYPE='BLOB' group by PAGE_TYPE; + +--echo +--echo # Clean up + +--remove_file $MYSQLTEST_VARDIR/mysqld.1/data/ib_buffer_pool +DROP TABLE t1; diff --git a/mysql-test/suite/sys_vars/t/sysvars_innodb.test b/mysql-test/suite/sys_vars/t/sysvars_innodb.test index 2abafda34c6..fe91835eac5 100644 --- a/mysql-test/suite/sys_vars/t/sysvars_innodb.test +++ b/mysql-test/suite/sys_vars/t/sysvars_innodb.test @@ -16,5 +16,6 @@ select * from information_schema.system_variables 'innodb_disallow_writes', # only available WITH_WSREP 'innodb_numa_interleave', # only available WITH_NUMA 'innodb_sched_priority_cleaner', # linux only - 'innodb_use_native_aio') # default value depends on OS + 'innodb_use_native_aio', # default value depends on OS + 'innodb_buffer_pool_load_pages_abort') # debug build only, and is only for testing order by variable_name; |