Debian Codegraph @

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

raw
1 ############################################
2 # Variable Name: innodb_buffer_pool_dump_pct
3 # Scope: GLOBAL
4 # Access Type: Dynamic
5 # Data Type: Integer
6 # Default Value: 100
7 # Range: 1-100
8 ############################################
9
10
11 # Check the default value
12 SELECT @@global.innodb_buffer_pool_dump_pct;
13
14 # Set the valid value
15 SET GLOBAL innodb_buffer_pool_dump_pct=20;
16
17 # Check the value is 20
18 SELECT @@global.innodb_buffer_pool_dump_pct;
19
20 # Set the lower Boundary value
21 SET GLOBAL innodb_buffer_pool_dump_pct=1;
22
23 # Check the value is 1
24 SELECT @@global.innodb_buffer_pool_dump_pct;
25
26 # Set the upper boundary value
27 SET GLOBAL innodb_buffer_pool_dump_pct=100;
28
29 # Check the value is 100
30 SELECT @@global.innodb_buffer_pool_dump_pct;
31
32 # Set the beyond upper boundary value
33 SET GLOBAL innodb_buffer_pool_dump_pct=101;
34
35 # Check the value is 100
36 SELECT @@global.innodb_buffer_pool_dump_pct;
37
38 # Set the beyond lower boundary value
39 SET GLOBAL innodb_buffer_pool_dump_pct=-1;
40
41 # Check the value is 1
42 SELECT @@global.innodb_buffer_pool_dump_pct;
43
44 # Set the Default value
45 SET GLOBAL innodb_buffer_pool_dump_pct=Default;
46
47 # Check the default value
48 SELECT @@global.innodb_buffer_pool_dump_pct;
49
50 # Set with some invalid value
51 --error ER_WRONG_TYPE_FOR_VAR
52 SET GLOBAL innodb_buffer_pool_dump_pct='foo';
53
54 # Set without using Global
55 --error ER_GLOBAL_VARIABLE
56 SET innodb_buffer_pool_dump_pct=50;