Debian Codegraph @

mysql-test/suite/sys_vars/r/sysvars_server_notembedded,win.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 @@ -284,7 +284,7 @@ READ_ONLY NO
98 COMMAND_LINE_ARGUMENT OPTIONAL
99 VARIABLE_NAME AUTO_INCREMENT_INCREMENT
100 VARIABLE_SCOPE SESSION
101 -VARIABLE_TYPE BIGINT UNSIGNED
102 +VARIABLE_TYPE INT UNSIGNED
103 VARIABLE_COMMENT Auto-increment columns are incremented by this
104 NUMERIC_MIN_VALUE 1
105 NUMERIC_MAX_VALUE 65535
106 @@ -294,7 +294,7 @@ READ_ONLY NO
107 COMMAND_LINE_ARGUMENT OPTIONAL
108 VARIABLE_NAME AUTO_INCREMENT_OFFSET
109 VARIABLE_SCOPE SESSION
110 -VARIABLE_TYPE BIGINT UNSIGNED
111 +VARIABLE_TYPE INT UNSIGNED
112 VARIABLE_COMMENT Offset added to Auto-increment columns. Used when auto-increment-increment != 1
113 NUMERIC_MIN_VALUE 1
114 NUMERIC_MAX_VALUE 65535
115 @@ -304,7 +304,7 @@ READ_ONLY NO
116 COMMAND_LINE_ARGUMENT OPTIONAL
117 VARIABLE_NAME BACK_LOG
118 VARIABLE_SCOPE GLOBAL
119 -VARIABLE_TYPE BIGINT UNSIGNED
120 +VARIABLE_TYPE INT UNSIGNED
121 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
122 NUMERIC_MIN_VALUE 0
123 NUMERIC_MAX_VALUE 65535
124 @@ -384,20 +384,20 @@ READ_ONLY NO
125 COMMAND_LINE_ARGUMENT REQUIRED
126 VARIABLE_NAME BINLOG_COMMIT_WAIT_COUNT
127 VARIABLE_SCOPE GLOBAL
128 -VARIABLE_TYPE BIGINT UNSIGNED
129 +VARIABLE_TYPE INT UNSIGNED
130 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
131 NUMERIC_MIN_VALUE 0
132 -NUMERIC_MAX_VALUE 18446744073709551615
133 +NUMERIC_MAX_VALUE 4294967295
134 NUMERIC_BLOCK_SIZE 1
135 ENUM_VALUE_LIST NULL
136 READ_ONLY NO
137 COMMAND_LINE_ARGUMENT REQUIRED
138 VARIABLE_NAME BINLOG_COMMIT_WAIT_USEC
139 VARIABLE_SCOPE GLOBAL
140 -VARIABLE_TYPE BIGINT UNSIGNED
141 +VARIABLE_TYPE INT UNSIGNED
142 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
143 NUMERIC_MIN_VALUE 0
144 -NUMERIC_MAX_VALUE 18446744073709551615
145 +NUMERIC_MAX_VALUE 4294967295
146 NUMERIC_BLOCK_SIZE 1
147 ENUM_VALUE_LIST NULL
148 READ_ONLY NO
149 @@ -424,7 +424,7 @@ READ_ONLY YES
150 COMMAND_LINE_ARGUMENT NULL
151 VARIABLE_NAME BINLOG_EXPIRE_LOGS_SECONDS
152 VARIABLE_SCOPE GLOBAL
153 -VARIABLE_TYPE BIGINT UNSIGNED
154 +VARIABLE_TYPE INT UNSIGNED
155 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
156 NUMERIC_MIN_VALUE 0
157 NUMERIC_MAX_VALUE 8553600
158 @@ -784,7 +784,7 @@ READ_ONLY NO
159 COMMAND_LINE_ARGUMENT OPTIONAL
160 VARIABLE_NAME CONNECT_TIMEOUT
161 VARIABLE_SCOPE GLOBAL
162 -VARIABLE_TYPE BIGINT UNSIGNED
163 +VARIABLE_TYPE INT UNSIGNED
164 VARIABLE_COMMENT The number of seconds the MariaDB server is waiting for a connect packet before responding with 'Bad handshake'
165 NUMERIC_MIN_VALUE 2
166 NUMERIC_MAX_VALUE 31536000
167 @@ -814,7 +814,7 @@ READ_ONLY YES
168 COMMAND_LINE_ARGUMENT REQUIRED
169 VARIABLE_NAME DEADLOCK_SEARCH_DEPTH_LONG
170 VARIABLE_SCOPE SESSION
171 -VARIABLE_TYPE BIGINT UNSIGNED
172 +VARIABLE_TYPE INT UNSIGNED
173 VARIABLE_COMMENT Long search depth for the two-step deadlock detection
174 NUMERIC_MIN_VALUE 0
175 NUMERIC_MAX_VALUE 33
176 @@ -824,7 +824,7 @@ READ_ONLY NO
177 COMMAND_LINE_ARGUMENT REQUIRED
178 VARIABLE_NAME DEADLOCK_SEARCH_DEPTH_SHORT
179 VARIABLE_SCOPE SESSION
180 -VARIABLE_TYPE BIGINT UNSIGNED
181 +VARIABLE_TYPE INT UNSIGNED
182 VARIABLE_COMMENT Short search depth for the two-step deadlock detection
183 NUMERIC_MIN_VALUE 0
184 NUMERIC_MAX_VALUE 32
185 @@ -834,7 +834,7 @@ READ_ONLY NO
186 COMMAND_LINE_ARGUMENT REQUIRED
187 VARIABLE_NAME DEADLOCK_TIMEOUT_LONG
188 VARIABLE_SCOPE SESSION
189 -VARIABLE_TYPE BIGINT UNSIGNED
190 +VARIABLE_TYPE INT UNSIGNED
191 VARIABLE_COMMENT Long timeout for the two-step deadlock detection (in microseconds)
192 NUMERIC_MIN_VALUE 0
193 NUMERIC_MAX_VALUE 4294967295
194 @@ -844,7 +844,7 @@ READ_ONLY NO
195 COMMAND_LINE_ARGUMENT REQUIRED
196 VARIABLE_NAME DEADLOCK_TIMEOUT_SHORT
197 VARIABLE_SCOPE SESSION
198 -VARIABLE_TYPE BIGINT UNSIGNED
199 +VARIABLE_TYPE INT UNSIGNED
200 VARIABLE_COMMENT Short timeout for the two-step deadlock detection (in microseconds)
201 NUMERIC_MIN_VALUE 0
202 NUMERIC_MAX_VALUE 4294967295
203 @@ -904,7 +904,7 @@ READ_ONLY NO
204 COMMAND_LINE_ARGUMENT NULL
205 VARIABLE_NAME DEFAULT_WEEK_FORMAT
206 VARIABLE_SCOPE SESSION
207 -VARIABLE_TYPE BIGINT UNSIGNED
208 +VARIABLE_TYPE INT UNSIGNED
209 VARIABLE_COMMENT The default week format used by WEEK() functions
210 NUMERIC_MIN_VALUE 0
211 NUMERIC_MAX_VALUE 7
212 @@ -914,7 +914,7 @@ READ_ONLY NO
213 COMMAND_LINE_ARGUMENT REQUIRED
214 VARIABLE_NAME DELAYED_INSERT_LIMIT
215 VARIABLE_SCOPE GLOBAL
216 -VARIABLE_TYPE BIGINT UNSIGNED
217 +VARIABLE_TYPE INT UNSIGNED
218 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
219 NUMERIC_MIN_VALUE 1
220 NUMERIC_MAX_VALUE 4294967295
221 @@ -924,7 +924,7 @@ READ_ONLY NO
222 COMMAND_LINE_ARGUMENT REQUIRED
223 VARIABLE_NAME DELAYED_INSERT_TIMEOUT
224 VARIABLE_SCOPE GLOBAL
225 -VARIABLE_TYPE BIGINT UNSIGNED
226 +VARIABLE_TYPE INT UNSIGNED
227 VARIABLE_COMMENT How long a INSERT DELAYED thread should wait for INSERT statements before terminating
228 NUMERIC_MIN_VALUE 1
229 NUMERIC_MAX_VALUE 31536000
230 @@ -934,7 +934,7 @@ READ_ONLY NO
231 COMMAND_LINE_ARGUMENT REQUIRED
232 VARIABLE_NAME DELAYED_QUEUE_SIZE
233 VARIABLE_SCOPE GLOBAL
234 -VARIABLE_TYPE BIGINT UNSIGNED
235 +VARIABLE_TYPE INT UNSIGNED
236 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
237 NUMERIC_MIN_VALUE 1
238 NUMERIC_MAX_VALUE 4294967295
239 @@ -964,7 +964,7 @@ READ_ONLY NO
240 COMMAND_LINE_ARGUMENT OPTIONAL
241 VARIABLE_NAME DIV_PRECISION_INCREMENT
242 VARIABLE_SCOPE SESSION
243 -VARIABLE_TYPE BIGINT UNSIGNED
244 +VARIABLE_TYPE INT UNSIGNED
245 VARIABLE_COMMENT Precision of the result of '/' operator will be increased on that value
246 NUMERIC_MIN_VALUE 0
247 NUMERIC_MAX_VALUE 38
248 @@ -1084,7 +1084,7 @@ READ_ONLY YES
249 COMMAND_LINE_ARGUMENT NULL
250 VARIABLE_NAME EXTRA_MAX_CONNECTIONS
251 VARIABLE_SCOPE GLOBAL
252 -VARIABLE_TYPE BIGINT UNSIGNED
253 +VARIABLE_TYPE INT UNSIGNED
254 VARIABLE_COMMENT The number of connections on extra-port
255 NUMERIC_MIN_VALUE 1
256 NUMERIC_MAX_VALUE 100000
257 @@ -1114,7 +1114,7 @@ READ_ONLY NO
258 COMMAND_LINE_ARGUMENT OPTIONAL
259 VARIABLE_NAME FLUSH_TIME
260 VARIABLE_SCOPE GLOBAL
261 -VARIABLE_TYPE BIGINT UNSIGNED
262 +VARIABLE_TYPE INT UNSIGNED
263 VARIABLE_COMMENT A dedicated thread is created to flush all tables at the given interval
264 NUMERIC_MIN_VALUE 0
265 NUMERIC_MAX_VALUE 31536000
266 @@ -1144,7 +1144,7 @@ READ_ONLY NO
267 COMMAND_LINE_ARGUMENT REQUIRED
268 VARIABLE_NAME FT_MAX_WORD_LEN
269 VARIABLE_SCOPE GLOBAL
270 -VARIABLE_TYPE BIGINT UNSIGNED
271 +VARIABLE_TYPE INT UNSIGNED
272 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
273 NUMERIC_MIN_VALUE 10
274 NUMERIC_MAX_VALUE 84
275 @@ -1154,7 +1154,7 @@ READ_ONLY YES
276 COMMAND_LINE_ARGUMENT REQUIRED
277 VARIABLE_NAME FT_MIN_WORD_LEN
278 VARIABLE_SCOPE GLOBAL
279 -VARIABLE_TYPE BIGINT UNSIGNED
280 +VARIABLE_TYPE INT UNSIGNED
281 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
282 NUMERIC_MIN_VALUE 1
283 NUMERIC_MAX_VALUE 84
284 @@ -1164,7 +1164,7 @@ READ_ONLY YES
285 COMMAND_LINE_ARGUMENT REQUIRED
286 VARIABLE_NAME FT_QUERY_EXPANSION_LIMIT
287 VARIABLE_SCOPE GLOBAL
288 -VARIABLE_TYPE BIGINT UNSIGNED
289 +VARIABLE_TYPE INT UNSIGNED
290 VARIABLE_COMMENT Number of best matches to use for query expansion
291 NUMERIC_MIN_VALUE 0
292 NUMERIC_MAX_VALUE 1000
293 @@ -1414,7 +1414,7 @@ READ_ONLY YES
294 COMMAND_LINE_ARGUMENT NULL
295 VARIABLE_NAME HISTOGRAM_SIZE
296 VARIABLE_SCOPE SESSION
297 -VARIABLE_TYPE BIGINT UNSIGNED
298 +VARIABLE_TYPE INT UNSIGNED
299 VARIABLE_COMMENT Number of bytes used for a histogram. If set to 0, no histograms are created by ANALYZE
300 NUMERIC_MIN_VALUE 0
301 NUMERIC_MAX_VALUE 255
302 @@ -1444,7 +1444,7 @@ READ_ONLY YES
303 COMMAND_LINE_ARGUMENT NULL
304 VARIABLE_NAME HOST_CACHE_SIZE
305 VARIABLE_SCOPE GLOBAL
306 -VARIABLE_TYPE BIGINT UNSIGNED
307 +VARIABLE_TYPE INT UNSIGNED
308 VARIABLE_COMMENT How many host names should be cached to avoid resolving
309 NUMERIC_MIN_VALUE 0
310 NUMERIC_MAX_VALUE 65536
311 @@ -1467,7 +1467,7 @@ VARIABLE_SCOPE SESSION
312 VARIABLE_TYPE INT UNSIGNED
313 VARIABLE_COMMENT The number of seconds the server waits for read-only idle transaction
314 NUMERIC_MIN_VALUE 0
315 -NUMERIC_MAX_VALUE 31536000
316 +NUMERIC_MAX_VALUE 2147483
317 NUMERIC_BLOCK_SIZE 1
318 ENUM_VALUE_LIST NULL
319 READ_ONLY NO
320 @@ -1477,7 +1477,7 @@ VARIABLE_SCOPE SESSION
321 VARIABLE_TYPE INT UNSIGNED
322 VARIABLE_COMMENT The number of seconds the server waits for idle transaction
323 NUMERIC_MIN_VALUE 0
324 -NUMERIC_MAX_VALUE 31536000
325 +NUMERIC_MAX_VALUE 2147483
326 NUMERIC_BLOCK_SIZE 1
327 ENUM_VALUE_LIST NULL
328 READ_ONLY NO
329 @@ -1487,7 +1487,7 @@ VARIABLE_SCOPE SESSION
330 VARIABLE_TYPE INT UNSIGNED
331 VARIABLE_COMMENT The number of seconds the server waits for write idle transaction
332 NUMERIC_MIN_VALUE 0
333 -NUMERIC_MAX_VALUE 31536000
334 +NUMERIC_MAX_VALUE 2147483
335 NUMERIC_BLOCK_SIZE 1
336 ENUM_VALUE_LIST NULL
337 READ_ONLY NO
338 @@ -1554,7 +1554,7 @@ READ_ONLY NO
339 COMMAND_LINE_ARGUMENT NULL
340 VARIABLE_NAME INTERACTIVE_TIMEOUT
341 VARIABLE_SCOPE SESSION
342 -VARIABLE_TYPE BIGINT UNSIGNED
343 +VARIABLE_TYPE INT UNSIGNED
344 VARIABLE_COMMENT The number of seconds the server waits for activity on an interactive connection before closing it
345 NUMERIC_MIN_VALUE 1
346 NUMERIC_MAX_VALUE 31536000
347 @@ -1604,7 +1604,7 @@ READ_ONLY NO
348 COMMAND_LINE_ARGUMENT REQUIRED
349 VARIABLE_NAME JOIN_CACHE_LEVEL
350 VARIABLE_SCOPE SESSION
351 -VARIABLE_TYPE BIGINT UNSIGNED
352 +VARIABLE_TYPE INT UNSIGNED
353 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
354 NUMERIC_MIN_VALUE 0
355 NUMERIC_MAX_VALUE 8
356 @@ -1782,19 +1782,9 @@ NUMERIC_BLOCK_SIZE NULL
357 ENUM_VALUE_LIST OFF,ON
358 READ_ONLY NO
359 COMMAND_LINE_ARGUMENT OPTIONAL
360 -VARIABLE_NAME LOCKED_IN_MEMORY
361 -VARIABLE_SCOPE GLOBAL
362 -VARIABLE_TYPE BOOLEAN
363 -VARIABLE_COMMENT Whether mariadbd process was locked in memory with --memlock
364 -NUMERIC_MIN_VALUE NULL
365 -NUMERIC_MAX_VALUE NULL
366 -NUMERIC_BLOCK_SIZE NULL
367 -ENUM_VALUE_LIST OFF,ON
368 -READ_ONLY YES
369 -COMMAND_LINE_ARGUMENT NULL
370 VARIABLE_NAME LOCK_WAIT_TIMEOUT
371 VARIABLE_SCOPE SESSION
372 -VARIABLE_TYPE BIGINT UNSIGNED
373 +VARIABLE_TYPE INT UNSIGNED
374 VARIABLE_COMMENT Timeout in seconds to wait for a lock before returning an error
375 NUMERIC_MIN_VALUE 0
376 NUMERIC_MAX_VALUE 31536000
377 @@ -1944,7 +1934,7 @@ READ_ONLY NO
378 COMMAND_LINE_ARGUMENT REQUIRED
379 VARIABLE_NAME LOG_SLOW_MAX_WARNINGS
380 VARIABLE_SCOPE SESSION
381 -VARIABLE_TYPE BIGINT UNSIGNED
382 +VARIABLE_TYPE INT UNSIGNED
383 VARIABLE_COMMENT Max numbers of warnings printed to slow query log per statement
384 NUMERIC_MIN_VALUE 0
385 NUMERIC_MAX_VALUE 1000
386 @@ -1994,7 +1984,7 @@ READ_ONLY NO
387 COMMAND_LINE_ARGUMENT REQUIRED
388 VARIABLE_NAME LOG_SLOW_RATE_LIMIT
389 VARIABLE_SCOPE SESSION
390 -VARIABLE_TYPE BIGINT UNSIGNED
391 +VARIABLE_TYPE INT UNSIGNED
392 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
393 NUMERIC_MIN_VALUE 1
394 NUMERIC_MAX_VALUE 4294967295
395 @@ -2024,7 +2014,7 @@ READ_ONLY NO
396 COMMAND_LINE_ARGUMENT REQUIRED
397 VARIABLE_NAME LOG_WARNINGS
398 VARIABLE_SCOPE SESSION
399 -VARIABLE_TYPE BIGINT UNSIGNED
400 +VARIABLE_TYPE INT UNSIGNED
401 VARIABLE_COMMENT Log some non-critical warnings to the error log. Value can be between 0 and 11. Higher values mean more verbosity
402 NUMERIC_MIN_VALUE 0
403 NUMERIC_MAX_VALUE 4294967295
404 @@ -2084,7 +2074,7 @@ READ_ONLY NO
405 COMMAND_LINE_ARGUMENT OPTIONAL
406 VARIABLE_NAME MAX_ALLOWED_PACKET
407 VARIABLE_SCOPE SESSION
408 -VARIABLE_TYPE BIGINT UNSIGNED
409 +VARIABLE_TYPE INT UNSIGNED
410 VARIABLE_COMMENT Max packet length to send to or receive from the server
411 NUMERIC_MIN_VALUE 1024
412 NUMERIC_MAX_VALUE 1073741824
413 @@ -2104,7 +2094,7 @@ READ_ONLY NO
414 COMMAND_LINE_ARGUMENT REQUIRED
415 VARIABLE_NAME MAX_BINLOG_SIZE
416 VARIABLE_SCOPE GLOBAL
417 -VARIABLE_TYPE BIGINT UNSIGNED
418 +VARIABLE_TYPE INT UNSIGNED
419 VARIABLE_COMMENT Binary log will be rotated automatically when the size exceeds this value, unless `binlog_large_commit_threshold` causes rotation prematurely
420 NUMERIC_MIN_VALUE 4096
421 NUMERIC_MAX_VALUE 1073741824
422 @@ -2134,7 +2124,7 @@ READ_ONLY NO
423 COMMAND_LINE_ARGUMENT REQUIRED
424 VARIABLE_NAME MAX_CONNECTIONS
425 VARIABLE_SCOPE GLOBAL
426 -VARIABLE_TYPE BIGINT UNSIGNED
427 +VARIABLE_TYPE INT UNSIGNED
428 VARIABLE_COMMENT The number of simultaneous clients allowed
429 NUMERIC_MIN_VALUE 10
430 NUMERIC_MAX_VALUE 100000
431 @@ -2144,7 +2134,7 @@ READ_ONLY NO
432 COMMAND_LINE_ARGUMENT REQUIRED
433 VARIABLE_NAME MAX_CONNECT_ERRORS
434 VARIABLE_SCOPE GLOBAL
435 -VARIABLE_TYPE BIGINT UNSIGNED
436 +VARIABLE_TYPE INT UNSIGNED
437 VARIABLE_COMMENT If there is more than this number of interrupted connections from a host this host will be blocked from further connections
438 NUMERIC_MIN_VALUE 1
439 NUMERIC_MAX_VALUE 4294967295
440 @@ -2154,7 +2144,7 @@ READ_ONLY NO
441 COMMAND_LINE_ARGUMENT REQUIRED
442 VARIABLE_NAME MAX_DELAYED_THREADS
443 VARIABLE_SCOPE SESSION
444 -VARIABLE_TYPE BIGINT UNSIGNED
445 +VARIABLE_TYPE INT UNSIGNED
446 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
447 NUMERIC_MIN_VALUE 0
448 NUMERIC_MAX_VALUE 16384
449 @@ -2174,7 +2164,7 @@ READ_ONLY YES
450 COMMAND_LINE_ARGUMENT REQUIRED
451 VARIABLE_NAME MAX_ERROR_COUNT
452 VARIABLE_SCOPE SESSION
453 -VARIABLE_TYPE BIGINT UNSIGNED
454 +VARIABLE_TYPE INT UNSIGNED
455 VARIABLE_COMMENT Max number of errors/warnings to store for a statement
456 NUMERIC_MIN_VALUE 0
457 NUMERIC_MAX_VALUE 65535
458 @@ -2194,7 +2184,7 @@ READ_ONLY NO
459 COMMAND_LINE_ARGUMENT REQUIRED
460 VARIABLE_NAME MAX_INSERT_DELAYED_THREADS
461 VARIABLE_SCOPE SESSION
462 -VARIABLE_TYPE BIGINT UNSIGNED
463 +VARIABLE_TYPE INT UNSIGNED
464 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
465 NUMERIC_MIN_VALUE 0
466 NUMERIC_MAX_VALUE 16384
467 @@ -2214,7 +2204,7 @@ READ_ONLY NO
468 COMMAND_LINE_ARGUMENT REQUIRED
469 VARIABLE_NAME MAX_LENGTH_FOR_SORT_DATA
470 VARIABLE_SCOPE SESSION
471 -VARIABLE_TYPE BIGINT UNSIGNED
472 +VARIABLE_TYPE INT UNSIGNED
473 VARIABLE_COMMENT Max number of bytes in sorted records
474 NUMERIC_MIN_VALUE 4
475 NUMERIC_MAX_VALUE 8388608
476 @@ -2244,7 +2234,7 @@ READ_ONLY NO
477 COMMAND_LINE_ARGUMENT REQUIRED
478 VARIABLE_NAME MAX_RECURSIVE_ITERATIONS
479 VARIABLE_SCOPE SESSION
480 -VARIABLE_TYPE BIGINT UNSIGNED
481 +VARIABLE_TYPE INT UNSIGNED
482 VARIABLE_COMMENT Maximum number of iterations when executing recursive queries
483 NUMERIC_MIN_VALUE 0
484 NUMERIC_MAX_VALUE 4294967295
485 @@ -2274,7 +2264,7 @@ READ_ONLY NO
486 COMMAND_LINE_ARGUMENT REQUIRED
487 VARIABLE_NAME MAX_SEEKS_FOR_KEY
488 VARIABLE_SCOPE SESSION
489 -VARIABLE_TYPE BIGINT UNSIGNED
490 +VARIABLE_TYPE INT UNSIGNED
491 VARIABLE_COMMENT Limit assumed max number of seeks when looking up rows based on a key
492 NUMERIC_MIN_VALUE 1
493 NUMERIC_MAX_VALUE 4294967295
494 @@ -2294,7 +2284,7 @@ READ_ONLY NO
495 COMMAND_LINE_ARGUMENT REQUIRED
496 VARIABLE_NAME MAX_SORT_LENGTH
497 VARIABLE_SCOPE SESSION
498 -VARIABLE_TYPE BIGINT UNSIGNED
499 +VARIABLE_TYPE INT UNSIGNED
500 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)
501 NUMERIC_MIN_VALUE 64
502 NUMERIC_MAX_VALUE 8388608
503 @@ -2304,7 +2294,7 @@ READ_ONLY NO
504 COMMAND_LINE_ARGUMENT REQUIRED
505 VARIABLE_NAME MAX_SP_RECURSION_DEPTH
506 VARIABLE_SCOPE SESSION
507 -VARIABLE_TYPE BIGINT UNSIGNED
508 +VARIABLE_TYPE INT UNSIGNED
509 VARIABLE_COMMENT Maximum stored procedure recursion depth
510 NUMERIC_MIN_VALUE 0
511 NUMERIC_MAX_VALUE 255
512 @@ -2354,7 +2344,7 @@ READ_ONLY NO
513 COMMAND_LINE_ARGUMENT REQUIRED
514 VARIABLE_NAME MAX_WRITE_LOCK_COUNT
515 VARIABLE_SCOPE GLOBAL
516 -VARIABLE_TYPE BIGINT UNSIGNED
517 +VARIABLE_TYPE INT UNSIGNED
518 VARIABLE_COMMENT After this many write locks, allow some read locks to run in between
519 NUMERIC_MIN_VALUE 1
520 NUMERIC_MAX_VALUE 4294967295
521 @@ -2364,7 +2354,7 @@ READ_ONLY NO
522 COMMAND_LINE_ARGUMENT REQUIRED
523 VARIABLE_NAME METADATA_LOCKS_CACHE_SIZE
524 VARIABLE_SCOPE GLOBAL
525 -VARIABLE_TYPE BIGINT UNSIGNED
526 +VARIABLE_TYPE INT UNSIGNED
527 VARIABLE_COMMENT Unused
528 NUMERIC_MIN_VALUE 1
529 NUMERIC_MAX_VALUE 1048576
530 @@ -2374,7 +2364,7 @@ READ_ONLY YES
531 COMMAND_LINE_ARGUMENT REQUIRED
532 VARIABLE_NAME METADATA_LOCKS_HASH_INSTANCES
533 VARIABLE_SCOPE GLOBAL
534 -VARIABLE_TYPE BIGINT UNSIGNED
535 +VARIABLE_TYPE INT UNSIGNED
536 VARIABLE_COMMENT Unused
537 NUMERIC_MIN_VALUE 1
538 NUMERIC_MAX_VALUE 1024
539 @@ -2384,7 +2374,7 @@ READ_ONLY YES
540 COMMAND_LINE_ARGUMENT REQUIRED
541 VARIABLE_NAME MIN_EXAMINED_ROW_LIMIT
542 VARIABLE_SCOPE SESSION
543 -VARIABLE_TYPE BIGINT UNSIGNED
544 +VARIABLE_TYPE INT UNSIGNED
545 VARIABLE_COMMENT Alias for log_slow_min_examined_row_limit. Don't write queries to slow log that examine fewer rows than that
546 NUMERIC_MIN_VALUE 0
547 NUMERIC_MAX_VALUE 4294967295
548 @@ -2394,7 +2384,7 @@ READ_ONLY NO
549 COMMAND_LINE_ARGUMENT REQUIRED
550 VARIABLE_NAME MRR_BUFFER_SIZE
551 VARIABLE_SCOPE SESSION
552 -VARIABLE_TYPE BIGINT UNSIGNED
553 +VARIABLE_TYPE INT UNSIGNED
554 VARIABLE_COMMENT Size of buffer to use when using MRR with range access
555 NUMERIC_MIN_VALUE 8192
556 NUMERIC_MAX_VALUE 2147483647
557 @@ -2404,7 +2394,7 @@ READ_ONLY NO
558 COMMAND_LINE_ARGUMENT REQUIRED
559 VARIABLE_NAME MYISAM_BLOCK_SIZE
560 VARIABLE_SCOPE GLOBAL
561 -VARIABLE_TYPE BIGINT UNSIGNED
562 +VARIABLE_TYPE INT UNSIGNED
563 VARIABLE_COMMENT Block size to be used for MyISAM index pages
564 NUMERIC_MIN_VALUE 1024
565 NUMERIC_MAX_VALUE 16384
566 @@ -2414,7 +2404,7 @@ READ_ONLY YES
567 COMMAND_LINE_ARGUMENT REQUIRED
568 VARIABLE_NAME MYISAM_DATA_POINTER_SIZE
569 VARIABLE_SCOPE GLOBAL
570 -VARIABLE_TYPE BIGINT UNSIGNED
571 +VARIABLE_TYPE INT UNSIGNED
572 VARIABLE_COMMENT Default pointer size to be used for MyISAM tables
573 NUMERIC_MIN_VALUE 2
574 NUMERIC_MAX_VALUE 7
575 @@ -2454,10 +2444,10 @@ READ_ONLY YES
576 COMMAND_LINE_ARGUMENT OPTIONAL
577 VARIABLE_NAME MYISAM_REPAIR_THREADS
578 VARIABLE_SCOPE SESSION
579 -VARIABLE_TYPE BIGINT UNSIGNED
580 +VARIABLE_TYPE INT UNSIGNED
581 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
582 NUMERIC_MIN_VALUE 1
583 -NUMERIC_MAX_VALUE 18446744073709551615
584 +NUMERIC_MAX_VALUE 4294967295
585 NUMERIC_BLOCK_SIZE 1
586 ENUM_VALUE_LIST NULL
587 READ_ONLY NO
588 @@ -2502,9 +2492,19 @@ NUMERIC_BLOCK_SIZE NULL
589 ENUM_VALUE_LIST OFF,ON
590 READ_ONLY NO
591 COMMAND_LINE_ARGUMENT OPTIONAL
592 +VARIABLE_NAME NAMED_PIPE
593 +VARIABLE_SCOPE GLOBAL
594 +VARIABLE_TYPE BOOLEAN
595 +VARIABLE_COMMENT Enable the named pipe (NT)
596 +NUMERIC_MIN_VALUE NULL
597 +NUMERIC_MAX_VALUE NULL
598 +NUMERIC_BLOCK_SIZE NULL
599 +ENUM_VALUE_LIST OFF,ON
600 +READ_ONLY YES
601 +COMMAND_LINE_ARGUMENT OPTIONAL
602 VARIABLE_NAME NET_BUFFER_LENGTH
603 VARIABLE_SCOPE SESSION
604 -VARIABLE_TYPE BIGINT UNSIGNED
605 +VARIABLE_TYPE INT UNSIGNED
606 VARIABLE_COMMENT Buffer length for TCP/IP and socket communication
607 NUMERIC_MIN_VALUE 1024
608 NUMERIC_MAX_VALUE 1048576
609 @@ -2514,7 +2514,7 @@ READ_ONLY NO
610 COMMAND_LINE_ARGUMENT REQUIRED
611 VARIABLE_NAME NET_READ_TIMEOUT
612 VARIABLE_SCOPE SESSION
613 -VARIABLE_TYPE BIGINT UNSIGNED
614 +VARIABLE_TYPE INT UNSIGNED
615 VARIABLE_COMMENT Number of seconds to wait for more data from a connection before aborting the read
616 NUMERIC_MIN_VALUE 1
617 NUMERIC_MAX_VALUE 31536000
618 @@ -2524,7 +2524,7 @@ READ_ONLY NO
619 COMMAND_LINE_ARGUMENT REQUIRED
620 VARIABLE_NAME NET_RETRY_COUNT
621 VARIABLE_SCOPE SESSION
622 -VARIABLE_TYPE BIGINT UNSIGNED
623 +VARIABLE_TYPE INT UNSIGNED
624 VARIABLE_COMMENT If a read on a communication port is interrupted, retry this many times before giving up
625 NUMERIC_MIN_VALUE 1
626 NUMERIC_MAX_VALUE 4294967295
627 @@ -2534,7 +2534,7 @@ READ_ONLY NO
628 COMMAND_LINE_ARGUMENT REQUIRED
629 VARIABLE_NAME NET_WRITE_TIMEOUT
630 VARIABLE_SCOPE SESSION
631 -VARIABLE_TYPE BIGINT UNSIGNED
632 +VARIABLE_TYPE INT UNSIGNED
633 VARIABLE_COMMENT Number of seconds to wait for a block to be written to a connection before aborting the write
634 NUMERIC_MIN_VALUE 1
635 NUMERIC_MAX_VALUE 31536000
636 @@ -2584,7 +2584,7 @@ READ_ONLY NO
637 COMMAND_LINE_ARGUMENT OPTIONAL
638 VARIABLE_NAME OPEN_FILES_LIMIT
639 VARIABLE_SCOPE GLOBAL
640 -VARIABLE_TYPE BIGINT UNSIGNED
641 +VARIABLE_TYPE INT UNSIGNED
642 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
643 NUMERIC_MIN_VALUE 0
644 NUMERIC_MAX_VALUE 4294967295
645 @@ -2594,7 +2594,7 @@ READ_ONLY YES
646 COMMAND_LINE_ARGUMENT REQUIRED
647 VARIABLE_NAME OPTIMIZER_ADJUST_SECONDARY_KEY_COSTS
648 VARIABLE_SCOPE SESSION
649 -VARIABLE_TYPE BIGINT UNSIGNED
650 +VARIABLE_TYPE INT UNSIGNED
651 VARIABLE_COMMENT Unused
652 NUMERIC_MIN_VALUE 0
653 NUMERIC_MAX_VALUE 2
654 @@ -2694,7 +2694,7 @@ READ_ONLY NO
655 COMMAND_LINE_ARGUMENT REQUIRED
656 VARIABLE_NAME OPTIMIZER_MAX_SEL_ARGS
657 VARIABLE_SCOPE SESSION
658 -VARIABLE_TYPE BIGINT UNSIGNED
659 +VARIABLE_TYPE INT UNSIGNED
660 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
661 NUMERIC_MIN_VALUE 0
662 NUMERIC_MAX_VALUE 4294967295
663 @@ -2704,7 +2704,7 @@ READ_ONLY NO
664 COMMAND_LINE_ARGUMENT REQUIRED
665 VARIABLE_NAME OPTIMIZER_MAX_SEL_ARG_WEIGHT
666 VARIABLE_SCOPE SESSION
667 -VARIABLE_TYPE BIGINT UNSIGNED
668 +VARIABLE_TYPE INT UNSIGNED
669 VARIABLE_COMMENT The maximum weight of the SEL_ARG graph. Set to 0 for no limit
670 NUMERIC_MIN_VALUE 0
671 NUMERIC_MAX_VALUE 4294967295
672 @@ -2714,7 +2714,7 @@ READ_ONLY NO
673 COMMAND_LINE_ARGUMENT REQUIRED
674 VARIABLE_NAME OPTIMIZER_PRUNE_LEVEL
675 VARIABLE_SCOPE SESSION
676 -VARIABLE_TYPE BIGINT UNSIGNED
677 +VARIABLE_TYPE INT UNSIGNED
678 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
679 NUMERIC_MIN_VALUE 0
680 NUMERIC_MAX_VALUE 2
681 @@ -2784,7 +2784,7 @@ READ_ONLY NO
682 COMMAND_LINE_ARGUMENT REQUIRED
683 VARIABLE_NAME OPTIMIZER_SEARCH_DEPTH
684 VARIABLE_SCOPE SESSION
685 -VARIABLE_TYPE BIGINT UNSIGNED
686 +VARIABLE_TYPE INT UNSIGNED
687 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
688 NUMERIC_MIN_VALUE 0
689 NUMERIC_MAX_VALUE 62
690 @@ -2794,7 +2794,7 @@ READ_ONLY NO
691 COMMAND_LINE_ARGUMENT REQUIRED
692 VARIABLE_NAME OPTIMIZER_SELECTIVITY_SAMPLING_LIMIT
693 VARIABLE_SCOPE SESSION
694 -VARIABLE_TYPE BIGINT UNSIGNED
695 +VARIABLE_TYPE INT UNSIGNED
696 VARIABLE_COMMENT Controls number of record samples to check condition selectivity
697 NUMERIC_MIN_VALUE 10
698 NUMERIC_MAX_VALUE 4294967295
699 @@ -2824,17 +2824,17 @@ READ_ONLY NO
700 COMMAND_LINE_ARGUMENT REQUIRED
701 VARIABLE_NAME OPTIMIZER_TRACE_MAX_MEM_SIZE
702 VARIABLE_SCOPE SESSION
703 -VARIABLE_TYPE BIGINT UNSIGNED
704 +VARIABLE_TYPE INT UNSIGNED
705 VARIABLE_COMMENT Maximum allowed size of an optimizer trace
706 NUMERIC_MIN_VALUE 0
707 -NUMERIC_MAX_VALUE 18446744073709551615
708 +NUMERIC_MAX_VALUE 4294967295
709 NUMERIC_BLOCK_SIZE 1
710 ENUM_VALUE_LIST NULL
711 READ_ONLY NO
712 COMMAND_LINE_ARGUMENT REQUIRED
713 VARIABLE_NAME OPTIMIZER_USE_CONDITION_SELECTIVITY
714 VARIABLE_SCOPE SESSION
715 -VARIABLE_TYPE BIGINT UNSIGNED
716 +VARIABLE_TYPE INT UNSIGNED
717 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
718 NUMERIC_MIN_VALUE 1
719 NUMERIC_MAX_VALUE 5
720 @@ -2864,7 +2864,7 @@ READ_ONLY YES
721 COMMAND_LINE_ARGUMENT OPTIONAL
722 VARIABLE_NAME PERFORMANCE_SCHEMA_ACCOUNTS_SIZE
723 VARIABLE_SCOPE GLOBAL
724 -VARIABLE_TYPE BIGINT
725 +VARIABLE_TYPE INT
726 VARIABLE_COMMENT Maximum number of instrumented user@host accounts. Use 0 to disable, -1 for automated sizing
727 NUMERIC_MIN_VALUE -1
728 NUMERIC_MAX_VALUE 1048576
729 @@ -2874,7 +2874,7 @@ READ_ONLY YES
730 COMMAND_LINE_ARGUMENT REQUIRED
731 VARIABLE_NAME PERFORMANCE_SCHEMA_DIGESTS_SIZE
732 VARIABLE_SCOPE GLOBAL
733 -VARIABLE_TYPE BIGINT
734 +VARIABLE_TYPE INT
735 VARIABLE_COMMENT Size of the statement digest. Use 0 to disable, -1 for automated sizing
736 NUMERIC_MIN_VALUE -1
737 NUMERIC_MAX_VALUE 1048576
738 @@ -2884,7 +2884,7 @@ READ_ONLY YES
739 COMMAND_LINE_ARGUMENT REQUIRED
740 VARIABLE_NAME PERFORMANCE_SCHEMA_EVENTS_STAGES_HISTORY_LONG_SIZE
741 VARIABLE_SCOPE GLOBAL
742 -VARIABLE_TYPE BIGINT
743 +VARIABLE_TYPE INT
744 VARIABLE_COMMENT Number of rows in EVENTS_STAGES_HISTORY_LONG. Use 0 to disable, -1 for automated sizing
745 NUMERIC_MIN_VALUE -1
746 NUMERIC_MAX_VALUE 1048576
747 @@ -2894,7 +2894,7 @@ READ_ONLY YES
748 COMMAND_LINE_ARGUMENT REQUIRED
749 VARIABLE_NAME PERFORMANCE_SCHEMA_EVENTS_STAGES_HISTORY_SIZE
750 VARIABLE_SCOPE GLOBAL
751 -VARIABLE_TYPE BIGINT
752 +VARIABLE_TYPE INT
753 VARIABLE_COMMENT Number of rows per thread in EVENTS_STAGES_HISTORY. Use 0 to disable, -1 for automated sizing
754 NUMERIC_MIN_VALUE -1
755 NUMERIC_MAX_VALUE 1024
756 @@ -2904,7 +2904,7 @@ READ_ONLY YES
757 COMMAND_LINE_ARGUMENT REQUIRED
758 VARIABLE_NAME PERFORMANCE_SCHEMA_EVENTS_STATEMENTS_HISTORY_LONG_SIZE
759 VARIABLE_SCOPE GLOBAL
760 -VARIABLE_TYPE BIGINT
761 +VARIABLE_TYPE INT
762 VARIABLE_COMMENT Number of rows in EVENTS_STATEMENTS_HISTORY_LONG. Use 0 to disable, -1 for automated sizing
763 NUMERIC_MIN_VALUE -1
764 NUMERIC_MAX_VALUE 1048576
765 @@ -2914,7 +2914,7 @@ READ_ONLY YES
766 COMMAND_LINE_ARGUMENT REQUIRED
767 VARIABLE_NAME PERFORMANCE_SCHEMA_EVENTS_STATEMENTS_HISTORY_SIZE
768 VARIABLE_SCOPE GLOBAL
769 -VARIABLE_TYPE BIGINT
770 +VARIABLE_TYPE INT
771 VARIABLE_COMMENT Number of rows per thread in EVENTS_STATEMENTS_HISTORY. Use 0 to disable, -1 for automated sizing
772 NUMERIC_MIN_VALUE -1
773 NUMERIC_MAX_VALUE 1024
774 @@ -2924,7 +2924,7 @@ READ_ONLY YES
775 COMMAND_LINE_ARGUMENT REQUIRED
776 VARIABLE_NAME PERFORMANCE_SCHEMA_EVENTS_TRANSACTIONS_HISTORY_LONG_SIZE
777 VARIABLE_SCOPE GLOBAL
778 -VARIABLE_TYPE BIGINT
779 +VARIABLE_TYPE INT
780 VARIABLE_COMMENT Number of rows in EVENTS_TRANSACTIONS_HISTORY_LONG. Use 0 to disable, -1 for automated sizing
781 NUMERIC_MIN_VALUE -1
782 NUMERIC_MAX_VALUE 1048576
783 @@ -2934,7 +2934,7 @@ READ_ONLY YES
784 COMMAND_LINE_ARGUMENT REQUIRED
785 VARIABLE_NAME PERFORMANCE_SCHEMA_EVENTS_TRANSACTIONS_HISTORY_SIZE
786 VARIABLE_SCOPE GLOBAL
787 -VARIABLE_TYPE BIGINT
788 +VARIABLE_TYPE INT
789 VARIABLE_COMMENT Number of rows per thread in EVENTS_TRANSACTIONS_HISTORY. Use 0 to disable, -1 for automated sizing
790 NUMERIC_MIN_VALUE -1
791 NUMERIC_MAX_VALUE 1024
792 @@ -2944,7 +2944,7 @@ READ_ONLY YES
793 COMMAND_LINE_ARGUMENT REQUIRED
794 VARIABLE_NAME PERFORMANCE_SCHEMA_EVENTS_WAITS_HISTORY_LONG_SIZE
795 VARIABLE_SCOPE GLOBAL
796 -VARIABLE_TYPE BIGINT
797 +VARIABLE_TYPE INT
798 VARIABLE_COMMENT Number of rows in EVENTS_WAITS_HISTORY_LONG. Use 0 to disable, -1 for automated sizing
799 NUMERIC_MIN_VALUE -1
800 NUMERIC_MAX_VALUE 1048576
801 @@ -2954,7 +2954,7 @@ READ_ONLY YES
802 COMMAND_LINE_ARGUMENT REQUIRED
803 VARIABLE_NAME PERFORMANCE_SCHEMA_EVENTS_WAITS_HISTORY_SIZE
804 VARIABLE_SCOPE GLOBAL
805 -VARIABLE_TYPE BIGINT
806 +VARIABLE_TYPE INT
807 VARIABLE_COMMENT Number of rows per thread in EVENTS_WAITS_HISTORY. Use 0 to disable, -1 for automated sizing
808 NUMERIC_MIN_VALUE -1
809 NUMERIC_MAX_VALUE 1024
810 @@ -2964,7 +2964,7 @@ READ_ONLY YES
811 COMMAND_LINE_ARGUMENT REQUIRED
812 VARIABLE_NAME PERFORMANCE_SCHEMA_HOSTS_SIZE
813 VARIABLE_SCOPE GLOBAL
814 -VARIABLE_TYPE BIGINT
815 +VARIABLE_TYPE INT
816 VARIABLE_COMMENT Maximum number of instrumented hosts. Use 0 to disable, -1 for automated sizing
817 NUMERIC_MIN_VALUE -1
818 NUMERIC_MAX_VALUE 1048576
819 @@ -2974,7 +2974,7 @@ READ_ONLY YES
820 COMMAND_LINE_ARGUMENT REQUIRED
821 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_COND_CLASSES
822 VARIABLE_SCOPE GLOBAL
823 -VARIABLE_TYPE BIGINT UNSIGNED
824 +VARIABLE_TYPE INT UNSIGNED
825 VARIABLE_COMMENT Maximum number of condition instruments
826 NUMERIC_MIN_VALUE 0
827 NUMERIC_MAX_VALUE 256
828 @@ -2984,7 +2984,7 @@ READ_ONLY YES
829 COMMAND_LINE_ARGUMENT REQUIRED
830 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_COND_INSTANCES
831 VARIABLE_SCOPE GLOBAL
832 -VARIABLE_TYPE BIGINT
833 +VARIABLE_TYPE INT
834 VARIABLE_COMMENT Maximum number of instrumented condition objects. Use 0 to disable, -1 for automated sizing
835 NUMERIC_MIN_VALUE -1
836 NUMERIC_MAX_VALUE 1048576
837 @@ -2994,7 +2994,7 @@ READ_ONLY YES
838 COMMAND_LINE_ARGUMENT REQUIRED
839 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_DIGEST_LENGTH
840 VARIABLE_SCOPE GLOBAL
841 -VARIABLE_TYPE BIGINT
842 +VARIABLE_TYPE INT
843 VARIABLE_COMMENT Maximum length considered for digest text, when stored in performance_schema tables
844 NUMERIC_MIN_VALUE 0
845 NUMERIC_MAX_VALUE 1048576
846 @@ -3004,7 +3004,7 @@ READ_ONLY YES
847 COMMAND_LINE_ARGUMENT REQUIRED
848 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_FILE_CLASSES
849 VARIABLE_SCOPE GLOBAL
850 -VARIABLE_TYPE BIGINT UNSIGNED
851 +VARIABLE_TYPE INT UNSIGNED
852 VARIABLE_COMMENT Maximum number of file instruments
853 NUMERIC_MIN_VALUE 0
854 NUMERIC_MAX_VALUE 256
855 @@ -3014,7 +3014,7 @@ READ_ONLY YES
856 COMMAND_LINE_ARGUMENT REQUIRED
857 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_FILE_HANDLES
858 VARIABLE_SCOPE GLOBAL
859 -VARIABLE_TYPE BIGINT UNSIGNED
860 +VARIABLE_TYPE INT UNSIGNED
861 VARIABLE_COMMENT Maximum number of opened instrumented files
862 NUMERIC_MIN_VALUE 0
863 NUMERIC_MAX_VALUE 1048576
864 @@ -3024,7 +3024,7 @@ READ_ONLY YES
865 COMMAND_LINE_ARGUMENT REQUIRED
866 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_FILE_INSTANCES
867 VARIABLE_SCOPE GLOBAL
868 -VARIABLE_TYPE BIGINT
869 +VARIABLE_TYPE INT
870 VARIABLE_COMMENT Maximum number of instrumented files. Use 0 to disable, -1 for automated sizing
871 NUMERIC_MIN_VALUE -1
872 NUMERIC_MAX_VALUE 1048576
873 @@ -3034,7 +3034,7 @@ READ_ONLY YES
874 COMMAND_LINE_ARGUMENT REQUIRED
875 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_INDEX_STAT
876 VARIABLE_SCOPE GLOBAL
877 -VARIABLE_TYPE BIGINT
878 +VARIABLE_TYPE INT
879 VARIABLE_COMMENT Maximum number of index statistics for instrumented tables. Use 0 to disable, -1 for automated scaling
880 NUMERIC_MIN_VALUE -1
881 NUMERIC_MAX_VALUE 1048576
882 @@ -3044,7 +3044,7 @@ READ_ONLY YES
883 COMMAND_LINE_ARGUMENT REQUIRED
884 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_MEMORY_CLASSES
885 VARIABLE_SCOPE GLOBAL
886 -VARIABLE_TYPE BIGINT UNSIGNED
887 +VARIABLE_TYPE INT UNSIGNED
888 VARIABLE_COMMENT Maximum number of memory pool instruments
889 NUMERIC_MIN_VALUE 0
890 NUMERIC_MAX_VALUE 1024
891 @@ -3054,7 +3054,7 @@ READ_ONLY YES
892 COMMAND_LINE_ARGUMENT REQUIRED
893 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_METADATA_LOCKS
894 VARIABLE_SCOPE GLOBAL
895 -VARIABLE_TYPE BIGINT
896 +VARIABLE_TYPE INT
897 VARIABLE_COMMENT Maximum number of metadata locks. Use 0 to disable, -1 for automated scaling
898 NUMERIC_MIN_VALUE -1
899 NUMERIC_MAX_VALUE 104857600
900 @@ -3064,7 +3064,7 @@ READ_ONLY YES
901 COMMAND_LINE_ARGUMENT REQUIRED
902 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_MUTEX_CLASSES
903 VARIABLE_SCOPE GLOBAL
904 -VARIABLE_TYPE BIGINT UNSIGNED
905 +VARIABLE_TYPE INT UNSIGNED
906 VARIABLE_COMMENT Maximum number of mutex instruments
907 NUMERIC_MIN_VALUE 0
908 NUMERIC_MAX_VALUE 256
909 @@ -3074,7 +3074,7 @@ READ_ONLY YES
910 COMMAND_LINE_ARGUMENT REQUIRED
911 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_MUTEX_INSTANCES
912 VARIABLE_SCOPE GLOBAL
913 -VARIABLE_TYPE BIGINT
914 +VARIABLE_TYPE INT
915 VARIABLE_COMMENT Maximum number of instrumented MUTEX objects. Use 0 to disable, -1 for automated sizing
916 NUMERIC_MIN_VALUE -1
917 NUMERIC_MAX_VALUE 104857600
918 @@ -3084,7 +3084,7 @@ READ_ONLY YES
919 COMMAND_LINE_ARGUMENT REQUIRED
920 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_PREPARED_STATEMENTS_INSTANCES
921 VARIABLE_SCOPE GLOBAL
922 -VARIABLE_TYPE BIGINT
923 +VARIABLE_TYPE INT
924 VARIABLE_COMMENT Maximum number of instrumented prepared statements. Use 0 to disable, -1 for automated scaling
925 NUMERIC_MIN_VALUE -1
926 NUMERIC_MAX_VALUE 1048576
927 @@ -3094,7 +3094,7 @@ READ_ONLY YES
928 COMMAND_LINE_ARGUMENT REQUIRED
929 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_PROGRAM_INSTANCES
930 VARIABLE_SCOPE GLOBAL
931 -VARIABLE_TYPE BIGINT
932 +VARIABLE_TYPE INT
933 VARIABLE_COMMENT Maximum number of instrumented programs. Use 0 to disable, -1 for automated scaling
934 NUMERIC_MIN_VALUE -1
935 NUMERIC_MAX_VALUE 1048576
936 @@ -3104,7 +3104,7 @@ READ_ONLY YES
937 COMMAND_LINE_ARGUMENT REQUIRED
938 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_RWLOCK_CLASSES
939 VARIABLE_SCOPE GLOBAL
940 -VARIABLE_TYPE BIGINT UNSIGNED
941 +VARIABLE_TYPE INT UNSIGNED
942 VARIABLE_COMMENT Maximum number of rwlock instruments
943 NUMERIC_MIN_VALUE 0
944 NUMERIC_MAX_VALUE 256
945 @@ -3114,7 +3114,7 @@ READ_ONLY YES
946 COMMAND_LINE_ARGUMENT REQUIRED
947 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_RWLOCK_INSTANCES
948 VARIABLE_SCOPE GLOBAL
949 -VARIABLE_TYPE BIGINT
950 +VARIABLE_TYPE INT
951 VARIABLE_COMMENT Maximum number of instrumented RWLOCK objects. Use 0 to disable, -1 for automated sizing
952 NUMERIC_MIN_VALUE -1
953 NUMERIC_MAX_VALUE 104857600
954 @@ -3124,7 +3124,7 @@ READ_ONLY YES
955 COMMAND_LINE_ARGUMENT REQUIRED
956 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_SOCKET_CLASSES
957 VARIABLE_SCOPE GLOBAL
958 -VARIABLE_TYPE BIGINT UNSIGNED
959 +VARIABLE_TYPE INT UNSIGNED
960 VARIABLE_COMMENT Maximum number of socket instruments
961 NUMERIC_MIN_VALUE 0
962 NUMERIC_MAX_VALUE 256
963 @@ -3134,7 +3134,7 @@ READ_ONLY YES
964 COMMAND_LINE_ARGUMENT REQUIRED
965 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_SOCKET_INSTANCES
966 VARIABLE_SCOPE GLOBAL
967 -VARIABLE_TYPE BIGINT
968 +VARIABLE_TYPE INT
969 VARIABLE_COMMENT Maximum number of opened instrumented sockets. Use 0 to disable, -1 for automated sizing
970 NUMERIC_MIN_VALUE -1
971 NUMERIC_MAX_VALUE 1048576
972 @@ -3144,7 +3144,7 @@ READ_ONLY YES
973 COMMAND_LINE_ARGUMENT REQUIRED
974 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_SQL_TEXT_LENGTH
975 VARIABLE_SCOPE GLOBAL
976 -VARIABLE_TYPE BIGINT
977 +VARIABLE_TYPE INT
978 VARIABLE_COMMENT Maximum length of displayed sql text
979 NUMERIC_MIN_VALUE 0
980 NUMERIC_MAX_VALUE 1048576
981 @@ -3154,7 +3154,7 @@ READ_ONLY YES
982 COMMAND_LINE_ARGUMENT REQUIRED
983 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_STAGE_CLASSES
984 VARIABLE_SCOPE GLOBAL
985 -VARIABLE_TYPE BIGINT UNSIGNED
986 +VARIABLE_TYPE INT UNSIGNED
987 VARIABLE_COMMENT Maximum number of stage instruments
988 NUMERIC_MIN_VALUE 0
989 NUMERIC_MAX_VALUE 256
990 @@ -3164,7 +3164,7 @@ READ_ONLY YES
991 COMMAND_LINE_ARGUMENT REQUIRED
992 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_STATEMENT_CLASSES
993 VARIABLE_SCOPE GLOBAL
994 -VARIABLE_TYPE BIGINT UNSIGNED
995 +VARIABLE_TYPE INT UNSIGNED
996 VARIABLE_COMMENT Maximum number of statement instruments
997 NUMERIC_MIN_VALUE 0
998 NUMERIC_MAX_VALUE 256
999 @@ -3174,7 +3174,7 @@ READ_ONLY YES
1000 COMMAND_LINE_ARGUMENT REQUIRED
1001 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_STATEMENT_STACK
1002 VARIABLE_SCOPE GLOBAL
1003 -VARIABLE_TYPE BIGINT UNSIGNED
1004 +VARIABLE_TYPE INT UNSIGNED
1005 VARIABLE_COMMENT Number of rows per thread in EVENTS_STATEMENTS_CURRENT
1006 NUMERIC_MIN_VALUE 1
1007 NUMERIC_MAX_VALUE 256
1008 @@ -3184,7 +3184,7 @@ READ_ONLY YES
1009 COMMAND_LINE_ARGUMENT REQUIRED
1010 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_TABLE_HANDLES
1011 VARIABLE_SCOPE GLOBAL
1012 -VARIABLE_TYPE BIGINT
1013 +VARIABLE_TYPE INT
1014 VARIABLE_COMMENT Maximum number of opened instrumented tables. Use 0 to disable, -1 for automated sizing
1015 NUMERIC_MIN_VALUE -1
1016 NUMERIC_MAX_VALUE 1048576
1017 @@ -3194,7 +3194,7 @@ READ_ONLY YES
1018 COMMAND_LINE_ARGUMENT REQUIRED
1019 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_TABLE_INSTANCES
1020 VARIABLE_SCOPE GLOBAL
1021 -VARIABLE_TYPE BIGINT
1022 +VARIABLE_TYPE INT
1023 VARIABLE_COMMENT Maximum number of instrumented tables. Use 0 to disable, -1 for automated sizing
1024 NUMERIC_MIN_VALUE -1
1025 NUMERIC_MAX_VALUE 1048576
1026 @@ -3204,7 +3204,7 @@ READ_ONLY YES
1027 COMMAND_LINE_ARGUMENT REQUIRED
1028 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_TABLE_LOCK_STAT
1029 VARIABLE_SCOPE GLOBAL
1030 -VARIABLE_TYPE BIGINT
1031 +VARIABLE_TYPE INT
1032 VARIABLE_COMMENT Maximum number of lock statistics for instrumented tables. Use 0 to disable, -1 for automated scaling
1033 NUMERIC_MIN_VALUE -1
1034 NUMERIC_MAX_VALUE 1048576
1035 @@ -3214,7 +3214,7 @@ READ_ONLY YES
1036 COMMAND_LINE_ARGUMENT REQUIRED
1037 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_THREAD_CLASSES
1038 VARIABLE_SCOPE GLOBAL
1039 -VARIABLE_TYPE BIGINT UNSIGNED
1040 +VARIABLE_TYPE INT UNSIGNED
1041 VARIABLE_COMMENT Maximum number of thread instruments
1042 NUMERIC_MIN_VALUE 0
1043 NUMERIC_MAX_VALUE 256
1044 @@ -3224,7 +3224,7 @@ READ_ONLY YES
1045 COMMAND_LINE_ARGUMENT REQUIRED
1046 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_THREAD_INSTANCES
1047 VARIABLE_SCOPE GLOBAL
1048 -VARIABLE_TYPE BIGINT
1049 +VARIABLE_TYPE INT
1050 VARIABLE_COMMENT Maximum number of instrumented threads. Use 0 to disable, -1 for automated sizing
1051 NUMERIC_MIN_VALUE -1
1052 NUMERIC_MAX_VALUE 1048576
1053 @@ -3234,7 +3234,7 @@ READ_ONLY YES
1054 COMMAND_LINE_ARGUMENT REQUIRED
1055 VARIABLE_NAME PERFORMANCE_SCHEMA_SESSION_CONNECT_ATTRS_SIZE
1056 VARIABLE_SCOPE GLOBAL
1057 -VARIABLE_TYPE BIGINT
1058 +VARIABLE_TYPE INT
1059 VARIABLE_COMMENT Size of session attribute string buffer per thread. Use 0 to disable, -1 for automated sizing
1060 NUMERIC_MIN_VALUE -1
1061 NUMERIC_MAX_VALUE 1048576
1062 @@ -3244,7 +3244,7 @@ READ_ONLY YES
1063 COMMAND_LINE_ARGUMENT REQUIRED
1064 VARIABLE_NAME PERFORMANCE_SCHEMA_SETUP_ACTORS_SIZE
1065 VARIABLE_SCOPE GLOBAL
1066 -VARIABLE_TYPE BIGINT
1067 +VARIABLE_TYPE INT
1068 VARIABLE_COMMENT Maximum number of rows in SETUP_ACTORS
1069 NUMERIC_MIN_VALUE -1
1070 NUMERIC_MAX_VALUE 1024
1071 @@ -3254,7 +3254,7 @@ READ_ONLY YES
1072 COMMAND_LINE_ARGUMENT REQUIRED
1073 VARIABLE_NAME PERFORMANCE_SCHEMA_SETUP_OBJECTS_SIZE
1074 VARIABLE_SCOPE GLOBAL
1075 -VARIABLE_TYPE BIGINT
1076 +VARIABLE_TYPE INT
1077 VARIABLE_COMMENT Maximum number of rows in SETUP_OBJECTS
1078 NUMERIC_MIN_VALUE -1
1079 NUMERIC_MAX_VALUE 1048576
1080 @@ -3264,7 +3264,7 @@ READ_ONLY YES
1081 COMMAND_LINE_ARGUMENT REQUIRED
1082 VARIABLE_NAME PERFORMANCE_SCHEMA_USERS_SIZE
1083 VARIABLE_SCOPE GLOBAL
1084 -VARIABLE_TYPE BIGINT
1085 +VARIABLE_TYPE INT
1086 VARIABLE_COMMENT Maximum number of instrumented users. Use 0 to disable, -1 for automated sizing
1087 NUMERIC_MIN_VALUE -1
1088 NUMERIC_MAX_VALUE 1048576
1089 @@ -3314,7 +3314,7 @@ READ_ONLY YES
1090 COMMAND_LINE_ARGUMENT REQUIRED
1091 VARIABLE_NAME PRELOAD_BUFFER_SIZE
1092 VARIABLE_SCOPE SESSION
1093 -VARIABLE_TYPE BIGINT UNSIGNED
1094 +VARIABLE_TYPE INT UNSIGNED
1095 VARIABLE_COMMENT The size of the buffer that is allocated when preloading indexes
1096 NUMERIC_MIN_VALUE 1024
1097 NUMERIC_MAX_VALUE 1073741824
1098 @@ -3334,7 +3334,7 @@ READ_ONLY NO
1099 COMMAND_LINE_ARGUMENT NULL
1100 VARIABLE_NAME PROFILING_HISTORY_SIZE
1101 VARIABLE_SCOPE SESSION
1102 -VARIABLE_TYPE BIGINT UNSIGNED
1103 +VARIABLE_TYPE INT UNSIGNED
1104 VARIABLE_COMMENT Number of statements about which profiling information is maintained. If set to 0, no profiles are stored. See SHOW PROFILES
1105 NUMERIC_MIN_VALUE 0
1106 NUMERIC_MAX_VALUE 100
1107 @@ -3344,7 +3344,7 @@ READ_ONLY NO
1108 COMMAND_LINE_ARGUMENT REQUIRED
1109 VARIABLE_NAME PROGRESS_REPORT_TIME
1110 VARIABLE_SCOPE SESSION
1111 -VARIABLE_TYPE BIGINT UNSIGNED
1112 +VARIABLE_TYPE INT UNSIGNED
1113 VARIABLE_COMMENT Seconds between sending progress reports to the client for time-consuming statements. Set to 0 to disable progress reporting
1114 NUMERIC_MIN_VALUE 0
1115 NUMERIC_MAX_VALUE 4294967295
1116 @@ -3404,7 +3404,7 @@ READ_ONLY NO
1117 COMMAND_LINE_ARGUMENT NULL
1118 VARIABLE_NAME QUERY_ALLOC_BLOCK_SIZE
1119 VARIABLE_SCOPE SESSION
1120 -VARIABLE_TYPE BIGINT UNSIGNED
1121 +VARIABLE_TYPE INT UNSIGNED
1122 VARIABLE_COMMENT Allocation block size for query parsing and execution
1123 NUMERIC_MIN_VALUE 1024
1124 NUMERIC_MAX_VALUE 4294967295
1125 @@ -3414,7 +3414,7 @@ READ_ONLY NO
1126 COMMAND_LINE_ARGUMENT REQUIRED
1127 VARIABLE_NAME QUERY_CACHE_LIMIT
1128 VARIABLE_SCOPE GLOBAL
1129 -VARIABLE_TYPE BIGINT UNSIGNED
1130 +VARIABLE_TYPE INT UNSIGNED
1131 VARIABLE_COMMENT Don't cache results that are bigger than this
1132 NUMERIC_MIN_VALUE 0
1133 NUMERIC_MAX_VALUE 4294967295
1134 @@ -3424,7 +3424,7 @@ READ_ONLY NO
1135 COMMAND_LINE_ARGUMENT REQUIRED
1136 VARIABLE_NAME QUERY_CACHE_MIN_RES_UNIT
1137 VARIABLE_SCOPE GLOBAL
1138 -VARIABLE_TYPE BIGINT UNSIGNED
1139 +VARIABLE_TYPE INT UNSIGNED
1140 VARIABLE_COMMENT The minimum size for blocks allocated by the query cache
1141 NUMERIC_MIN_VALUE 0
1142 NUMERIC_MAX_VALUE 4294967295
1143 @@ -3437,7 +3437,7 @@ VARIABLE_SCOPE GLOBAL
1144 VARIABLE_TYPE BIGINT UNSIGNED
1145 VARIABLE_COMMENT The memory allocated to store results from old queries
1146 NUMERIC_MIN_VALUE 0
1147 -NUMERIC_MAX_VALUE 18446744073709551615
1148 +NUMERIC_MAX_VALUE 4294967295
1149 NUMERIC_BLOCK_SIZE 1024
1150 ENUM_VALUE_LIST NULL
1151 READ_ONLY NO
1152 @@ -3474,7 +3474,7 @@ READ_ONLY NO
1153 COMMAND_LINE_ARGUMENT OPTIONAL
1154 VARIABLE_NAME QUERY_PREALLOC_SIZE
1155 VARIABLE_SCOPE SESSION
1156 -VARIABLE_TYPE BIGINT UNSIGNED
1157 +VARIABLE_TYPE INT UNSIGNED
1158 VARIABLE_COMMENT Persistent buffer for query parsing and execution
1159 NUMERIC_MIN_VALUE 1024
1160 NUMERIC_MAX_VALUE 4294967295
1161 @@ -3487,7 +3487,7 @@ VARIABLE_SCOPE SESSION ONLY
1162 VARIABLE_TYPE BIGINT UNSIGNED
1163 VARIABLE_COMMENT Sets the internal state of the RAND() generator for replication purposes
1164 NUMERIC_MIN_VALUE 0
1165 -NUMERIC_MAX_VALUE 18446744073709551615
1166 +NUMERIC_MAX_VALUE 4294967295
1167 NUMERIC_BLOCK_SIZE 1
1168 ENUM_VALUE_LIST NULL
1169 READ_ONLY NO
1170 @@ -3497,14 +3497,14 @@ VARIABLE_SCOPE SESSION ONLY
1171 VARIABLE_TYPE BIGINT UNSIGNED
1172 VARIABLE_COMMENT Sets the internal state of the RAND() generator for replication purposes
1173 NUMERIC_MIN_VALUE 0
1174 -NUMERIC_MAX_VALUE 18446744073709551615
1175 +NUMERIC_MAX_VALUE 4294967295
1176 NUMERIC_BLOCK_SIZE 1
1177 ENUM_VALUE_LIST NULL
1178 READ_ONLY NO
1179 COMMAND_LINE_ARGUMENT NULL
1180 VARIABLE_NAME RANGE_ALLOC_BLOCK_SIZE
1181 VARIABLE_SCOPE SESSION
1182 -VARIABLE_TYPE BIGINT UNSIGNED
1183 +VARIABLE_TYPE INT UNSIGNED
1184 VARIABLE_COMMENT Allocation block size for storing ranges during optimization
1185 NUMERIC_MIN_VALUE 4096
1186 NUMERIC_MAX_VALUE 4294967295
1187 @@ -3517,14 +3517,14 @@ VARIABLE_SCOPE GLOBAL
1188 VARIABLE_TYPE BIGINT UNSIGNED
1189 VARIABLE_COMMENT Maximum speed(KB/s) to read binlog from master (0 = no limit)
1190 NUMERIC_MIN_VALUE 0
1191 -NUMERIC_MAX_VALUE 18446744073709551615
1192 +NUMERIC_MAX_VALUE 4294967295
1193 NUMERIC_BLOCK_SIZE 1
1194 ENUM_VALUE_LIST NULL
1195 READ_ONLY NO
1196 COMMAND_LINE_ARGUMENT REQUIRED
1197 VARIABLE_NAME READ_BUFFER_SIZE
1198 VARIABLE_SCOPE SESSION
1199 -VARIABLE_TYPE BIGINT UNSIGNED
1200 +VARIABLE_TYPE INT UNSIGNED
1201 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
1202 NUMERIC_MIN_VALUE 8192
1203 NUMERIC_MAX_VALUE 2147483647
1204 @@ -3544,7 +3544,7 @@ READ_ONLY NO
1205 COMMAND_LINE_ARGUMENT OPTIONAL
1206 VARIABLE_NAME READ_RND_BUFFER_SIZE
1207 VARIABLE_SCOPE SESSION
1208 -VARIABLE_TYPE BIGINT UNSIGNED
1209 +VARIABLE_TYPE INT UNSIGNED
1210 VARIABLE_COMMENT When reading rows in sorted order after a sort, the rows are read through this buffer to avoid a disk seeks
1211 NUMERIC_MIN_VALUE 1
1212 NUMERIC_MAX_VALUE 2147483647
1213 @@ -3774,10 +3774,10 @@ READ_ONLY NO
1214 COMMAND_LINE_ARGUMENT OPTIONAL
1215 VARIABLE_NAME ROWID_MERGE_BUFF_SIZE
1216 VARIABLE_SCOPE SESSION
1217 -VARIABLE_TYPE BIGINT UNSIGNED
1218 +VARIABLE_TYPE INT UNSIGNED
1219 VARIABLE_COMMENT The size of the buffers used [NOT] IN evaluation via partial matching
1220 NUMERIC_MIN_VALUE 0
1221 -NUMERIC_MAX_VALUE 9223372036854775807
1222 +NUMERIC_MAX_VALUE 2147483647
1223 NUMERIC_BLOCK_SIZE 1
1224 ENUM_VALUE_LIST NULL
1225 READ_ONLY NO
1226 @@ -3794,20 +3794,20 @@ READ_ONLY NO
1227 COMMAND_LINE_ARGUMENT OPTIONAL
1228 VARIABLE_NAME RPL_SEMI_SYNC_MASTER_TIMEOUT
1229 VARIABLE_SCOPE GLOBAL
1230 -VARIABLE_TYPE BIGINT UNSIGNED
1231 +VARIABLE_TYPE INT UNSIGNED
1232 VARIABLE_COMMENT The timeout value (in ms) for semi-synchronous replication in the master
1233 NUMERIC_MIN_VALUE 0
1234 -NUMERIC_MAX_VALUE 18446744073709551615
1235 +NUMERIC_MAX_VALUE 4294967295
1236 NUMERIC_BLOCK_SIZE 1
1237 ENUM_VALUE_LIST NULL
1238 READ_ONLY NO
1239 COMMAND_LINE_ARGUMENT REQUIRED
1240 VARIABLE_NAME RPL_SEMI_SYNC_MASTER_TRACE_LEVEL
1241 VARIABLE_SCOPE GLOBAL
1242 -VARIABLE_TYPE BIGINT UNSIGNED
1243 +VARIABLE_TYPE INT UNSIGNED
1244 VARIABLE_COMMENT The tracing level for semi-sync replication
1245 NUMERIC_MIN_VALUE 0
1246 -NUMERIC_MAX_VALUE 18446744073709551615
1247 +NUMERIC_MAX_VALUE 4294967295
1248 NUMERIC_BLOCK_SIZE 1
1249 ENUM_VALUE_LIST NULL
1250 READ_ONLY NO
1251 @@ -3864,10 +3864,10 @@ READ_ONLY NO
1252 COMMAND_LINE_ARGUMENT OPTIONAL
1253 VARIABLE_NAME RPL_SEMI_SYNC_SLAVE_TRACE_LEVEL
1254 VARIABLE_SCOPE GLOBAL
1255 -VARIABLE_TYPE BIGINT UNSIGNED
1256 +VARIABLE_TYPE INT UNSIGNED
1257 VARIABLE_COMMENT The tracing level for semi-sync replication
1258 NUMERIC_MIN_VALUE 0
1259 -NUMERIC_MAX_VALUE 18446744073709551615
1260 +NUMERIC_MAX_VALUE 4294967295
1261 NUMERIC_BLOCK_SIZE 1
1262 ENUM_VALUE_LIST NULL
1263 READ_ONLY NO
1264 @@ -3904,7 +3904,7 @@ READ_ONLY YES
1265 COMMAND_LINE_ARGUMENT REQUIRED
1266 VARIABLE_NAME SERVER_ID
1267 VARIABLE_SCOPE SESSION
1268 -VARIABLE_TYPE BIGINT UNSIGNED
1269 +VARIABLE_TYPE INT UNSIGNED
1270 VARIABLE_COMMENT Uniquely identifies the server instance in the community of replication partners
1271 NUMERIC_MIN_VALUE 1
1272 NUMERIC_MAX_VALUE 4294967295
1273 @@ -4074,7 +4074,7 @@ READ_ONLY NO
1274 COMMAND_LINE_ARGUMENT REQUIRED
1275 VARIABLE_NAME SLAVE_DOMAIN_PARALLEL_THREADS
1276 VARIABLE_SCOPE GLOBAL
1277 -VARIABLE_TYPE BIGINT UNSIGNED
1278 +VARIABLE_TYPE INT UNSIGNED
1279 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
1280 NUMERIC_MIN_VALUE 0
1281 NUMERIC_MAX_VALUE 16383
1282 @@ -4104,7 +4104,7 @@ READ_ONLY YES
1283 COMMAND_LINE_ARGUMENT REQUIRED
1284 VARIABLE_NAME SLAVE_MAX_ALLOWED_PACKET
1285 VARIABLE_SCOPE GLOBAL
1286 -VARIABLE_TYPE BIGINT UNSIGNED
1287 +VARIABLE_TYPE INT UNSIGNED
1288 VARIABLE_COMMENT The maximum packet length to sent successfully from the master to slave
1289 NUMERIC_MIN_VALUE 1024
1290 NUMERIC_MAX_VALUE 1073741824
1291 @@ -4134,7 +4134,7 @@ READ_ONLY NO
1292 COMMAND_LINE_ARGUMENT REQUIRED
1293 VARIABLE_NAME SLAVE_PARALLEL_MAX_QUEUED
1294 VARIABLE_SCOPE GLOBAL
1295 -VARIABLE_TYPE BIGINT UNSIGNED
1296 +VARIABLE_TYPE INT UNSIGNED
1297 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
1298 NUMERIC_MIN_VALUE 0
1299 NUMERIC_MAX_VALUE 2147483647
1300 @@ -4154,7 +4154,7 @@ READ_ONLY NO
1301 COMMAND_LINE_ARGUMENT NULL
1302 VARIABLE_NAME SLAVE_PARALLEL_THREADS
1303 VARIABLE_SCOPE GLOBAL
1304 -VARIABLE_TYPE BIGINT UNSIGNED
1305 +VARIABLE_TYPE INT UNSIGNED
1306 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
1307 NUMERIC_MIN_VALUE 0
1308 NUMERIC_MAX_VALUE 16383
1309 @@ -4164,7 +4164,7 @@ READ_ONLY NO
1310 COMMAND_LINE_ARGUMENT REQUIRED
1311 VARIABLE_NAME SLAVE_PARALLEL_WORKERS
1312 VARIABLE_SCOPE GLOBAL
1313 -VARIABLE_TYPE BIGINT UNSIGNED
1314 +VARIABLE_TYPE INT UNSIGNED
1315 VARIABLE_COMMENT Alias for slave_parallel_threads
1316 NUMERIC_MIN_VALUE 0
1317 NUMERIC_MAX_VALUE 16383
1318 @@ -4204,7 +4204,7 @@ READ_ONLY NO
1319 COMMAND_LINE_ARGUMENT OPTIONAL
1320 VARIABLE_NAME SLAVE_TRANSACTION_RETRIES
1321 VARIABLE_SCOPE GLOBAL
1322 -VARIABLE_TYPE BIGINT UNSIGNED
1323 +VARIABLE_TYPE INT UNSIGNED
1324 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
1325 NUMERIC_MIN_VALUE 0
1326 NUMERIC_MAX_VALUE 4294967295
1327 @@ -4224,7 +4224,7 @@ READ_ONLY YES
1328 COMMAND_LINE_ARGUMENT REQUIRED
1329 VARIABLE_NAME SLAVE_TRANSACTION_RETRY_INTERVAL
1330 VARIABLE_SCOPE GLOBAL
1331 -VARIABLE_TYPE BIGINT UNSIGNED
1332 +VARIABLE_TYPE INT UNSIGNED
1333 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
1334 NUMERIC_MIN_VALUE 0
1335 NUMERIC_MAX_VALUE 3600
1336 @@ -4244,7 +4244,7 @@ READ_ONLY NO
1337 COMMAND_LINE_ARGUMENT REQUIRED
1338 VARIABLE_NAME SLOW_LAUNCH_TIME
1339 VARIABLE_SCOPE GLOBAL
1340 -VARIABLE_TYPE BIGINT UNSIGNED
1341 +VARIABLE_TYPE INT UNSIGNED
1342 VARIABLE_COMMENT If creating the thread takes longer than this value (in seconds), the Slow_launch_threads counter will be incremented
1343 NUMERIC_MIN_VALUE 0
1344 NUMERIC_MAX_VALUE 31536000
1345 @@ -4514,7 +4514,7 @@ READ_ONLY NO
1346 COMMAND_LINE_ARGUMENT NULL
1347 VARIABLE_NAME STORED_PROGRAM_CACHE
1348 VARIABLE_SCOPE GLOBAL
1349 -VARIABLE_TYPE BIGINT UNSIGNED
1350 +VARIABLE_TYPE INT UNSIGNED
1351 VARIABLE_COMMENT The soft upper limit for number of cached stored routines for one connection
1352 NUMERIC_MIN_VALUE 0
1353 NUMERIC_MAX_VALUE 524288
1354 @@ -4624,7 +4624,7 @@ READ_ONLY NO
1355 COMMAND_LINE_ARGUMENT OPTIONAL
1356 VARIABLE_NAME TABLE_DEFINITION_CACHE
1357 VARIABLE_SCOPE GLOBAL
1358 -VARIABLE_TYPE BIGINT UNSIGNED
1359 +VARIABLE_TYPE INT UNSIGNED
1360 VARIABLE_COMMENT The number of cached table definitions
1361 NUMERIC_MIN_VALUE 400
1362 NUMERIC_MAX_VALUE 2097152
1363 @@ -4634,7 +4634,7 @@ READ_ONLY NO
1364 COMMAND_LINE_ARGUMENT REQUIRED
1365 VARIABLE_NAME TABLE_OPEN_CACHE
1366 VARIABLE_SCOPE GLOBAL
1367 -VARIABLE_TYPE BIGINT UNSIGNED
1368 +VARIABLE_TYPE INT UNSIGNED
1369 VARIABLE_COMMENT The number of cached open tables
1370 NUMERIC_MIN_VALUE 10
1371 NUMERIC_MAX_VALUE 1048576
1372 @@ -4694,7 +4694,7 @@ READ_ONLY NO
1373 COMMAND_LINE_ARGUMENT OPTIONAL
1374 VARIABLE_NAME THREAD_CACHE_SIZE
1375 VARIABLE_SCOPE GLOBAL
1376 -VARIABLE_TYPE BIGINT UNSIGNED
1377 +VARIABLE_TYPE INT UNSIGNED
1378 VARIABLE_COMMENT How many threads we should keep in a cache for reuse. These are freed after 5 minutes of idle time
1379 NUMERIC_MIN_VALUE 0
1380 NUMERIC_MAX_VALUE 16384
1381 @@ -4752,6 +4752,26 @@ NUMERIC_BLOCK_SIZE 1
1382 ENUM_VALUE_LIST NULL
1383 READ_ONLY NO
1384 COMMAND_LINE_ARGUMENT REQUIRED
1385 +VARIABLE_NAME THREAD_POOL_MIN_THREADS
1386 +VARIABLE_SCOPE GLOBAL
1387 +VARIABLE_TYPE INT UNSIGNED
1388 +VARIABLE_COMMENT Minimum number of threads in the thread pool
1389 +NUMERIC_MIN_VALUE 1
1390 +NUMERIC_MAX_VALUE 256
1391 +NUMERIC_BLOCK_SIZE 1
1392 +ENUM_VALUE_LIST NULL
1393 +READ_ONLY NO
1394 +COMMAND_LINE_ARGUMENT REQUIRED
1395 +VARIABLE_NAME THREAD_POOL_MODE
1396 +VARIABLE_SCOPE GLOBAL
1397 +VARIABLE_TYPE ENUM
1398 +VARIABLE_COMMENT Chose implementation of the threadpool
1399 +NUMERIC_MIN_VALUE NULL
1400 +NUMERIC_MAX_VALUE NULL
1401 +NUMERIC_BLOCK_SIZE NULL
1402 +ENUM_VALUE_LIST windows,generic
1403 +READ_ONLY YES
1404 +COMMAND_LINE_ARGUMENT REQUIRED
1405 VARIABLE_NAME THREAD_POOL_OVERSUBSCRIBE
1406 VARIABLE_SCOPE GLOBAL
1407 VARIABLE_TYPE INT UNSIGNED
1408 @@ -4835,7 +4855,7 @@ COMMAND_LINE_ARGUMENT REQUIRED
1409 VARIABLE_NAME TMPDIR
1410 VARIABLE_SCOPE GLOBAL
1411 VARIABLE_TYPE VARCHAR
1412 -VARIABLE_COMMENT Path for temporary files. Files that are created in background for binlogging by user threads are placed in a separate location (see `binlog_large_commit_threshold` option). Several paths may be specified, separated by a colon (:), in this case they are used in a round-robin fashion
1413 +VARIABLE_COMMENT Path for temporary files. Files that are created in background for binlogging by user threads are placed in a separate location (see `binlog_large_commit_threshold` option). Several paths may be specified, separated by a semicolon (;), in this case they are used in a round-robin fashion
1414 NUMERIC_MIN_VALUE NULL
1415 NUMERIC_MAX_VALUE NULL
1416 NUMERIC_BLOCK_SIZE NULL
1417 @@ -4874,7 +4894,7 @@ READ_ONLY NO
1418 COMMAND_LINE_ARGUMENT REQUIRED
1419 VARIABLE_NAME TRANSACTION_ALLOC_BLOCK_SIZE
1420 VARIABLE_SCOPE SESSION
1421 -VARIABLE_TYPE BIGINT UNSIGNED
1422 +VARIABLE_TYPE INT UNSIGNED
1423 VARIABLE_COMMENT Allocation block size for transactions to be stored in binary log
1424 NUMERIC_MIN_VALUE 1024
1425 NUMERIC_MAX_VALUE 134217728
1426 @@ -4894,7 +4914,7 @@ READ_ONLY NO
1427 COMMAND_LINE_ARGUMENT NULL
1428 VARIABLE_NAME TRANSACTION_PREALLOC_SIZE
1429 VARIABLE_SCOPE SESSION
1430 -VARIABLE_TYPE BIGINT UNSIGNED
1431 +VARIABLE_TYPE INT UNSIGNED
1432 VARIABLE_COMMENT Persistent buffer for transactions to be stored in binary log
1433 NUMERIC_MIN_VALUE 1024
1434 NUMERIC_MAX_VALUE 134217728
1435 @@ -5044,10 +5064,10 @@ READ_ONLY YES
1436 COMMAND_LINE_ARGUMENT NULL
1437 VARIABLE_NAME WAIT_TIMEOUT
1438 VARIABLE_SCOPE SESSION
1439 -VARIABLE_TYPE BIGINT UNSIGNED
1440 +VARIABLE_TYPE INT UNSIGNED
1441 VARIABLE_COMMENT The number of seconds the server waits for activity on a connection before closing it
1442 NUMERIC_MIN_VALUE 1
1443 -NUMERIC_MAX_VALUE 31536000
1444 +NUMERIC_MAX_VALUE 2147483
1445 NUMERIC_BLOCK_SIZE 1
1446 ENUM_VALUE_LIST NULL
1447 READ_ONLY NO
1448 @@ -5071,7 +5091,7 @@ order by variable_name;
1449 VARIABLE_NAME LOG_TC_SIZE
1450 GLOBAL_VALUE_ORIGIN AUTO
1451 VARIABLE_SCOPE GLOBAL
1452 -VARIABLE_TYPE BIGINT UNSIGNED
1453 +VARIABLE_TYPE INT UNSIGNED
1454 VARIABLE_COMMENT Size of transaction coordinator log
1455 ENUM_VALUE_LIST NULL
1456 READ_ONLY YES