# # Basic test for innodb_buffer_pool_filename # -- source include/have_innodb.inc # Check the default value and save for later restoration SET @orig = @@global.innodb_buffer_pool_filename; SELECT @orig; let $old_val=query_get_value(SHOW STATUS LIKE 'innodb_buffer_pool_dump_status', Value, 1); sleep 1; # to ensure that the previous and the next dumps are at least a second apart # Try with a non-default filename SET GLOBAL innodb_buffer_pool_filename = 'innodb_foobar_dump'; SET GLOBAL innodb_buffer_pool_dump_now = ON; -- let $file = `SELECT CONCAT(@@datadir, @@global.innodb_buffer_pool_filename)` # Wait for the dump to complete let $wait_condition = SELECT variable_value LIKE 'Buffer pool(s) dump completed at %' AND variable_value <> '$old_val' FROM information_schema.global_status WHERE variable_name = 'innodb_buffer_pool_dump_status'; -- source include/wait_condition.inc -- file_exists $file # Restore the env SET GLOBAL innodb_buffer_pool_filename = @orig;