MOON
Server: Apache/2.2.21 (Unix) mod_ssl/2.2.21 OpenSSL/0.9.8e-fips-rhel5 mod_auth_passthrough/2.1 mod_bwlimited/1.4
System: Linux vps.panamaemb.org.sg 3.10.0-1160.80.1.vz7.191.4 #1 SMP Thu Dec 15 20:31:06 MSK 2022 x86_64
User: panama (500)
PHP: 5.2.17
Disabled: NONE
Upload Files
File: //proc/3/cwd/usr/share/mysql-test/suite/sys_vars/t/innodb_buffer_pool_dump_now_basic.test
#
# Basic test for innodb_buffer_pool_dump_now
#

-- source include/have_innodb.inc

# Check the default value
SET @orig = @@global.innodb_buffer_pool_dump_now;
SELECT @orig;

# Do the dump
SET GLOBAL innodb_buffer_pool_dump_now = ON;
# Should always be OFF
SELECT @@global.innodb_buffer_pool_dump_now;

# 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