1-- source include/have_innodb.inc
2#
3# first, ensure that we _can_ set various options without limitation
4#
5SET @TEMP=@@GLOBAL.AUTO_INCREMENT_INCREMENT;
6
7SET @@GLOBAL.AUTO_INCREMENT_INCREMENT=1;
8SELECT @@GLOBAL.AUTO_INCREMENT_INCREMENT;
9
10SET @@GLOBAL.AUTO_INCREMENT_INCREMENT=2;
11SELECT @@GLOBAL.AUTO_INCREMENT_INCREMENT;
12
13SET @@GLOBAL.AUTO_INCREMENT_INCREMENT=15;
14SELECT @@GLOBAL.AUTO_INCREMENT_INCREMENT;
15
16SET @@GLOBAL.AUTO_INCREMENT_INCREMENT=@TEMP;
17SET @TEMP=@@LOCAL.AUTO_INCREMENT_INCREMENT;
18
19SET @@LOCAL.AUTO_INCREMENT_INCREMENT=1;
20SELECT @@LOCAL.AUTO_INCREMENT_INCREMENT;
21
22SET @@LOCAL.AUTO_INCREMENT_INCREMENT=2;
23SELECT @@LOCAL.AUTO_INCREMENT_INCREMENT;
24
25SET @@LOCAL.AUTO_INCREMENT_INCREMENT=15;
26SELECT @@LOCAL.AUTO_INCREMENT_INCREMENT;
27
28SET @@LOCAL.AUTO_INCREMENT_INCREMENT=@TEMP;
29
30SET @@GLOBAL.AUTO_INCREMENT_OFFSET=5;
31
32SET @@LOCAL.AUTO_INCREMENT_OFFSET=5;
33
34SELECT @@GLOBAL.BINLOG_ROW_IMAGE;
35
36SELECT @@LOCAL.BINLOG_ROW_IMAGE;
37
38SET @@GLOBAL.BINLOG_ROW_IMAGE= MINIMAL;
39
40SET @@LOCAL.BINLOG_ROW_IMAGE= MINIMAL;
41
42SET @TEMP=@@GLOBAL.INNODB_IO_CAPACITY;
43
44SET @@GLOBAL.INNODB_IO_CAPACITY=100;
45SELECT @@GLOBAL.INNODB_IO_CAPACITY;
46
47SET @@GLOBAL.INNODB_IO_CAPACITY=300;
48SELECT @@GLOBAL.INNODB_IO_CAPACITY;
49
50SET @@GLOBAL.INNODB_IO_CAPACITY=160;
51SELECT @@GLOBAL.INNODB_IO_CAPACITY;
52
53SET @@GLOBAL.INNODB_IO_CAPACITY=@TEMP;
54
55SET @@GLOBAL.INNODB_SPIN_WAIT_DELAY=10;
56
57SET @@GLOBAL.INNODB_READ_AHEAD_THRESHOLD=32;
58
59#
60# restart the server with some options modifiers and limits
61#
62--let $restart_parameters=restart:--auto-increment-increment=7 --minimum-auto-increment-increment=5 --maximum-auto-increment-increment=10 --readonly-auto-increment-offset=TRUE --hidden-binlog-row-image=TRUE --innodb-io-capacity=150 --minimum-innodb-io-capacity=150 --maximum-innodb-io-capacity=200 --readonly-innodb-spin-wait-delay=TRUE --hidden-innodb-read-ahead-threshold=TRUE
63--source include/restart_mysqld.inc
64
65#
66# test the limits set by the above options modifiers
67#
68SET @TEMP=@@GLOBAL.AUTO_INCREMENT_INCREMENT;
69
70SET @@GLOBAL.AUTO_INCREMENT_INCREMENT=1;
71SELECT @@GLOBAL.AUTO_INCREMENT_INCREMENT;
72
73SET @@GLOBAL.AUTO_INCREMENT_INCREMENT=2;
74SELECT @@GLOBAL.AUTO_INCREMENT_INCREMENT;
75
76SET @@GLOBAL.AUTO_INCREMENT_INCREMENT=15;
77SELECT @@GLOBAL.AUTO_INCREMENT_INCREMENT;
78
79SET @@GLOBAL.AUTO_INCREMENT_INCREMENT=@TEMP;
80SET @TEMP=@@LOCAL.AUTO_INCREMENT_INCREMENT;
81
82SET @@LOCAL.AUTO_INCREMENT_INCREMENT=1;
83SELECT @@LOCAL.AUTO_INCREMENT_INCREMENT;
84
85SET @@LOCAL.AUTO_INCREMENT_INCREMENT=2;
86SELECT @@LOCAL.AUTO_INCREMENT_INCREMENT;
87
88SET @@LOCAL.AUTO_INCREMENT_INCREMENT=15;
89SELECT @@LOCAL.AUTO_INCREMENT_INCREMENT;
90
91SET @@LOCAL.AUTO_INCREMENT_INCREMENT=@TEMP;
92
93--error ER_INCORRECT_GLOBAL_LOCAL_VAR
94SET @@GLOBAL.AUTO_INCREMENT_OFFSET=5;
95
96--error ER_INCORRECT_GLOBAL_LOCAL_VAR
97SET @@LOCAL.AUTO_INCREMENT_OFFSET=5;
98
99--error ER_UNKNOWN_SYSTEM_VARIABLE
100SELECT @@GLOBAL.BINLOG_ROW_IMAGE;
101
102--error ER_UNKNOWN_SYSTEM_VARIABLE
103SELECT @@LOCAL.BINLOG_ROW_IMAGE;
104
105--error ER_UNKNOWN_SYSTEM_VARIABLE
106SET @@GLOBAL.BINLOG_ROW_IMAGE= MINIMAL;
107
108--error ER_UNKNOWN_SYSTEM_VARIABLE
109SET @@LOCAL.BINLOG_ROW_IMAGE= MINIMAL;
110
111
112SET @TEMP=@@GLOBAL.INNODB_IO_CAPACITY;
113
114SET @@GLOBAL.INNODB_IO_CAPACITY=100;
115SELECT @@GLOBAL.INNODB_IO_CAPACITY;
116
117SET @@GLOBAL.INNODB_IO_CAPACITY=300;
118SELECT @@GLOBAL.INNODB_IO_CAPACITY;
119
120SET @@GLOBAL.INNODB_IO_CAPACITY=160;
121SELECT @@GLOBAL.INNODB_IO_CAPACITY;
122
123SET @@GLOBAL.INNODB_IO_CAPACITY=@TEMP;
124
125--error ER_INCORRECT_GLOBAL_LOCAL_VAR
126SET @@GLOBAL.INNODB_SPIN_WAIT_DELAY=10;
127
128--error ER_UNKNOWN_SYSTEM_VARIABLE
129SET @@GLOBAL.INNODB_READ_AHEAD_THRESHOLD=32;
130
131#
132# Now test allowed modifier combinations
133#
134--let $restart_parameters=restart:--readonly-loose-auto-increment-offset=TRUE --hidden-loose-binlog-row-image=TRUE --readonly-loose-innodb-spin-wait-delay=TRUE --hidden-loose-innodb-read-ahead-threshold=TRUE
135--source include/restart_mysqld.inc
136
137--error ER_INCORRECT_GLOBAL_LOCAL_VAR
138SET @@GLOBAL.AUTO_INCREMENT_OFFSET=5;
139
140--error ER_INCORRECT_GLOBAL_LOCAL_VAR
141SET @@LOCAL.AUTO_INCREMENT_OFFSET=5;
142
143--error ER_UNKNOWN_SYSTEM_VARIABLE
144SELECT @@GLOBAL.BINLOG_ROW_IMAGE;
145
146--error ER_UNKNOWN_SYSTEM_VARIABLE
147SELECT @@LOCAL.BINLOG_ROW_IMAGE;
148
149--error ER_UNKNOWN_SYSTEM_VARIABLE
150SET @@GLOBAL.BINLOG_ROW_IMAGE= MINIMAL;
151
152--error ER_UNKNOWN_SYSTEM_VARIABLE
153SET @@LOCAL.BINLOG_ROW_IMAGE= MINIMAL;
154
155--error ER_INCORRECT_GLOBAL_LOCAL_VAR
156SET @@GLOBAL.INNODB_SPIN_WAIT_DELAY=10;
157
158--error ER_UNKNOWN_SYSTEM_VARIABLE
159SET @@GLOBAL.INNODB_READ_AHEAD_THRESHOLD=72;
160