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 -- source include/have_innodb.inc
11
12 # Save the default value
13 SET @orig = @@global.innodb_buffer_pool_dump_pct;
14 SELECT @orig;
15
16 SET GLOBAL innodb_buffer_pool_dump_pct=3;
17
18 --echo # Do the dump
19
20 --disable_query_log
21 --disable_result_log
22 --source innodb_buffer_pool_dump_now_basic.test
23 --enable_result_log
24 --enable_query_log
25
26 # Set the valid value
27 SET GLOBAL innodb_buffer_pool_dump_pct=20;
28
29 # Check the value is 20
30 SELECT @@global.innodb_buffer_pool_dump_pct;
31
32 # Set the lower Boundary value
33 SET GLOBAL innodb_buffer_pool_dump_pct=1;
34
35 # Check the value is 1
36 SELECT @@global.innodb_buffer_pool_dump_pct;
37
38 # Set the upper boundary value
39 SET GLOBAL innodb_buffer_pool_dump_pct=100;
40
41 # Check the value is 100
42 SELECT @@global.innodb_buffer_pool_dump_pct;
43
44 # Set the beyond upper boundary value
45 SET GLOBAL innodb_buffer_pool_dump_pct=101;
46
47 # Check the value is 100
48 SELECT @@global.innodb_buffer_pool_dump_pct;
49
50 # Set the beyond lower boundary value
51 SET GLOBAL innodb_buffer_pool_dump_pct=-1;
52
53 # Check the value is 1
54 SELECT @@global.innodb_buffer_pool_dump_pct;
55
56 # Set the Default value
57 SET GLOBAL innodb_buffer_pool_dump_pct=Default;
58
59 # Check the default value
60 SELECT @@global.innodb_buffer_pool_dump_pct;
61
62 # Set with some invalid value
63 --error ER_WRONG_TYPE_FOR_VAR
64 SET GLOBAL innodb_buffer_pool_dump_pct='foo';
65
66 # Set without using Global
67 --error ER_GLOBAL_VARIABLE
68 SET innodb_buffer_pool_dump_pct=50;
69
70 # Restore original value
71 SET GLOBAL innodb_buffer_pool_dump_pct=@orig;