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
31
32
|
#
# 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;
|
