Debian Codegraph @

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

raw
1 --- a/mysql-test/suite/sys_vars/r/sysvars_server_notembedded.result
2 +++ b/mysql-test/suite/sys_vars/r/sysvars_server_notembedded.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 @@ -367,7 +367,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 @@ -384,20 +384,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 @@ -424,7 +424,7 @@ READ_ONLY YES
168 COMMAND_LINE_ARGUMENT NULL
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 @@ -437,7 +437,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 @@ -524,7 +524,7 @@ READ_ONLY YES
186 COMMAND_LINE_ARGUMENT REQUIRED
187 VARIABLE_NAME BINLOG_ROW_EVENT_MAX_SIZE
188 VARIABLE_SCOPE GLOBAL
189 -VARIABLE_TYPE BIGINT UNSIGNED
190 +VARIABLE_TYPE INT UNSIGNED
191 VARIABLE_COMMENT The maximum size of a row-based binary log event in bytes. Rows will be grouped into events smaller than this size if possible. The value has to be a multiple of 256
192 NUMERIC_MIN_VALUE 256
193 NUMERIC_MAX_VALUE 4294967040
194 @@ -567,7 +567,7 @@ VARIABLE_SCOPE GLOBAL
195 VARIABLE_TYPE BIGINT UNSIGNED
196 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
197 NUMERIC_MIN_VALUE 4096
198 -NUMERIC_MAX_VALUE 18446744073709551615
199 +NUMERIC_MAX_VALUE 4294967295
200 NUMERIC_BLOCK_SIZE 4096
201 ENUM_VALUE_LIST NULL
202 READ_ONLY NO
203 @@ -587,7 +587,7 @@ VARIABLE_SCOPE SESSION
204 VARIABLE_TYPE BIGINT UNSIGNED
205 VARIABLE_COMMENT Size of tree cache used in bulk insert optimization. Note that this is a limit per thread
206 NUMERIC_MIN_VALUE 0
207 -NUMERIC_MAX_VALUE 18446744073709551615
208 +NUMERIC_MAX_VALUE 4294967295
209 NUMERIC_BLOCK_SIZE 1
210 ENUM_VALUE_LIST NULL
211 READ_ONLY NO
212 @@ -784,7 +784,7 @@ READ_ONLY NO
213 COMMAND_LINE_ARGUMENT OPTIONAL
214 VARIABLE_NAME CONNECT_TIMEOUT
215 VARIABLE_SCOPE GLOBAL
216 -VARIABLE_TYPE BIGINT UNSIGNED
217 +VARIABLE_TYPE INT UNSIGNED
218 VARIABLE_COMMENT The number of seconds the MariaDB server is waiting for a connect packet before responding with 'Bad handshake'
219 NUMERIC_MIN_VALUE 2
220 NUMERIC_MAX_VALUE 31536000
221 @@ -814,7 +814,7 @@ READ_ONLY YES
222 COMMAND_LINE_ARGUMENT REQUIRED
223 VARIABLE_NAME DEADLOCK_SEARCH_DEPTH_LONG
224 VARIABLE_SCOPE SESSION
225 -VARIABLE_TYPE BIGINT UNSIGNED
226 +VARIABLE_TYPE INT UNSIGNED
227 VARIABLE_COMMENT Long search depth for the two-step deadlock detection
228 NUMERIC_MIN_VALUE 0
229 NUMERIC_MAX_VALUE 33
230 @@ -824,7 +824,7 @@ READ_ONLY NO
231 COMMAND_LINE_ARGUMENT REQUIRED
232 VARIABLE_NAME DEADLOCK_SEARCH_DEPTH_SHORT
233 VARIABLE_SCOPE SESSION
234 -VARIABLE_TYPE BIGINT UNSIGNED
235 +VARIABLE_TYPE INT UNSIGNED
236 VARIABLE_COMMENT Short search depth for the two-step deadlock detection
237 NUMERIC_MIN_VALUE 0
238 NUMERIC_MAX_VALUE 32
239 @@ -834,7 +834,7 @@ READ_ONLY NO
240 COMMAND_LINE_ARGUMENT REQUIRED
241 VARIABLE_NAME DEADLOCK_TIMEOUT_LONG
242 VARIABLE_SCOPE SESSION
243 -VARIABLE_TYPE BIGINT UNSIGNED
244 +VARIABLE_TYPE INT UNSIGNED
245 VARIABLE_COMMENT Long 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 REQUIRED
250 VARIABLE_NAME DEADLOCK_TIMEOUT_SHORT
251 VARIABLE_SCOPE SESSION
252 -VARIABLE_TYPE BIGINT UNSIGNED
253 +VARIABLE_TYPE INT UNSIGNED
254 VARIABLE_COMMENT Short timeout for the two-step deadlock detection (in microseconds)
255 NUMERIC_MIN_VALUE 0
256 NUMERIC_MAX_VALUE 4294967295
257 @@ -904,7 +904,7 @@ READ_ONLY NO
258 COMMAND_LINE_ARGUMENT NULL
259 VARIABLE_NAME DEFAULT_WEEK_FORMAT
260 VARIABLE_SCOPE SESSION
261 -VARIABLE_TYPE BIGINT UNSIGNED
262 +VARIABLE_TYPE INT UNSIGNED
263 VARIABLE_COMMENT The default week format used by WEEK() functions
264 NUMERIC_MIN_VALUE 0
265 NUMERIC_MAX_VALUE 7
266 @@ -914,7 +914,7 @@ READ_ONLY NO
267 COMMAND_LINE_ARGUMENT REQUIRED
268 VARIABLE_NAME DELAYED_INSERT_LIMIT
269 VARIABLE_SCOPE GLOBAL
270 -VARIABLE_TYPE BIGINT UNSIGNED
271 +VARIABLE_TYPE INT UNSIGNED
272 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
273 NUMERIC_MIN_VALUE 1
274 NUMERIC_MAX_VALUE 4294967295
275 @@ -924,7 +924,7 @@ READ_ONLY NO
276 COMMAND_LINE_ARGUMENT REQUIRED
277 VARIABLE_NAME DELAYED_INSERT_TIMEOUT
278 VARIABLE_SCOPE GLOBAL
279 -VARIABLE_TYPE BIGINT UNSIGNED
280 +VARIABLE_TYPE INT UNSIGNED
281 VARIABLE_COMMENT How long a INSERT DELAYED thread should wait for INSERT statements before terminating
282 NUMERIC_MIN_VALUE 1
283 NUMERIC_MAX_VALUE 31536000
284 @@ -934,7 +934,7 @@ READ_ONLY NO
285 COMMAND_LINE_ARGUMENT REQUIRED
286 VARIABLE_NAME DELAYED_QUEUE_SIZE
287 VARIABLE_SCOPE GLOBAL
288 -VARIABLE_TYPE BIGINT UNSIGNED
289 +VARIABLE_TYPE INT UNSIGNED
290 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
291 NUMERIC_MIN_VALUE 1
292 NUMERIC_MAX_VALUE 4294967295
293 @@ -964,7 +964,7 @@ READ_ONLY NO
294 COMMAND_LINE_ARGUMENT OPTIONAL
295 VARIABLE_NAME DIV_PRECISION_INCREMENT
296 VARIABLE_SCOPE SESSION
297 -VARIABLE_TYPE BIGINT UNSIGNED
298 +VARIABLE_TYPE INT UNSIGNED
299 VARIABLE_COMMENT Precision of the result of '/' operator will be increased on that value
300 NUMERIC_MIN_VALUE 0
301 NUMERIC_MAX_VALUE 38
302 @@ -1084,7 +1084,7 @@ READ_ONLY YES
303 COMMAND_LINE_ARGUMENT NULL
304 VARIABLE_NAME EXTRA_MAX_CONNECTIONS
305 VARIABLE_SCOPE GLOBAL
306 -VARIABLE_TYPE BIGINT UNSIGNED
307 +VARIABLE_TYPE INT UNSIGNED
308 VARIABLE_COMMENT The number of connections on extra-port
309 NUMERIC_MIN_VALUE 1
310 NUMERIC_MAX_VALUE 100000
311 @@ -1114,7 +1114,7 @@ READ_ONLY NO
312 COMMAND_LINE_ARGUMENT OPTIONAL
313 VARIABLE_NAME FLUSH_TIME
314 VARIABLE_SCOPE GLOBAL
315 -VARIABLE_TYPE BIGINT UNSIGNED
316 +VARIABLE_TYPE INT UNSIGNED
317 VARIABLE_COMMENT A dedicated thread is created to flush all tables at the given interval
318 NUMERIC_MIN_VALUE 0
319 NUMERIC_MAX_VALUE 31536000
320 @@ -1144,7 +1144,7 @@ READ_ONLY NO
321 COMMAND_LINE_ARGUMENT REQUIRED
322 VARIABLE_NAME FT_MAX_WORD_LEN
323 VARIABLE_SCOPE GLOBAL
324 -VARIABLE_TYPE BIGINT UNSIGNED
325 +VARIABLE_TYPE INT UNSIGNED
326 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
327 NUMERIC_MIN_VALUE 10
328 NUMERIC_MAX_VALUE 84
329 @@ -1154,7 +1154,7 @@ READ_ONLY YES
330 COMMAND_LINE_ARGUMENT REQUIRED
331 VARIABLE_NAME FT_MIN_WORD_LEN
332 VARIABLE_SCOPE GLOBAL
333 -VARIABLE_TYPE BIGINT UNSIGNED
334 +VARIABLE_TYPE INT UNSIGNED
335 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
336 NUMERIC_MIN_VALUE 1
337 NUMERIC_MAX_VALUE 84
338 @@ -1164,7 +1164,7 @@ READ_ONLY YES
339 COMMAND_LINE_ARGUMENT REQUIRED
340 VARIABLE_NAME FT_QUERY_EXPANSION_LIMIT
341 VARIABLE_SCOPE GLOBAL
342 -VARIABLE_TYPE BIGINT UNSIGNED
343 +VARIABLE_TYPE INT UNSIGNED
344 VARIABLE_COMMENT Number of best matches to use for query expansion
345 NUMERIC_MIN_VALUE 0
346 NUMERIC_MAX_VALUE 1000
347 @@ -1414,7 +1414,7 @@ READ_ONLY YES
348 COMMAND_LINE_ARGUMENT NULL
349 VARIABLE_NAME HISTOGRAM_SIZE
350 VARIABLE_SCOPE SESSION
351 -VARIABLE_TYPE BIGINT UNSIGNED
352 +VARIABLE_TYPE INT UNSIGNED
353 VARIABLE_COMMENT Number of bytes used for a histogram. If set to 0, no histograms are created by ANALYZE
354 NUMERIC_MIN_VALUE 0
355 NUMERIC_MAX_VALUE 255
356 @@ -1444,7 +1444,7 @@ READ_ONLY YES
357 COMMAND_LINE_ARGUMENT NULL
358 VARIABLE_NAME HOST_CACHE_SIZE
359 VARIABLE_SCOPE GLOBAL
360 -VARIABLE_TYPE BIGINT UNSIGNED
361 +VARIABLE_TYPE INT UNSIGNED
362 VARIABLE_COMMENT How many host names should be cached to avoid resolving
363 NUMERIC_MIN_VALUE 0
364 NUMERIC_MAX_VALUE 65536
365 @@ -1554,7 +1554,7 @@ READ_ONLY NO
366 COMMAND_LINE_ARGUMENT NULL
367 VARIABLE_NAME INTERACTIVE_TIMEOUT
368 VARIABLE_SCOPE SESSION
369 -VARIABLE_TYPE BIGINT UNSIGNED
370 +VARIABLE_TYPE INT UNSIGNED
371 VARIABLE_COMMENT The number of seconds the server waits for activity on an interactive connection before closing it
372 NUMERIC_MIN_VALUE 1
373 NUMERIC_MAX_VALUE 31536000
374 @@ -1587,7 +1587,7 @@ VARIABLE_SCOPE SESSION
375 VARIABLE_TYPE BIGINT UNSIGNED
376 VARIABLE_COMMENT The size of the buffer that is used for joins
377 NUMERIC_MIN_VALUE 128
378 -NUMERIC_MAX_VALUE 18446744073709551615
379 +NUMERIC_MAX_VALUE 4294967295
380 NUMERIC_BLOCK_SIZE 128
381 ENUM_VALUE_LIST NULL
382 READ_ONLY NO
383 @@ -1604,7 +1604,7 @@ READ_ONLY NO
384 COMMAND_LINE_ARGUMENT REQUIRED
385 VARIABLE_NAME JOIN_CACHE_LEVEL
386 VARIABLE_SCOPE SESSION
387 -VARIABLE_TYPE BIGINT UNSIGNED
388 +VARIABLE_TYPE INT UNSIGNED
389 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
390 NUMERIC_MIN_VALUE 0
391 NUMERIC_MAX_VALUE 8
392 @@ -1627,7 +1627,7 @@ VARIABLE_SCOPE GLOBAL
393 VARIABLE_TYPE BIGINT UNSIGNED
394 VARIABLE_COMMENT The size of the buffer used for index blocks for MyISAM tables. Increase this to get faster index handling
395 NUMERIC_MIN_VALUE 0
396 -NUMERIC_MAX_VALUE 18446744073709551615
397 +NUMERIC_MAX_VALUE 4294967295
398 NUMERIC_BLOCK_SIZE 4096
399 ENUM_VALUE_LIST NULL
400 READ_ONLY NO
401 @@ -1794,7 +1794,7 @@ READ_ONLY YES
402 COMMAND_LINE_ARGUMENT NULL
403 VARIABLE_NAME LOCK_WAIT_TIMEOUT
404 VARIABLE_SCOPE SESSION
405 -VARIABLE_TYPE BIGINT UNSIGNED
406 +VARIABLE_TYPE INT UNSIGNED
407 VARIABLE_COMMENT Timeout in seconds to wait for a lock before returning an error
408 NUMERIC_MIN_VALUE 0
409 NUMERIC_MAX_VALUE 31536000
410 @@ -1954,7 +1954,7 @@ READ_ONLY NO
411 COMMAND_LINE_ARGUMENT REQUIRED
412 VARIABLE_NAME LOG_SLOW_MAX_WARNINGS
413 VARIABLE_SCOPE SESSION
414 -VARIABLE_TYPE BIGINT UNSIGNED
415 +VARIABLE_TYPE INT UNSIGNED
416 VARIABLE_COMMENT Max numbers of warnings printed to slow query log per statement
417 NUMERIC_MIN_VALUE 0
418 NUMERIC_MAX_VALUE 1000
419 @@ -1964,7 +1964,7 @@ READ_ONLY NO
420 COMMAND_LINE_ARGUMENT REQUIRED
421 VARIABLE_NAME LOG_SLOW_MIN_EXAMINED_ROW_LIMIT
422 VARIABLE_SCOPE SESSION
423 -VARIABLE_TYPE BIGINT UNSIGNED
424 +VARIABLE_TYPE INT UNSIGNED
425 VARIABLE_COMMENT Don't write queries to slow log that examine fewer rows than that
426 NUMERIC_MIN_VALUE 0
427 NUMERIC_MAX_VALUE 4294967295
428 @@ -2004,7 +2004,7 @@ READ_ONLY NO
429 COMMAND_LINE_ARGUMENT REQUIRED
430 VARIABLE_NAME LOG_SLOW_RATE_LIMIT
431 VARIABLE_SCOPE SESSION
432 -VARIABLE_TYPE BIGINT UNSIGNED
433 +VARIABLE_TYPE INT UNSIGNED
434 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
435 NUMERIC_MIN_VALUE 1
436 NUMERIC_MAX_VALUE 4294967295
437 @@ -2034,7 +2034,7 @@ READ_ONLY NO
438 COMMAND_LINE_ARGUMENT REQUIRED
439 VARIABLE_NAME LOG_WARNINGS
440 VARIABLE_SCOPE SESSION
441 -VARIABLE_TYPE BIGINT UNSIGNED
442 +VARIABLE_TYPE INT UNSIGNED
443 VARIABLE_COMMENT Log some non-critical warnings to the error log. Value can be between 0 and 11. Higher values mean more verbosity
444 NUMERIC_MIN_VALUE 0
445 NUMERIC_MAX_VALUE 4294967295
446 @@ -2094,7 +2094,7 @@ READ_ONLY NO
447 COMMAND_LINE_ARGUMENT OPTIONAL
448 VARIABLE_NAME MAX_ALLOWED_PACKET
449 VARIABLE_SCOPE SESSION
450 -VARIABLE_TYPE BIGINT UNSIGNED
451 +VARIABLE_TYPE INT UNSIGNED
452 VARIABLE_COMMENT Max packet length to send to or receive from the server
453 NUMERIC_MIN_VALUE 1024
454 NUMERIC_MAX_VALUE 1073741824
455 @@ -2107,14 +2107,14 @@ VARIABLE_SCOPE GLOBAL
456 VARIABLE_TYPE BIGINT UNSIGNED
457 VARIABLE_COMMENT Sets the total size of the transactional cache
458 NUMERIC_MIN_VALUE 4096
459 -NUMERIC_MAX_VALUE 18446744073709551615
460 +NUMERIC_MAX_VALUE 4294967295
461 NUMERIC_BLOCK_SIZE 4096
462 ENUM_VALUE_LIST NULL
463 READ_ONLY NO
464 COMMAND_LINE_ARGUMENT REQUIRED
465 VARIABLE_NAME MAX_BINLOG_SIZE
466 VARIABLE_SCOPE GLOBAL
467 -VARIABLE_TYPE BIGINT UNSIGNED
468 +VARIABLE_TYPE INT UNSIGNED
469 VARIABLE_COMMENT Binary log will be rotated automatically when the size exceeds this value, unless `binlog_large_commit_threshold` causes rotation prematurely
470 NUMERIC_MIN_VALUE 4096
471 NUMERIC_MAX_VALUE 1073741824
472 @@ -2127,7 +2127,7 @@ VARIABLE_SCOPE GLOBAL
473 VARIABLE_TYPE BIGINT UNSIGNED
474 VARIABLE_COMMENT Sets the total size of the statement cache
475 NUMERIC_MIN_VALUE 4096
476 -NUMERIC_MAX_VALUE 18446744073709551615
477 +NUMERIC_MAX_VALUE 4294967295
478 NUMERIC_BLOCK_SIZE 4096
479 ENUM_VALUE_LIST NULL
480 READ_ONLY NO
481 @@ -2144,7 +2144,7 @@ READ_ONLY NO
482 COMMAND_LINE_ARGUMENT REQUIRED
483 VARIABLE_NAME MAX_CONNECTIONS
484 VARIABLE_SCOPE GLOBAL
485 -VARIABLE_TYPE BIGINT UNSIGNED
486 +VARIABLE_TYPE INT UNSIGNED
487 VARIABLE_COMMENT The number of simultaneous clients allowed
488 NUMERIC_MIN_VALUE 10
489 NUMERIC_MAX_VALUE 100000
490 @@ -2154,7 +2154,7 @@ READ_ONLY NO
491 COMMAND_LINE_ARGUMENT REQUIRED
492 VARIABLE_NAME MAX_CONNECT_ERRORS
493 VARIABLE_SCOPE GLOBAL
494 -VARIABLE_TYPE BIGINT UNSIGNED
495 +VARIABLE_TYPE INT UNSIGNED
496 VARIABLE_COMMENT If there is more than this number of interrupted connections from a host this host will be blocked from further connections
497 NUMERIC_MIN_VALUE 1
498 NUMERIC_MAX_VALUE 4294967295
499 @@ -2164,7 +2164,7 @@ READ_ONLY NO
500 COMMAND_LINE_ARGUMENT REQUIRED
501 VARIABLE_NAME MAX_DELAYED_THREADS
502 VARIABLE_SCOPE SESSION
503 -VARIABLE_TYPE BIGINT UNSIGNED
504 +VARIABLE_TYPE INT UNSIGNED
505 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
506 NUMERIC_MIN_VALUE 0
507 NUMERIC_MAX_VALUE 16384
508 @@ -2184,7 +2184,7 @@ READ_ONLY YES
509 COMMAND_LINE_ARGUMENT REQUIRED
510 VARIABLE_NAME MAX_ERROR_COUNT
511 VARIABLE_SCOPE SESSION
512 -VARIABLE_TYPE BIGINT UNSIGNED
513 +VARIABLE_TYPE INT UNSIGNED
514 VARIABLE_COMMENT Max number of errors/warnings to store for a statement
515 NUMERIC_MIN_VALUE 0
516 NUMERIC_MAX_VALUE 65535
517 @@ -2197,14 +2197,14 @@ VARIABLE_SCOPE SESSION
518 VARIABLE_TYPE BIGINT UNSIGNED
519 VARIABLE_COMMENT Don't allow creation of heap tables bigger than this
520 NUMERIC_MIN_VALUE 16384
521 -NUMERIC_MAX_VALUE 18446744073709551615
522 +NUMERIC_MAX_VALUE 4294967295
523 NUMERIC_BLOCK_SIZE 1024
524 ENUM_VALUE_LIST NULL
525 READ_ONLY NO
526 COMMAND_LINE_ARGUMENT REQUIRED
527 VARIABLE_NAME MAX_INSERT_DELAYED_THREADS
528 VARIABLE_SCOPE SESSION
529 -VARIABLE_TYPE BIGINT UNSIGNED
530 +VARIABLE_TYPE INT UNSIGNED
531 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
532 NUMERIC_MIN_VALUE 0
533 NUMERIC_MAX_VALUE 16384
534 @@ -2224,7 +2224,7 @@ READ_ONLY NO
535 COMMAND_LINE_ARGUMENT REQUIRED
536 VARIABLE_NAME MAX_LENGTH_FOR_SORT_DATA
537 VARIABLE_SCOPE SESSION
538 -VARIABLE_TYPE BIGINT UNSIGNED
539 +VARIABLE_TYPE INT UNSIGNED
540 VARIABLE_COMMENT Max number of bytes in sorted records
541 NUMERIC_MIN_VALUE 4
542 NUMERIC_MAX_VALUE 8388608
543 @@ -2254,7 +2254,7 @@ READ_ONLY NO
544 COMMAND_LINE_ARGUMENT REQUIRED
545 VARIABLE_NAME MAX_RECURSIVE_ITERATIONS
546 VARIABLE_SCOPE SESSION
547 -VARIABLE_TYPE BIGINT UNSIGNED
548 +VARIABLE_TYPE INT UNSIGNED
549 VARIABLE_COMMENT Maximum number of iterations when executing recursive queries
550 NUMERIC_MIN_VALUE 0
551 NUMERIC_MAX_VALUE 4294967295
552 @@ -2277,14 +2277,14 @@ VARIABLE_SCOPE SESSION
553 VARIABLE_TYPE BIGINT UNSIGNED
554 VARIABLE_COMMENT The maximum size of the container of a rowid filter
555 NUMERIC_MIN_VALUE 1024
556 -NUMERIC_MAX_VALUE 18446744073709551615
557 +NUMERIC_MAX_VALUE 4294967295
558 NUMERIC_BLOCK_SIZE 1
559 ENUM_VALUE_LIST NULL
560 READ_ONLY NO
561 COMMAND_LINE_ARGUMENT REQUIRED
562 VARIABLE_NAME MAX_SEEKS_FOR_KEY
563 VARIABLE_SCOPE SESSION
564 -VARIABLE_TYPE BIGINT UNSIGNED
565 +VARIABLE_TYPE INT UNSIGNED
566 VARIABLE_COMMENT Limit assumed max number of seeks when looking up rows based on a key
567 NUMERIC_MIN_VALUE 1
568 NUMERIC_MAX_VALUE 4294967295
569 @@ -2304,7 +2304,7 @@ READ_ONLY NO
570 COMMAND_LINE_ARGUMENT REQUIRED
571 VARIABLE_NAME MAX_SORT_LENGTH
572 VARIABLE_SCOPE SESSION
573 -VARIABLE_TYPE BIGINT UNSIGNED
574 +VARIABLE_TYPE INT UNSIGNED
575 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)
576 NUMERIC_MIN_VALUE 64
577 NUMERIC_MAX_VALUE 8388608
578 @@ -2314,7 +2314,7 @@ READ_ONLY NO
579 COMMAND_LINE_ARGUMENT REQUIRED
580 VARIABLE_NAME MAX_SP_RECURSION_DEPTH
581 VARIABLE_SCOPE SESSION
582 -VARIABLE_TYPE BIGINT UNSIGNED
583 +VARIABLE_TYPE INT UNSIGNED
584 VARIABLE_COMMENT Maximum stored procedure recursion depth
585 NUMERIC_MIN_VALUE 0
586 NUMERIC_MAX_VALUE 255
587 @@ -2364,7 +2364,7 @@ READ_ONLY NO
588 COMMAND_LINE_ARGUMENT REQUIRED
589 VARIABLE_NAME MAX_WRITE_LOCK_COUNT
590 VARIABLE_SCOPE GLOBAL
591 -VARIABLE_TYPE BIGINT UNSIGNED
592 +VARIABLE_TYPE INT UNSIGNED
593 VARIABLE_COMMENT After this many write locks, allow some read locks to run in between
594 NUMERIC_MIN_VALUE 1
595 NUMERIC_MAX_VALUE 4294967295
596 @@ -2374,7 +2374,7 @@ READ_ONLY NO
597 COMMAND_LINE_ARGUMENT REQUIRED
598 VARIABLE_NAME METADATA_LOCKS_CACHE_SIZE
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 1048576
605 @@ -2384,7 +2384,7 @@ READ_ONLY YES
606 COMMAND_LINE_ARGUMENT REQUIRED
607 VARIABLE_NAME METADATA_LOCKS_HASH_INSTANCES
608 VARIABLE_SCOPE GLOBAL
609 -VARIABLE_TYPE BIGINT UNSIGNED
610 +VARIABLE_TYPE INT UNSIGNED
611 VARIABLE_COMMENT Unused
612 NUMERIC_MIN_VALUE 1
613 NUMERIC_MAX_VALUE 1024
614 @@ -2427,14 +2427,14 @@ VARIABLE_SCOPE GLOBAL
615 VARIABLE_TYPE BIGINT UNSIGNED
616 VARIABLE_COMMENT Upper limit for one MHNSW vector index cache
617 NUMERIC_MIN_VALUE 1048576
618 -NUMERIC_MAX_VALUE 18446744073709551615
619 +NUMERIC_MAX_VALUE 4294967295
620 NUMERIC_BLOCK_SIZE 1
621 ENUM_VALUE_LIST NULL
622 READ_ONLY NO
623 COMMAND_LINE_ARGUMENT REQUIRED
624 VARIABLE_NAME MIN_EXAMINED_ROW_LIMIT
625 VARIABLE_SCOPE SESSION
626 -VARIABLE_TYPE BIGINT UNSIGNED
627 +VARIABLE_TYPE INT UNSIGNED
628 VARIABLE_COMMENT Alias for log_slow_min_examined_row_limit. Don't write queries to slow log that examine fewer rows than that
629 NUMERIC_MIN_VALUE 0
630 NUMERIC_MAX_VALUE 4294967295
631 @@ -2444,7 +2444,7 @@ READ_ONLY NO
632 COMMAND_LINE_ARGUMENT REQUIRED
633 VARIABLE_NAME MRR_BUFFER_SIZE
634 VARIABLE_SCOPE SESSION
635 -VARIABLE_TYPE BIGINT UNSIGNED
636 +VARIABLE_TYPE INT UNSIGNED
637 VARIABLE_COMMENT Size of buffer to use when using MRR with range access
638 NUMERIC_MIN_VALUE 8192
639 NUMERIC_MAX_VALUE 2147483647
640 @@ -2454,7 +2454,7 @@ READ_ONLY NO
641 COMMAND_LINE_ARGUMENT REQUIRED
642 VARIABLE_NAME MYISAM_BLOCK_SIZE
643 VARIABLE_SCOPE GLOBAL
644 -VARIABLE_TYPE BIGINT UNSIGNED
645 +VARIABLE_TYPE INT UNSIGNED
646 VARIABLE_COMMENT Block size to be used for MyISAM index pages
647 NUMERIC_MIN_VALUE 1024
648 NUMERIC_MAX_VALUE 16384
649 @@ -2464,7 +2464,7 @@ READ_ONLY YES
650 COMMAND_LINE_ARGUMENT REQUIRED
651 VARIABLE_NAME MYISAM_DATA_POINTER_SIZE
652 VARIABLE_SCOPE GLOBAL
653 -VARIABLE_TYPE BIGINT UNSIGNED
654 +VARIABLE_TYPE INT UNSIGNED
655 VARIABLE_COMMENT Default pointer size to be used for MyISAM tables
656 NUMERIC_MIN_VALUE 2
657 NUMERIC_MAX_VALUE 7
658 @@ -2487,7 +2487,7 @@ VARIABLE_SCOPE GLOBAL
659 VARIABLE_TYPE BIGINT UNSIGNED
660 VARIABLE_COMMENT Restricts the total memory used for memory mapping of MyISAM tables
661 NUMERIC_MIN_VALUE 7
662 -NUMERIC_MAX_VALUE 18446744073709551615
663 +NUMERIC_MAX_VALUE 4294967295
664 NUMERIC_BLOCK_SIZE 1
665 ENUM_VALUE_LIST NULL
666 READ_ONLY YES
667 @@ -2504,10 +2504,10 @@ READ_ONLY YES
668 COMMAND_LINE_ARGUMENT OPTIONAL
669 VARIABLE_NAME MYISAM_REPAIR_THREADS
670 VARIABLE_SCOPE SESSION
671 -VARIABLE_TYPE BIGINT UNSIGNED
672 +VARIABLE_TYPE INT UNSIGNED
673 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
674 NUMERIC_MIN_VALUE 1
675 -NUMERIC_MAX_VALUE 18446744073709551615
676 +NUMERIC_MAX_VALUE 4294967295
677 NUMERIC_BLOCK_SIZE 1
678 ENUM_VALUE_LIST NULL
679 READ_ONLY NO
680 @@ -2517,7 +2517,7 @@ VARIABLE_SCOPE SESSION
681 VARIABLE_TYPE BIGINT UNSIGNED
682 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
683 NUMERIC_MIN_VALUE 4096
684 -NUMERIC_MAX_VALUE 1152921504606846975
685 +NUMERIC_MAX_VALUE 268435455
686 NUMERIC_BLOCK_SIZE 1
687 ENUM_VALUE_LIST NULL
688 READ_ONLY NO
689 @@ -2554,7 +2554,7 @@ READ_ONLY NO
690 COMMAND_LINE_ARGUMENT OPTIONAL
691 VARIABLE_NAME NET_BUFFER_LENGTH
692 VARIABLE_SCOPE SESSION
693 -VARIABLE_TYPE BIGINT UNSIGNED
694 +VARIABLE_TYPE INT UNSIGNED
695 VARIABLE_COMMENT Buffer length for TCP/IP and socket communication
696 NUMERIC_MIN_VALUE 1024
697 NUMERIC_MAX_VALUE 1048576
698 @@ -2564,7 +2564,7 @@ READ_ONLY NO
699 COMMAND_LINE_ARGUMENT REQUIRED
700 VARIABLE_NAME NET_READ_TIMEOUT
701 VARIABLE_SCOPE SESSION
702 -VARIABLE_TYPE BIGINT UNSIGNED
703 +VARIABLE_TYPE INT UNSIGNED
704 VARIABLE_COMMENT Number of seconds to wait for more data from a connection before aborting the read
705 NUMERIC_MIN_VALUE 1
706 NUMERIC_MAX_VALUE 31536000
707 @@ -2574,7 +2574,7 @@ READ_ONLY NO
708 COMMAND_LINE_ARGUMENT REQUIRED
709 VARIABLE_NAME NET_RETRY_COUNT
710 VARIABLE_SCOPE SESSION
711 -VARIABLE_TYPE BIGINT UNSIGNED
712 +VARIABLE_TYPE INT UNSIGNED
713 VARIABLE_COMMENT If a read on a communication port is interrupted, retry this many times before giving up
714 NUMERIC_MIN_VALUE 1
715 NUMERIC_MAX_VALUE 4294967295
716 @@ -2584,7 +2584,7 @@ READ_ONLY NO
717 COMMAND_LINE_ARGUMENT REQUIRED
718 VARIABLE_NAME NET_WRITE_TIMEOUT
719 VARIABLE_SCOPE SESSION
720 -VARIABLE_TYPE BIGINT UNSIGNED
721 +VARIABLE_TYPE INT UNSIGNED
722 VARIABLE_COMMENT Number of seconds to wait for a block to be written to a connection before aborting the write
723 NUMERIC_MIN_VALUE 1
724 NUMERIC_MAX_VALUE 31536000
725 @@ -2634,7 +2634,7 @@ READ_ONLY NO
726 COMMAND_LINE_ARGUMENT OPTIONAL
727 VARIABLE_NAME OPEN_FILES_LIMIT
728 VARIABLE_SCOPE GLOBAL
729 -VARIABLE_TYPE BIGINT UNSIGNED
730 +VARIABLE_TYPE INT UNSIGNED
731 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
732 NUMERIC_MIN_VALUE 0
733 NUMERIC_MAX_VALUE 4294967295
734 @@ -2644,7 +2644,7 @@ READ_ONLY YES
735 COMMAND_LINE_ARGUMENT REQUIRED
736 VARIABLE_NAME OPTIMIZER_ADJUST_SECONDARY_KEY_COSTS
737 VARIABLE_SCOPE SESSION
738 -VARIABLE_TYPE BIGINT UNSIGNED
739 +VARIABLE_TYPE INT UNSIGNED
740 VARIABLE_COMMENT Unused
741 NUMERIC_MIN_VALUE 0
742 NUMERIC_MAX_VALUE 2
743 @@ -2674,7 +2674,7 @@ READ_ONLY NO
744 COMMAND_LINE_ARGUMENT REQUIRED
745 VARIABLE_NAME OPTIMIZER_EXTRA_PRUNING_DEPTH
746 VARIABLE_SCOPE SESSION
747 -VARIABLE_TYPE BIGINT UNSIGNED
748 +VARIABLE_TYPE INT UNSIGNED
749 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
750 NUMERIC_MIN_VALUE 0
751 NUMERIC_MAX_VALUE 62
752 @@ -2744,7 +2744,7 @@ READ_ONLY NO
753 COMMAND_LINE_ARGUMENT REQUIRED
754 VARIABLE_NAME OPTIMIZER_MAX_SEL_ARGS
755 VARIABLE_SCOPE SESSION
756 -VARIABLE_TYPE BIGINT UNSIGNED
757 +VARIABLE_TYPE INT UNSIGNED
758 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
759 NUMERIC_MIN_VALUE 0
760 NUMERIC_MAX_VALUE 4294967295
761 @@ -2754,7 +2754,7 @@ READ_ONLY NO
762 COMMAND_LINE_ARGUMENT REQUIRED
763 VARIABLE_NAME OPTIMIZER_MAX_SEL_ARG_WEIGHT
764 VARIABLE_SCOPE SESSION
765 -VARIABLE_TYPE BIGINT UNSIGNED
766 +VARIABLE_TYPE INT UNSIGNED
767 VARIABLE_COMMENT The maximum weight of the SEL_ARG graph. Set to 0 for no limit
768 NUMERIC_MIN_VALUE 0
769 NUMERIC_MAX_VALUE 4294967295
770 @@ -2764,7 +2764,7 @@ READ_ONLY NO
771 COMMAND_LINE_ARGUMENT REQUIRED
772 VARIABLE_NAME OPTIMIZER_PRUNE_LEVEL
773 VARIABLE_SCOPE SESSION
774 -VARIABLE_TYPE BIGINT UNSIGNED
775 +VARIABLE_TYPE INT UNSIGNED
776 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
777 NUMERIC_MIN_VALUE 0
778 NUMERIC_MAX_VALUE 2
779 @@ -2834,7 +2834,7 @@ READ_ONLY NO
780 COMMAND_LINE_ARGUMENT REQUIRED
781 VARIABLE_NAME OPTIMIZER_SEARCH_DEPTH
782 VARIABLE_SCOPE SESSION
783 -VARIABLE_TYPE BIGINT UNSIGNED
784 +VARIABLE_TYPE INT UNSIGNED
785 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
786 NUMERIC_MIN_VALUE 0
787 NUMERIC_MAX_VALUE 62
788 @@ -2844,7 +2844,7 @@ READ_ONLY NO
789 COMMAND_LINE_ARGUMENT REQUIRED
790 VARIABLE_NAME OPTIMIZER_SELECTIVITY_SAMPLING_LIMIT
791 VARIABLE_SCOPE SESSION
792 -VARIABLE_TYPE BIGINT UNSIGNED
793 +VARIABLE_TYPE INT UNSIGNED
794 VARIABLE_COMMENT Controls number of record samples to check condition selectivity
795 NUMERIC_MIN_VALUE 10
796 NUMERIC_MAX_VALUE 4294967295
797 @@ -2874,17 +2874,17 @@ READ_ONLY NO
798 COMMAND_LINE_ARGUMENT REQUIRED
799 VARIABLE_NAME OPTIMIZER_TRACE_MAX_MEM_SIZE
800 VARIABLE_SCOPE SESSION
801 -VARIABLE_TYPE BIGINT UNSIGNED
802 +VARIABLE_TYPE INT UNSIGNED
803 VARIABLE_COMMENT Maximum allowed size of an optimizer trace
804 NUMERIC_MIN_VALUE 0
805 -NUMERIC_MAX_VALUE 18446744073709551615
806 +NUMERIC_MAX_VALUE 4294967295
807 NUMERIC_BLOCK_SIZE 1
808 ENUM_VALUE_LIST NULL
809 READ_ONLY NO
810 COMMAND_LINE_ARGUMENT REQUIRED
811 VARIABLE_NAME OPTIMIZER_USE_CONDITION_SELECTIVITY
812 VARIABLE_SCOPE SESSION
813 -VARIABLE_TYPE BIGINT UNSIGNED
814 +VARIABLE_TYPE INT UNSIGNED
815 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
816 NUMERIC_MIN_VALUE 1
817 NUMERIC_MAX_VALUE 5
818 @@ -2914,7 +2914,7 @@ READ_ONLY YES
819 COMMAND_LINE_ARGUMENT OPTIONAL
820 VARIABLE_NAME PERFORMANCE_SCHEMA_ACCOUNTS_SIZE
821 VARIABLE_SCOPE GLOBAL
822 -VARIABLE_TYPE BIGINT
823 +VARIABLE_TYPE INT
824 VARIABLE_COMMENT Maximum number of instrumented user@host accounts. Use 0 to disable, -1 for automated sizing
825 NUMERIC_MIN_VALUE -1
826 NUMERIC_MAX_VALUE 1048576
827 @@ -2924,7 +2924,7 @@ READ_ONLY YES
828 COMMAND_LINE_ARGUMENT REQUIRED
829 VARIABLE_NAME PERFORMANCE_SCHEMA_DIGESTS_SIZE
830 VARIABLE_SCOPE GLOBAL
831 -VARIABLE_TYPE BIGINT
832 +VARIABLE_TYPE INT
833 VARIABLE_COMMENT Size of the statement digest. Use 0 to disable, -1 for automated sizing
834 NUMERIC_MIN_VALUE -1
835 NUMERIC_MAX_VALUE 1048576
836 @@ -2934,7 +2934,7 @@ READ_ONLY YES
837 COMMAND_LINE_ARGUMENT REQUIRED
838 VARIABLE_NAME PERFORMANCE_SCHEMA_EVENTS_STAGES_HISTORY_LONG_SIZE
839 VARIABLE_SCOPE GLOBAL
840 -VARIABLE_TYPE BIGINT
841 +VARIABLE_TYPE INT
842 VARIABLE_COMMENT Number of rows in EVENTS_STAGES_HISTORY_LONG. Use 0 to disable, -1 for automated sizing
843 NUMERIC_MIN_VALUE -1
844 NUMERIC_MAX_VALUE 1048576
845 @@ -2944,7 +2944,7 @@ READ_ONLY YES
846 COMMAND_LINE_ARGUMENT REQUIRED
847 VARIABLE_NAME PERFORMANCE_SCHEMA_EVENTS_STAGES_HISTORY_SIZE
848 VARIABLE_SCOPE GLOBAL
849 -VARIABLE_TYPE BIGINT
850 +VARIABLE_TYPE INT
851 VARIABLE_COMMENT Number of rows per thread in EVENTS_STAGES_HISTORY. Use 0 to disable, -1 for automated sizing
852 NUMERIC_MIN_VALUE -1
853 NUMERIC_MAX_VALUE 1024
854 @@ -2954,7 +2954,7 @@ READ_ONLY YES
855 COMMAND_LINE_ARGUMENT REQUIRED
856 VARIABLE_NAME PERFORMANCE_SCHEMA_EVENTS_STATEMENTS_HISTORY_LONG_SIZE
857 VARIABLE_SCOPE GLOBAL
858 -VARIABLE_TYPE BIGINT
859 +VARIABLE_TYPE INT
860 VARIABLE_COMMENT Number of rows in EVENTS_STATEMENTS_HISTORY_LONG. Use 0 to disable, -1 for automated sizing
861 NUMERIC_MIN_VALUE -1
862 NUMERIC_MAX_VALUE 1048576
863 @@ -2964,7 +2964,7 @@ READ_ONLY YES
864 COMMAND_LINE_ARGUMENT REQUIRED
865 VARIABLE_NAME PERFORMANCE_SCHEMA_EVENTS_STATEMENTS_HISTORY_SIZE
866 VARIABLE_SCOPE GLOBAL
867 -VARIABLE_TYPE BIGINT
868 +VARIABLE_TYPE INT
869 VARIABLE_COMMENT Number of rows per thread in EVENTS_STATEMENTS_HISTORY. Use 0 to disable, -1 for automated sizing
870 NUMERIC_MIN_VALUE -1
871 NUMERIC_MAX_VALUE 1024
872 @@ -2974,7 +2974,7 @@ READ_ONLY YES
873 COMMAND_LINE_ARGUMENT REQUIRED
874 VARIABLE_NAME PERFORMANCE_SCHEMA_EVENTS_TRANSACTIONS_HISTORY_LONG_SIZE
875 VARIABLE_SCOPE GLOBAL
876 -VARIABLE_TYPE BIGINT
877 +VARIABLE_TYPE INT
878 VARIABLE_COMMENT Number of rows in EVENTS_TRANSACTIONS_HISTORY_LONG. Use 0 to disable, -1 for automated sizing
879 NUMERIC_MIN_VALUE -1
880 NUMERIC_MAX_VALUE 1048576
881 @@ -2984,7 +2984,7 @@ READ_ONLY YES
882 COMMAND_LINE_ARGUMENT REQUIRED
883 VARIABLE_NAME PERFORMANCE_SCHEMA_EVENTS_TRANSACTIONS_HISTORY_SIZE
884 VARIABLE_SCOPE GLOBAL
885 -VARIABLE_TYPE BIGINT
886 +VARIABLE_TYPE INT
887 VARIABLE_COMMENT Number of rows per thread in EVENTS_TRANSACTIONS_HISTORY. Use 0 to disable, -1 for automated sizing
888 NUMERIC_MIN_VALUE -1
889 NUMERIC_MAX_VALUE 1024
890 @@ -2994,7 +2994,7 @@ READ_ONLY YES
891 COMMAND_LINE_ARGUMENT REQUIRED
892 VARIABLE_NAME PERFORMANCE_SCHEMA_EVENTS_WAITS_HISTORY_LONG_SIZE
893 VARIABLE_SCOPE GLOBAL
894 -VARIABLE_TYPE BIGINT
895 +VARIABLE_TYPE INT
896 VARIABLE_COMMENT Number of rows in EVENTS_WAITS_HISTORY_LONG. Use 0 to disable, -1 for automated sizing
897 NUMERIC_MIN_VALUE -1
898 NUMERIC_MAX_VALUE 1048576
899 @@ -3004,7 +3004,7 @@ READ_ONLY YES
900 COMMAND_LINE_ARGUMENT REQUIRED
901 VARIABLE_NAME PERFORMANCE_SCHEMA_EVENTS_WAITS_HISTORY_SIZE
902 VARIABLE_SCOPE GLOBAL
903 -VARIABLE_TYPE BIGINT
904 +VARIABLE_TYPE INT
905 VARIABLE_COMMENT Number of rows per thread in EVENTS_WAITS_HISTORY. Use 0 to disable, -1 for automated sizing
906 NUMERIC_MIN_VALUE -1
907 NUMERIC_MAX_VALUE 1024
908 @@ -3014,7 +3014,7 @@ READ_ONLY YES
909 COMMAND_LINE_ARGUMENT REQUIRED
910 VARIABLE_NAME PERFORMANCE_SCHEMA_HOSTS_SIZE
911 VARIABLE_SCOPE GLOBAL
912 -VARIABLE_TYPE BIGINT
913 +VARIABLE_TYPE INT
914 VARIABLE_COMMENT Maximum number of instrumented hosts. Use 0 to disable, -1 for automated sizing
915 NUMERIC_MIN_VALUE -1
916 NUMERIC_MAX_VALUE 1048576
917 @@ -3024,7 +3024,7 @@ READ_ONLY YES
918 COMMAND_LINE_ARGUMENT REQUIRED
919 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_COND_CLASSES
920 VARIABLE_SCOPE GLOBAL
921 -VARIABLE_TYPE BIGINT UNSIGNED
922 +VARIABLE_TYPE INT UNSIGNED
923 VARIABLE_COMMENT Maximum number of condition instruments
924 NUMERIC_MIN_VALUE 0
925 NUMERIC_MAX_VALUE 256
926 @@ -3034,7 +3034,7 @@ READ_ONLY YES
927 COMMAND_LINE_ARGUMENT REQUIRED
928 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_COND_INSTANCES
929 VARIABLE_SCOPE GLOBAL
930 -VARIABLE_TYPE BIGINT
931 +VARIABLE_TYPE INT
932 VARIABLE_COMMENT Maximum number of instrumented condition objects. Use 0 to disable, -1 for automated sizing
933 NUMERIC_MIN_VALUE -1
934 NUMERIC_MAX_VALUE 1048576
935 @@ -3044,7 +3044,7 @@ READ_ONLY YES
936 COMMAND_LINE_ARGUMENT REQUIRED
937 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_DIGEST_LENGTH
938 VARIABLE_SCOPE GLOBAL
939 -VARIABLE_TYPE BIGINT
940 +VARIABLE_TYPE INT
941 VARIABLE_COMMENT Maximum length considered for digest text, when stored in performance_schema tables
942 NUMERIC_MIN_VALUE 0
943 NUMERIC_MAX_VALUE 1048576
944 @@ -3054,7 +3054,7 @@ READ_ONLY YES
945 COMMAND_LINE_ARGUMENT REQUIRED
946 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_FILE_CLASSES
947 VARIABLE_SCOPE GLOBAL
948 -VARIABLE_TYPE BIGINT UNSIGNED
949 +VARIABLE_TYPE INT UNSIGNED
950 VARIABLE_COMMENT Maximum number of file instruments
951 NUMERIC_MIN_VALUE 0
952 NUMERIC_MAX_VALUE 256
953 @@ -3064,7 +3064,7 @@ READ_ONLY YES
954 COMMAND_LINE_ARGUMENT REQUIRED
955 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_FILE_HANDLES
956 VARIABLE_SCOPE GLOBAL
957 -VARIABLE_TYPE BIGINT UNSIGNED
958 +VARIABLE_TYPE INT UNSIGNED
959 VARIABLE_COMMENT Maximum number of opened instrumented files
960 NUMERIC_MIN_VALUE 0
961 NUMERIC_MAX_VALUE 1048576
962 @@ -3074,7 +3074,7 @@ READ_ONLY YES
963 COMMAND_LINE_ARGUMENT REQUIRED
964 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_FILE_INSTANCES
965 VARIABLE_SCOPE GLOBAL
966 -VARIABLE_TYPE BIGINT
967 +VARIABLE_TYPE INT
968 VARIABLE_COMMENT Maximum number of instrumented files. Use 0 to disable, -1 for automated sizing
969 NUMERIC_MIN_VALUE -1
970 NUMERIC_MAX_VALUE 1048576
971 @@ -3084,7 +3084,7 @@ READ_ONLY YES
972 COMMAND_LINE_ARGUMENT REQUIRED
973 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_INDEX_STAT
974 VARIABLE_SCOPE GLOBAL
975 -VARIABLE_TYPE BIGINT
976 +VARIABLE_TYPE INT
977 VARIABLE_COMMENT Maximum number of index statistics for instrumented tables. Use 0 to disable, -1 for automated scaling
978 NUMERIC_MIN_VALUE -1
979 NUMERIC_MAX_VALUE 1048576
980 @@ -3094,7 +3094,7 @@ READ_ONLY YES
981 COMMAND_LINE_ARGUMENT REQUIRED
982 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_MEMORY_CLASSES
983 VARIABLE_SCOPE GLOBAL
984 -VARIABLE_TYPE BIGINT UNSIGNED
985 +VARIABLE_TYPE INT UNSIGNED
986 VARIABLE_COMMENT Maximum number of memory pool instruments
987 NUMERIC_MIN_VALUE 0
988 NUMERIC_MAX_VALUE 1024
989 @@ -3104,7 +3104,7 @@ READ_ONLY YES
990 COMMAND_LINE_ARGUMENT REQUIRED
991 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_METADATA_LOCKS
992 VARIABLE_SCOPE GLOBAL
993 -VARIABLE_TYPE BIGINT
994 +VARIABLE_TYPE INT
995 VARIABLE_COMMENT Maximum number of metadata locks. Use 0 to disable, -1 for automated scaling
996 NUMERIC_MIN_VALUE -1
997 NUMERIC_MAX_VALUE 104857600
998 @@ -3114,7 +3114,7 @@ READ_ONLY YES
999 COMMAND_LINE_ARGUMENT REQUIRED
1000 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_MUTEX_CLASSES
1001 VARIABLE_SCOPE GLOBAL
1002 -VARIABLE_TYPE BIGINT UNSIGNED
1003 +VARIABLE_TYPE INT UNSIGNED
1004 VARIABLE_COMMENT Maximum number of mutex instruments
1005 NUMERIC_MIN_VALUE 0
1006 NUMERIC_MAX_VALUE 256
1007 @@ -3124,7 +3124,7 @@ READ_ONLY YES
1008 COMMAND_LINE_ARGUMENT REQUIRED
1009 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_MUTEX_INSTANCES
1010 VARIABLE_SCOPE GLOBAL
1011 -VARIABLE_TYPE BIGINT
1012 +VARIABLE_TYPE INT
1013 VARIABLE_COMMENT Maximum number of instrumented MUTEX objects. Use 0 to disable, -1 for automated sizing
1014 NUMERIC_MIN_VALUE -1
1015 NUMERIC_MAX_VALUE 104857600
1016 @@ -3134,7 +3134,7 @@ READ_ONLY YES
1017 COMMAND_LINE_ARGUMENT REQUIRED
1018 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_PREPARED_STATEMENTS_INSTANCES
1019 VARIABLE_SCOPE GLOBAL
1020 -VARIABLE_TYPE BIGINT
1021 +VARIABLE_TYPE INT
1022 VARIABLE_COMMENT Maximum number of instrumented prepared statements. Use 0 to disable, -1 for automated scaling
1023 NUMERIC_MIN_VALUE -1
1024 NUMERIC_MAX_VALUE 1048576
1025 @@ -3144,7 +3144,7 @@ READ_ONLY YES
1026 COMMAND_LINE_ARGUMENT REQUIRED
1027 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_PROGRAM_INSTANCES
1028 VARIABLE_SCOPE GLOBAL
1029 -VARIABLE_TYPE BIGINT
1030 +VARIABLE_TYPE INT
1031 VARIABLE_COMMENT Maximum number of instrumented programs. Use 0 to disable, -1 for automated scaling
1032 NUMERIC_MIN_VALUE -1
1033 NUMERIC_MAX_VALUE 1048576
1034 @@ -3154,7 +3154,7 @@ READ_ONLY YES
1035 COMMAND_LINE_ARGUMENT REQUIRED
1036 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_RWLOCK_CLASSES
1037 VARIABLE_SCOPE GLOBAL
1038 -VARIABLE_TYPE BIGINT UNSIGNED
1039 +VARIABLE_TYPE INT UNSIGNED
1040 VARIABLE_COMMENT Maximum number of rwlock instruments
1041 NUMERIC_MIN_VALUE 0
1042 NUMERIC_MAX_VALUE 256
1043 @@ -3164,7 +3164,7 @@ READ_ONLY YES
1044 COMMAND_LINE_ARGUMENT REQUIRED
1045 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_RWLOCK_INSTANCES
1046 VARIABLE_SCOPE GLOBAL
1047 -VARIABLE_TYPE BIGINT
1048 +VARIABLE_TYPE INT
1049 VARIABLE_COMMENT Maximum number of instrumented RWLOCK objects. Use 0 to disable, -1 for automated sizing
1050 NUMERIC_MIN_VALUE -1
1051 NUMERIC_MAX_VALUE 104857600
1052 @@ -3174,7 +3174,7 @@ READ_ONLY YES
1053 COMMAND_LINE_ARGUMENT REQUIRED
1054 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_SOCKET_CLASSES
1055 VARIABLE_SCOPE GLOBAL
1056 -VARIABLE_TYPE BIGINT UNSIGNED
1057 +VARIABLE_TYPE INT UNSIGNED
1058 VARIABLE_COMMENT Maximum number of socket instruments
1059 NUMERIC_MIN_VALUE 0
1060 NUMERIC_MAX_VALUE 256
1061 @@ -3184,7 +3184,7 @@ READ_ONLY YES
1062 COMMAND_LINE_ARGUMENT REQUIRED
1063 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_SOCKET_INSTANCES
1064 VARIABLE_SCOPE GLOBAL
1065 -VARIABLE_TYPE BIGINT
1066 +VARIABLE_TYPE INT
1067 VARIABLE_COMMENT Maximum number of opened instrumented sockets. Use 0 to disable, -1 for automated sizing
1068 NUMERIC_MIN_VALUE -1
1069 NUMERIC_MAX_VALUE 1048576
1070 @@ -3194,7 +3194,7 @@ READ_ONLY YES
1071 COMMAND_LINE_ARGUMENT REQUIRED
1072 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_SQL_TEXT_LENGTH
1073 VARIABLE_SCOPE GLOBAL
1074 -VARIABLE_TYPE BIGINT
1075 +VARIABLE_TYPE INT
1076 VARIABLE_COMMENT Maximum length of displayed sql text
1077 NUMERIC_MIN_VALUE 0
1078 NUMERIC_MAX_VALUE 1048576
1079 @@ -3204,7 +3204,7 @@ READ_ONLY YES
1080 COMMAND_LINE_ARGUMENT REQUIRED
1081 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_STAGE_CLASSES
1082 VARIABLE_SCOPE GLOBAL
1083 -VARIABLE_TYPE BIGINT UNSIGNED
1084 +VARIABLE_TYPE INT UNSIGNED
1085 VARIABLE_COMMENT Maximum number of stage instruments
1086 NUMERIC_MIN_VALUE 0
1087 NUMERIC_MAX_VALUE 256
1088 @@ -3214,7 +3214,7 @@ READ_ONLY YES
1089 COMMAND_LINE_ARGUMENT REQUIRED
1090 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_STATEMENT_CLASSES
1091 VARIABLE_SCOPE GLOBAL
1092 -VARIABLE_TYPE BIGINT UNSIGNED
1093 +VARIABLE_TYPE INT UNSIGNED
1094 VARIABLE_COMMENT Maximum number of statement instruments
1095 NUMERIC_MIN_VALUE 0
1096 NUMERIC_MAX_VALUE 256
1097 @@ -3224,7 +3224,7 @@ READ_ONLY YES
1098 COMMAND_LINE_ARGUMENT REQUIRED
1099 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_STATEMENT_STACK
1100 VARIABLE_SCOPE GLOBAL
1101 -VARIABLE_TYPE BIGINT UNSIGNED
1102 +VARIABLE_TYPE INT UNSIGNED
1103 VARIABLE_COMMENT Number of rows per thread in EVENTS_STATEMENTS_CURRENT
1104 NUMERIC_MIN_VALUE 1
1105 NUMERIC_MAX_VALUE 256
1106 @@ -3234,7 +3234,7 @@ READ_ONLY YES
1107 COMMAND_LINE_ARGUMENT REQUIRED
1108 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_TABLE_HANDLES
1109 VARIABLE_SCOPE GLOBAL
1110 -VARIABLE_TYPE BIGINT
1111 +VARIABLE_TYPE INT
1112 VARIABLE_COMMENT Maximum number of opened instrumented tables. Use 0 to disable, -1 for automated sizing
1113 NUMERIC_MIN_VALUE -1
1114 NUMERIC_MAX_VALUE 1048576
1115 @@ -3244,7 +3244,7 @@ READ_ONLY YES
1116 COMMAND_LINE_ARGUMENT REQUIRED
1117 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_TABLE_INSTANCES
1118 VARIABLE_SCOPE GLOBAL
1119 -VARIABLE_TYPE BIGINT
1120 +VARIABLE_TYPE INT
1121 VARIABLE_COMMENT Maximum number of instrumented tables. Use 0 to disable, -1 for automated sizing
1122 NUMERIC_MIN_VALUE -1
1123 NUMERIC_MAX_VALUE 1048576
1124 @@ -3254,7 +3254,7 @@ READ_ONLY YES
1125 COMMAND_LINE_ARGUMENT REQUIRED
1126 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_TABLE_LOCK_STAT
1127 VARIABLE_SCOPE GLOBAL
1128 -VARIABLE_TYPE BIGINT
1129 +VARIABLE_TYPE INT
1130 VARIABLE_COMMENT Maximum number of lock statistics for instrumented tables. Use 0 to disable, -1 for automated scaling
1131 NUMERIC_MIN_VALUE -1
1132 NUMERIC_MAX_VALUE 1048576
1133 @@ -3264,7 +3264,7 @@ READ_ONLY YES
1134 COMMAND_LINE_ARGUMENT REQUIRED
1135 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_THREAD_CLASSES
1136 VARIABLE_SCOPE GLOBAL
1137 -VARIABLE_TYPE BIGINT UNSIGNED
1138 +VARIABLE_TYPE INT UNSIGNED
1139 VARIABLE_COMMENT Maximum number of thread instruments
1140 NUMERIC_MIN_VALUE 0
1141 NUMERIC_MAX_VALUE 256
1142 @@ -3274,7 +3274,7 @@ READ_ONLY YES
1143 COMMAND_LINE_ARGUMENT REQUIRED
1144 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_THREAD_INSTANCES
1145 VARIABLE_SCOPE GLOBAL
1146 -VARIABLE_TYPE BIGINT
1147 +VARIABLE_TYPE INT
1148 VARIABLE_COMMENT Maximum number of instrumented threads. Use 0 to disable, -1 for automated sizing
1149 NUMERIC_MIN_VALUE -1
1150 NUMERIC_MAX_VALUE 1048576
1151 @@ -3284,7 +3284,7 @@ READ_ONLY YES
1152 COMMAND_LINE_ARGUMENT REQUIRED
1153 VARIABLE_NAME PERFORMANCE_SCHEMA_SESSION_CONNECT_ATTRS_SIZE
1154 VARIABLE_SCOPE GLOBAL
1155 -VARIABLE_TYPE BIGINT
1156 +VARIABLE_TYPE INT
1157 VARIABLE_COMMENT Size of session attribute string buffer per thread. Use 0 to disable, -1 for automated sizing
1158 NUMERIC_MIN_VALUE -1
1159 NUMERIC_MAX_VALUE 1048576
1160 @@ -3294,7 +3294,7 @@ READ_ONLY YES
1161 COMMAND_LINE_ARGUMENT REQUIRED
1162 VARIABLE_NAME PERFORMANCE_SCHEMA_SETUP_ACTORS_SIZE
1163 VARIABLE_SCOPE GLOBAL
1164 -VARIABLE_TYPE BIGINT
1165 +VARIABLE_TYPE INT
1166 VARIABLE_COMMENT Maximum number of rows in SETUP_ACTORS
1167 NUMERIC_MIN_VALUE -1
1168 NUMERIC_MAX_VALUE 1024
1169 @@ -3304,7 +3304,7 @@ READ_ONLY YES
1170 COMMAND_LINE_ARGUMENT REQUIRED
1171 VARIABLE_NAME PERFORMANCE_SCHEMA_SETUP_OBJECTS_SIZE
1172 VARIABLE_SCOPE GLOBAL
1173 -VARIABLE_TYPE BIGINT
1174 +VARIABLE_TYPE INT
1175 VARIABLE_COMMENT Maximum number of rows in SETUP_OBJECTS
1176 NUMERIC_MIN_VALUE -1
1177 NUMERIC_MAX_VALUE 1048576
1178 @@ -3314,7 +3314,7 @@ READ_ONLY YES
1179 COMMAND_LINE_ARGUMENT REQUIRED
1180 VARIABLE_NAME PERFORMANCE_SCHEMA_USERS_SIZE
1181 VARIABLE_SCOPE GLOBAL
1182 -VARIABLE_TYPE BIGINT
1183 +VARIABLE_TYPE INT
1184 VARIABLE_COMMENT Maximum number of instrumented users. Use 0 to disable, -1 for automated sizing
1185 NUMERIC_MIN_VALUE -1
1186 NUMERIC_MAX_VALUE 1048576
1187 @@ -3364,7 +3364,7 @@ READ_ONLY YES
1188 COMMAND_LINE_ARGUMENT REQUIRED
1189 VARIABLE_NAME PRELOAD_BUFFER_SIZE
1190 VARIABLE_SCOPE SESSION
1191 -VARIABLE_TYPE BIGINT UNSIGNED
1192 +VARIABLE_TYPE INT UNSIGNED
1193 VARIABLE_COMMENT The size of the buffer that is allocated when preloading indexes
1194 NUMERIC_MIN_VALUE 1024
1195 NUMERIC_MAX_VALUE 1073741824
1196 @@ -3384,7 +3384,7 @@ READ_ONLY NO
1197 COMMAND_LINE_ARGUMENT NULL
1198 VARIABLE_NAME PROFILING_HISTORY_SIZE
1199 VARIABLE_SCOPE SESSION
1200 -VARIABLE_TYPE BIGINT UNSIGNED
1201 +VARIABLE_TYPE INT UNSIGNED
1202 VARIABLE_COMMENT Number of statements about which profiling information is maintained. If set to 0, no profiles are stored. See SHOW PROFILES
1203 NUMERIC_MIN_VALUE 0
1204 NUMERIC_MAX_VALUE 100
1205 @@ -3394,7 +3394,7 @@ READ_ONLY NO
1206 COMMAND_LINE_ARGUMENT REQUIRED
1207 VARIABLE_NAME PROGRESS_REPORT_TIME
1208 VARIABLE_SCOPE SESSION
1209 -VARIABLE_TYPE BIGINT UNSIGNED
1210 +VARIABLE_TYPE INT UNSIGNED
1211 VARIABLE_COMMENT Seconds between sending progress reports to the client for time-consuming statements. Set to 0 to disable progress reporting
1212 NUMERIC_MIN_VALUE 0
1213 NUMERIC_MAX_VALUE 4294967295
1214 @@ -3454,7 +3454,7 @@ READ_ONLY NO
1215 COMMAND_LINE_ARGUMENT NULL
1216 VARIABLE_NAME QUERY_ALLOC_BLOCK_SIZE
1217 VARIABLE_SCOPE SESSION
1218 -VARIABLE_TYPE BIGINT UNSIGNED
1219 +VARIABLE_TYPE INT UNSIGNED
1220 VARIABLE_COMMENT Allocation block size for query parsing and execution
1221 NUMERIC_MIN_VALUE 1024
1222 NUMERIC_MAX_VALUE 4294967295
1223 @@ -3464,7 +3464,7 @@ READ_ONLY NO
1224 COMMAND_LINE_ARGUMENT REQUIRED
1225 VARIABLE_NAME QUERY_CACHE_LIMIT
1226 VARIABLE_SCOPE GLOBAL
1227 -VARIABLE_TYPE BIGINT UNSIGNED
1228 +VARIABLE_TYPE INT UNSIGNED
1229 VARIABLE_COMMENT Don't cache results that are bigger than this
1230 NUMERIC_MIN_VALUE 0
1231 NUMERIC_MAX_VALUE 4294967295
1232 @@ -3474,7 +3474,7 @@ READ_ONLY NO
1233 COMMAND_LINE_ARGUMENT REQUIRED
1234 VARIABLE_NAME QUERY_CACHE_MIN_RES_UNIT
1235 VARIABLE_SCOPE GLOBAL
1236 -VARIABLE_TYPE BIGINT UNSIGNED
1237 +VARIABLE_TYPE INT UNSIGNED
1238 VARIABLE_COMMENT The minimum size for blocks allocated by the query cache
1239 NUMERIC_MIN_VALUE 0
1240 NUMERIC_MAX_VALUE 4294967295
1241 @@ -3487,7 +3487,7 @@ VARIABLE_SCOPE GLOBAL
1242 VARIABLE_TYPE BIGINT UNSIGNED
1243 VARIABLE_COMMENT The memory allocated to store results from old queries
1244 NUMERIC_MIN_VALUE 0
1245 -NUMERIC_MAX_VALUE 18446744073709551615
1246 +NUMERIC_MAX_VALUE 4294967295
1247 NUMERIC_BLOCK_SIZE 1024
1248 ENUM_VALUE_LIST NULL
1249 READ_ONLY NO
1250 @@ -3524,7 +3524,7 @@ READ_ONLY NO
1251 COMMAND_LINE_ARGUMENT OPTIONAL
1252 VARIABLE_NAME QUERY_PREALLOC_SIZE
1253 VARIABLE_SCOPE SESSION
1254 -VARIABLE_TYPE BIGINT UNSIGNED
1255 +VARIABLE_TYPE INT UNSIGNED
1256 VARIABLE_COMMENT Persistent buffer for query parsing and execution
1257 NUMERIC_MIN_VALUE 1024
1258 NUMERIC_MAX_VALUE 4294967295
1259 @@ -3537,7 +3537,7 @@ 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 @@ -3547,14 +3547,14 @@ VARIABLE_SCOPE SESSION ONLY
1269 VARIABLE_TYPE BIGINT UNSIGNED
1270 VARIABLE_COMMENT Sets the internal state of the RAND() generator for replication purposes
1271 NUMERIC_MIN_VALUE 0
1272 -NUMERIC_MAX_VALUE 18446744073709551615
1273 +NUMERIC_MAX_VALUE 4294967295
1274 NUMERIC_BLOCK_SIZE 1
1275 ENUM_VALUE_LIST NULL
1276 READ_ONLY NO
1277 COMMAND_LINE_ARGUMENT NULL
1278 VARIABLE_NAME RANGE_ALLOC_BLOCK_SIZE
1279 VARIABLE_SCOPE SESSION
1280 -VARIABLE_TYPE BIGINT UNSIGNED
1281 +VARIABLE_TYPE INT UNSIGNED
1282 VARIABLE_COMMENT Allocation block size for storing ranges during optimization
1283 NUMERIC_MIN_VALUE 4096
1284 NUMERIC_MAX_VALUE 4294967295
1285 @@ -3567,14 +3567,14 @@ VARIABLE_SCOPE GLOBAL
1286 VARIABLE_TYPE BIGINT UNSIGNED
1287 VARIABLE_COMMENT Maximum speed(KB/s) to read binlog from master (0 = no limit)
1288 NUMERIC_MIN_VALUE 0
1289 -NUMERIC_MAX_VALUE 18446744073709551615
1290 +NUMERIC_MAX_VALUE 4294967295
1291 NUMERIC_BLOCK_SIZE 1
1292 ENUM_VALUE_LIST NULL
1293 READ_ONLY NO
1294 COMMAND_LINE_ARGUMENT REQUIRED
1295 VARIABLE_NAME READ_BUFFER_SIZE
1296 VARIABLE_SCOPE SESSION
1297 -VARIABLE_TYPE BIGINT UNSIGNED
1298 +VARIABLE_TYPE INT UNSIGNED
1299 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
1300 NUMERIC_MIN_VALUE 8192
1301 NUMERIC_MAX_VALUE 2147483647
1302 @@ -3594,7 +3594,7 @@ READ_ONLY NO
1303 COMMAND_LINE_ARGUMENT OPTIONAL
1304 VARIABLE_NAME READ_RND_BUFFER_SIZE
1305 VARIABLE_SCOPE SESSION
1306 -VARIABLE_TYPE BIGINT UNSIGNED
1307 +VARIABLE_TYPE INT UNSIGNED
1308 VARIABLE_COMMENT When reading rows in sorted order after a sort, the rows are read through this buffer to avoid a disk seeks
1309 NUMERIC_MIN_VALUE 1
1310 NUMERIC_MAX_VALUE 2147483647
1311 @@ -3824,10 +3824,10 @@ READ_ONLY NO
1312 COMMAND_LINE_ARGUMENT OPTIONAL
1313 VARIABLE_NAME ROWID_MERGE_BUFF_SIZE
1314 VARIABLE_SCOPE SESSION
1315 -VARIABLE_TYPE BIGINT UNSIGNED
1316 +VARIABLE_TYPE INT UNSIGNED
1317 VARIABLE_COMMENT The size of the buffers used [NOT] IN evaluation via partial matching
1318 NUMERIC_MIN_VALUE 0
1319 -NUMERIC_MAX_VALUE 9223372036854775807
1320 +NUMERIC_MAX_VALUE 2147483647
1321 NUMERIC_BLOCK_SIZE 1
1322 ENUM_VALUE_LIST NULL
1323 READ_ONLY NO
1324 @@ -3844,20 +3844,20 @@ READ_ONLY NO
1325 COMMAND_LINE_ARGUMENT OPTIONAL
1326 VARIABLE_NAME RPL_SEMI_SYNC_MASTER_TIMEOUT
1327 VARIABLE_SCOPE GLOBAL
1328 -VARIABLE_TYPE BIGINT UNSIGNED
1329 +VARIABLE_TYPE INT UNSIGNED
1330 VARIABLE_COMMENT The timeout value (in ms) for semi-synchronous replication in the master
1331 NUMERIC_MIN_VALUE 0
1332 -NUMERIC_MAX_VALUE 18446744073709551615
1333 +NUMERIC_MAX_VALUE 4294967295
1334 NUMERIC_BLOCK_SIZE 1
1335 ENUM_VALUE_LIST NULL
1336 READ_ONLY NO
1337 COMMAND_LINE_ARGUMENT REQUIRED
1338 VARIABLE_NAME RPL_SEMI_SYNC_MASTER_TRACE_LEVEL
1339 VARIABLE_SCOPE GLOBAL
1340 -VARIABLE_TYPE BIGINT UNSIGNED
1341 +VARIABLE_TYPE INT UNSIGNED
1342 VARIABLE_COMMENT The tracing level for semi-sync replication
1343 NUMERIC_MIN_VALUE 0
1344 -NUMERIC_MAX_VALUE 18446744073709551615
1345 +NUMERIC_MAX_VALUE 4294967295
1346 NUMERIC_BLOCK_SIZE 1
1347 ENUM_VALUE_LIST NULL
1348 READ_ONLY NO
1349 @@ -3914,10 +3914,10 @@ READ_ONLY NO
1350 COMMAND_LINE_ARGUMENT OPTIONAL
1351 VARIABLE_NAME RPL_SEMI_SYNC_SLAVE_TRACE_LEVEL
1352 VARIABLE_SCOPE GLOBAL
1353 -VARIABLE_TYPE BIGINT UNSIGNED
1354 +VARIABLE_TYPE INT UNSIGNED
1355 VARIABLE_COMMENT The tracing level for semi-sync replication
1356 NUMERIC_MIN_VALUE 0
1357 -NUMERIC_MAX_VALUE 18446744073709551615
1358 +NUMERIC_MAX_VALUE 4294967295
1359 NUMERIC_BLOCK_SIZE 1
1360 ENUM_VALUE_LIST NULL
1361 READ_ONLY NO
1362 @@ -3954,7 +3954,7 @@ READ_ONLY YES
1363 COMMAND_LINE_ARGUMENT REQUIRED
1364 VARIABLE_NAME SERVER_ID
1365 VARIABLE_SCOPE SESSION
1366 -VARIABLE_TYPE BIGINT UNSIGNED
1367 +VARIABLE_TYPE INT UNSIGNED
1368 VARIABLE_COMMENT Uniquely identifies the server instance in the community of replication partners
1369 NUMERIC_MIN_VALUE 1
1370 NUMERIC_MAX_VALUE 4294967295
1371 @@ -4124,7 +4124,7 @@ READ_ONLY NO
1372 COMMAND_LINE_ARGUMENT REQUIRED
1373 VARIABLE_NAME SLAVE_DOMAIN_PARALLEL_THREADS
1374 VARIABLE_SCOPE GLOBAL
1375 -VARIABLE_TYPE BIGINT UNSIGNED
1376 +VARIABLE_TYPE INT UNSIGNED
1377 VARIABLE_COMMENT Maximum number of parallel threads to use on slave for events in a single replication domain. When using multiple domains, this can be used to limit a single domain from grabbing all threads and thus stalling other domains. The default of 0 means to allow a domain to grab as many threads as it wants, up to the value of slave_parallel_threads
1378 NUMERIC_MIN_VALUE 0
1379 NUMERIC_MAX_VALUE 16383
1380 @@ -4154,7 +4154,7 @@ READ_ONLY YES
1381 COMMAND_LINE_ARGUMENT REQUIRED
1382 VARIABLE_NAME SLAVE_MAX_ALLOWED_PACKET
1383 VARIABLE_SCOPE GLOBAL
1384 -VARIABLE_TYPE BIGINT UNSIGNED
1385 +VARIABLE_TYPE INT UNSIGNED
1386 VARIABLE_COMMENT The maximum packet length to sent successfully from the master to slave
1387 NUMERIC_MIN_VALUE 1024
1388 NUMERIC_MAX_VALUE 1073741824
1389 @@ -4184,7 +4184,7 @@ READ_ONLY NO
1390 COMMAND_LINE_ARGUMENT REQUIRED
1391 VARIABLE_NAME SLAVE_PARALLEL_MAX_QUEUED
1392 VARIABLE_SCOPE GLOBAL
1393 -VARIABLE_TYPE BIGINT UNSIGNED
1394 +VARIABLE_TYPE INT UNSIGNED
1395 VARIABLE_COMMENT Limit on how much memory SQL threads should use per parallel replication thread when reading ahead in the relay log looking for opportunities for parallel replication. Only used when --slave-parallel-threads > 0
1396 NUMERIC_MIN_VALUE 0
1397 NUMERIC_MAX_VALUE 2147483647
1398 @@ -4204,7 +4204,7 @@ READ_ONLY NO
1399 COMMAND_LINE_ARGUMENT NULL
1400 VARIABLE_NAME SLAVE_PARALLEL_THREADS
1401 VARIABLE_SCOPE GLOBAL
1402 -VARIABLE_TYPE BIGINT UNSIGNED
1403 +VARIABLE_TYPE INT UNSIGNED
1404 VARIABLE_COMMENT If non-zero, number of threads to spawn to apply in parallel events on the slave that were group-committed on the master or were logged with GTID in different replication domains. Note that these threads are in addition to the IO and SQL threads, which are always created by a replication slave
1405 NUMERIC_MIN_VALUE 0
1406 NUMERIC_MAX_VALUE 16383
1407 @@ -4214,7 +4214,7 @@ READ_ONLY NO
1408 COMMAND_LINE_ARGUMENT REQUIRED
1409 VARIABLE_NAME SLAVE_PARALLEL_WORKERS
1410 VARIABLE_SCOPE GLOBAL
1411 -VARIABLE_TYPE BIGINT UNSIGNED
1412 +VARIABLE_TYPE INT UNSIGNED
1413 VARIABLE_COMMENT Alias for slave_parallel_threads
1414 NUMERIC_MIN_VALUE 0
1415 NUMERIC_MAX_VALUE 16383
1416 @@ -4254,7 +4254,7 @@ READ_ONLY NO
1417 COMMAND_LINE_ARGUMENT OPTIONAL
1418 VARIABLE_NAME SLAVE_TRANSACTION_RETRIES
1419 VARIABLE_SCOPE GLOBAL
1420 -VARIABLE_TYPE BIGINT UNSIGNED
1421 +VARIABLE_TYPE INT UNSIGNED
1422 VARIABLE_COMMENT Number of times the slave SQL thread will retry a transaction in case it failed with a deadlock, elapsed lock wait timeout or listed in slave_transaction_retry_errors, before giving up and stopping
1423 NUMERIC_MIN_VALUE 0
1424 NUMERIC_MAX_VALUE 4294967295
1425 @@ -4274,7 +4274,7 @@ READ_ONLY YES
1426 COMMAND_LINE_ARGUMENT REQUIRED
1427 VARIABLE_NAME SLAVE_TRANSACTION_RETRY_INTERVAL
1428 VARIABLE_SCOPE GLOBAL
1429 -VARIABLE_TYPE BIGINT UNSIGNED
1430 +VARIABLE_TYPE INT UNSIGNED
1431 VARIABLE_COMMENT Interval of the slave SQL thread will retry a transaction in case it failed with a deadlock or elapsed lock wait timeout or listed in slave_transaction_retry_errors
1432 NUMERIC_MIN_VALUE 0
1433 NUMERIC_MAX_VALUE 3600
1434 @@ -4294,7 +4294,7 @@ READ_ONLY NO
1435 COMMAND_LINE_ARGUMENT REQUIRED
1436 VARIABLE_NAME SLOW_LAUNCH_TIME
1437 VARIABLE_SCOPE GLOBAL
1438 -VARIABLE_TYPE BIGINT UNSIGNED
1439 +VARIABLE_TYPE INT UNSIGNED
1440 VARIABLE_COMMENT If creating the thread takes longer than this value (in seconds), the Slow_launch_threads counter will be incremented
1441 NUMERIC_MIN_VALUE 0
1442 NUMERIC_MAX_VALUE 31536000
1443 @@ -4337,7 +4337,7 @@ VARIABLE_SCOPE SESSION
1444 VARIABLE_TYPE BIGINT UNSIGNED
1445 VARIABLE_COMMENT Each thread that needs to do a sort allocates a buffer of this size
1446 NUMERIC_MIN_VALUE 1024
1447 -NUMERIC_MAX_VALUE 18446744073709551615
1448 +NUMERIC_MAX_VALUE 4294967295
1449 NUMERIC_BLOCK_SIZE 1
1450 ENUM_VALUE_LIST NULL
1451 READ_ONLY NO
1452 @@ -4564,7 +4564,7 @@ READ_ONLY NO
1453 COMMAND_LINE_ARGUMENT NULL
1454 VARIABLE_NAME STORED_PROGRAM_CACHE
1455 VARIABLE_SCOPE GLOBAL
1456 -VARIABLE_TYPE BIGINT UNSIGNED
1457 +VARIABLE_TYPE INT UNSIGNED
1458 VARIABLE_COMMENT The soft upper limit for number of cached stored routines for one connection
1459 NUMERIC_MIN_VALUE 0
1460 NUMERIC_MAX_VALUE 524288
1461 @@ -4674,7 +4674,7 @@ READ_ONLY NO
1462 COMMAND_LINE_ARGUMENT OPTIONAL
1463 VARIABLE_NAME TABLE_DEFINITION_CACHE
1464 VARIABLE_SCOPE GLOBAL
1465 -VARIABLE_TYPE BIGINT UNSIGNED
1466 +VARIABLE_TYPE INT UNSIGNED
1467 VARIABLE_COMMENT The number of cached table definitions
1468 NUMERIC_MIN_VALUE 400
1469 NUMERIC_MAX_VALUE 2097152
1470 @@ -4684,7 +4684,7 @@ READ_ONLY NO
1471 COMMAND_LINE_ARGUMENT REQUIRED
1472 VARIABLE_NAME TABLE_OPEN_CACHE
1473 VARIABLE_SCOPE GLOBAL
1474 -VARIABLE_TYPE BIGINT UNSIGNED
1475 +VARIABLE_TYPE INT UNSIGNED
1476 VARIABLE_COMMENT The number of cached open tables
1477 NUMERIC_MIN_VALUE 10
1478 NUMERIC_MAX_VALUE 1048576
1479 @@ -4744,7 +4744,7 @@ READ_ONLY NO
1480 COMMAND_LINE_ARGUMENT OPTIONAL
1481 VARIABLE_NAME THREAD_CACHE_SIZE
1482 VARIABLE_SCOPE GLOBAL
1483 -VARIABLE_TYPE BIGINT UNSIGNED
1484 +VARIABLE_TYPE INT UNSIGNED
1485 VARIABLE_COMMENT How many threads we should keep in a cache for reuse. These are freed after 5 minutes of idle time
1486 NUMERIC_MIN_VALUE 0
1487 NUMERIC_MAX_VALUE 16384
1488 @@ -4897,7 +4897,7 @@ VARIABLE_SCOPE SESSION
1489 VARIABLE_TYPE BIGINT UNSIGNED
1490 VARIABLE_COMMENT Max size for data for an internal temporary on-disk MyISAM or Aria table
1491 NUMERIC_MIN_VALUE 1024
1492 -NUMERIC_MAX_VALUE 18446744073709551615
1493 +NUMERIC_MAX_VALUE 4294967295
1494 NUMERIC_BLOCK_SIZE 1
1495 ENUM_VALUE_LIST NULL
1496 READ_ONLY NO
1497 @@ -4907,7 +4907,7 @@ VARIABLE_SCOPE SESSION
1498 VARIABLE_TYPE BIGINT UNSIGNED
1499 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
1500 NUMERIC_MIN_VALUE 0
1501 -NUMERIC_MAX_VALUE 18446744073709551615
1502 +NUMERIC_MAX_VALUE 4294967295
1503 NUMERIC_BLOCK_SIZE 16384
1504 ENUM_VALUE_LIST NULL
1505 READ_ONLY NO
1506 @@ -4917,14 +4917,14 @@ VARIABLE_SCOPE SESSION
1507 VARIABLE_TYPE BIGINT UNSIGNED
1508 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
1509 NUMERIC_MIN_VALUE 0
1510 -NUMERIC_MAX_VALUE 18446744073709551615
1511 +NUMERIC_MAX_VALUE 4294967295
1512 NUMERIC_BLOCK_SIZE 16384
1513 ENUM_VALUE_LIST NULL
1514 READ_ONLY NO
1515 COMMAND_LINE_ARGUMENT REQUIRED
1516 VARIABLE_NAME TRANSACTION_ALLOC_BLOCK_SIZE
1517 VARIABLE_SCOPE SESSION
1518 -VARIABLE_TYPE BIGINT UNSIGNED
1519 +VARIABLE_TYPE INT UNSIGNED
1520 VARIABLE_COMMENT Allocation block size for transactions to be stored in binary log
1521 NUMERIC_MIN_VALUE 1024
1522 NUMERIC_MAX_VALUE 134217728
1523 @@ -4944,7 +4944,7 @@ READ_ONLY NO
1524 COMMAND_LINE_ARGUMENT NULL
1525 VARIABLE_NAME TRANSACTION_PREALLOC_SIZE
1526 VARIABLE_SCOPE SESSION
1527 -VARIABLE_TYPE BIGINT UNSIGNED
1528 +VARIABLE_TYPE INT UNSIGNED
1529 VARIABLE_COMMENT Persistent buffer for transactions to be stored in binary log
1530 NUMERIC_MIN_VALUE 1024
1531 NUMERIC_MAX_VALUE 134217728
1532 @@ -5094,7 +5094,7 @@ READ_ONLY YES
1533 COMMAND_LINE_ARGUMENT NULL
1534 VARIABLE_NAME WAIT_TIMEOUT
1535 VARIABLE_SCOPE SESSION
1536 -VARIABLE_TYPE BIGINT UNSIGNED
1537 +VARIABLE_TYPE INT UNSIGNED
1538 VARIABLE_COMMENT The number of seconds the server waits for activity on a connection before closing it
1539 NUMERIC_MIN_VALUE 1
1540 NUMERIC_MAX_VALUE 31536000
1541 @@ -5121,7 +5121,7 @@ order by variable_name;
1542 VARIABLE_NAME LOG_TC_SIZE
1543 GLOBAL_VALUE_ORIGIN AUTO
1544 VARIABLE_SCOPE GLOBAL
1545 -VARIABLE_TYPE BIGINT UNSIGNED
1546 +VARIABLE_TYPE INT UNSIGNED
1547 VARIABLE_COMMENT Size of transaction coordinator log
1548 ENUM_VALUE_LIST NULL
1549 READ_ONLY YES