Debian Codegraph @

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

raw
1 --- a/mysql-test/suite/sys_vars/r/sysvars_server_embedded.result
2 +++ b/mysql-test/suite/sys_vars/r/sysvars_server_embedded.result
3 @@ -44,7 +44,7 @@ READ_ONLY NO
4 COMMAND_LINE_ARGUMENT REQUIRED
5 VARIABLE_NAME ARIA_BLOCK_SIZE
6 VARIABLE_SCOPE GLOBAL
7 -VARIABLE_TYPE BIGINT UNSIGNED
8 +VARIABLE_TYPE INT UNSIGNED
9 VARIABLE_COMMENT Block size to be used for Aria index pages
10 NUMERIC_MIN_VALUE 4096
11 NUMERIC_MAX_VALUE 32768
12 @@ -54,7 +54,7 @@ READ_ONLY YES
13 COMMAND_LINE_ARGUMENT REQUIRED
14 VARIABLE_NAME ARIA_CHECKPOINT_INTERVAL
15 VARIABLE_SCOPE GLOBAL
16 -VARIABLE_TYPE BIGINT UNSIGNED
17 +VARIABLE_TYPE INT UNSIGNED
18 VARIABLE_COMMENT Interval between tries to do an automatic checkpoints. In seconds; 0 means 'no automatic checkpoints' which makes sense only for testing
19 NUMERIC_MIN_VALUE 0
20 NUMERIC_MAX_VALUE 4294967295
21 @@ -64,7 +64,7 @@ READ_ONLY NO
22 COMMAND_LINE_ARGUMENT REQUIRED
23 VARIABLE_NAME ARIA_CHECKPOINT_LOG_ACTIVITY
24 VARIABLE_SCOPE GLOBAL
25 -VARIABLE_TYPE BIGINT UNSIGNED
26 +VARIABLE_TYPE INT UNSIGNED
27 VARIABLE_COMMENT Number of bytes that the transaction log has to grow between checkpoints before a new checkpoint is written to the log
28 NUMERIC_MIN_VALUE 0
29 NUMERIC_MAX_VALUE 4294967295
30 @@ -84,7 +84,7 @@ READ_ONLY NO
31 COMMAND_LINE_ARGUMENT OPTIONAL
32 VARIABLE_NAME ARIA_FORCE_START_AFTER_RECOVERY_FAILURES
33 VARIABLE_SCOPE GLOBAL
34 -VARIABLE_TYPE BIGINT UNSIGNED
35 +VARIABLE_TYPE INT UNSIGNED
36 VARIABLE_COMMENT Number of consecutive log recovery failures after which logs will be automatically deleted to cure the problem; 0 (the default) disables the feature
37 NUMERIC_MIN_VALUE 0
38 NUMERIC_MAX_VALUE 255
39 @@ -104,7 +104,7 @@ READ_ONLY NO
40 COMMAND_LINE_ARGUMENT REQUIRED
41 VARIABLE_NAME ARIA_GROUP_COMMIT_INTERVAL
42 VARIABLE_SCOPE GLOBAL
43 -VARIABLE_TYPE BIGINT UNSIGNED
44 +VARIABLE_TYPE INT UNSIGNED
45 VARIABLE_COMMENT Interval between commits in microseconds (1/1000000 sec). 0 stands for no waiting for other threads to come and do a commit in "hard" mode and no sync()/commit at all in "soft" mode. Option has only an effect if aria_group_commit is used
46 NUMERIC_MIN_VALUE 0
47 NUMERIC_MAX_VALUE 4294967295
48 @@ -124,7 +124,7 @@ READ_ONLY YES
49 COMMAND_LINE_ARGUMENT REQUIRED
50 VARIABLE_NAME ARIA_LOG_FILE_SIZE
51 VARIABLE_SCOPE GLOBAL
52 -VARIABLE_TYPE BIGINT UNSIGNED
53 +VARIABLE_TYPE INT UNSIGNED
54 VARIABLE_COMMENT Limit for transaction log size
55 NUMERIC_MIN_VALUE 8388608
56 NUMERIC_MAX_VALUE 4294967295
57 @@ -154,10 +154,10 @@ READ_ONLY NO
58 COMMAND_LINE_ARGUMENT REQUIRED
59 VARIABLE_NAME ARIA_PAGECACHE_AGE_THRESHOLD
60 VARIABLE_SCOPE GLOBAL
61 -VARIABLE_TYPE BIGINT UNSIGNED
62 +VARIABLE_TYPE INT UNSIGNED
63 VARIABLE_COMMENT This characterizes the number of hits a hot block has to be untouched until it is considered aged enough to be downgraded to a warm block. This specifies the percentage ratio of that number of hits to the total number of blocks in the page cache
64 NUMERIC_MIN_VALUE 100
65 -NUMERIC_MAX_VALUE 18446744073709551615
66 +NUMERIC_MAX_VALUE 4294967295
67 NUMERIC_BLOCK_SIZE 100
68 ENUM_VALUE_LIST NULL
69 READ_ONLY NO
70 @@ -174,7 +174,7 @@ READ_ONLY YES
71 COMMAND_LINE_ARGUMENT REQUIRED
72 VARIABLE_NAME ARIA_PAGECACHE_DIVISION_LIMIT
73 VARIABLE_SCOPE GLOBAL
74 -VARIABLE_TYPE BIGINT UNSIGNED
75 +VARIABLE_TYPE INT UNSIGNED
76 VARIABLE_COMMENT The minimum percentage of warm blocks in key cache
77 NUMERIC_MIN_VALUE 1
78 NUMERIC_MAX_VALUE 100
79 @@ -184,7 +184,7 @@ READ_ONLY NO
80 COMMAND_LINE_ARGUMENT REQUIRED
81 VARIABLE_NAME ARIA_PAGECACHE_FILE_HASH_SIZE
82 VARIABLE_SCOPE GLOBAL
83 -VARIABLE_TYPE BIGINT UNSIGNED
84 +VARIABLE_TYPE INT UNSIGNED
85 VARIABLE_COMMENT Number of hash buckets for open and changed files. If you have a lot of Aria files open you should increase this for faster flush of changes. A good value is probably 1/10 of number of possible open Aria files
86 NUMERIC_MIN_VALUE 128
87 NUMERIC_MAX_VALUE 16384
88 @@ -214,7 +214,7 @@ READ_ONLY NO
89 COMMAND_LINE_ARGUMENT OPTIONAL
90 VARIABLE_NAME ARIA_REPAIR_THREADS
91 VARIABLE_SCOPE SESSION
92 -VARIABLE_TYPE BIGINT UNSIGNED
93 +VARIABLE_TYPE INT UNSIGNED
94 VARIABLE_COMMENT Number of threads to use when repairing Aria tables. The value of 1 disables parallel repair
95 NUMERIC_MIN_VALUE 1
96 NUMERIC_MAX_VALUE 128
97 @@ -227,7 +227,7 @@ VARIABLE_SCOPE SESSION
98 VARIABLE_TYPE BIGINT UNSIGNED
99 VARIABLE_COMMENT The buffer that is allocated when sorting the index when doing a REPAIR or when creating indexes with CREATE INDEX or ALTER TABLE
100 NUMERIC_MIN_VALUE 16352
101 -NUMERIC_MAX_VALUE 1152921504606846975
102 +NUMERIC_MAX_VALUE 268435455
103 NUMERIC_BLOCK_SIZE 1
104 ENUM_VALUE_LIST NULL
105 READ_ONLY NO
106 @@ -284,7 +284,7 @@ READ_ONLY NO
107 COMMAND_LINE_ARGUMENT OPTIONAL
108 VARIABLE_NAME AUTO_INCREMENT_INCREMENT
109 VARIABLE_SCOPE SESSION
110 -VARIABLE_TYPE BIGINT UNSIGNED
111 +VARIABLE_TYPE INT UNSIGNED
112 VARIABLE_COMMENT Auto-increment columns are incremented by this
113 NUMERIC_MIN_VALUE 1
114 NUMERIC_MAX_VALUE 65535
115 @@ -294,7 +294,7 @@ READ_ONLY NO
116 COMMAND_LINE_ARGUMENT OPTIONAL
117 VARIABLE_NAME AUTO_INCREMENT_OFFSET
118 VARIABLE_SCOPE SESSION
119 -VARIABLE_TYPE BIGINT UNSIGNED
120 +VARIABLE_TYPE INT UNSIGNED
121 VARIABLE_COMMENT Offset added to Auto-increment columns. Used when auto-increment-increment != 1
122 NUMERIC_MIN_VALUE 1
123 NUMERIC_MAX_VALUE 65535
124 @@ -304,7 +304,7 @@ READ_ONLY NO
125 COMMAND_LINE_ARGUMENT OPTIONAL
126 VARIABLE_NAME BACK_LOG
127 VARIABLE_SCOPE GLOBAL
128 -VARIABLE_TYPE BIGINT UNSIGNED
129 +VARIABLE_TYPE INT UNSIGNED
130 VARIABLE_COMMENT The number of outstanding connection requests MariaDB can have. This comes into play when the main MariaDB thread gets many connection requests in a very short time
131 NUMERIC_MIN_VALUE 0
132 NUMERIC_MAX_VALUE 65535
133 @@ -357,7 +357,7 @@ VARIABLE_SCOPE GLOBAL
134 VARIABLE_TYPE BIGINT UNSIGNED
135 VARIABLE_COMMENT The size of the transactional cache for updates to transactional engines for the binary log. If you often use transactions containing many statements, you can increase this to get more performance
136 NUMERIC_MIN_VALUE 4096
137 -NUMERIC_MAX_VALUE 18446744073709551615
138 +NUMERIC_MAX_VALUE 4294967295
139 NUMERIC_BLOCK_SIZE 4096
140 ENUM_VALUE_LIST NULL
141 READ_ONLY NO
142 @@ -374,20 +374,20 @@ READ_ONLY NO
143 COMMAND_LINE_ARGUMENT REQUIRED
144 VARIABLE_NAME BINLOG_COMMIT_WAIT_COUNT
145 VARIABLE_SCOPE GLOBAL
146 -VARIABLE_TYPE BIGINT UNSIGNED
147 +VARIABLE_TYPE INT UNSIGNED
148 VARIABLE_COMMENT If non-zero, binlog write will wait at most binlog_commit_wait_usec microseconds for at least this many commits to queue up for group commit to the binlog. This can reduce I/O on the binlog and provide increased opportunity for parallel apply on the slave, but too high a value will decrease commit throughput
149 NUMERIC_MIN_VALUE 0
150 -NUMERIC_MAX_VALUE 18446744073709551615
151 +NUMERIC_MAX_VALUE 4294967295
152 NUMERIC_BLOCK_SIZE 1
153 ENUM_VALUE_LIST NULL
154 READ_ONLY NO
155 COMMAND_LINE_ARGUMENT REQUIRED
156 VARIABLE_NAME BINLOG_COMMIT_WAIT_USEC
157 VARIABLE_SCOPE GLOBAL
158 -VARIABLE_TYPE BIGINT UNSIGNED
159 +VARIABLE_TYPE INT UNSIGNED
160 VARIABLE_COMMENT Maximum time, in microseconds, to wait for more commits to queue up for binlog group commit. Only takes effect if the value of binlog_commit_wait_count is non-zero
161 NUMERIC_MIN_VALUE 0
162 -NUMERIC_MAX_VALUE 18446744073709551615
163 +NUMERIC_MAX_VALUE 4294967295
164 NUMERIC_BLOCK_SIZE 1
165 ENUM_VALUE_LIST NULL
166 READ_ONLY NO
167 @@ -404,7 +404,7 @@ READ_ONLY NO
168 COMMAND_LINE_ARGUMENT OPTIONAL
169 VARIABLE_NAME BINLOG_EXPIRE_LOGS_SECONDS
170 VARIABLE_SCOPE GLOBAL
171 -VARIABLE_TYPE BIGINT UNSIGNED
172 +VARIABLE_TYPE INT UNSIGNED
173 VARIABLE_COMMENT If non-zero, binary logs will be purged after binlog_expire_logs_seconds seconds; It and expire_logs_days are linked, such that changes in one are converted into the other. Possible purges happen at startup and at binary log rotation
174 NUMERIC_MIN_VALUE 0
175 NUMERIC_MAX_VALUE 8553600
176 @@ -417,7 +417,7 @@ VARIABLE_SCOPE GLOBAL
177 VARIABLE_TYPE BIGINT UNSIGNED
178 VARIABLE_COMMENT The size of file cache for the binary log
179 NUMERIC_MIN_VALUE 8192
180 -NUMERIC_MAX_VALUE 18446744073709551615
181 +NUMERIC_MAX_VALUE 4294967295
182 NUMERIC_BLOCK_SIZE 4096
183 ENUM_VALUE_LIST NULL
184 READ_ONLY NO
185 @@ -517,7 +517,7 @@ VARIABLE_SCOPE GLOBAL
186 VARIABLE_TYPE BIGINT UNSIGNED
187 VARIABLE_COMMENT The size of the statement cache for updates to non-transactional engines for the binary log. If you often use statements updating a great number of rows, you can increase this to get more performance
188 NUMERIC_MIN_VALUE 4096
189 -NUMERIC_MAX_VALUE 18446744073709551615
190 +NUMERIC_MAX_VALUE 4294967295
191 NUMERIC_BLOCK_SIZE 4096
192 ENUM_VALUE_LIST NULL
193 READ_ONLY NO
194 @@ -537,7 +537,7 @@ VARIABLE_SCOPE SESSION
195 VARIABLE_TYPE BIGINT UNSIGNED
196 VARIABLE_COMMENT Size of tree cache used in bulk insert optimization. Note that this is a limit per thread
197 NUMERIC_MIN_VALUE 0
198 -NUMERIC_MAX_VALUE 18446744073709551615
199 +NUMERIC_MAX_VALUE 4294967295
200 NUMERIC_BLOCK_SIZE 1
201 ENUM_VALUE_LIST NULL
202 READ_ONLY NO
203 @@ -734,7 +734,7 @@ READ_ONLY NO
204 COMMAND_LINE_ARGUMENT OPTIONAL
205 VARIABLE_NAME CONNECT_TIMEOUT
206 VARIABLE_SCOPE GLOBAL
207 -VARIABLE_TYPE BIGINT UNSIGNED
208 +VARIABLE_TYPE INT UNSIGNED
209 VARIABLE_COMMENT The number of seconds the MariaDB server is waiting for a connect packet before responding with 'Bad handshake'
210 NUMERIC_MIN_VALUE 2
211 NUMERIC_MAX_VALUE 31536000
212 @@ -764,7 +764,7 @@ READ_ONLY YES
213 COMMAND_LINE_ARGUMENT REQUIRED
214 VARIABLE_NAME DEADLOCK_SEARCH_DEPTH_LONG
215 VARIABLE_SCOPE SESSION
216 -VARIABLE_TYPE BIGINT UNSIGNED
217 +VARIABLE_TYPE INT UNSIGNED
218 VARIABLE_COMMENT Long search depth for the two-step deadlock detection
219 NUMERIC_MIN_VALUE 0
220 NUMERIC_MAX_VALUE 33
221 @@ -774,7 +774,7 @@ READ_ONLY NO
222 COMMAND_LINE_ARGUMENT REQUIRED
223 VARIABLE_NAME DEADLOCK_SEARCH_DEPTH_SHORT
224 VARIABLE_SCOPE SESSION
225 -VARIABLE_TYPE BIGINT UNSIGNED
226 +VARIABLE_TYPE INT UNSIGNED
227 VARIABLE_COMMENT Short search depth for the two-step deadlock detection
228 NUMERIC_MIN_VALUE 0
229 NUMERIC_MAX_VALUE 32
230 @@ -784,7 +784,7 @@ READ_ONLY NO
231 COMMAND_LINE_ARGUMENT REQUIRED
232 VARIABLE_NAME DEADLOCK_TIMEOUT_LONG
233 VARIABLE_SCOPE SESSION
234 -VARIABLE_TYPE BIGINT UNSIGNED
235 +VARIABLE_TYPE INT UNSIGNED
236 VARIABLE_COMMENT Long timeout for the two-step deadlock detection (in microseconds)
237 NUMERIC_MIN_VALUE 0
238 NUMERIC_MAX_VALUE 4294967295
239 @@ -794,7 +794,7 @@ READ_ONLY NO
240 COMMAND_LINE_ARGUMENT REQUIRED
241 VARIABLE_NAME DEADLOCK_TIMEOUT_SHORT
242 VARIABLE_SCOPE SESSION
243 -VARIABLE_TYPE BIGINT UNSIGNED
244 +VARIABLE_TYPE INT UNSIGNED
245 VARIABLE_COMMENT Short timeout for the two-step deadlock detection (in microseconds)
246 NUMERIC_MIN_VALUE 0
247 NUMERIC_MAX_VALUE 4294967295
248 @@ -844,7 +844,7 @@ READ_ONLY NO
249 COMMAND_LINE_ARGUMENT NULL
250 VARIABLE_NAME DEFAULT_WEEK_FORMAT
251 VARIABLE_SCOPE SESSION
252 -VARIABLE_TYPE BIGINT UNSIGNED
253 +VARIABLE_TYPE INT UNSIGNED
254 VARIABLE_COMMENT The default week format used by WEEK() functions
255 NUMERIC_MIN_VALUE 0
256 NUMERIC_MAX_VALUE 7
257 @@ -854,7 +854,7 @@ READ_ONLY NO
258 COMMAND_LINE_ARGUMENT REQUIRED
259 VARIABLE_NAME DELAYED_INSERT_LIMIT
260 VARIABLE_SCOPE GLOBAL
261 -VARIABLE_TYPE BIGINT UNSIGNED
262 +VARIABLE_TYPE INT UNSIGNED
263 VARIABLE_COMMENT After inserting delayed_insert_limit rows, the INSERT DELAYED handler will check if there are any SELECT statements pending. If so, it allows these to execute before continuing
264 NUMERIC_MIN_VALUE 1
265 NUMERIC_MAX_VALUE 4294967295
266 @@ -864,7 +864,7 @@ READ_ONLY NO
267 COMMAND_LINE_ARGUMENT REQUIRED
268 VARIABLE_NAME DELAYED_INSERT_TIMEOUT
269 VARIABLE_SCOPE GLOBAL
270 -VARIABLE_TYPE BIGINT UNSIGNED
271 +VARIABLE_TYPE INT UNSIGNED
272 VARIABLE_COMMENT How long a INSERT DELAYED thread should wait for INSERT statements before terminating
273 NUMERIC_MIN_VALUE 1
274 NUMERIC_MAX_VALUE 31536000
275 @@ -874,7 +874,7 @@ READ_ONLY NO
276 COMMAND_LINE_ARGUMENT REQUIRED
277 VARIABLE_NAME DELAYED_QUEUE_SIZE
278 VARIABLE_SCOPE GLOBAL
279 -VARIABLE_TYPE BIGINT UNSIGNED
280 +VARIABLE_TYPE INT UNSIGNED
281 VARIABLE_COMMENT What size queue (in rows) should be allocated for handling INSERT DELAYED. If the queue becomes full, any client that does INSERT DELAYED will wait until there is room in the queue again
282 NUMERIC_MIN_VALUE 1
283 NUMERIC_MAX_VALUE 4294967295
284 @@ -904,7 +904,7 @@ READ_ONLY NO
285 COMMAND_LINE_ARGUMENT OPTIONAL
286 VARIABLE_NAME DIV_PRECISION_INCREMENT
287 VARIABLE_SCOPE SESSION
288 -VARIABLE_TYPE BIGINT UNSIGNED
289 +VARIABLE_TYPE INT UNSIGNED
290 VARIABLE_COMMENT Precision of the result of '/' operator will be increased on that value
291 NUMERIC_MIN_VALUE 0
292 NUMERIC_MAX_VALUE 38
293 @@ -1014,7 +1014,7 @@ READ_ONLY YES
294 COMMAND_LINE_ARGUMENT NULL
295 VARIABLE_NAME EXTRA_MAX_CONNECTIONS
296 VARIABLE_SCOPE GLOBAL
297 -VARIABLE_TYPE BIGINT UNSIGNED
298 +VARIABLE_TYPE INT UNSIGNED
299 VARIABLE_COMMENT The number of connections on extra-port
300 NUMERIC_MIN_VALUE 1
301 NUMERIC_MAX_VALUE 100000
302 @@ -1044,7 +1044,7 @@ READ_ONLY NO
303 COMMAND_LINE_ARGUMENT OPTIONAL
304 VARIABLE_NAME FLUSH_TIME
305 VARIABLE_SCOPE GLOBAL
306 -VARIABLE_TYPE BIGINT UNSIGNED
307 +VARIABLE_TYPE INT UNSIGNED
308 VARIABLE_COMMENT A dedicated thread is created to flush all tables at the given interval
309 NUMERIC_MIN_VALUE 0
310 NUMERIC_MAX_VALUE 31536000
311 @@ -1074,7 +1074,7 @@ READ_ONLY NO
312 COMMAND_LINE_ARGUMENT REQUIRED
313 VARIABLE_NAME FT_MAX_WORD_LEN
314 VARIABLE_SCOPE GLOBAL
315 -VARIABLE_TYPE BIGINT UNSIGNED
316 +VARIABLE_TYPE INT UNSIGNED
317 VARIABLE_COMMENT The maximum length of the word to be included in a FULLTEXT index. Note: FULLTEXT indexes must be rebuilt after changing this variable
318 NUMERIC_MIN_VALUE 10
319 NUMERIC_MAX_VALUE 84
320 @@ -1084,7 +1084,7 @@ READ_ONLY YES
321 COMMAND_LINE_ARGUMENT REQUIRED
322 VARIABLE_NAME FT_MIN_WORD_LEN
323 VARIABLE_SCOPE GLOBAL
324 -VARIABLE_TYPE BIGINT UNSIGNED
325 +VARIABLE_TYPE INT UNSIGNED
326 VARIABLE_COMMENT The minimum length of the word to be included in a FULLTEXT index. Note: FULLTEXT indexes must be rebuilt after changing this variable
327 NUMERIC_MIN_VALUE 1
328 NUMERIC_MAX_VALUE 84
329 @@ -1094,7 +1094,7 @@ READ_ONLY YES
330 COMMAND_LINE_ARGUMENT REQUIRED
331 VARIABLE_NAME FT_QUERY_EXPANSION_LIMIT
332 VARIABLE_SCOPE GLOBAL
333 -VARIABLE_TYPE BIGINT UNSIGNED
334 +VARIABLE_TYPE INT UNSIGNED
335 VARIABLE_COMMENT Number of best matches to use for query expansion
336 NUMERIC_MIN_VALUE 0
337 NUMERIC_MAX_VALUE 1000
338 @@ -1264,7 +1264,7 @@ READ_ONLY YES
339 COMMAND_LINE_ARGUMENT NULL
340 VARIABLE_NAME HISTOGRAM_SIZE
341 VARIABLE_SCOPE SESSION
342 -VARIABLE_TYPE BIGINT UNSIGNED
343 +VARIABLE_TYPE INT UNSIGNED
344 VARIABLE_COMMENT Number of bytes used for a histogram. If set to 0, no histograms are created by ANALYZE
345 NUMERIC_MIN_VALUE 0
346 NUMERIC_MAX_VALUE 255
347 @@ -1294,7 +1294,7 @@ READ_ONLY YES
348 COMMAND_LINE_ARGUMENT NULL
349 VARIABLE_NAME HOST_CACHE_SIZE
350 VARIABLE_SCOPE GLOBAL
351 -VARIABLE_TYPE BIGINT UNSIGNED
352 +VARIABLE_TYPE INT UNSIGNED
353 VARIABLE_COMMENT How many host names should be cached to avoid resolving
354 NUMERIC_MIN_VALUE 0
355 NUMERIC_MAX_VALUE 65536
356 @@ -1404,7 +1404,7 @@ READ_ONLY NO
357 COMMAND_LINE_ARGUMENT NULL
358 VARIABLE_NAME INTERACTIVE_TIMEOUT
359 VARIABLE_SCOPE SESSION
360 -VARIABLE_TYPE BIGINT UNSIGNED
361 +VARIABLE_TYPE INT UNSIGNED
362 VARIABLE_COMMENT The number of seconds the server waits for activity on an interactive connection before closing it
363 NUMERIC_MIN_VALUE 1
364 NUMERIC_MAX_VALUE 31536000
365 @@ -1437,7 +1437,7 @@ VARIABLE_SCOPE SESSION
366 VARIABLE_TYPE BIGINT UNSIGNED
367 VARIABLE_COMMENT The size of the buffer that is used for joins
368 NUMERIC_MIN_VALUE 128
369 -NUMERIC_MAX_VALUE 18446744073709551615
370 +NUMERIC_MAX_VALUE 4294967295
371 NUMERIC_BLOCK_SIZE 128
372 ENUM_VALUE_LIST NULL
373 READ_ONLY NO
374 @@ -1454,7 +1454,7 @@ READ_ONLY NO
375 COMMAND_LINE_ARGUMENT REQUIRED
376 VARIABLE_NAME JOIN_CACHE_LEVEL
377 VARIABLE_SCOPE SESSION
378 -VARIABLE_TYPE BIGINT UNSIGNED
379 +VARIABLE_TYPE INT UNSIGNED
380 VARIABLE_COMMENT Controls what join operations can be executed with join buffers. Odd numbers are used for plain join buffers while even numbers are used for linked buffers
381 NUMERIC_MIN_VALUE 0
382 NUMERIC_MAX_VALUE 8
383 @@ -1477,7 +1477,7 @@ VARIABLE_SCOPE GLOBAL
384 VARIABLE_TYPE BIGINT UNSIGNED
385 VARIABLE_COMMENT The size of the buffer used for index blocks for MyISAM tables. Increase this to get faster index handling
386 NUMERIC_MIN_VALUE 0
387 -NUMERIC_MAX_VALUE 18446744073709551615
388 +NUMERIC_MAX_VALUE 4294967295
389 NUMERIC_BLOCK_SIZE 4096
390 ENUM_VALUE_LIST NULL
391 READ_ONLY NO
392 @@ -1634,7 +1634,7 @@ READ_ONLY YES
393 COMMAND_LINE_ARGUMENT NULL
394 VARIABLE_NAME LOCK_WAIT_TIMEOUT
395 VARIABLE_SCOPE SESSION
396 -VARIABLE_TYPE BIGINT UNSIGNED
397 +VARIABLE_TYPE INT UNSIGNED
398 VARIABLE_COMMENT Timeout in seconds to wait for a lock before returning an error
399 NUMERIC_MIN_VALUE 0
400 NUMERIC_MAX_VALUE 31536000
401 @@ -1764,7 +1764,7 @@ READ_ONLY NO
402 COMMAND_LINE_ARGUMENT REQUIRED
403 VARIABLE_NAME LOG_SLOW_MAX_WARNINGS
404 VARIABLE_SCOPE SESSION
405 -VARIABLE_TYPE BIGINT UNSIGNED
406 +VARIABLE_TYPE INT UNSIGNED
407 VARIABLE_COMMENT Max numbers of warnings printed to slow query log per statement
408 NUMERIC_MIN_VALUE 0
409 NUMERIC_MAX_VALUE 1000
410 @@ -1774,7 +1774,7 @@ READ_ONLY NO
411 COMMAND_LINE_ARGUMENT REQUIRED
412 VARIABLE_NAME LOG_SLOW_MIN_EXAMINED_ROW_LIMIT
413 VARIABLE_SCOPE SESSION
414 -VARIABLE_TYPE BIGINT UNSIGNED
415 +VARIABLE_TYPE INT UNSIGNED
416 VARIABLE_COMMENT Don't write queries to slow log that examine fewer rows than that
417 NUMERIC_MIN_VALUE 0
418 NUMERIC_MAX_VALUE 4294967295
419 @@ -1814,7 +1814,7 @@ READ_ONLY NO
420 COMMAND_LINE_ARGUMENT REQUIRED
421 VARIABLE_NAME LOG_SLOW_RATE_LIMIT
422 VARIABLE_SCOPE SESSION
423 -VARIABLE_TYPE BIGINT UNSIGNED
424 +VARIABLE_TYPE INT UNSIGNED
425 VARIABLE_COMMENT Write to slow log every #th slow query. Set to 1 to log everything. Increase it to reduce the size of the slow or the performance impact of slow logging
426 NUMERIC_MIN_VALUE 1
427 NUMERIC_MAX_VALUE 4294967295
428 @@ -1844,7 +1844,7 @@ READ_ONLY NO
429 COMMAND_LINE_ARGUMENT REQUIRED
430 VARIABLE_NAME LOG_WARNINGS
431 VARIABLE_SCOPE SESSION
432 -VARIABLE_TYPE BIGINT UNSIGNED
433 +VARIABLE_TYPE INT UNSIGNED
434 VARIABLE_COMMENT Log some non-critical warnings to the error log. Value can be between 0 and 11. Higher values mean more verbosity
435 NUMERIC_MIN_VALUE 0
436 NUMERIC_MAX_VALUE 4294967295
437 @@ -1894,7 +1894,7 @@ READ_ONLY NO
438 COMMAND_LINE_ARGUMENT OPTIONAL
439 VARIABLE_NAME MAX_ALLOWED_PACKET
440 VARIABLE_SCOPE SESSION
441 -VARIABLE_TYPE BIGINT UNSIGNED
442 +VARIABLE_TYPE INT UNSIGNED
443 VARIABLE_COMMENT Max packet length to send to or receive from the server
444 NUMERIC_MIN_VALUE 1024
445 NUMERIC_MAX_VALUE 1073741824
446 @@ -1907,14 +1907,14 @@ VARIABLE_SCOPE GLOBAL
447 VARIABLE_TYPE BIGINT UNSIGNED
448 VARIABLE_COMMENT Sets the total size of the transactional cache
449 NUMERIC_MIN_VALUE 4096
450 -NUMERIC_MAX_VALUE 18446744073709551615
451 +NUMERIC_MAX_VALUE 4294967295
452 NUMERIC_BLOCK_SIZE 4096
453 ENUM_VALUE_LIST NULL
454 READ_ONLY NO
455 COMMAND_LINE_ARGUMENT REQUIRED
456 VARIABLE_NAME MAX_BINLOG_SIZE
457 VARIABLE_SCOPE GLOBAL
458 -VARIABLE_TYPE BIGINT UNSIGNED
459 +VARIABLE_TYPE INT UNSIGNED
460 VARIABLE_COMMENT Binary log will be rotated automatically when the size exceeds this value, unless `binlog_large_commit_threshold` causes rotation prematurely
461 NUMERIC_MIN_VALUE 4096
462 NUMERIC_MAX_VALUE 1073741824
463 @@ -1927,7 +1927,7 @@ VARIABLE_SCOPE GLOBAL
464 VARIABLE_TYPE BIGINT UNSIGNED
465 VARIABLE_COMMENT Sets the total size of the statement cache
466 NUMERIC_MIN_VALUE 4096
467 -NUMERIC_MAX_VALUE 18446744073709551615
468 +NUMERIC_MAX_VALUE 4294967295
469 NUMERIC_BLOCK_SIZE 4096
470 ENUM_VALUE_LIST NULL
471 READ_ONLY NO
472 @@ -1944,7 +1944,7 @@ READ_ONLY NO
473 COMMAND_LINE_ARGUMENT REQUIRED
474 VARIABLE_NAME MAX_CONNECTIONS
475 VARIABLE_SCOPE GLOBAL
476 -VARIABLE_TYPE BIGINT UNSIGNED
477 +VARIABLE_TYPE INT UNSIGNED
478 VARIABLE_COMMENT The number of simultaneous clients allowed
479 NUMERIC_MIN_VALUE 10
480 NUMERIC_MAX_VALUE 100000
481 @@ -1954,7 +1954,7 @@ READ_ONLY NO
482 COMMAND_LINE_ARGUMENT REQUIRED
483 VARIABLE_NAME MAX_CONNECT_ERRORS
484 VARIABLE_SCOPE GLOBAL
485 -VARIABLE_TYPE BIGINT UNSIGNED
486 +VARIABLE_TYPE INT UNSIGNED
487 VARIABLE_COMMENT If there is more than this number of interrupted connections from a host this host will be blocked from further connections
488 NUMERIC_MIN_VALUE 1
489 NUMERIC_MAX_VALUE 4294967295
490 @@ -1964,7 +1964,7 @@ READ_ONLY NO
491 COMMAND_LINE_ARGUMENT REQUIRED
492 VARIABLE_NAME MAX_DELAYED_THREADS
493 VARIABLE_SCOPE SESSION
494 -VARIABLE_TYPE BIGINT UNSIGNED
495 +VARIABLE_TYPE INT UNSIGNED
496 VARIABLE_COMMENT Don't start more than this number of threads to handle INSERT DELAYED statements. If set to zero INSERT DELAYED will be not used
497 NUMERIC_MIN_VALUE 0
498 NUMERIC_MAX_VALUE 16384
499 @@ -1984,7 +1984,7 @@ READ_ONLY YES
500 COMMAND_LINE_ARGUMENT REQUIRED
501 VARIABLE_NAME MAX_ERROR_COUNT
502 VARIABLE_SCOPE SESSION
503 -VARIABLE_TYPE BIGINT UNSIGNED
504 +VARIABLE_TYPE INT UNSIGNED
505 VARIABLE_COMMENT Max number of errors/warnings to store for a statement
506 NUMERIC_MIN_VALUE 0
507 NUMERIC_MAX_VALUE 65535
508 @@ -1997,14 +1997,14 @@ VARIABLE_SCOPE SESSION
509 VARIABLE_TYPE BIGINT UNSIGNED
510 VARIABLE_COMMENT Don't allow creation of heap tables bigger than this
511 NUMERIC_MIN_VALUE 16384
512 -NUMERIC_MAX_VALUE 18446744073709551615
513 +NUMERIC_MAX_VALUE 4294967295
514 NUMERIC_BLOCK_SIZE 1024
515 ENUM_VALUE_LIST NULL
516 READ_ONLY NO
517 COMMAND_LINE_ARGUMENT REQUIRED
518 VARIABLE_NAME MAX_INSERT_DELAYED_THREADS
519 VARIABLE_SCOPE SESSION
520 -VARIABLE_TYPE BIGINT UNSIGNED
521 +VARIABLE_TYPE INT UNSIGNED
522 VARIABLE_COMMENT Alias for max_delayed_threads. Don't start more than this number of threads to handle INSERT DELAYED statements. If set to zero INSERT DELAYED will be not used
523 NUMERIC_MIN_VALUE 0
524 NUMERIC_MAX_VALUE 16384
525 @@ -2024,7 +2024,7 @@ READ_ONLY NO
526 COMMAND_LINE_ARGUMENT REQUIRED
527 VARIABLE_NAME MAX_LENGTH_FOR_SORT_DATA
528 VARIABLE_SCOPE SESSION
529 -VARIABLE_TYPE BIGINT UNSIGNED
530 +VARIABLE_TYPE INT UNSIGNED
531 VARIABLE_COMMENT Max number of bytes in sorted records
532 NUMERIC_MIN_VALUE 4
533 NUMERIC_MAX_VALUE 8388608
534 @@ -2054,7 +2054,7 @@ READ_ONLY NO
535 COMMAND_LINE_ARGUMENT REQUIRED
536 VARIABLE_NAME MAX_RECURSIVE_ITERATIONS
537 VARIABLE_SCOPE SESSION
538 -VARIABLE_TYPE BIGINT UNSIGNED
539 +VARIABLE_TYPE INT UNSIGNED
540 VARIABLE_COMMENT Maximum number of iterations when executing recursive queries
541 NUMERIC_MIN_VALUE 0
542 NUMERIC_MAX_VALUE 4294967295
543 @@ -2067,14 +2067,14 @@ VARIABLE_SCOPE SESSION
544 VARIABLE_TYPE BIGINT UNSIGNED
545 VARIABLE_COMMENT The maximum size of the container of a rowid filter
546 NUMERIC_MIN_VALUE 1024
547 -NUMERIC_MAX_VALUE 18446744073709551615
548 +NUMERIC_MAX_VALUE 4294967295
549 NUMERIC_BLOCK_SIZE 1
550 ENUM_VALUE_LIST NULL
551 READ_ONLY NO
552 COMMAND_LINE_ARGUMENT REQUIRED
553 VARIABLE_NAME MAX_SEEKS_FOR_KEY
554 VARIABLE_SCOPE SESSION
555 -VARIABLE_TYPE BIGINT UNSIGNED
556 +VARIABLE_TYPE INT UNSIGNED
557 VARIABLE_COMMENT Limit assumed max number of seeks when looking up rows based on a key
558 NUMERIC_MIN_VALUE 1
559 NUMERIC_MAX_VALUE 4294967295
560 @@ -2094,7 +2094,7 @@ READ_ONLY NO
561 COMMAND_LINE_ARGUMENT REQUIRED
562 VARIABLE_NAME MAX_SORT_LENGTH
563 VARIABLE_SCOPE SESSION
564 -VARIABLE_TYPE BIGINT UNSIGNED
565 +VARIABLE_TYPE INT UNSIGNED
566 VARIABLE_COMMENT The number of bytes to use when sorting BLOB or TEXT values (only the first max_sort_length bytes of each value are used; the rest are ignored)
567 NUMERIC_MIN_VALUE 64
568 NUMERIC_MAX_VALUE 8388608
569 @@ -2104,7 +2104,7 @@ READ_ONLY NO
570 COMMAND_LINE_ARGUMENT REQUIRED
571 VARIABLE_NAME MAX_SP_RECURSION_DEPTH
572 VARIABLE_SCOPE SESSION
573 -VARIABLE_TYPE BIGINT UNSIGNED
574 +VARIABLE_TYPE INT UNSIGNED
575 VARIABLE_COMMENT Maximum stored procedure recursion depth
576 NUMERIC_MIN_VALUE 0
577 NUMERIC_MAX_VALUE 255
578 @@ -2154,7 +2154,7 @@ READ_ONLY NO
579 COMMAND_LINE_ARGUMENT REQUIRED
580 VARIABLE_NAME MAX_WRITE_LOCK_COUNT
581 VARIABLE_SCOPE GLOBAL
582 -VARIABLE_TYPE BIGINT UNSIGNED
583 +VARIABLE_TYPE INT UNSIGNED
584 VARIABLE_COMMENT After this many write locks, allow some read locks to run in between
585 NUMERIC_MIN_VALUE 1
586 NUMERIC_MAX_VALUE 4294967295
587 @@ -2164,7 +2164,7 @@ READ_ONLY NO
588 COMMAND_LINE_ARGUMENT REQUIRED
589 VARIABLE_NAME METADATA_LOCKS_CACHE_SIZE
590 VARIABLE_SCOPE GLOBAL
591 -VARIABLE_TYPE BIGINT UNSIGNED
592 +VARIABLE_TYPE INT UNSIGNED
593 VARIABLE_COMMENT Unused
594 NUMERIC_MIN_VALUE 1
595 NUMERIC_MAX_VALUE 1048576
596 @@ -2174,7 +2174,7 @@ READ_ONLY YES
597 COMMAND_LINE_ARGUMENT REQUIRED
598 VARIABLE_NAME METADATA_LOCKS_HASH_INSTANCES
599 VARIABLE_SCOPE GLOBAL
600 -VARIABLE_TYPE BIGINT UNSIGNED
601 +VARIABLE_TYPE INT UNSIGNED
602 VARIABLE_COMMENT Unused
603 NUMERIC_MIN_VALUE 1
604 NUMERIC_MAX_VALUE 1024
605 @@ -2217,14 +2217,14 @@ VARIABLE_SCOPE GLOBAL
606 VARIABLE_TYPE BIGINT UNSIGNED
607 VARIABLE_COMMENT Upper limit for one MHNSW vector index cache
608 NUMERIC_MIN_VALUE 1048576
609 -NUMERIC_MAX_VALUE 18446744073709551615
610 +NUMERIC_MAX_VALUE 4294967295
611 NUMERIC_BLOCK_SIZE 1
612 ENUM_VALUE_LIST NULL
613 READ_ONLY NO
614 COMMAND_LINE_ARGUMENT REQUIRED
615 VARIABLE_NAME MIN_EXAMINED_ROW_LIMIT
616 VARIABLE_SCOPE SESSION
617 -VARIABLE_TYPE BIGINT UNSIGNED
618 +VARIABLE_TYPE INT UNSIGNED
619 VARIABLE_COMMENT Alias for log_slow_min_examined_row_limit. Don't write queries to slow log that examine fewer rows than that
620 NUMERIC_MIN_VALUE 0
621 NUMERIC_MAX_VALUE 4294967295
622 @@ -2234,7 +2234,7 @@ READ_ONLY NO
623 COMMAND_LINE_ARGUMENT REQUIRED
624 VARIABLE_NAME MRR_BUFFER_SIZE
625 VARIABLE_SCOPE SESSION
626 -VARIABLE_TYPE BIGINT UNSIGNED
627 +VARIABLE_TYPE INT UNSIGNED
628 VARIABLE_COMMENT Size of buffer to use when using MRR with range access
629 NUMERIC_MIN_VALUE 8192
630 NUMERIC_MAX_VALUE 2147483647
631 @@ -2244,7 +2244,7 @@ READ_ONLY NO
632 COMMAND_LINE_ARGUMENT REQUIRED
633 VARIABLE_NAME MYISAM_BLOCK_SIZE
634 VARIABLE_SCOPE GLOBAL
635 -VARIABLE_TYPE BIGINT UNSIGNED
636 +VARIABLE_TYPE INT UNSIGNED
637 VARIABLE_COMMENT Block size to be used for MyISAM index pages
638 NUMERIC_MIN_VALUE 1024
639 NUMERIC_MAX_VALUE 16384
640 @@ -2254,7 +2254,7 @@ READ_ONLY YES
641 COMMAND_LINE_ARGUMENT REQUIRED
642 VARIABLE_NAME MYISAM_DATA_POINTER_SIZE
643 VARIABLE_SCOPE GLOBAL
644 -VARIABLE_TYPE BIGINT UNSIGNED
645 +VARIABLE_TYPE INT UNSIGNED
646 VARIABLE_COMMENT Default pointer size to be used for MyISAM tables
647 NUMERIC_MIN_VALUE 2
648 NUMERIC_MAX_VALUE 7
649 @@ -2277,7 +2277,7 @@ VARIABLE_SCOPE GLOBAL
650 VARIABLE_TYPE BIGINT UNSIGNED
651 VARIABLE_COMMENT Restricts the total memory used for memory mapping of MyISAM tables
652 NUMERIC_MIN_VALUE 7
653 -NUMERIC_MAX_VALUE 18446744073709551615
654 +NUMERIC_MAX_VALUE 4294967295
655 NUMERIC_BLOCK_SIZE 1
656 ENUM_VALUE_LIST NULL
657 READ_ONLY YES
658 @@ -2294,10 +2294,10 @@ READ_ONLY YES
659 COMMAND_LINE_ARGUMENT OPTIONAL
660 VARIABLE_NAME MYISAM_REPAIR_THREADS
661 VARIABLE_SCOPE SESSION
662 -VARIABLE_TYPE BIGINT UNSIGNED
663 +VARIABLE_TYPE INT UNSIGNED
664 VARIABLE_COMMENT If larger than 1, when repairing a MyISAM table all indexes will be created in parallel, with one thread per index. The value of 1 disables parallel repair
665 NUMERIC_MIN_VALUE 1
666 -NUMERIC_MAX_VALUE 18446744073709551615
667 +NUMERIC_MAX_VALUE 4294967295
668 NUMERIC_BLOCK_SIZE 1
669 ENUM_VALUE_LIST NULL
670 READ_ONLY NO
671 @@ -2307,7 +2307,7 @@ VARIABLE_SCOPE SESSION
672 VARIABLE_TYPE BIGINT UNSIGNED
673 VARIABLE_COMMENT The buffer that is allocated when sorting the index when doing a REPAIR or when creating indexes with CREATE INDEX or ALTER TABLE
674 NUMERIC_MIN_VALUE 4096
675 -NUMERIC_MAX_VALUE 1152921504606846975
676 +NUMERIC_MAX_VALUE 268435455
677 NUMERIC_BLOCK_SIZE 1
678 ENUM_VALUE_LIST NULL
679 READ_ONLY NO
680 @@ -2344,7 +2344,7 @@ READ_ONLY NO
681 COMMAND_LINE_ARGUMENT OPTIONAL
682 VARIABLE_NAME NET_BUFFER_LENGTH
683 VARIABLE_SCOPE SESSION
684 -VARIABLE_TYPE BIGINT UNSIGNED
685 +VARIABLE_TYPE INT UNSIGNED
686 VARIABLE_COMMENT Buffer length for TCP/IP and socket communication
687 NUMERIC_MIN_VALUE 1024
688 NUMERIC_MAX_VALUE 1048576
689 @@ -2354,7 +2354,7 @@ READ_ONLY NO
690 COMMAND_LINE_ARGUMENT REQUIRED
691 VARIABLE_NAME NET_READ_TIMEOUT
692 VARIABLE_SCOPE SESSION
693 -VARIABLE_TYPE BIGINT UNSIGNED
694 +VARIABLE_TYPE INT UNSIGNED
695 VARIABLE_COMMENT Number of seconds to wait for more data from a connection before aborting the read
696 NUMERIC_MIN_VALUE 1
697 NUMERIC_MAX_VALUE 31536000
698 @@ -2364,7 +2364,7 @@ READ_ONLY NO
699 COMMAND_LINE_ARGUMENT REQUIRED
700 VARIABLE_NAME NET_RETRY_COUNT
701 VARIABLE_SCOPE SESSION
702 -VARIABLE_TYPE BIGINT UNSIGNED
703 +VARIABLE_TYPE INT UNSIGNED
704 VARIABLE_COMMENT If a read on a communication port is interrupted, retry this many times before giving up
705 NUMERIC_MIN_VALUE 1
706 NUMERIC_MAX_VALUE 4294967295
707 @@ -2374,7 +2374,7 @@ READ_ONLY NO
708 COMMAND_LINE_ARGUMENT REQUIRED
709 VARIABLE_NAME NET_WRITE_TIMEOUT
710 VARIABLE_SCOPE SESSION
711 -VARIABLE_TYPE BIGINT UNSIGNED
712 +VARIABLE_TYPE INT UNSIGNED
713 VARIABLE_COMMENT Number of seconds to wait for a block to be written to a connection before aborting the write
714 NUMERIC_MIN_VALUE 1
715 NUMERIC_MAX_VALUE 31536000
716 @@ -2424,7 +2424,7 @@ READ_ONLY NO
717 COMMAND_LINE_ARGUMENT OPTIONAL
718 VARIABLE_NAME OPEN_FILES_LIMIT
719 VARIABLE_SCOPE GLOBAL
720 -VARIABLE_TYPE BIGINT UNSIGNED
721 +VARIABLE_TYPE INT UNSIGNED
722 VARIABLE_COMMENT If this is not 0, then mariadbd will use this value to reserve file descriptors to use with setrlimit(). If this value is 0 or autoset then mariadbd will reserve max_connections*5 or max_connections + table_cache*2 (whichever is larger) number of file descriptors
723 NUMERIC_MIN_VALUE 0
724 NUMERIC_MAX_VALUE 4294967295
725 @@ -2434,7 +2434,7 @@ READ_ONLY YES
726 COMMAND_LINE_ARGUMENT REQUIRED
727 VARIABLE_NAME OPTIMIZER_ADJUST_SECONDARY_KEY_COSTS
728 VARIABLE_SCOPE SESSION
729 -VARIABLE_TYPE BIGINT UNSIGNED
730 +VARIABLE_TYPE INT UNSIGNED
731 VARIABLE_COMMENT Unused
732 NUMERIC_MIN_VALUE 0
733 NUMERIC_MAX_VALUE 2
734 @@ -2464,7 +2464,7 @@ READ_ONLY NO
735 COMMAND_LINE_ARGUMENT REQUIRED
736 VARIABLE_NAME OPTIMIZER_EXTRA_PRUNING_DEPTH
737 VARIABLE_SCOPE SESSION
738 -VARIABLE_TYPE BIGINT UNSIGNED
739 +VARIABLE_TYPE INT UNSIGNED
740 VARIABLE_COMMENT If the optimizer needs to enumerate join prefix of this size or larger, then it will try aggressively prune away the search space
741 NUMERIC_MIN_VALUE 0
742 NUMERIC_MAX_VALUE 62
743 @@ -2534,7 +2534,7 @@ READ_ONLY NO
744 COMMAND_LINE_ARGUMENT REQUIRED
745 VARIABLE_NAME OPTIMIZER_MAX_SEL_ARGS
746 VARIABLE_SCOPE SESSION
747 -VARIABLE_TYPE BIGINT UNSIGNED
748 +VARIABLE_TYPE INT UNSIGNED
749 VARIABLE_COMMENT The maximum number of SEL_ARG objects created when optimizing a range. If more objects would be needed, the range will not be used by the optimizer
750 NUMERIC_MIN_VALUE 0
751 NUMERIC_MAX_VALUE 4294967295
752 @@ -2544,7 +2544,7 @@ READ_ONLY NO
753 COMMAND_LINE_ARGUMENT REQUIRED
754 VARIABLE_NAME OPTIMIZER_MAX_SEL_ARG_WEIGHT
755 VARIABLE_SCOPE SESSION
756 -VARIABLE_TYPE BIGINT UNSIGNED
757 +VARIABLE_TYPE INT UNSIGNED
758 VARIABLE_COMMENT The maximum weight of the SEL_ARG graph. Set to 0 for no limit
759 NUMERIC_MIN_VALUE 0
760 NUMERIC_MAX_VALUE 4294967295
761 @@ -2554,7 +2554,7 @@ READ_ONLY NO
762 COMMAND_LINE_ARGUMENT REQUIRED
763 VARIABLE_NAME OPTIMIZER_PRUNE_LEVEL
764 VARIABLE_SCOPE SESSION
765 -VARIABLE_TYPE BIGINT UNSIGNED
766 +VARIABLE_TYPE INT UNSIGNED
767 VARIABLE_COMMENT Controls the heuristic(s) applied during query optimization to prune less-promising partial plans from the optimizer search space. Meaning: 0 - do not apply any heuristic, thus perform exhaustive search: 1 - prune plans based on cost and number of retrieved rows eq_ref: 2 - prune also if we find an eq_ref chain
768 NUMERIC_MIN_VALUE 0
769 NUMERIC_MAX_VALUE 2
770 @@ -2624,7 +2624,7 @@ READ_ONLY NO
771 COMMAND_LINE_ARGUMENT REQUIRED
772 VARIABLE_NAME OPTIMIZER_SEARCH_DEPTH
773 VARIABLE_SCOPE SESSION
774 -VARIABLE_TYPE BIGINT UNSIGNED
775 +VARIABLE_TYPE INT UNSIGNED
776 VARIABLE_COMMENT Maximum depth of search performed by the query optimizer. Values larger than the number of relations in a query result in better query plans, but take longer to compile a query. Values smaller than the number of tables in a relation result in faster optimization, but may produce very bad query plans. If set to 0, the system will automatically pick a reasonable value
777 NUMERIC_MIN_VALUE 0
778 NUMERIC_MAX_VALUE 62
779 @@ -2634,7 +2634,7 @@ READ_ONLY NO
780 COMMAND_LINE_ARGUMENT REQUIRED
781 VARIABLE_NAME OPTIMIZER_SELECTIVITY_SAMPLING_LIMIT
782 VARIABLE_SCOPE SESSION
783 -VARIABLE_TYPE BIGINT UNSIGNED
784 +VARIABLE_TYPE INT UNSIGNED
785 VARIABLE_COMMENT Controls number of record samples to check condition selectivity
786 NUMERIC_MIN_VALUE 10
787 NUMERIC_MAX_VALUE 4294967295
788 @@ -2664,17 +2664,17 @@ READ_ONLY NO
789 COMMAND_LINE_ARGUMENT REQUIRED
790 VARIABLE_NAME OPTIMIZER_TRACE_MAX_MEM_SIZE
791 VARIABLE_SCOPE SESSION
792 -VARIABLE_TYPE BIGINT UNSIGNED
793 +VARIABLE_TYPE INT UNSIGNED
794 VARIABLE_COMMENT Maximum allowed size of an optimizer trace
795 NUMERIC_MIN_VALUE 0
796 -NUMERIC_MAX_VALUE 18446744073709551615
797 +NUMERIC_MAX_VALUE 4294967295
798 NUMERIC_BLOCK_SIZE 1
799 ENUM_VALUE_LIST NULL
800 READ_ONLY NO
801 COMMAND_LINE_ARGUMENT REQUIRED
802 VARIABLE_NAME OPTIMIZER_USE_CONDITION_SELECTIVITY
803 VARIABLE_SCOPE SESSION
804 -VARIABLE_TYPE BIGINT UNSIGNED
805 +VARIABLE_TYPE INT UNSIGNED
806 VARIABLE_COMMENT Controls selectivity of which conditions the optimizer takes into account to calculate cardinality of a partial join when it searches for the best execution plan Meaning: 1 - use selectivity of index backed range conditions to calculate the cardinality of a partial join if the last joined table is accessed by full table scan or an index scan, 2 - use selectivity of index backed range conditions to calculate the cardinality of a partial join in any case, 3 - additionally always use selectivity of range conditions that are not backed by any index to calculate the cardinality of a partial join, 4 - use histograms to calculate selectivity of range conditions that are not backed by any index to calculate the cardinality of a partial join. 5 - additionally use selectivity of certain non-range predicates calculated on record samples
807 NUMERIC_MIN_VALUE 1
808 NUMERIC_MAX_VALUE 5
809 @@ -2704,7 +2704,7 @@ READ_ONLY YES
810 COMMAND_LINE_ARGUMENT OPTIONAL
811 VARIABLE_NAME PERFORMANCE_SCHEMA_ACCOUNTS_SIZE
812 VARIABLE_SCOPE GLOBAL
813 -VARIABLE_TYPE BIGINT
814 +VARIABLE_TYPE INT
815 VARIABLE_COMMENT Maximum number of instrumented user@host accounts. Use 0 to disable, -1 for automated sizing
816 NUMERIC_MIN_VALUE -1
817 NUMERIC_MAX_VALUE 1048576
818 @@ -2714,7 +2714,7 @@ READ_ONLY YES
819 COMMAND_LINE_ARGUMENT REQUIRED
820 VARIABLE_NAME PERFORMANCE_SCHEMA_DIGESTS_SIZE
821 VARIABLE_SCOPE GLOBAL
822 -VARIABLE_TYPE BIGINT
823 +VARIABLE_TYPE INT
824 VARIABLE_COMMENT Size of the statement digest. Use 0 to disable, -1 for automated sizing
825 NUMERIC_MIN_VALUE -1
826 NUMERIC_MAX_VALUE 1048576
827 @@ -2724,7 +2724,7 @@ READ_ONLY YES
828 COMMAND_LINE_ARGUMENT REQUIRED
829 VARIABLE_NAME PERFORMANCE_SCHEMA_EVENTS_STAGES_HISTORY_LONG_SIZE
830 VARIABLE_SCOPE GLOBAL
831 -VARIABLE_TYPE BIGINT
832 +VARIABLE_TYPE INT
833 VARIABLE_COMMENT Number of rows in EVENTS_STAGES_HISTORY_LONG. Use 0 to disable, -1 for automated sizing
834 NUMERIC_MIN_VALUE -1
835 NUMERIC_MAX_VALUE 1048576
836 @@ -2734,7 +2734,7 @@ READ_ONLY YES
837 COMMAND_LINE_ARGUMENT REQUIRED
838 VARIABLE_NAME PERFORMANCE_SCHEMA_EVENTS_STAGES_HISTORY_SIZE
839 VARIABLE_SCOPE GLOBAL
840 -VARIABLE_TYPE BIGINT
841 +VARIABLE_TYPE INT
842 VARIABLE_COMMENT Number of rows per thread in EVENTS_STAGES_HISTORY. Use 0 to disable, -1 for automated sizing
843 NUMERIC_MIN_VALUE -1
844 NUMERIC_MAX_VALUE 1024
845 @@ -2744,7 +2744,7 @@ READ_ONLY YES
846 COMMAND_LINE_ARGUMENT REQUIRED
847 VARIABLE_NAME PERFORMANCE_SCHEMA_EVENTS_STATEMENTS_HISTORY_LONG_SIZE
848 VARIABLE_SCOPE GLOBAL
849 -VARIABLE_TYPE BIGINT
850 +VARIABLE_TYPE INT
851 VARIABLE_COMMENT Number of rows in EVENTS_STATEMENTS_HISTORY_LONG. Use 0 to disable, -1 for automated sizing
852 NUMERIC_MIN_VALUE -1
853 NUMERIC_MAX_VALUE 1048576
854 @@ -2754,7 +2754,7 @@ READ_ONLY YES
855 COMMAND_LINE_ARGUMENT REQUIRED
856 VARIABLE_NAME PERFORMANCE_SCHEMA_EVENTS_STATEMENTS_HISTORY_SIZE
857 VARIABLE_SCOPE GLOBAL
858 -VARIABLE_TYPE BIGINT
859 +VARIABLE_TYPE INT
860 VARIABLE_COMMENT Number of rows per thread in EVENTS_STATEMENTS_HISTORY. Use 0 to disable, -1 for automated sizing
861 NUMERIC_MIN_VALUE -1
862 NUMERIC_MAX_VALUE 1024
863 @@ -2764,7 +2764,7 @@ READ_ONLY YES
864 COMMAND_LINE_ARGUMENT REQUIRED
865 VARIABLE_NAME PERFORMANCE_SCHEMA_EVENTS_TRANSACTIONS_HISTORY_LONG_SIZE
866 VARIABLE_SCOPE GLOBAL
867 -VARIABLE_TYPE BIGINT
868 +VARIABLE_TYPE INT
869 VARIABLE_COMMENT Number of rows in EVENTS_TRANSACTIONS_HISTORY_LONG. Use 0 to disable, -1 for automated sizing
870 NUMERIC_MIN_VALUE -1
871 NUMERIC_MAX_VALUE 1048576
872 @@ -2774,7 +2774,7 @@ READ_ONLY YES
873 COMMAND_LINE_ARGUMENT REQUIRED
874 VARIABLE_NAME PERFORMANCE_SCHEMA_EVENTS_TRANSACTIONS_HISTORY_SIZE
875 VARIABLE_SCOPE GLOBAL
876 -VARIABLE_TYPE BIGINT
877 +VARIABLE_TYPE INT
878 VARIABLE_COMMENT Number of rows per thread in EVENTS_TRANSACTIONS_HISTORY. Use 0 to disable, -1 for automated sizing
879 NUMERIC_MIN_VALUE -1
880 NUMERIC_MAX_VALUE 1024
881 @@ -2784,7 +2784,7 @@ READ_ONLY YES
882 COMMAND_LINE_ARGUMENT REQUIRED
883 VARIABLE_NAME PERFORMANCE_SCHEMA_EVENTS_WAITS_HISTORY_LONG_SIZE
884 VARIABLE_SCOPE GLOBAL
885 -VARIABLE_TYPE BIGINT
886 +VARIABLE_TYPE INT
887 VARIABLE_COMMENT Number of rows in EVENTS_WAITS_HISTORY_LONG. Use 0 to disable, -1 for automated sizing
888 NUMERIC_MIN_VALUE -1
889 NUMERIC_MAX_VALUE 1048576
890 @@ -2794,7 +2794,7 @@ READ_ONLY YES
891 COMMAND_LINE_ARGUMENT REQUIRED
892 VARIABLE_NAME PERFORMANCE_SCHEMA_EVENTS_WAITS_HISTORY_SIZE
893 VARIABLE_SCOPE GLOBAL
894 -VARIABLE_TYPE BIGINT
895 +VARIABLE_TYPE INT
896 VARIABLE_COMMENT Number of rows per thread in EVENTS_WAITS_HISTORY. Use 0 to disable, -1 for automated sizing
897 NUMERIC_MIN_VALUE -1
898 NUMERIC_MAX_VALUE 1024
899 @@ -2804,7 +2804,7 @@ READ_ONLY YES
900 COMMAND_LINE_ARGUMENT REQUIRED
901 VARIABLE_NAME PERFORMANCE_SCHEMA_HOSTS_SIZE
902 VARIABLE_SCOPE GLOBAL
903 -VARIABLE_TYPE BIGINT
904 +VARIABLE_TYPE INT
905 VARIABLE_COMMENT Maximum number of instrumented hosts. Use 0 to disable, -1 for automated sizing
906 NUMERIC_MIN_VALUE -1
907 NUMERIC_MAX_VALUE 1048576
908 @@ -2814,7 +2814,7 @@ READ_ONLY YES
909 COMMAND_LINE_ARGUMENT REQUIRED
910 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_COND_CLASSES
911 VARIABLE_SCOPE GLOBAL
912 -VARIABLE_TYPE BIGINT UNSIGNED
913 +VARIABLE_TYPE INT UNSIGNED
914 VARIABLE_COMMENT Maximum number of condition instruments
915 NUMERIC_MIN_VALUE 0
916 NUMERIC_MAX_VALUE 256
917 @@ -2824,7 +2824,7 @@ READ_ONLY YES
918 COMMAND_LINE_ARGUMENT REQUIRED
919 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_COND_INSTANCES
920 VARIABLE_SCOPE GLOBAL
921 -VARIABLE_TYPE BIGINT
922 +VARIABLE_TYPE INT
923 VARIABLE_COMMENT Maximum number of instrumented condition objects. Use 0 to disable, -1 for automated sizing
924 NUMERIC_MIN_VALUE -1
925 NUMERIC_MAX_VALUE 1048576
926 @@ -2834,7 +2834,7 @@ READ_ONLY YES
927 COMMAND_LINE_ARGUMENT REQUIRED
928 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_DIGEST_LENGTH
929 VARIABLE_SCOPE GLOBAL
930 -VARIABLE_TYPE BIGINT
931 +VARIABLE_TYPE INT
932 VARIABLE_COMMENT Maximum length considered for digest text, when stored in performance_schema tables
933 NUMERIC_MIN_VALUE 0
934 NUMERIC_MAX_VALUE 1048576
935 @@ -2844,7 +2844,7 @@ READ_ONLY YES
936 COMMAND_LINE_ARGUMENT REQUIRED
937 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_FILE_CLASSES
938 VARIABLE_SCOPE GLOBAL
939 -VARIABLE_TYPE BIGINT UNSIGNED
940 +VARIABLE_TYPE INT UNSIGNED
941 VARIABLE_COMMENT Maximum number of file instruments
942 NUMERIC_MIN_VALUE 0
943 NUMERIC_MAX_VALUE 256
944 @@ -2854,7 +2854,7 @@ READ_ONLY YES
945 COMMAND_LINE_ARGUMENT REQUIRED
946 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_FILE_HANDLES
947 VARIABLE_SCOPE GLOBAL
948 -VARIABLE_TYPE BIGINT UNSIGNED
949 +VARIABLE_TYPE INT UNSIGNED
950 VARIABLE_COMMENT Maximum number of opened instrumented files
951 NUMERIC_MIN_VALUE 0
952 NUMERIC_MAX_VALUE 1048576
953 @@ -2864,7 +2864,7 @@ READ_ONLY YES
954 COMMAND_LINE_ARGUMENT REQUIRED
955 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_FILE_INSTANCES
956 VARIABLE_SCOPE GLOBAL
957 -VARIABLE_TYPE BIGINT
958 +VARIABLE_TYPE INT
959 VARIABLE_COMMENT Maximum number of instrumented files. Use 0 to disable, -1 for automated sizing
960 NUMERIC_MIN_VALUE -1
961 NUMERIC_MAX_VALUE 1048576
962 @@ -2874,7 +2874,7 @@ READ_ONLY YES
963 COMMAND_LINE_ARGUMENT REQUIRED
964 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_INDEX_STAT
965 VARIABLE_SCOPE GLOBAL
966 -VARIABLE_TYPE BIGINT
967 +VARIABLE_TYPE INT
968 VARIABLE_COMMENT Maximum number of index statistics for instrumented tables. Use 0 to disable, -1 for automated scaling
969 NUMERIC_MIN_VALUE -1
970 NUMERIC_MAX_VALUE 1048576
971 @@ -2884,7 +2884,7 @@ READ_ONLY YES
972 COMMAND_LINE_ARGUMENT REQUIRED
973 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_MEMORY_CLASSES
974 VARIABLE_SCOPE GLOBAL
975 -VARIABLE_TYPE BIGINT UNSIGNED
976 +VARIABLE_TYPE INT UNSIGNED
977 VARIABLE_COMMENT Maximum number of memory pool instruments
978 NUMERIC_MIN_VALUE 0
979 NUMERIC_MAX_VALUE 1024
980 @@ -2894,7 +2894,7 @@ READ_ONLY YES
981 COMMAND_LINE_ARGUMENT REQUIRED
982 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_METADATA_LOCKS
983 VARIABLE_SCOPE GLOBAL
984 -VARIABLE_TYPE BIGINT
985 +VARIABLE_TYPE INT
986 VARIABLE_COMMENT Maximum number of metadata locks. Use 0 to disable, -1 for automated scaling
987 NUMERIC_MIN_VALUE -1
988 NUMERIC_MAX_VALUE 104857600
989 @@ -2904,7 +2904,7 @@ READ_ONLY YES
990 COMMAND_LINE_ARGUMENT REQUIRED
991 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_MUTEX_CLASSES
992 VARIABLE_SCOPE GLOBAL
993 -VARIABLE_TYPE BIGINT UNSIGNED
994 +VARIABLE_TYPE INT UNSIGNED
995 VARIABLE_COMMENT Maximum number of mutex instruments
996 NUMERIC_MIN_VALUE 0
997 NUMERIC_MAX_VALUE 256
998 @@ -2914,7 +2914,7 @@ READ_ONLY YES
999 COMMAND_LINE_ARGUMENT REQUIRED
1000 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_MUTEX_INSTANCES
1001 VARIABLE_SCOPE GLOBAL
1002 -VARIABLE_TYPE BIGINT
1003 +VARIABLE_TYPE INT
1004 VARIABLE_COMMENT Maximum number of instrumented MUTEX objects. Use 0 to disable, -1 for automated sizing
1005 NUMERIC_MIN_VALUE -1
1006 NUMERIC_MAX_VALUE 104857600
1007 @@ -2924,7 +2924,7 @@ READ_ONLY YES
1008 COMMAND_LINE_ARGUMENT REQUIRED
1009 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_PREPARED_STATEMENTS_INSTANCES
1010 VARIABLE_SCOPE GLOBAL
1011 -VARIABLE_TYPE BIGINT
1012 +VARIABLE_TYPE INT
1013 VARIABLE_COMMENT Maximum number of instrumented prepared statements. Use 0 to disable, -1 for automated scaling
1014 NUMERIC_MIN_VALUE -1
1015 NUMERIC_MAX_VALUE 1048576
1016 @@ -2934,7 +2934,7 @@ READ_ONLY YES
1017 COMMAND_LINE_ARGUMENT REQUIRED
1018 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_PROGRAM_INSTANCES
1019 VARIABLE_SCOPE GLOBAL
1020 -VARIABLE_TYPE BIGINT
1021 +VARIABLE_TYPE INT
1022 VARIABLE_COMMENT Maximum number of instrumented programs. Use 0 to disable, -1 for automated scaling
1023 NUMERIC_MIN_VALUE -1
1024 NUMERIC_MAX_VALUE 1048576
1025 @@ -2944,7 +2944,7 @@ READ_ONLY YES
1026 COMMAND_LINE_ARGUMENT REQUIRED
1027 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_RWLOCK_CLASSES
1028 VARIABLE_SCOPE GLOBAL
1029 -VARIABLE_TYPE BIGINT UNSIGNED
1030 +VARIABLE_TYPE INT UNSIGNED
1031 VARIABLE_COMMENT Maximum number of rwlock instruments
1032 NUMERIC_MIN_VALUE 0
1033 NUMERIC_MAX_VALUE 256
1034 @@ -2954,7 +2954,7 @@ READ_ONLY YES
1035 COMMAND_LINE_ARGUMENT REQUIRED
1036 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_RWLOCK_INSTANCES
1037 VARIABLE_SCOPE GLOBAL
1038 -VARIABLE_TYPE BIGINT
1039 +VARIABLE_TYPE INT
1040 VARIABLE_COMMENT Maximum number of instrumented RWLOCK objects. Use 0 to disable, -1 for automated sizing
1041 NUMERIC_MIN_VALUE -1
1042 NUMERIC_MAX_VALUE 104857600
1043 @@ -2964,7 +2964,7 @@ READ_ONLY YES
1044 COMMAND_LINE_ARGUMENT REQUIRED
1045 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_SOCKET_CLASSES
1046 VARIABLE_SCOPE GLOBAL
1047 -VARIABLE_TYPE BIGINT UNSIGNED
1048 +VARIABLE_TYPE INT UNSIGNED
1049 VARIABLE_COMMENT Maximum number of socket instruments
1050 NUMERIC_MIN_VALUE 0
1051 NUMERIC_MAX_VALUE 256
1052 @@ -2974,7 +2974,7 @@ READ_ONLY YES
1053 COMMAND_LINE_ARGUMENT REQUIRED
1054 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_SOCKET_INSTANCES
1055 VARIABLE_SCOPE GLOBAL
1056 -VARIABLE_TYPE BIGINT
1057 +VARIABLE_TYPE INT
1058 VARIABLE_COMMENT Maximum number of opened instrumented sockets. Use 0 to disable, -1 for automated sizing
1059 NUMERIC_MIN_VALUE -1
1060 NUMERIC_MAX_VALUE 1048576
1061 @@ -2984,7 +2984,7 @@ READ_ONLY YES
1062 COMMAND_LINE_ARGUMENT REQUIRED
1063 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_SQL_TEXT_LENGTH
1064 VARIABLE_SCOPE GLOBAL
1065 -VARIABLE_TYPE BIGINT
1066 +VARIABLE_TYPE INT
1067 VARIABLE_COMMENT Maximum length of displayed sql text
1068 NUMERIC_MIN_VALUE 0
1069 NUMERIC_MAX_VALUE 1048576
1070 @@ -2994,7 +2994,7 @@ READ_ONLY YES
1071 COMMAND_LINE_ARGUMENT REQUIRED
1072 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_STAGE_CLASSES
1073 VARIABLE_SCOPE GLOBAL
1074 -VARIABLE_TYPE BIGINT UNSIGNED
1075 +VARIABLE_TYPE INT UNSIGNED
1076 VARIABLE_COMMENT Maximum number of stage instruments
1077 NUMERIC_MIN_VALUE 0
1078 NUMERIC_MAX_VALUE 256
1079 @@ -3004,7 +3004,7 @@ READ_ONLY YES
1080 COMMAND_LINE_ARGUMENT REQUIRED
1081 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_STATEMENT_CLASSES
1082 VARIABLE_SCOPE GLOBAL
1083 -VARIABLE_TYPE BIGINT UNSIGNED
1084 +VARIABLE_TYPE INT UNSIGNED
1085 VARIABLE_COMMENT Maximum number of statement instruments
1086 NUMERIC_MIN_VALUE 0
1087 NUMERIC_MAX_VALUE 256
1088 @@ -3014,7 +3014,7 @@ READ_ONLY YES
1089 COMMAND_LINE_ARGUMENT REQUIRED
1090 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_STATEMENT_STACK
1091 VARIABLE_SCOPE GLOBAL
1092 -VARIABLE_TYPE BIGINT UNSIGNED
1093 +VARIABLE_TYPE INT UNSIGNED
1094 VARIABLE_COMMENT Number of rows per thread in EVENTS_STATEMENTS_CURRENT
1095 NUMERIC_MIN_VALUE 1
1096 NUMERIC_MAX_VALUE 256
1097 @@ -3024,7 +3024,7 @@ READ_ONLY YES
1098 COMMAND_LINE_ARGUMENT REQUIRED
1099 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_TABLE_HANDLES
1100 VARIABLE_SCOPE GLOBAL
1101 -VARIABLE_TYPE BIGINT
1102 +VARIABLE_TYPE INT
1103 VARIABLE_COMMENT Maximum number of opened instrumented tables. Use 0 to disable, -1 for automated sizing
1104 NUMERIC_MIN_VALUE -1
1105 NUMERIC_MAX_VALUE 1048576
1106 @@ -3034,7 +3034,7 @@ READ_ONLY YES
1107 COMMAND_LINE_ARGUMENT REQUIRED
1108 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_TABLE_INSTANCES
1109 VARIABLE_SCOPE GLOBAL
1110 -VARIABLE_TYPE BIGINT
1111 +VARIABLE_TYPE INT
1112 VARIABLE_COMMENT Maximum number of instrumented tables. Use 0 to disable, -1 for automated sizing
1113 NUMERIC_MIN_VALUE -1
1114 NUMERIC_MAX_VALUE 1048576
1115 @@ -3044,7 +3044,7 @@ READ_ONLY YES
1116 COMMAND_LINE_ARGUMENT REQUIRED
1117 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_TABLE_LOCK_STAT
1118 VARIABLE_SCOPE GLOBAL
1119 -VARIABLE_TYPE BIGINT
1120 +VARIABLE_TYPE INT
1121 VARIABLE_COMMENT Maximum number of lock statistics for instrumented tables. Use 0 to disable, -1 for automated scaling
1122 NUMERIC_MIN_VALUE -1
1123 NUMERIC_MAX_VALUE 1048576
1124 @@ -3054,7 +3054,7 @@ READ_ONLY YES
1125 COMMAND_LINE_ARGUMENT REQUIRED
1126 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_THREAD_CLASSES
1127 VARIABLE_SCOPE GLOBAL
1128 -VARIABLE_TYPE BIGINT UNSIGNED
1129 +VARIABLE_TYPE INT UNSIGNED
1130 VARIABLE_COMMENT Maximum number of thread instruments
1131 NUMERIC_MIN_VALUE 0
1132 NUMERIC_MAX_VALUE 256
1133 @@ -3064,7 +3064,7 @@ READ_ONLY YES
1134 COMMAND_LINE_ARGUMENT REQUIRED
1135 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_THREAD_INSTANCES
1136 VARIABLE_SCOPE GLOBAL
1137 -VARIABLE_TYPE BIGINT
1138 +VARIABLE_TYPE INT
1139 VARIABLE_COMMENT Maximum number of instrumented threads. Use 0 to disable, -1 for automated sizing
1140 NUMERIC_MIN_VALUE -1
1141 NUMERIC_MAX_VALUE 1048576
1142 @@ -3074,7 +3074,7 @@ READ_ONLY YES
1143 COMMAND_LINE_ARGUMENT REQUIRED
1144 VARIABLE_NAME PERFORMANCE_SCHEMA_SESSION_CONNECT_ATTRS_SIZE
1145 VARIABLE_SCOPE GLOBAL
1146 -VARIABLE_TYPE BIGINT
1147 +VARIABLE_TYPE INT
1148 VARIABLE_COMMENT Size of session attribute string buffer per thread. Use 0 to disable, -1 for automated sizing
1149 NUMERIC_MIN_VALUE -1
1150 NUMERIC_MAX_VALUE 1048576
1151 @@ -3084,7 +3084,7 @@ READ_ONLY YES
1152 COMMAND_LINE_ARGUMENT REQUIRED
1153 VARIABLE_NAME PERFORMANCE_SCHEMA_SETUP_ACTORS_SIZE
1154 VARIABLE_SCOPE GLOBAL
1155 -VARIABLE_TYPE BIGINT
1156 +VARIABLE_TYPE INT
1157 VARIABLE_COMMENT Maximum number of rows in SETUP_ACTORS
1158 NUMERIC_MIN_VALUE -1
1159 NUMERIC_MAX_VALUE 1024
1160 @@ -3094,7 +3094,7 @@ READ_ONLY YES
1161 COMMAND_LINE_ARGUMENT REQUIRED
1162 VARIABLE_NAME PERFORMANCE_SCHEMA_SETUP_OBJECTS_SIZE
1163 VARIABLE_SCOPE GLOBAL
1164 -VARIABLE_TYPE BIGINT
1165 +VARIABLE_TYPE INT
1166 VARIABLE_COMMENT Maximum number of rows in SETUP_OBJECTS
1167 NUMERIC_MIN_VALUE -1
1168 NUMERIC_MAX_VALUE 1048576
1169 @@ -3104,7 +3104,7 @@ READ_ONLY YES
1170 COMMAND_LINE_ARGUMENT REQUIRED
1171 VARIABLE_NAME PERFORMANCE_SCHEMA_USERS_SIZE
1172 VARIABLE_SCOPE GLOBAL
1173 -VARIABLE_TYPE BIGINT
1174 +VARIABLE_TYPE INT
1175 VARIABLE_COMMENT Maximum number of instrumented users. Use 0 to disable, -1 for automated sizing
1176 NUMERIC_MIN_VALUE -1
1177 NUMERIC_MAX_VALUE 1048576
1178 @@ -3154,7 +3154,7 @@ READ_ONLY YES
1179 COMMAND_LINE_ARGUMENT REQUIRED
1180 VARIABLE_NAME PRELOAD_BUFFER_SIZE
1181 VARIABLE_SCOPE SESSION
1182 -VARIABLE_TYPE BIGINT UNSIGNED
1183 +VARIABLE_TYPE INT UNSIGNED
1184 VARIABLE_COMMENT The size of the buffer that is allocated when preloading indexes
1185 NUMERIC_MIN_VALUE 1024
1186 NUMERIC_MAX_VALUE 1073741824
1187 @@ -3174,7 +3174,7 @@ READ_ONLY NO
1188 COMMAND_LINE_ARGUMENT NULL
1189 VARIABLE_NAME PROFILING_HISTORY_SIZE
1190 VARIABLE_SCOPE SESSION
1191 -VARIABLE_TYPE BIGINT UNSIGNED
1192 +VARIABLE_TYPE INT UNSIGNED
1193 VARIABLE_COMMENT Number of statements about which profiling information is maintained. If set to 0, no profiles are stored. See SHOW PROFILES
1194 NUMERIC_MIN_VALUE 0
1195 NUMERIC_MAX_VALUE 100
1196 @@ -3184,7 +3184,7 @@ READ_ONLY NO
1197 COMMAND_LINE_ARGUMENT REQUIRED
1198 VARIABLE_NAME PROGRESS_REPORT_TIME
1199 VARIABLE_SCOPE SESSION
1200 -VARIABLE_TYPE BIGINT UNSIGNED
1201 +VARIABLE_TYPE INT UNSIGNED
1202 VARIABLE_COMMENT Seconds between sending progress reports to the client for time-consuming statements. Set to 0 to disable progress reporting
1203 NUMERIC_MIN_VALUE 0
1204 NUMERIC_MAX_VALUE 4294967295
1205 @@ -3244,7 +3244,7 @@ READ_ONLY NO
1206 COMMAND_LINE_ARGUMENT NULL
1207 VARIABLE_NAME QUERY_ALLOC_BLOCK_SIZE
1208 VARIABLE_SCOPE SESSION
1209 -VARIABLE_TYPE BIGINT UNSIGNED
1210 +VARIABLE_TYPE INT UNSIGNED
1211 VARIABLE_COMMENT Allocation block size for query parsing and execution
1212 NUMERIC_MIN_VALUE 1024
1213 NUMERIC_MAX_VALUE 4294967295
1214 @@ -3254,7 +3254,7 @@ READ_ONLY NO
1215 COMMAND_LINE_ARGUMENT REQUIRED
1216 VARIABLE_NAME QUERY_CACHE_LIMIT
1217 VARIABLE_SCOPE GLOBAL
1218 -VARIABLE_TYPE BIGINT UNSIGNED
1219 +VARIABLE_TYPE INT UNSIGNED
1220 VARIABLE_COMMENT Don't cache results that are bigger than this
1221 NUMERIC_MIN_VALUE 0
1222 NUMERIC_MAX_VALUE 4294967295
1223 @@ -3264,7 +3264,7 @@ READ_ONLY NO
1224 COMMAND_LINE_ARGUMENT REQUIRED
1225 VARIABLE_NAME QUERY_CACHE_MIN_RES_UNIT
1226 VARIABLE_SCOPE GLOBAL
1227 -VARIABLE_TYPE BIGINT UNSIGNED
1228 +VARIABLE_TYPE INT UNSIGNED
1229 VARIABLE_COMMENT The minimum size for blocks allocated by the query cache
1230 NUMERIC_MIN_VALUE 0
1231 NUMERIC_MAX_VALUE 4294967295
1232 @@ -3277,7 +3277,7 @@ VARIABLE_SCOPE GLOBAL
1233 VARIABLE_TYPE BIGINT UNSIGNED
1234 VARIABLE_COMMENT The memory allocated to store results from old queries
1235 NUMERIC_MIN_VALUE 0
1236 -NUMERIC_MAX_VALUE 18446744073709551615
1237 +NUMERIC_MAX_VALUE 4294967295
1238 NUMERIC_BLOCK_SIZE 1024
1239 ENUM_VALUE_LIST NULL
1240 READ_ONLY NO
1241 @@ -3314,7 +3314,7 @@ READ_ONLY NO
1242 COMMAND_LINE_ARGUMENT OPTIONAL
1243 VARIABLE_NAME QUERY_PREALLOC_SIZE
1244 VARIABLE_SCOPE SESSION
1245 -VARIABLE_TYPE BIGINT UNSIGNED
1246 +VARIABLE_TYPE INT UNSIGNED
1247 VARIABLE_COMMENT Persistent buffer for query parsing and execution
1248 NUMERIC_MIN_VALUE 1024
1249 NUMERIC_MAX_VALUE 4294967295
1250 @@ -3327,7 +3327,7 @@ VARIABLE_SCOPE SESSION ONLY
1251 VARIABLE_TYPE BIGINT UNSIGNED
1252 VARIABLE_COMMENT Sets the internal state of the RAND() generator for replication purposes
1253 NUMERIC_MIN_VALUE 0
1254 -NUMERIC_MAX_VALUE 18446744073709551615
1255 +NUMERIC_MAX_VALUE 4294967295
1256 NUMERIC_BLOCK_SIZE 1
1257 ENUM_VALUE_LIST NULL
1258 READ_ONLY NO
1259 @@ -3337,14 +3337,14 @@ VARIABLE_SCOPE SESSION ONLY
1260 VARIABLE_TYPE BIGINT UNSIGNED
1261 VARIABLE_COMMENT Sets the internal state of the RAND() generator for replication purposes
1262 NUMERIC_MIN_VALUE 0
1263 -NUMERIC_MAX_VALUE 18446744073709551615
1264 +NUMERIC_MAX_VALUE 4294967295
1265 NUMERIC_BLOCK_SIZE 1
1266 ENUM_VALUE_LIST NULL
1267 READ_ONLY NO
1268 COMMAND_LINE_ARGUMENT NULL
1269 VARIABLE_NAME RANGE_ALLOC_BLOCK_SIZE
1270 VARIABLE_SCOPE SESSION
1271 -VARIABLE_TYPE BIGINT UNSIGNED
1272 +VARIABLE_TYPE INT UNSIGNED
1273 VARIABLE_COMMENT Allocation block size for storing ranges during optimization
1274 NUMERIC_MIN_VALUE 4096
1275 NUMERIC_MAX_VALUE 4294967295
1276 @@ -3354,7 +3354,7 @@ READ_ONLY NO
1277 COMMAND_LINE_ARGUMENT REQUIRED
1278 VARIABLE_NAME READ_BUFFER_SIZE
1279 VARIABLE_SCOPE SESSION
1280 -VARIABLE_TYPE BIGINT UNSIGNED
1281 +VARIABLE_TYPE INT UNSIGNED
1282 VARIABLE_COMMENT Each thread that does a sequential scan allocates a buffer of this size for each table it scans. If you do many sequential scans, you may want to increase this value
1283 NUMERIC_MIN_VALUE 8192
1284 NUMERIC_MAX_VALUE 2147483647
1285 @@ -3374,7 +3374,7 @@ READ_ONLY NO
1286 COMMAND_LINE_ARGUMENT OPTIONAL
1287 VARIABLE_NAME READ_RND_BUFFER_SIZE
1288 VARIABLE_SCOPE SESSION
1289 -VARIABLE_TYPE BIGINT UNSIGNED
1290 +VARIABLE_TYPE INT UNSIGNED
1291 VARIABLE_COMMENT When reading rows in sorted order after a sort, the rows are read through this buffer to avoid a disk seeks
1292 NUMERIC_MIN_VALUE 1
1293 NUMERIC_MAX_VALUE 2147483647
1294 @@ -3394,10 +3394,10 @@ READ_ONLY NO
1295 COMMAND_LINE_ARGUMENT OPTIONAL
1296 VARIABLE_NAME ROWID_MERGE_BUFF_SIZE
1297 VARIABLE_SCOPE SESSION
1298 -VARIABLE_TYPE BIGINT UNSIGNED
1299 +VARIABLE_TYPE INT UNSIGNED
1300 VARIABLE_COMMENT The size of the buffers used [NOT] IN evaluation via partial matching
1301 NUMERIC_MIN_VALUE 0
1302 -NUMERIC_MAX_VALUE 9223372036854775807
1303 +NUMERIC_MAX_VALUE 2147483647
1304 NUMERIC_BLOCK_SIZE 1
1305 ENUM_VALUE_LIST NULL
1306 READ_ONLY NO
1307 @@ -3434,7 +3434,7 @@ READ_ONLY YES
1308 COMMAND_LINE_ARGUMENT REQUIRED
1309 VARIABLE_NAME SERVER_ID
1310 VARIABLE_SCOPE SESSION
1311 -VARIABLE_TYPE BIGINT UNSIGNED
1312 +VARIABLE_TYPE INT UNSIGNED
1313 VARIABLE_COMMENT Uniquely identifies the server instance in the community of replication partners
1314 NUMERIC_MIN_VALUE 1
1315 NUMERIC_MAX_VALUE 4294967295
1316 @@ -3534,7 +3534,7 @@ READ_ONLY NO
1317 COMMAND_LINE_ARGUMENT REQUIRED
1318 VARIABLE_NAME SLAVE_MAX_ALLOWED_PACKET
1319 VARIABLE_SCOPE GLOBAL
1320 -VARIABLE_TYPE BIGINT UNSIGNED
1321 +VARIABLE_TYPE INT UNSIGNED
1322 VARIABLE_COMMENT The maximum packet length to sent successfully from the master to slave
1323 NUMERIC_MIN_VALUE 1024
1324 NUMERIC_MAX_VALUE 1073741824
1325 @@ -3544,7 +3544,7 @@ READ_ONLY NO
1326 COMMAND_LINE_ARGUMENT REQUIRED
1327 VARIABLE_NAME SLOW_LAUNCH_TIME
1328 VARIABLE_SCOPE GLOBAL
1329 -VARIABLE_TYPE BIGINT UNSIGNED
1330 +VARIABLE_TYPE INT UNSIGNED
1331 VARIABLE_COMMENT If creating the thread takes longer than this value (in seconds), the Slow_launch_threads counter will be incremented
1332 NUMERIC_MIN_VALUE 0
1333 NUMERIC_MAX_VALUE 31536000
1334 @@ -3587,7 +3587,7 @@ VARIABLE_SCOPE SESSION
1335 VARIABLE_TYPE BIGINT UNSIGNED
1336 VARIABLE_COMMENT Each thread that needs to do a sort allocates a buffer of this size
1337 NUMERIC_MIN_VALUE 1024
1338 -NUMERIC_MAX_VALUE 18446744073709551615
1339 +NUMERIC_MAX_VALUE 4294967295
1340 NUMERIC_BLOCK_SIZE 1
1341 ENUM_VALUE_LIST NULL
1342 READ_ONLY NO
1343 @@ -3804,7 +3804,7 @@ READ_ONLY NO
1344 COMMAND_LINE_ARGUMENT NULL
1345 VARIABLE_NAME STORED_PROGRAM_CACHE
1346 VARIABLE_SCOPE GLOBAL
1347 -VARIABLE_TYPE BIGINT UNSIGNED
1348 +VARIABLE_TYPE INT UNSIGNED
1349 VARIABLE_COMMENT The soft upper limit for number of cached stored routines for one connection
1350 NUMERIC_MIN_VALUE 0
1351 NUMERIC_MAX_VALUE 524288
1352 @@ -3894,7 +3894,7 @@ READ_ONLY NO
1353 COMMAND_LINE_ARGUMENT OPTIONAL
1354 VARIABLE_NAME TABLE_DEFINITION_CACHE
1355 VARIABLE_SCOPE GLOBAL
1356 -VARIABLE_TYPE BIGINT UNSIGNED
1357 +VARIABLE_TYPE INT UNSIGNED
1358 VARIABLE_COMMENT The number of cached table definitions
1359 NUMERIC_MIN_VALUE 400
1360 NUMERIC_MAX_VALUE 2097152
1361 @@ -3904,7 +3904,7 @@ READ_ONLY NO
1362 COMMAND_LINE_ARGUMENT REQUIRED
1363 VARIABLE_NAME TABLE_OPEN_CACHE
1364 VARIABLE_SCOPE GLOBAL
1365 -VARIABLE_TYPE BIGINT UNSIGNED
1366 +VARIABLE_TYPE INT UNSIGNED
1367 VARIABLE_COMMENT The number of cached open tables
1368 NUMERIC_MIN_VALUE 10
1369 NUMERIC_MAX_VALUE 1048576
1370 @@ -3964,7 +3964,7 @@ READ_ONLY NO
1371 COMMAND_LINE_ARGUMENT OPTIONAL
1372 VARIABLE_NAME THREAD_CACHE_SIZE
1373 VARIABLE_SCOPE GLOBAL
1374 -VARIABLE_TYPE BIGINT UNSIGNED
1375 +VARIABLE_TYPE INT UNSIGNED
1376 VARIABLE_COMMENT How many threads we should keep in a cache for reuse. These are freed after 5 minutes of idle time
1377 NUMERIC_MIN_VALUE 0
1378 NUMERIC_MAX_VALUE 16384
1379 @@ -4027,7 +4027,7 @@ VARIABLE_SCOPE SESSION
1380 VARIABLE_TYPE BIGINT UNSIGNED
1381 VARIABLE_COMMENT Max size for data for an internal temporary on-disk MyISAM or Aria table
1382 NUMERIC_MIN_VALUE 1024
1383 -NUMERIC_MAX_VALUE 18446744073709551615
1384 +NUMERIC_MAX_VALUE 4294967295
1385 NUMERIC_BLOCK_SIZE 1
1386 ENUM_VALUE_LIST NULL
1387 READ_ONLY NO
1388 @@ -4037,7 +4037,7 @@ VARIABLE_SCOPE SESSION
1389 VARIABLE_TYPE BIGINT UNSIGNED
1390 VARIABLE_COMMENT If an internal in-memory temporary table exceeds this size, MariaDB will automatically convert it to an on-disk MyISAM or Aria table. Same as tmp_table_size
1391 NUMERIC_MIN_VALUE 0
1392 -NUMERIC_MAX_VALUE 18446744073709551615
1393 +NUMERIC_MAX_VALUE 4294967295
1394 NUMERIC_BLOCK_SIZE 16384
1395 ENUM_VALUE_LIST NULL
1396 READ_ONLY NO
1397 @@ -4047,14 +4047,14 @@ VARIABLE_SCOPE SESSION
1398 VARIABLE_TYPE BIGINT UNSIGNED
1399 VARIABLE_COMMENT Alias for tmp_memory_table_size. If an internal in-memory temporary table exceeds this size, MariaDB will automatically convert it to an on-disk MyISAM or Aria table
1400 NUMERIC_MIN_VALUE 0
1401 -NUMERIC_MAX_VALUE 18446744073709551615
1402 +NUMERIC_MAX_VALUE 4294967295
1403 NUMERIC_BLOCK_SIZE 16384
1404 ENUM_VALUE_LIST NULL
1405 READ_ONLY NO
1406 COMMAND_LINE_ARGUMENT REQUIRED
1407 VARIABLE_NAME TRANSACTION_ALLOC_BLOCK_SIZE
1408 VARIABLE_SCOPE SESSION
1409 -VARIABLE_TYPE BIGINT UNSIGNED
1410 +VARIABLE_TYPE INT UNSIGNED
1411 VARIABLE_COMMENT Allocation block size for transactions to be stored in binary log
1412 NUMERIC_MIN_VALUE 1024
1413 NUMERIC_MAX_VALUE 134217728
1414 @@ -4074,7 +4074,7 @@ READ_ONLY NO
1415 COMMAND_LINE_ARGUMENT NULL
1416 VARIABLE_NAME TRANSACTION_PREALLOC_SIZE
1417 VARIABLE_SCOPE SESSION
1418 -VARIABLE_TYPE BIGINT UNSIGNED
1419 +VARIABLE_TYPE INT UNSIGNED
1420 VARIABLE_COMMENT Persistent buffer for transactions to be stored in binary log
1421 NUMERIC_MIN_VALUE 1024
1422 NUMERIC_MAX_VALUE 134217728
1423 @@ -4224,7 +4224,7 @@ READ_ONLY YES
1424 COMMAND_LINE_ARGUMENT NULL
1425 VARIABLE_NAME WAIT_TIMEOUT
1426 VARIABLE_SCOPE SESSION
1427 -VARIABLE_TYPE BIGINT UNSIGNED
1428 +VARIABLE_TYPE INT UNSIGNED
1429 VARIABLE_COMMENT The number of seconds the server waits for activity on a connection before closing it
1430 NUMERIC_MIN_VALUE 1
1431 NUMERIC_MAX_VALUE 31536000
1432 @@ -4251,7 +4251,7 @@ order by variable_name;
1433 VARIABLE_NAME LOG_TC_SIZE
1434 GLOBAL_VALUE_ORIGIN AUTO
1435 VARIABLE_SCOPE GLOBAL
1436 -VARIABLE_TYPE BIGINT UNSIGNED
1437 +VARIABLE_TYPE INT UNSIGNED
1438 VARIABLE_COMMENT Size of transaction coordinator log
1439 ENUM_VALUE_LIST NULL
1440 READ_ONLY YES