Debian Codegraph @

mysql-test/suite/sys_vars/t/innodb_buffer_pool_dump_at_shutdown_basic.test

raw
1 #
2 # Basic test for innodb_buffer_pool_dump_at_shutdown
3 #
4
5 -- source include/have_innodb.inc
6 # include/restart_mysqld.inc does not work in embedded mode
7 -- source include/not_embedded.inc
8 -- source include/no_valgrind_without_big.inc
9
10 # Check the default value
11 SET @orig = @@global.innodb_buffer_pool_dump_at_shutdown;
12 SELECT @orig;
13
14 # Confirm that we can change the value
15 SET GLOBAL innodb_buffer_pool_dump_at_shutdown = OFF;
16 SELECT @@global.innodb_buffer_pool_dump_at_shutdown;
17 SET GLOBAL innodb_buffer_pool_dump_at_shutdown = ON;
18 SELECT @@global.innodb_buffer_pool_dump_at_shutdown;
19
20 # Check the type
21
22 -- error ER_WRONG_TYPE_FOR_VAR, ER_WRONG_VALUE_FOR_VAR
23 SET GLOBAL innodb_buffer_pool_dump_at_shutdown = 12.34;
24
25 -- error ER_WRONG_TYPE_FOR_VAR, ER_WRONG_VALUE_FOR_VAR
26 SET GLOBAL innodb_buffer_pool_dump_at_shutdown = "string";
27
28 -- error ER_WRONG_TYPE_FOR_VAR, ER_WRONG_VALUE_FOR_VAR
29 SET GLOBAL innodb_buffer_pool_dump_at_shutdown = 5;
30
31 # Confirm that the dump file is created at shutdown
32
33 -- let $file = `SELECT CONCAT(@@datadir, @@global.innodb_buffer_pool_filename)`
34
35 -- error 0,1
36 -- remove_file $file
37
38 -- error 1
39 -- file_exists $file
40
41 -- source include/restart_mysqld.inc
42
43 -- file_exists $file
44
45 SET GLOBAL innodb_buffer_pool_dump_at_shutdown = default;