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 #Plugin 'MEMORY' has ref_count=1 after shutdown
6 call mtr.add_suppression("Plugin \'MEMORY\'");
7
8 # Check the default value
9 SET @orig = @@global.innodb_buffer_pool_dump_at_shutdown;
10 SELECT @orig;
11
12 # Confirm that we can change the value
13 SET GLOBAL innodb_buffer_pool_dump_at_shutdown = OFF;
14 SELECT @@global.innodb_buffer_pool_dump_at_shutdown;
15 SET GLOBAL innodb_buffer_pool_dump_at_shutdown = ON;
16 SELECT @@global.innodb_buffer_pool_dump_at_shutdown;
17
18 # Check the type
19
20 -- error ER_WRONG_TYPE_FOR_VAR, ER_WRONG_VALUE_FOR_VAR
21 SET GLOBAL innodb_buffer_pool_dump_at_shutdown = 12.34;
22
23 -- error ER_WRONG_TYPE_FOR_VAR, ER_WRONG_VALUE_FOR_VAR
24 SET GLOBAL innodb_buffer_pool_dump_at_shutdown = "string";
25
26 -- error ER_WRONG_TYPE_FOR_VAR, ER_WRONG_VALUE_FOR_VAR
27 SET GLOBAL innodb_buffer_pool_dump_at_shutdown = 5;
28
29 # Confirm that the dump file is created at shutdown
30
31 -- let $file = `SELECT CONCAT(@@datadir, @@global.innodb_buffer_pool_filename)`
32
33 -- error 0,1
34 -- remove_file $file
35
36 -- error 1
37 -- file_exists $file
38
39 -- source include/restart_mysqld.inc
40
41 -- file_exists $file
42
43 SET GLOBAL innodb_buffer_pool_dump_at_shutdown = default;