summaryrefslogtreecommitdiff
path: root/mysql-test/suite/sys_vars/t/innodb_buffer_pool_dump_pct_basic.test
diff options
context:
space:
mode:
authorJan Lindström <jan.lindstrom@mariadb.com>2015-12-15 09:46:53 +0200
committerJan Lindström <jan.lindstrom@mariadb.com>2015-12-15 09:46:53 +0200
commitefeb905736724f7792b4b533ca5f04425098b5d5 (patch)
tree45f45d44035d57622bbfea81a1a90463fed3d5f1 /mysql-test/suite/sys_vars/t/innodb_buffer_pool_dump_pct_basic.test
parent82bec8bfdf87b75e0a055a4739a69f5090ed699d (diff)
downloadmariadb-git-efeb905736724f7792b4b533ca5f04425098b5d5.tar.gz
Rename test files.
Diffstat (limited to 'mysql-test/suite/sys_vars/t/innodb_buffer_pool_dump_pct_basic.test')
-rw-r--r--mysql-test/suite/sys_vars/t/innodb_buffer_pool_dump_pct_basic.test34
1 files changed, 34 insertions, 0 deletions
diff --git a/mysql-test/suite/sys_vars/t/innodb_buffer_pool_dump_pct_basic.test b/mysql-test/suite/sys_vars/t/innodb_buffer_pool_dump_pct_basic.test
new file mode 100644
index 00000000000..d2f5cb4a0de
--- /dev/null
+++ b/mysql-test/suite/sys_vars/t/innodb_buffer_pool_dump_pct_basic.test
@@ -0,0 +1,34 @@
+#
+# 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;
+
+# Do the dump
+SET GLOBAL innodb_buffer_pool_dump_pct=3, GLOBAL innodb_buffer_pool_dump_now = ON;
+
+# Wait 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
+
+# Confirm that the dump file has been created
+-- let $file = `SELECT CONCAT(@@datadir, @@global.innodb_buffer_pool_filename)`
+-- file_exists $file
+
+--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;