Debian Codegraph @

mysql-test/suite/sys_vars/r/sysvars_innodb,32bit.rdiff

raw
1 --- a/mysql-test/suite/sys_vars/r/sysvars_innodb.result
2 +++ b/mysql-test/suite/sys_vars/r/sysvars_innodb.result
3 @@ -52,7 +52,7 @@
4 VARIABLE_TYPE INT UNSIGNED
5 VARIABLE_COMMENT Number of adaptive hash table cells in each partition; 16381 at start defaults to being derived from innodb_buffer_pool_size
6 NUMERIC_MIN_VALUE 16381
7 -NUMERIC_MAX_VALUE 4294967295
8 +NUMERIC_MAX_VALUE 1073741823
9 NUMERIC_BLOCK_SIZE 0
10 ENUM_VALUE_LIST NULL
11 READ_ONLY NO
12 @@ -61,7 +61,7 @@
13 SESSION_VALUE NULL
14 DEFAULT_VALUE 8
15 VARIABLE_SCOPE GLOBAL
16 -VARIABLE_TYPE BIGINT UNSIGNED
17 +VARIABLE_TYPE INT UNSIGNED
18 VARIABLE_COMMENT Number of InnoDB Adaptive Hash Index Partitions (default 8)
19 NUMERIC_MIN_VALUE 1
20 NUMERIC_MAX_VALUE 512
21 @@ -97,7 +97,7 @@
22 SESSION_VALUE NULL
23 DEFAULT_VALUE 1
24 VARIABLE_SCOPE GLOBAL
25 -VARIABLE_TYPE BIGINT
26 +VARIABLE_TYPE INT
27 VARIABLE_COMMENT The AUTOINC lock modes supported by InnoDB: 0 => Old style AUTOINC locking (for backward compatibility); 1 => New style AUTOINC locking; 2 => No AUTOINC locking (unsafe for SBR)
28 NUMERIC_MIN_VALUE 0
29 NUMERIC_MAX_VALUE 2
30 @@ -109,10 +109,10 @@
31 SESSION_VALUE NULL
32 DEFAULT_VALUE 0
33 VARIABLE_SCOPE GLOBAL
34 -VARIABLE_TYPE BIGINT UNSIGNED
35 +VARIABLE_TYPE INT UNSIGNED
36 VARIABLE_COMMENT Deprecated parameter with no effect
37 NUMERIC_MIN_VALUE 0
38 -NUMERIC_MAX_VALUE 18446744073709551615
39 +NUMERIC_MAX_VALUE 4294967295
40 NUMERIC_BLOCK_SIZE 1048576
41 ENUM_VALUE_LIST NULL
42 READ_ONLY YES
43 @@ -145,7 +145,7 @@
44 SESSION_VALUE NULL
45 DEFAULT_VALUE 25
46 VARIABLE_SCOPE GLOBAL
47 -VARIABLE_TYPE BIGINT UNSIGNED
48 +VARIABLE_TYPE INT UNSIGNED
49 VARIABLE_COMMENT Dump only the hottest N% of each buffer pool, defaults to 25
50 NUMERIC_MIN_VALUE 1
51 NUMERIC_MAX_VALUE 100
52 @@ -217,10 +217,10 @@
53 SESSION_VALUE NULL
54 DEFAULT_VALUE 134217728
55 VARIABLE_SCOPE GLOBAL
56 -VARIABLE_TYPE BIGINT UNSIGNED
57 +VARIABLE_TYPE INT UNSIGNED
58 VARIABLE_COMMENT The size of the memory buffer InnoDB uses to cache data and indexes of its tables
59 NUMERIC_MIN_VALUE 2097152
60 -NUMERIC_MAX_VALUE 18446744073701163008
61 +NUMERIC_MAX_VALUE 4292870144
62 NUMERIC_BLOCK_SIZE 1048576
63 ENUM_VALUE_LIST NULL
64 READ_ONLY NO
65 @@ -229,11 +229,11 @@
66 SESSION_VALUE NULL
67 DEFAULT_VALUE 0
68 VARIABLE_SCOPE GLOBAL
69 -VARIABLE_TYPE BIGINT UNSIGNED
70 +VARIABLE_TYPE INT UNSIGNED
71 VARIABLE_COMMENT Minimum innodb_buffer_pool_size for dynamic shrinking on memory pressure
72 NUMERIC_MIN_VALUE 0
73 -NUMERIC_MAX_VALUE 18446744073701163008
74 -NUMERIC_BLOCK_SIZE 8388608
75 +NUMERIC_MAX_VALUE 4292870144
76 +NUMERIC_BLOCK_SIZE 2097152
77 ENUM_VALUE_LIST NULL
78 READ_ONLY NO
79 COMMAND_LINE_ARGUMENT REQUIRED
80 @@ -241,7 +241,7 @@
81 SESSION_VALUE NULL
82 DEFAULT_VALUE 0
83 VARIABLE_SCOPE GLOBAL
84 -VARIABLE_TYPE BIGINT UNSIGNED
85 +VARIABLE_TYPE INT UNSIGNED
86 VARIABLE_COMMENT A number that tells how often buffer pool dump status in percentages should be printed. E.g. 10 means that buffer pool dump status is printed when every 10% of number of buffer pool pages are dumped. Default is 0 (only start and end status is printed)
87 NUMERIC_MIN_VALUE 0
88 NUMERIC_MAX_VALUE 100
89 @@ -313,7 +313,7 @@
90 SESSION_VALUE NULL
91 DEFAULT_VALUE 5
92 VARIABLE_SCOPE GLOBAL
93 -VARIABLE_TYPE BIGINT UNSIGNED
94 +VARIABLE_TYPE INT UNSIGNED
95 VARIABLE_COMMENT If the compression failure rate of a table is greater than this number more padding is added to the pages to reduce the failures. A value of zero implies no padding
96 NUMERIC_MIN_VALUE 0
97 NUMERIC_MAX_VALUE 100
98 @@ -337,7 +337,7 @@
99 SESSION_VALUE NULL
100 DEFAULT_VALUE 50
101 VARIABLE_SCOPE GLOBAL
102 -VARIABLE_TYPE BIGINT UNSIGNED
103 +VARIABLE_TYPE INT UNSIGNED
104 VARIABLE_COMMENT Percentage of empty space on a data page that can be reserved to make the page compressible
105 NUMERIC_MIN_VALUE 0
106 NUMERIC_MAX_VALUE 75
107 @@ -577,7 +577,7 @@
108 SESSION_VALUE NULL
109 DEFAULT_VALUE 600
110 VARIABLE_SCOPE GLOBAL
111 -VARIABLE_TYPE BIGINT UNSIGNED
112 +VARIABLE_TYPE INT UNSIGNED
113 VARIABLE_COMMENT Maximum number of seconds that semaphore times out in InnoDB
114 NUMERIC_MIN_VALUE 1
115 NUMERIC_MAX_VALUE 4294967295
116 @@ -625,7 +625,7 @@
117 SESSION_VALUE NULL
118 DEFAULT_VALUE 30
119 VARIABLE_SCOPE GLOBAL
120 -VARIABLE_TYPE BIGINT UNSIGNED
121 +VARIABLE_TYPE INT UNSIGNED
122 VARIABLE_COMMENT Number of iterations over which the background flushing is averaged
123 NUMERIC_MIN_VALUE 1
124 NUMERIC_MAX_VALUE 1000
125 @@ -649,7 +649,7 @@
126 SESSION_VALUE NULL
127 DEFAULT_VALUE 1
128 VARIABLE_SCOPE GLOBAL
129 -VARIABLE_TYPE BIGINT UNSIGNED
130 +VARIABLE_TYPE INT UNSIGNED
131 VARIABLE_COMMENT Controls the durability/speed trade-off for commits. Set to 0 (write and flush redo log to disk only once per second), 1 (flush to disk at each commit), 2 (write to log at commit but flush to disk only once per second) or 3 (flush to disk at prepare and at commit, slower and usually redundant). 1 and 3 guarantees that after a crash, committed transactions will not be lost and will be consistent with the binlog and other transactional engines. 2 can get inconsistent and lose transactions if there is a power failure or kernel crash but not if mysqld crashes. 0 has no guarantees in case of crash. 0 and 2 can be faster than 1 or 3
132 NUMERIC_MIN_VALUE 0
133 NUMERIC_MAX_VALUE 3
134 @@ -673,7 +673,7 @@
135 SESSION_VALUE NULL
136 DEFAULT_VALUE 1
137 VARIABLE_SCOPE GLOBAL
138 -VARIABLE_TYPE BIGINT UNSIGNED
139 +VARIABLE_TYPE INT UNSIGNED
140 VARIABLE_COMMENT Set to 0 (don't flush neighbors from buffer pool), 1 (flush contiguous neighbors from buffer pool) or 2 (flush neighbors from buffer pool), when flushing a block
141 NUMERIC_MIN_VALUE 0
142 NUMERIC_MAX_VALUE 2
143 @@ -709,7 +709,7 @@
144 SESSION_VALUE NULL
145 DEFAULT_VALUE 0
146 VARIABLE_SCOPE GLOBAL
147 -VARIABLE_TYPE BIGINT UNSIGNED
148 +VARIABLE_TYPE INT UNSIGNED
149 VARIABLE_COMMENT Helps to save your data in case the disk image of the database becomes corrupt. Value 5 can return bogus data, and 6 can permanently corrupt data
150 NUMERIC_MIN_VALUE 0
151 NUMERIC_MAX_VALUE 6
152 @@ -733,10 +733,10 @@
153 SESSION_VALUE NULL
154 DEFAULT_VALUE 8000000
155 VARIABLE_SCOPE GLOBAL
156 -VARIABLE_TYPE BIGINT UNSIGNED
157 +VARIABLE_TYPE INT UNSIGNED
158 VARIABLE_COMMENT InnoDB Fulltext search cache size in bytes
159 NUMERIC_MIN_VALUE 1600000
160 -NUMERIC_MAX_VALUE 1099511627776
161 +NUMERIC_MAX_VALUE 536870912
162 NUMERIC_BLOCK_SIZE 0
163 ENUM_VALUE_LIST NULL
164 READ_ONLY NO
165 @@ -769,7 +769,7 @@
166 SESSION_VALUE NULL
167 DEFAULT_VALUE 84
168 VARIABLE_SCOPE GLOBAL
169 -VARIABLE_TYPE BIGINT UNSIGNED
170 +VARIABLE_TYPE INT UNSIGNED
171 VARIABLE_COMMENT InnoDB Fulltext search maximum token size in characters
172 NUMERIC_MIN_VALUE 10
173 NUMERIC_MAX_VALUE 84
174 @@ -781,7 +781,7 @@
175 SESSION_VALUE NULL
176 DEFAULT_VALUE 3
177 VARIABLE_SCOPE GLOBAL
178 -VARIABLE_TYPE BIGINT UNSIGNED
179 +VARIABLE_TYPE INT UNSIGNED
180 VARIABLE_COMMENT InnoDB Fulltext search minimum token size in characters
181 NUMERIC_MIN_VALUE 1
182 NUMERIC_MAX_VALUE 16
183 @@ -793,7 +793,7 @@
184 SESSION_VALUE NULL
185 DEFAULT_VALUE 2000
186 VARIABLE_SCOPE GLOBAL
187 -VARIABLE_TYPE BIGINT UNSIGNED
188 +VARIABLE_TYPE INT UNSIGNED
189 VARIABLE_COMMENT InnoDB Fulltext search number of words to optimize for each optimize table call
190 NUMERIC_MIN_VALUE 1000
191 NUMERIC_MAX_VALUE 10000
192 @@ -805,10 +805,10 @@
193 SESSION_VALUE NULL
194 DEFAULT_VALUE 2000000000
195 VARIABLE_SCOPE GLOBAL
196 -VARIABLE_TYPE BIGINT UNSIGNED
197 +VARIABLE_TYPE INT UNSIGNED
198 VARIABLE_COMMENT InnoDB Fulltext search query result cache limit in bytes
199 NUMERIC_MIN_VALUE 1000000
200 -NUMERIC_MAX_VALUE 18446744073709551615
201 +NUMERIC_MAX_VALUE 4294967295
202 NUMERIC_BLOCK_SIZE 0
203 ENUM_VALUE_LIST NULL
204 READ_ONLY NO
205 @@ -829,7 +829,7 @@
206 SESSION_VALUE NULL
207 DEFAULT_VALUE 2
208 VARIABLE_SCOPE GLOBAL
209 -VARIABLE_TYPE BIGINT UNSIGNED
210 +VARIABLE_TYPE INT UNSIGNED
211 VARIABLE_COMMENT InnoDB Fulltext search parallel sort degree, will round up to nearest power of 2 number
212 NUMERIC_MIN_VALUE 1
213 NUMERIC_MAX_VALUE 16
214 @@ -841,10 +841,10 @@
215 SESSION_VALUE NULL
216 DEFAULT_VALUE 640000000
217 VARIABLE_SCOPE GLOBAL
218 -VARIABLE_TYPE BIGINT UNSIGNED
219 +VARIABLE_TYPE INT UNSIGNED
220 VARIABLE_COMMENT Total memory allocated for InnoDB Fulltext Search cache
221 NUMERIC_MIN_VALUE 32000000
222 -NUMERIC_MAX_VALUE 1099511627776
223 +NUMERIC_MAX_VALUE 1600000000
224 NUMERIC_BLOCK_SIZE 0
225 ENUM_VALUE_LIST NULL
226 READ_ONLY NO
227 @@ -889,7 +889,7 @@
228 SESSION_VALUE NULL
229 DEFAULT_VALUE 200
230 VARIABLE_SCOPE GLOBAL
231 -VARIABLE_TYPE BIGINT UNSIGNED
232 +VARIABLE_TYPE INT UNSIGNED
233 VARIABLE_COMMENT Number of IOPs the server can do. Tunes the background IO rate
234 NUMERIC_MIN_VALUE 100
235 NUMERIC_MAX_VALUE 4294967295
236 @@ -901,7 +901,7 @@
237 SESSION_VALUE NULL
238 DEFAULT_VALUE 4294967295
239 VARIABLE_SCOPE GLOBAL
240 -VARIABLE_TYPE BIGINT UNSIGNED
241 +VARIABLE_TYPE INT UNSIGNED
242 VARIABLE_COMMENT Limit to which innodb_io_capacity can be inflated
243 NUMERIC_MIN_VALUE 100
244 NUMERIC_MAX_VALUE 4294967295
245 @@ -1033,10 +1033,10 @@
246 SESSION_VALUE NULL
247 DEFAULT_VALUE 32
248 VARIABLE_SCOPE GLOBAL
249 -VARIABLE_TYPE BIGINT UNSIGNED
250 +VARIABLE_TYPE INT UNSIGNED
251 VARIABLE_COMMENT Unused
252 NUMERIC_MIN_VALUE 1
253 -NUMERIC_MAX_VALUE 18446744073709551615
254 +NUMERIC_MAX_VALUE 4294967295
255 NUMERIC_BLOCK_SIZE 0
256 ENUM_VALUE_LIST NULL
257 READ_ONLY NO
258 @@ -1045,10 +1045,10 @@
259 SESSION_VALUE NULL
260 DEFAULT_VALUE 1536
261 VARIABLE_SCOPE GLOBAL
262 -VARIABLE_TYPE BIGINT UNSIGNED
263 +VARIABLE_TYPE INT UNSIGNED
264 VARIABLE_COMMENT How deep to scan LRU to keep it clean
265 NUMERIC_MIN_VALUE 100
266 -NUMERIC_MAX_VALUE 18446744073709551615
267 +NUMERIC_MAX_VALUE 4294967295
268 NUMERIC_BLOCK_SIZE 0
269 ENUM_VALUE_LIST NULL
270 READ_ONLY NO
271 @@ -1081,10 +1081,10 @@
272 SESSION_VALUE NULL
273 DEFAULT_VALUE 0
274 VARIABLE_SCOPE GLOBAL
275 -VARIABLE_TYPE BIGINT UNSIGNED
276 +VARIABLE_TYPE INT UNSIGNED
277 VARIABLE_COMMENT Desired maximum length of the purge queue (0 = no limit)
278 NUMERIC_MIN_VALUE 0
279 -NUMERIC_MAX_VALUE 18446744073709551615
280 +NUMERIC_MAX_VALUE 4294967295
281 NUMERIC_BLOCK_SIZE 0
282 ENUM_VALUE_LIST NULL
283 READ_ONLY NO
284 @@ -1093,7 +1093,7 @@
285 SESSION_VALUE NULL
286 DEFAULT_VALUE 0
287 VARIABLE_SCOPE GLOBAL
288 -VARIABLE_TYPE BIGINT UNSIGNED
289 +VARIABLE_TYPE INT UNSIGNED
290 VARIABLE_COMMENT Maximum delay of user threads in micro-seconds
291 NUMERIC_MIN_VALUE 0
292 NUMERIC_MAX_VALUE 10000000
293 @@ -1225,10 +1225,10 @@
294 SESSION_VALUE NULL
295 DEFAULT_VALUE 0
296 VARIABLE_SCOPE GLOBAL
297 -VARIABLE_TYPE BIGINT UNSIGNED
298 +VARIABLE_TYPE INT UNSIGNED
299 VARIABLE_COMMENT How many files at the maximum InnoDB keeps open at the same time
300 NUMERIC_MIN_VALUE 0
301 -NUMERIC_MAX_VALUE 9223372036854775807
302 +NUMERIC_MAX_VALUE 2147483647
303 NUMERIC_BLOCK_SIZE 0
304 ENUM_VALUE_LIST NULL
305 READ_ONLY YES
306 @@ -1249,7 +1249,7 @@
307 SESSION_VALUE NULL
308 DEFAULT_VALUE 16384
309 VARIABLE_SCOPE GLOBAL
310 -VARIABLE_TYPE BIGINT UNSIGNED
311 +VARIABLE_TYPE INT UNSIGNED
312 VARIABLE_COMMENT Page size to use for all InnoDB tablespaces
313 NUMERIC_MIN_VALUE 4096
314 NUMERIC_MAX_VALUE 65536
315 @@ -1285,7 +1285,7 @@
316 SESSION_VALUE NULL
317 DEFAULT_VALUE 127
318 VARIABLE_SCOPE GLOBAL
319 -VARIABLE_TYPE BIGINT UNSIGNED
320 +VARIABLE_TYPE INT UNSIGNED
321 VARIABLE_COMMENT Number of UNDO log pages to purge in one batch from the history list
322 NUMERIC_MIN_VALUE 1
323 NUMERIC_MAX_VALUE 5000
324 @@ -1297,7 +1297,7 @@
325 SESSION_VALUE NULL
326 DEFAULT_VALUE 128
327 VARIABLE_SCOPE GLOBAL
328 -VARIABLE_TYPE BIGINT UNSIGNED
329 +VARIABLE_TYPE INT UNSIGNED
330 VARIABLE_COMMENT Unused
331 NUMERIC_MIN_VALUE 1
332 NUMERIC_MAX_VALUE 128
333 @@ -1333,7 +1333,7 @@
334 SESSION_VALUE NULL
335 DEFAULT_VALUE 56
336 VARIABLE_SCOPE GLOBAL
337 -VARIABLE_TYPE BIGINT UNSIGNED
338 +VARIABLE_TYPE INT UNSIGNED
339 VARIABLE_COMMENT Number of pages that must be accessed sequentially for InnoDB to trigger a readahead
340 NUMERIC_MIN_VALUE 0
341 NUMERIC_MAX_VALUE 64
342 @@ -1417,7 +1417,7 @@
343 SESSION_VALUE NULL
344 DEFAULT_VALUE 1048576
345 VARIABLE_SCOPE GLOBAL
346 -VARIABLE_TYPE BIGINT UNSIGNED
347 +VARIABLE_TYPE INT UNSIGNED
348 VARIABLE_COMMENT Memory buffer size for index creation
349 NUMERIC_MIN_VALUE 65536
350 NUMERIC_MAX_VALUE 67108864
351 @@ -1585,10 +1585,10 @@
352 SESSION_VALUE NULL
353 DEFAULT_VALUE 30
354 VARIABLE_SCOPE GLOBAL
355 -VARIABLE_TYPE BIGINT UNSIGNED
356 +VARIABLE_TYPE INT UNSIGNED
357 VARIABLE_COMMENT Count of spin-loop rounds in InnoDB mutexes (30 by default)
358 NUMERIC_MIN_VALUE 0
359 -NUMERIC_MAX_VALUE 18446744073709551615
360 +NUMERIC_MAX_VALUE 4294967295
361 NUMERIC_BLOCK_SIZE 0
362 ENUM_VALUE_LIST NULL
363 READ_ONLY NO