1--- sysvars_server_notembedded.result 2019-09-02 17:27:55.739188565 +0300 2+++ sysvars_server_notembedded.reject 2019-09-02 17:55:08.525327501 +0300 3@@ -25,7 +25,7 @@ 4 COMMAND_LINE_ARGUMENT OPTIONAL 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 1024 11 NUMERIC_MAX_VALUE 32768 12@@ -35,7 +35,7 @@ 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@@ -45,7 +45,7 @@ 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@@ -65,7 +65,7 @@ 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@@ -85,7 +85,7 @@ 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 commite in microseconds (1/1000000c). 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@@ -95,7 +95,7 @@ 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@@ -125,10 +125,10 @@ 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@@ -145,7 +145,7 @@ 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@@ -155,7 +155,7 @@ 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@@ -185,7 +185,7 @@ 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@@ -198,7 +198,7 @@ 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 4096 101-NUMERIC_MAX_VALUE 18446744073709551615 102+NUMERIC_MAX_VALUE 4294967295 103 NUMERIC_BLOCK_SIZE 1 104 ENUM_VALUE_LIST NULL 105 READ_ONLY NO 106@@ -255,7 +255,7 @@ 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@@ -265,7 +265,7 @@ 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@@ -275,7 +275,7 @@ 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 very many connection requests in a very short time 131 NUMERIC_MIN_VALUE 0 132 NUMERIC_MAX_VALUE 65535 133@@ -328,7 +328,7 @@ 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@@ -345,20 +345,20 @@ 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@@ -378,7 +378,7 @@ 168 VARIABLE_TYPE BIGINT UNSIGNED 169 VARIABLE_COMMENT The size of file cache for the binary log 170 NUMERIC_MIN_VALUE 8192 171-NUMERIC_MAX_VALUE 18446744073709551615 172+NUMERIC_MAX_VALUE 4294967295 173 NUMERIC_BLOCK_SIZE 4096 174 ENUM_VALUE_LIST NULL 175 READ_ONLY NO 176@@ -418,7 +418,7 @@ 177 VARIABLE_TYPE BIGINT UNSIGNED 178 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. 179 NUMERIC_MIN_VALUE 4096 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@@ -428,7 +428,7 @@ 186 VARIABLE_TYPE BIGINT UNSIGNED 187 VARIABLE_COMMENT Size of tree cache used in bulk insert optimisation. Note that this is a limit per thread! 188 NUMERIC_MIN_VALUE 0 189-NUMERIC_MAX_VALUE 18446744073709551615 190+NUMERIC_MAX_VALUE 4294967295 191 NUMERIC_BLOCK_SIZE 1 192 ENUM_VALUE_LIST NULL 193 READ_ONLY NO 194@@ -615,7 +615,7 @@ 195 COMMAND_LINE_ARGUMENT OPTIONAL 196 VARIABLE_NAME CONNECT_TIMEOUT 197 VARIABLE_SCOPE GLOBAL 198-VARIABLE_TYPE BIGINT UNSIGNED 199+VARIABLE_TYPE INT UNSIGNED 200 VARIABLE_COMMENT The number of seconds the mysqld server is waiting for a connect packet before responding with 'Bad handshake' 201 NUMERIC_MIN_VALUE 2 202 NUMERIC_MAX_VALUE 31536000 203@@ -665,7 +665,7 @@ 204 COMMAND_LINE_ARGUMENT REQUIRED 205 VARIABLE_NAME DEADLOCK_SEARCH_DEPTH_LONG 206 VARIABLE_SCOPE SESSION 207-VARIABLE_TYPE BIGINT UNSIGNED 208+VARIABLE_TYPE INT UNSIGNED 209 VARIABLE_COMMENT Long search depth for the two-step deadlock detection 210 NUMERIC_MIN_VALUE 0 211 NUMERIC_MAX_VALUE 33 212@@ -675,7 +675,7 @@ 213 COMMAND_LINE_ARGUMENT REQUIRED 214 VARIABLE_NAME DEADLOCK_SEARCH_DEPTH_SHORT 215 VARIABLE_SCOPE SESSION 216-VARIABLE_TYPE BIGINT UNSIGNED 217+VARIABLE_TYPE INT UNSIGNED 218 VARIABLE_COMMENT Short search depth for the two-step deadlock detection 219 NUMERIC_MIN_VALUE 0 220 NUMERIC_MAX_VALUE 32 221@@ -685,7 +685,7 @@ 222 COMMAND_LINE_ARGUMENT REQUIRED 223 VARIABLE_NAME DEADLOCK_TIMEOUT_LONG 224 VARIABLE_SCOPE SESSION 225-VARIABLE_TYPE BIGINT UNSIGNED 226+VARIABLE_TYPE INT UNSIGNED 227 VARIABLE_COMMENT Long timeout for the two-step deadlock detection (in microseconds) 228 NUMERIC_MIN_VALUE 0 229 NUMERIC_MAX_VALUE 4294967295 230@@ -695,7 +695,7 @@ 231 COMMAND_LINE_ARGUMENT REQUIRED 232 VARIABLE_NAME DEADLOCK_TIMEOUT_SHORT 233 VARIABLE_SCOPE SESSION 234-VARIABLE_TYPE BIGINT UNSIGNED 235+VARIABLE_TYPE INT UNSIGNED 236 VARIABLE_COMMENT Short timeout for the two-step deadlock detection (in microseconds) 237 NUMERIC_MIN_VALUE 0 238 NUMERIC_MAX_VALUE 4294967295 239@@ -745,7 +745,7 @@ 240 COMMAND_LINE_ARGUMENT NULL 241 VARIABLE_NAME DEFAULT_WEEK_FORMAT 242 VARIABLE_SCOPE SESSION 243-VARIABLE_TYPE BIGINT UNSIGNED 244+VARIABLE_TYPE INT UNSIGNED 245 VARIABLE_COMMENT The default week format used by WEEK() functions 246 NUMERIC_MIN_VALUE 0 247 NUMERIC_MAX_VALUE 7 248@@ -755,7 +755,7 @@ 249 COMMAND_LINE_ARGUMENT REQUIRED 250 VARIABLE_NAME DELAYED_INSERT_LIMIT 251 VARIABLE_SCOPE GLOBAL 252-VARIABLE_TYPE BIGINT UNSIGNED 253+VARIABLE_TYPE INT UNSIGNED 254 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. 255 NUMERIC_MIN_VALUE 1 256 NUMERIC_MAX_VALUE 4294967295 257@@ -765,7 +765,7 @@ 258 COMMAND_LINE_ARGUMENT REQUIRED 259 VARIABLE_NAME DELAYED_INSERT_TIMEOUT 260 VARIABLE_SCOPE GLOBAL 261-VARIABLE_TYPE BIGINT UNSIGNED 262+VARIABLE_TYPE INT UNSIGNED 263 VARIABLE_COMMENT How long a INSERT DELAYED thread should wait for INSERT statements before terminating 264 NUMERIC_MIN_VALUE 1 265 NUMERIC_MAX_VALUE 31536000 266@@ -775,7 +775,7 @@ 267 COMMAND_LINE_ARGUMENT REQUIRED 268 VARIABLE_NAME DELAYED_QUEUE_SIZE 269 VARIABLE_SCOPE GLOBAL 270-VARIABLE_TYPE BIGINT UNSIGNED 271+VARIABLE_TYPE INT UNSIGNED 272 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 273 NUMERIC_MIN_VALUE 1 274 NUMERIC_MAX_VALUE 4294967295 275@@ -795,7 +795,7 @@ 276 COMMAND_LINE_ARGUMENT OPTIONAL 277 VARIABLE_NAME DIV_PRECISION_INCREMENT 278 VARIABLE_SCOPE SESSION 279-VARIABLE_TYPE BIGINT UNSIGNED 280+VARIABLE_TYPE INT UNSIGNED 281 VARIABLE_COMMENT Precision of the result of '/' operator will be increased on that value 282 NUMERIC_MIN_VALUE 0 283 NUMERIC_MAX_VALUE 38 284@@ -885,7 +885,7 @@ 285 COMMAND_LINE_ARGUMENT REQUIRED 286 VARIABLE_NAME EXPIRE_LOGS_DAYS 287 VARIABLE_SCOPE GLOBAL 288-VARIABLE_TYPE BIGINT UNSIGNED 289+VARIABLE_TYPE INT UNSIGNED 290 VARIABLE_COMMENT If non-zero, binary logs will be purged after expire_logs_days days; possible purges happen at startup and at binary log rotation 291 NUMERIC_MIN_VALUE 0 292 NUMERIC_MAX_VALUE 99 293@@ -915,7 +915,7 @@ 294 COMMAND_LINE_ARGUMENT NULL 295 VARIABLE_NAME EXTRA_MAX_CONNECTIONS 296 VARIABLE_SCOPE GLOBAL 297-VARIABLE_TYPE BIGINT UNSIGNED 298+VARIABLE_TYPE INT UNSIGNED 299 VARIABLE_COMMENT The number of connections on extra-port 300 NUMERIC_MIN_VALUE 1 301 NUMERIC_MAX_VALUE 100000 302@@ -945,7 +945,7 @@ 303 COMMAND_LINE_ARGUMENT OPTIONAL 304 VARIABLE_NAME FLUSH_TIME 305 VARIABLE_SCOPE GLOBAL 306-VARIABLE_TYPE BIGINT UNSIGNED 307+VARIABLE_TYPE INT UNSIGNED 308 VARIABLE_COMMENT A dedicated thread is created to flush all tables at the given interval 309 NUMERIC_MIN_VALUE 0 310 NUMERIC_MAX_VALUE 31536000 311@@ -975,7 +975,7 @@ 312 COMMAND_LINE_ARGUMENT REQUIRED 313 VARIABLE_NAME FT_MAX_WORD_LEN 314 VARIABLE_SCOPE GLOBAL 315-VARIABLE_TYPE BIGINT UNSIGNED 316+VARIABLE_TYPE INT UNSIGNED 317 VARIABLE_COMMENT The maximum length of the word to be included in a FULLTEXT index. Note: FULLTEXT indexes must be rebuilt after changing this variable 318 NUMERIC_MIN_VALUE 10 319 NUMERIC_MAX_VALUE 84 320@@ -985,7 +985,7 @@ 321 COMMAND_LINE_ARGUMENT REQUIRED 322 VARIABLE_NAME FT_MIN_WORD_LEN 323 VARIABLE_SCOPE GLOBAL 324-VARIABLE_TYPE BIGINT UNSIGNED 325+VARIABLE_TYPE INT UNSIGNED 326 VARIABLE_COMMENT The minimum length of the word to be included in a FULLTEXT index. Note: FULLTEXT indexes must be rebuilt after changing this variable 327 NUMERIC_MIN_VALUE 1 328 NUMERIC_MAX_VALUE 84 329@@ -995,7 +995,7 @@ 330 COMMAND_LINE_ARGUMENT REQUIRED 331 VARIABLE_NAME FT_QUERY_EXPANSION_LIMIT 332 VARIABLE_SCOPE GLOBAL 333-VARIABLE_TYPE BIGINT UNSIGNED 334+VARIABLE_TYPE INT UNSIGNED 335 VARIABLE_COMMENT Number of best matches to use for query expansion 336 NUMERIC_MIN_VALUE 0 337 NUMERIC_MAX_VALUE 1000 338@@ -1038,7 +1038,7 @@ 339 VARIABLE_TYPE BIGINT UNSIGNED 340 VARIABLE_COMMENT The maximum length of the result of function GROUP_CONCAT() 341 NUMERIC_MIN_VALUE 4 342-NUMERIC_MAX_VALUE 18446744073709551615 343+NUMERIC_MAX_VALUE 4294967295 344 NUMERIC_BLOCK_SIZE 1 345 ENUM_VALUE_LIST NULL 346 READ_ONLY NO 347@@ -1235,7 +1235,7 @@ 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@@ -1265,7 +1265,7 @@ 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@@ -1375,7 +1375,7 @@ 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@@ -1398,7 +1398,7 @@ 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@@ -1415,7 +1415,7 @@ 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@@ -1438,7 +1438,7 @@ 393 VARIABLE_TYPE BIGINT UNSIGNED 394 VARIABLE_COMMENT The size of the buffer used for index blocks for MyISAM tables. Increase this to get better index handling (for all reads and multiple writes) to as much as you can afford 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@@ -1605,7 +1605,7 @@ 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@@ -1755,7 +1755,7 @@ 411 COMMAND_LINE_ARGUMENT REQUIRED 412 VARIABLE_NAME LOG_SLOW_RATE_LIMIT 413 VARIABLE_SCOPE SESSION 414-VARIABLE_TYPE BIGINT UNSIGNED 415+VARIABLE_TYPE INT UNSIGNED 416 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 417 NUMERIC_MIN_VALUE 1 418 NUMERIC_MAX_VALUE 4294967295 419@@ -1785,7 +1785,7 @@ 420 COMMAND_LINE_ARGUMENT REQUIRED 421 VARIABLE_NAME LOG_WARNINGS 422 VARIABLE_SCOPE SESSION 423-VARIABLE_TYPE BIGINT UNSIGNED 424+VARIABLE_TYPE INT UNSIGNED 425 VARIABLE_COMMENT Log some not critical warnings to the general log file.Value can be between 0 and 11. Higher values mean more verbosity 426 NUMERIC_MIN_VALUE 0 427 NUMERIC_MAX_VALUE 4294967295 428@@ -1845,7 +1845,7 @@ 429 COMMAND_LINE_ARGUMENT OPTIONAL 430 VARIABLE_NAME MAX_ALLOWED_PACKET 431 VARIABLE_SCOPE SESSION 432-VARIABLE_TYPE BIGINT UNSIGNED 433+VARIABLE_TYPE INT UNSIGNED 434 VARIABLE_COMMENT Max packet length to send to or receive from the server 435 NUMERIC_MIN_VALUE 1024 436 NUMERIC_MAX_VALUE 1073741824 437@@ -1858,14 +1858,14 @@ 438 VARIABLE_TYPE BIGINT UNSIGNED 439 VARIABLE_COMMENT Sets the total size of the transactional cache 440 NUMERIC_MIN_VALUE 4096 441-NUMERIC_MAX_VALUE 18446744073709551615 442+NUMERIC_MAX_VALUE 4294967295 443 NUMERIC_BLOCK_SIZE 4096 444 ENUM_VALUE_LIST NULL 445 READ_ONLY NO 446 COMMAND_LINE_ARGUMENT REQUIRED 447 VARIABLE_NAME MAX_BINLOG_SIZE 448 VARIABLE_SCOPE GLOBAL 449-VARIABLE_TYPE BIGINT UNSIGNED 450+VARIABLE_TYPE INT UNSIGNED 451 VARIABLE_COMMENT Binary log will be rotated automatically when the size exceeds this value. 452 NUMERIC_MIN_VALUE 4096 453 NUMERIC_MAX_VALUE 1073741824 454@@ -1878,14 +1878,14 @@ 455 VARIABLE_TYPE BIGINT UNSIGNED 456 VARIABLE_COMMENT Sets the total size of the statement cache 457 NUMERIC_MIN_VALUE 4096 458-NUMERIC_MAX_VALUE 18446744073709551615 459+NUMERIC_MAX_VALUE 4294967295 460 NUMERIC_BLOCK_SIZE 4096 461 ENUM_VALUE_LIST NULL 462 READ_ONLY NO 463 COMMAND_LINE_ARGUMENT REQUIRED 464 VARIABLE_NAME MAX_CONNECTIONS 465 VARIABLE_SCOPE GLOBAL 466-VARIABLE_TYPE BIGINT UNSIGNED 467+VARIABLE_TYPE INT UNSIGNED 468 VARIABLE_COMMENT The number of simultaneous clients allowed 469 NUMERIC_MIN_VALUE 10 470 NUMERIC_MAX_VALUE 100000 471@@ -1895,7 +1895,7 @@ 472 COMMAND_LINE_ARGUMENT REQUIRED 473 VARIABLE_NAME MAX_CONNECT_ERRORS 474 VARIABLE_SCOPE GLOBAL 475-VARIABLE_TYPE BIGINT UNSIGNED 476+VARIABLE_TYPE INT UNSIGNED 477 VARIABLE_COMMENT If there is more than this number of interrupted connections from a host this host will be blocked from further connections 478 NUMERIC_MIN_VALUE 1 479 NUMERIC_MAX_VALUE 4294967295 480@@ -1905,7 +1905,7 @@ 481 COMMAND_LINE_ARGUMENT REQUIRED 482 VARIABLE_NAME MAX_DELAYED_THREADS 483 VARIABLE_SCOPE SESSION 484-VARIABLE_TYPE BIGINT UNSIGNED 485+VARIABLE_TYPE INT UNSIGNED 486 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 487 NUMERIC_MIN_VALUE 0 488 NUMERIC_MAX_VALUE 16384 489@@ -1925,7 +1925,7 @@ 490 COMMAND_LINE_ARGUMENT REQUIRED 491 VARIABLE_NAME MAX_ERROR_COUNT 492 VARIABLE_SCOPE SESSION 493-VARIABLE_TYPE BIGINT UNSIGNED 494+VARIABLE_TYPE INT UNSIGNED 495 VARIABLE_COMMENT Max number of errors/warnings to store for a statement 496 NUMERIC_MIN_VALUE 0 497 NUMERIC_MAX_VALUE 65535 498@@ -1938,14 +1938,14 @@ 499 VARIABLE_TYPE BIGINT UNSIGNED 500 VARIABLE_COMMENT Don't allow creation of heap tables bigger than this 501 NUMERIC_MIN_VALUE 16384 502-NUMERIC_MAX_VALUE 18446744073709551615 503+NUMERIC_MAX_VALUE 4294967295 504 NUMERIC_BLOCK_SIZE 1024 505 ENUM_VALUE_LIST NULL 506 READ_ONLY NO 507 COMMAND_LINE_ARGUMENT REQUIRED 508 VARIABLE_NAME MAX_INSERT_DELAYED_THREADS 509 VARIABLE_SCOPE SESSION 510-VARIABLE_TYPE BIGINT UNSIGNED 511+VARIABLE_TYPE INT UNSIGNED 512 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 513 NUMERIC_MIN_VALUE 0 514 NUMERIC_MAX_VALUE 16384 515@@ -1965,7 +1965,7 @@ 516 COMMAND_LINE_ARGUMENT REQUIRED 517 VARIABLE_NAME MAX_LENGTH_FOR_SORT_DATA 518 VARIABLE_SCOPE SESSION 519-VARIABLE_TYPE BIGINT UNSIGNED 520+VARIABLE_TYPE INT UNSIGNED 521 VARIABLE_COMMENT Max number of bytes in sorted records 522 NUMERIC_MIN_VALUE 4 523 NUMERIC_MAX_VALUE 8388608 524@@ -1975,7 +1975,7 @@ 525 COMMAND_LINE_ARGUMENT REQUIRED 526 VARIABLE_NAME MAX_LONG_DATA_SIZE 527 VARIABLE_SCOPE GLOBAL 528-VARIABLE_TYPE BIGINT UNSIGNED 529+VARIABLE_TYPE INT UNSIGNED 530 VARIABLE_COMMENT The maximum BLOB length to send to server from mysql_send_long_data API. Deprecated option; use max_allowed_packet instead. 531 NUMERIC_MIN_VALUE 1024 532 NUMERIC_MAX_VALUE 4294967295 533@@ -1995,7 +1995,7 @@ 534 COMMAND_LINE_ARGUMENT REQUIRED 535 VARIABLE_NAME MAX_RECURSIVE_ITERATIONS 536 VARIABLE_SCOPE SESSION 537-VARIABLE_TYPE BIGINT UNSIGNED 538+VARIABLE_TYPE INT UNSIGNED 539 VARIABLE_COMMENT Maximum number of iterations when executing recursive queries 540 NUMERIC_MIN_VALUE 0 541 NUMERIC_MAX_VALUE 4294967295 542@@ -2015,7 +2015,7 @@ 543 COMMAND_LINE_ARGUMENT REQUIRED 544 VARIABLE_NAME MAX_SEEKS_FOR_KEY 545 VARIABLE_SCOPE SESSION 546-VARIABLE_TYPE BIGINT UNSIGNED 547+VARIABLE_TYPE INT UNSIGNED 548 VARIABLE_COMMENT Limit assumed max number of seeks when looking up rows based on a key 549 NUMERIC_MIN_VALUE 1 550 NUMERIC_MAX_VALUE 4294967295 551@@ -2035,7 +2035,7 @@ 552 COMMAND_LINE_ARGUMENT REQUIRED 553 VARIABLE_NAME MAX_SORT_LENGTH 554 VARIABLE_SCOPE SESSION 555-VARIABLE_TYPE BIGINT UNSIGNED 556+VARIABLE_TYPE INT UNSIGNED 557 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) 558 NUMERIC_MIN_VALUE 4 559 NUMERIC_MAX_VALUE 8388608 560@@ -2045,7 +2045,7 @@ 561 COMMAND_LINE_ARGUMENT REQUIRED 562 VARIABLE_NAME MAX_SP_RECURSION_DEPTH 563 VARIABLE_SCOPE SESSION 564-VARIABLE_TYPE BIGINT UNSIGNED 565+VARIABLE_TYPE INT UNSIGNED 566 VARIABLE_COMMENT Maximum stored procedure recursion depth 567 NUMERIC_MIN_VALUE 0 568 NUMERIC_MAX_VALUE 255 569@@ -2065,7 +2065,7 @@ 570 COMMAND_LINE_ARGUMENT REQUIRED 571 VARIABLE_NAME MAX_TMP_TABLES 572 VARIABLE_SCOPE SESSION 573-VARIABLE_TYPE BIGINT UNSIGNED 574+VARIABLE_TYPE INT UNSIGNED 575 VARIABLE_COMMENT Unused, will be removed. 576 NUMERIC_MIN_VALUE 1 577 NUMERIC_MAX_VALUE 4294967295 578@@ -2085,7 +2085,7 @@ 579 COMMAND_LINE_ARGUMENT REQUIRED 580 VARIABLE_NAME MAX_WRITE_LOCK_COUNT 581 VARIABLE_SCOPE GLOBAL 582-VARIABLE_TYPE BIGINT UNSIGNED 583+VARIABLE_TYPE INT UNSIGNED 584 VARIABLE_COMMENT After this many write locks, allow some read locks to run in between 585 NUMERIC_MIN_VALUE 1 586 NUMERIC_MAX_VALUE 4294967295 587@@ -2095,7 +2095,7 @@ 588 COMMAND_LINE_ARGUMENT REQUIRED 589 VARIABLE_NAME METADATA_LOCKS_CACHE_SIZE 590 VARIABLE_SCOPE GLOBAL 591-VARIABLE_TYPE BIGINT UNSIGNED 592+VARIABLE_TYPE INT UNSIGNED 593 VARIABLE_COMMENT Unused 594 NUMERIC_MIN_VALUE 1 595 NUMERIC_MAX_VALUE 1048576 596@@ -2105,7 +2105,7 @@ 597 COMMAND_LINE_ARGUMENT REQUIRED 598 VARIABLE_NAME METADATA_LOCKS_HASH_INSTANCES 599 VARIABLE_SCOPE GLOBAL 600-VARIABLE_TYPE BIGINT UNSIGNED 601+VARIABLE_TYPE INT UNSIGNED 602 VARIABLE_COMMENT Unused 603 NUMERIC_MIN_VALUE 1 604 NUMERIC_MAX_VALUE 1024 605@@ -2115,7 +2115,7 @@ 606 COMMAND_LINE_ARGUMENT REQUIRED 607 VARIABLE_NAME MIN_EXAMINED_ROW_LIMIT 608 VARIABLE_SCOPE SESSION 609-VARIABLE_TYPE BIGINT UNSIGNED 610+VARIABLE_TYPE INT UNSIGNED 611 VARIABLE_COMMENT Don't write queries to slow log that examine fewer rows than that 612 NUMERIC_MIN_VALUE 0 613 NUMERIC_MAX_VALUE 4294967295 614@@ -2125,7 +2125,7 @@ 615 COMMAND_LINE_ARGUMENT REQUIRED 616 VARIABLE_NAME MRR_BUFFER_SIZE 617 VARIABLE_SCOPE SESSION 618-VARIABLE_TYPE BIGINT UNSIGNED 619+VARIABLE_TYPE INT UNSIGNED 620 VARIABLE_COMMENT Size of buffer to use when using MRR with range access 621 NUMERIC_MIN_VALUE 8192 622 NUMERIC_MAX_VALUE 2147483647 623@@ -2135,17 +2135,17 @@ 624 COMMAND_LINE_ARGUMENT REQUIRED 625 VARIABLE_NAME MULTI_RANGE_COUNT 626 VARIABLE_SCOPE SESSION 627-VARIABLE_TYPE BIGINT UNSIGNED 628+VARIABLE_TYPE INT UNSIGNED 629 VARIABLE_COMMENT Ignored. Use mrr_buffer_size instead 630 NUMERIC_MIN_VALUE 1 631-NUMERIC_MAX_VALUE 18446744073709551615 632+NUMERIC_MAX_VALUE 4294967295 633 NUMERIC_BLOCK_SIZE 1 634 ENUM_VALUE_LIST NULL 635 READ_ONLY NO 636 COMMAND_LINE_ARGUMENT REQUIRED 637 VARIABLE_NAME MYISAM_BLOCK_SIZE 638 VARIABLE_SCOPE GLOBAL 639-VARIABLE_TYPE BIGINT UNSIGNED 640+VARIABLE_TYPE INT UNSIGNED 641 VARIABLE_COMMENT Block size to be used for MyISAM index pages 642 NUMERIC_MIN_VALUE 1024 643 NUMERIC_MAX_VALUE 16384 644@@ -2155,7 +2155,7 @@ 645 COMMAND_LINE_ARGUMENT REQUIRED 646 VARIABLE_NAME MYISAM_DATA_POINTER_SIZE 647 VARIABLE_SCOPE GLOBAL 648-VARIABLE_TYPE BIGINT UNSIGNED 649+VARIABLE_TYPE INT UNSIGNED 650 VARIABLE_COMMENT Default pointer size to be used for MyISAM tables 651 NUMERIC_MIN_VALUE 2 652 NUMERIC_MAX_VALUE 7 653@@ -2178,7 +2178,7 @@ 654 VARIABLE_TYPE BIGINT UNSIGNED 655 VARIABLE_COMMENT Restricts the total memory used for memory mapping of MySQL tables 656 NUMERIC_MIN_VALUE 7 657-NUMERIC_MAX_VALUE 18446744073709551615 658+NUMERIC_MAX_VALUE 4294967295 659 NUMERIC_BLOCK_SIZE 1 660 ENUM_VALUE_LIST NULL 661 READ_ONLY YES 662@@ -2195,10 +2195,10 @@ 663 COMMAND_LINE_ARGUMENT OPTIONAL 664 VARIABLE_NAME MYISAM_REPAIR_THREADS 665 VARIABLE_SCOPE SESSION 666-VARIABLE_TYPE BIGINT UNSIGNED 667+VARIABLE_TYPE INT UNSIGNED 668 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 669 NUMERIC_MIN_VALUE 1 670-NUMERIC_MAX_VALUE 18446744073709551615 671+NUMERIC_MAX_VALUE 4294967295 672 NUMERIC_BLOCK_SIZE 1 673 ENUM_VALUE_LIST NULL 674 READ_ONLY NO 675@@ -2208,7 +2208,7 @@ 676 VARIABLE_TYPE BIGINT UNSIGNED 677 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 678 NUMERIC_MIN_VALUE 4096 679-NUMERIC_MAX_VALUE 18446744073709551615 680+NUMERIC_MAX_VALUE 4294967295 681 NUMERIC_BLOCK_SIZE 1 682 ENUM_VALUE_LIST NULL 683 READ_ONLY NO 684@@ -2245,7 +2245,7 @@ 685 COMMAND_LINE_ARGUMENT OPTIONAL 686 VARIABLE_NAME NET_BUFFER_LENGTH 687 VARIABLE_SCOPE SESSION 688-VARIABLE_TYPE BIGINT UNSIGNED 689+VARIABLE_TYPE INT UNSIGNED 690 VARIABLE_COMMENT Buffer length for TCP/IP and socket communication 691 NUMERIC_MIN_VALUE 1024 692 NUMERIC_MAX_VALUE 1048576 693@@ -2255,7 +2255,7 @@ 694 COMMAND_LINE_ARGUMENT REQUIRED 695 VARIABLE_NAME NET_READ_TIMEOUT 696 VARIABLE_SCOPE SESSION 697-VARIABLE_TYPE BIGINT UNSIGNED 698+VARIABLE_TYPE INT UNSIGNED 699 VARIABLE_COMMENT Number of seconds to wait for more data from a connection before aborting the read 700 NUMERIC_MIN_VALUE 1 701 NUMERIC_MAX_VALUE 31536000 702@@ -2265,7 +2265,7 @@ 703 COMMAND_LINE_ARGUMENT REQUIRED 704 VARIABLE_NAME NET_RETRY_COUNT 705 VARIABLE_SCOPE SESSION 706-VARIABLE_TYPE BIGINT UNSIGNED 707+VARIABLE_TYPE INT UNSIGNED 708 VARIABLE_COMMENT If a read on a communication port is interrupted, retry this many times before giving up 709 NUMERIC_MIN_VALUE 1 710 NUMERIC_MAX_VALUE 4294967295 711@@ -2275,7 +2275,7 @@ 712 COMMAND_LINE_ARGUMENT REQUIRED 713 VARIABLE_NAME NET_WRITE_TIMEOUT 714 VARIABLE_SCOPE SESSION 715-VARIABLE_TYPE BIGINT UNSIGNED 716+VARIABLE_TYPE INT UNSIGNED 717 VARIABLE_COMMENT Number of seconds to wait for a block to be written to a connection before aborting the write 718 NUMERIC_MIN_VALUE 1 719 NUMERIC_MAX_VALUE 31536000 720@@ -2325,7 +2325,7 @@ 721 COMMAND_LINE_ARGUMENT OPTIONAL 722 VARIABLE_NAME OPEN_FILES_LIMIT 723 VARIABLE_SCOPE GLOBAL 724-VARIABLE_TYPE BIGINT UNSIGNED 725+VARIABLE_TYPE INT UNSIGNED 726 VARIABLE_COMMENT If this is not 0, then mysqld will use this value to reserve file descriptors to use with setrlimit(). If this value is 0 or autoset then mysqld will reserve max_connections*5 or max_connections + table_cache*2 (whichever is larger) number of file descriptors 727 NUMERIC_MIN_VALUE 0 728 NUMERIC_MAX_VALUE 4294967295 729@@ -2335,7 +2335,7 @@ 730 COMMAND_LINE_ARGUMENT REQUIRED 731 VARIABLE_NAME OPTIMIZER_PRUNE_LEVEL 732 VARIABLE_SCOPE SESSION 733-VARIABLE_TYPE BIGINT UNSIGNED 734+VARIABLE_TYPE INT UNSIGNED 735 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 number of retrieved rows 736 NUMERIC_MIN_VALUE 0 737 NUMERIC_MAX_VALUE 1 738@@ -2345,7 +2345,7 @@ 739 COMMAND_LINE_ARGUMENT REQUIRED 740 VARIABLE_NAME OPTIMIZER_SEARCH_DEPTH 741 VARIABLE_SCOPE SESSION 742-VARIABLE_TYPE BIGINT UNSIGNED 743+VARIABLE_TYPE INT UNSIGNED 744 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. 745 NUMERIC_MIN_VALUE 0 746 NUMERIC_MAX_VALUE 62 747@@ -2355,7 +2355,7 @@ 748 COMMAND_LINE_ARGUMENT REQUIRED 749 VARIABLE_NAME OPTIMIZER_SELECTIVITY_SAMPLING_LIMIT 750 VARIABLE_SCOPE SESSION 751-VARIABLE_TYPE BIGINT UNSIGNED 752+VARIABLE_TYPE INT UNSIGNED 753 VARIABLE_COMMENT Controls number of record samples to check condition selectivity 754 NUMERIC_MIN_VALUE 10 755 NUMERIC_MAX_VALUE 4294967295 756@@ -2375,7 +2375,7 @@ 757 COMMAND_LINE_ARGUMENT REQUIRED 758 VARIABLE_NAME OPTIMIZER_USE_CONDITION_SELECTIVITY 759 VARIABLE_SCOPE SESSION 760-VARIABLE_TYPE BIGINT UNSIGNED 761+VARIABLE_TYPE INT UNSIGNED 762 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 763 NUMERIC_MIN_VALUE 1 764 NUMERIC_MAX_VALUE 5 765@@ -2395,7 +2395,7 @@ 766 COMMAND_LINE_ARGUMENT OPTIONAL 767 VARIABLE_NAME PERFORMANCE_SCHEMA_ACCOUNTS_SIZE 768 VARIABLE_SCOPE GLOBAL 769-VARIABLE_TYPE BIGINT 770+VARIABLE_TYPE INT 771 VARIABLE_COMMENT Maximum number of instrumented user@host accounts. Use 0 to disable, -1 for automated sizing. 772 NUMERIC_MIN_VALUE -1 773 NUMERIC_MAX_VALUE 1048576 774@@ -2405,7 +2405,7 @@ 775 COMMAND_LINE_ARGUMENT REQUIRED 776 VARIABLE_NAME PERFORMANCE_SCHEMA_DIGESTS_SIZE 777 VARIABLE_SCOPE GLOBAL 778-VARIABLE_TYPE BIGINT 779+VARIABLE_TYPE INT 780 VARIABLE_COMMENT Size of the statement digest. Use 0 to disable, -1 for automated sizing. 781 NUMERIC_MIN_VALUE -1 782 NUMERIC_MAX_VALUE 200 783@@ -2415,7 +2415,7 @@ 784 COMMAND_LINE_ARGUMENT REQUIRED 785 VARIABLE_NAME PERFORMANCE_SCHEMA_EVENTS_STAGES_HISTORY_LONG_SIZE 786 VARIABLE_SCOPE GLOBAL 787-VARIABLE_TYPE BIGINT 788+VARIABLE_TYPE INT 789 VARIABLE_COMMENT Number of rows in EVENTS_STAGES_HISTORY_LONG. Use 0 to disable, -1 for automated sizing. 790 NUMERIC_MIN_VALUE -1 791 NUMERIC_MAX_VALUE 1048576 792@@ -2425,7 +2425,7 @@ 793 COMMAND_LINE_ARGUMENT REQUIRED 794 VARIABLE_NAME PERFORMANCE_SCHEMA_EVENTS_STAGES_HISTORY_SIZE 795 VARIABLE_SCOPE GLOBAL 796-VARIABLE_TYPE BIGINT 797+VARIABLE_TYPE INT 798 VARIABLE_COMMENT Number of rows per thread in EVENTS_STAGES_HISTORY. Use 0 to disable, -1 for automated sizing. 799 NUMERIC_MIN_VALUE -1 800 NUMERIC_MAX_VALUE 1024 801@@ -2435,7 +2435,7 @@ 802 COMMAND_LINE_ARGUMENT REQUIRED 803 VARIABLE_NAME PERFORMANCE_SCHEMA_EVENTS_STATEMENTS_HISTORY_LONG_SIZE 804 VARIABLE_SCOPE GLOBAL 805-VARIABLE_TYPE BIGINT 806+VARIABLE_TYPE INT 807 VARIABLE_COMMENT Number of rows in EVENTS_STATEMENTS_HISTORY_LONG. Use 0 to disable, -1 for automated sizing. 808 NUMERIC_MIN_VALUE -1 809 NUMERIC_MAX_VALUE 1048576 810@@ -2445,7 +2445,7 @@ 811 COMMAND_LINE_ARGUMENT REQUIRED 812 VARIABLE_NAME PERFORMANCE_SCHEMA_EVENTS_STATEMENTS_HISTORY_SIZE 813 VARIABLE_SCOPE GLOBAL 814-VARIABLE_TYPE BIGINT 815+VARIABLE_TYPE INT 816 VARIABLE_COMMENT Number of rows per thread in EVENTS_STATEMENTS_HISTORY. Use 0 to disable, -1 for automated sizing. 817 NUMERIC_MIN_VALUE -1 818 NUMERIC_MAX_VALUE 1024 819@@ -2455,7 +2455,7 @@ 820 COMMAND_LINE_ARGUMENT REQUIRED 821 VARIABLE_NAME PERFORMANCE_SCHEMA_EVENTS_WAITS_HISTORY_LONG_SIZE 822 VARIABLE_SCOPE GLOBAL 823-VARIABLE_TYPE BIGINT 824+VARIABLE_TYPE INT 825 VARIABLE_COMMENT Number of rows in EVENTS_WAITS_HISTORY_LONG. Use 0 to disable, -1 for automated sizing. 826 NUMERIC_MIN_VALUE -1 827 NUMERIC_MAX_VALUE 1048576 828@@ -2465,7 +2465,7 @@ 829 COMMAND_LINE_ARGUMENT REQUIRED 830 VARIABLE_NAME PERFORMANCE_SCHEMA_EVENTS_WAITS_HISTORY_SIZE 831 VARIABLE_SCOPE GLOBAL 832-VARIABLE_TYPE BIGINT 833+VARIABLE_TYPE INT 834 VARIABLE_COMMENT Number of rows per thread in EVENTS_WAITS_HISTORY. Use 0 to disable, -1 for automated sizing. 835 NUMERIC_MIN_VALUE -1 836 NUMERIC_MAX_VALUE 1024 837@@ -2475,7 +2475,7 @@ 838 COMMAND_LINE_ARGUMENT REQUIRED 839 VARIABLE_NAME PERFORMANCE_SCHEMA_HOSTS_SIZE 840 VARIABLE_SCOPE GLOBAL 841-VARIABLE_TYPE BIGINT 842+VARIABLE_TYPE INT 843 VARIABLE_COMMENT Maximum number of instrumented hosts. Use 0 to disable, -1 for automated sizing. 844 NUMERIC_MIN_VALUE -1 845 NUMERIC_MAX_VALUE 1048576 846@@ -2485,7 +2485,7 @@ 847 COMMAND_LINE_ARGUMENT REQUIRED 848 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_COND_CLASSES 849 VARIABLE_SCOPE GLOBAL 850-VARIABLE_TYPE BIGINT UNSIGNED 851+VARIABLE_TYPE INT UNSIGNED 852 VARIABLE_COMMENT Maximum number of condition instruments. 853 NUMERIC_MIN_VALUE 0 854 NUMERIC_MAX_VALUE 256 855@@ -2495,7 +2495,7 @@ 856 COMMAND_LINE_ARGUMENT REQUIRED 857 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_COND_INSTANCES 858 VARIABLE_SCOPE GLOBAL 859-VARIABLE_TYPE BIGINT 860+VARIABLE_TYPE INT 861 VARIABLE_COMMENT Maximum number of instrumented condition objects. Use 0 to disable, -1 for automated sizing. 862 NUMERIC_MIN_VALUE -1 863 NUMERIC_MAX_VALUE 1048576 864@@ -2505,7 +2505,7 @@ 865 COMMAND_LINE_ARGUMENT REQUIRED 866 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_DIGEST_LENGTH 867 VARIABLE_SCOPE GLOBAL 868-VARIABLE_TYPE BIGINT 869+VARIABLE_TYPE INT 870 VARIABLE_COMMENT Maximum length considered for digest text, when stored in performance_schema tables. 871 NUMERIC_MIN_VALUE 0 872 NUMERIC_MAX_VALUE 1048576 873@@ -2515,7 +2515,7 @@ 874 COMMAND_LINE_ARGUMENT REQUIRED 875 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_FILE_CLASSES 876 VARIABLE_SCOPE GLOBAL 877-VARIABLE_TYPE BIGINT UNSIGNED 878+VARIABLE_TYPE INT UNSIGNED 879 VARIABLE_COMMENT Maximum number of file instruments. 880 NUMERIC_MIN_VALUE 0 881 NUMERIC_MAX_VALUE 256 882@@ -2525,7 +2525,7 @@ 883 COMMAND_LINE_ARGUMENT REQUIRED 884 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_FILE_HANDLES 885 VARIABLE_SCOPE GLOBAL 886-VARIABLE_TYPE BIGINT UNSIGNED 887+VARIABLE_TYPE INT UNSIGNED 888 VARIABLE_COMMENT Maximum number of opened instrumented files. 889 NUMERIC_MIN_VALUE 0 890 NUMERIC_MAX_VALUE 1048576 891@@ -2535,7 +2535,7 @@ 892 COMMAND_LINE_ARGUMENT REQUIRED 893 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_FILE_INSTANCES 894 VARIABLE_SCOPE GLOBAL 895-VARIABLE_TYPE BIGINT 896+VARIABLE_TYPE INT 897 VARIABLE_COMMENT Maximum number of instrumented files. Use 0 to disable, -1 for automated sizing. 898 NUMERIC_MIN_VALUE -1 899 NUMERIC_MAX_VALUE 1048576 900@@ -2545,7 +2545,7 @@ 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@@ -2555,7 +2555,7 @@ 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@@ -2565,7 +2565,7 @@ 919 COMMAND_LINE_ARGUMENT REQUIRED 920 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_RWLOCK_CLASSES 921 VARIABLE_SCOPE GLOBAL 922-VARIABLE_TYPE BIGINT UNSIGNED 923+VARIABLE_TYPE INT UNSIGNED 924 VARIABLE_COMMENT Maximum number of rwlock instruments. 925 NUMERIC_MIN_VALUE 0 926 NUMERIC_MAX_VALUE 256 927@@ -2575,7 +2575,7 @@ 928 COMMAND_LINE_ARGUMENT REQUIRED 929 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_RWLOCK_INSTANCES 930 VARIABLE_SCOPE GLOBAL 931-VARIABLE_TYPE BIGINT 932+VARIABLE_TYPE INT 933 VARIABLE_COMMENT Maximum number of instrumented RWLOCK objects. Use 0 to disable, -1 for automated sizing. 934 NUMERIC_MIN_VALUE -1 935 NUMERIC_MAX_VALUE 104857600 936@@ -2585,7 +2585,7 @@ 937 COMMAND_LINE_ARGUMENT REQUIRED 938 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_SOCKET_CLASSES 939 VARIABLE_SCOPE GLOBAL 940-VARIABLE_TYPE BIGINT UNSIGNED 941+VARIABLE_TYPE INT UNSIGNED 942 VARIABLE_COMMENT Maximum number of socket instruments. 943 NUMERIC_MIN_VALUE 0 944 NUMERIC_MAX_VALUE 256 945@@ -2595,7 +2595,7 @@ 946 COMMAND_LINE_ARGUMENT REQUIRED 947 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_SOCKET_INSTANCES 948 VARIABLE_SCOPE GLOBAL 949-VARIABLE_TYPE BIGINT 950+VARIABLE_TYPE INT 951 VARIABLE_COMMENT Maximum number of opened instrumented sockets. Use 0 to disable, -1 for automated sizing. 952 NUMERIC_MIN_VALUE -1 953 NUMERIC_MAX_VALUE 1048576 954@@ -2605,7 +2605,7 @@ 955 COMMAND_LINE_ARGUMENT REQUIRED 956 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_STAGE_CLASSES 957 VARIABLE_SCOPE GLOBAL 958-VARIABLE_TYPE BIGINT UNSIGNED 959+VARIABLE_TYPE INT UNSIGNED 960 VARIABLE_COMMENT Maximum number of stage instruments. 961 NUMERIC_MIN_VALUE 0 962 NUMERIC_MAX_VALUE 256 963@@ -2615,7 +2615,7 @@ 964 COMMAND_LINE_ARGUMENT REQUIRED 965 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_STATEMENT_CLASSES 966 VARIABLE_SCOPE GLOBAL 967-VARIABLE_TYPE BIGINT UNSIGNED 968+VARIABLE_TYPE INT UNSIGNED 969 VARIABLE_COMMENT Maximum number of statement instruments. 970 NUMERIC_MIN_VALUE 0 971 NUMERIC_MAX_VALUE 256 972@@ -2625,7 +2625,7 @@ 973 COMMAND_LINE_ARGUMENT REQUIRED 974 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_TABLE_HANDLES 975 VARIABLE_SCOPE GLOBAL 976-VARIABLE_TYPE BIGINT 977+VARIABLE_TYPE INT 978 VARIABLE_COMMENT Maximum number of opened instrumented tables. Use 0 to disable, -1 for automated sizing. 979 NUMERIC_MIN_VALUE -1 980 NUMERIC_MAX_VALUE 1048576 981@@ -2635,7 +2635,7 @@ 982 COMMAND_LINE_ARGUMENT REQUIRED 983 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_TABLE_INSTANCES 984 VARIABLE_SCOPE GLOBAL 985-VARIABLE_TYPE BIGINT 986+VARIABLE_TYPE INT 987 VARIABLE_COMMENT Maximum number of instrumented tables. Use 0 to disable, -1 for automated sizing. 988 NUMERIC_MIN_VALUE -1 989 NUMERIC_MAX_VALUE 1048576 990@@ -2645,7 +2645,7 @@ 991 COMMAND_LINE_ARGUMENT REQUIRED 992 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_THREAD_CLASSES 993 VARIABLE_SCOPE GLOBAL 994-VARIABLE_TYPE BIGINT UNSIGNED 995+VARIABLE_TYPE INT UNSIGNED 996 VARIABLE_COMMENT Maximum number of thread instruments. 997 NUMERIC_MIN_VALUE 0 998 NUMERIC_MAX_VALUE 256 999@@ -2655,7 +2655,7 @@ 1000 COMMAND_LINE_ARGUMENT REQUIRED 1001 VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_THREAD_INSTANCES 1002 VARIABLE_SCOPE GLOBAL 1003-VARIABLE_TYPE BIGINT 1004+VARIABLE_TYPE INT 1005 VARIABLE_COMMENT Maximum number of instrumented threads. Use 0 to disable, -1 for automated sizing. 1006 NUMERIC_MIN_VALUE -1 1007 NUMERIC_MAX_VALUE 1048576 1008@@ -2665,7 +2665,7 @@ 1009 COMMAND_LINE_ARGUMENT REQUIRED 1010 VARIABLE_NAME PERFORMANCE_SCHEMA_SESSION_CONNECT_ATTRS_SIZE 1011 VARIABLE_SCOPE GLOBAL 1012-VARIABLE_TYPE BIGINT 1013+VARIABLE_TYPE INT 1014 VARIABLE_COMMENT Size of session attribute string buffer per thread. Use 0 to disable, -1 for automated sizing. 1015 NUMERIC_MIN_VALUE -1 1016 NUMERIC_MAX_VALUE 1048576 1017@@ -2675,7 +2675,7 @@ 1018 COMMAND_LINE_ARGUMENT REQUIRED 1019 VARIABLE_NAME PERFORMANCE_SCHEMA_SETUP_ACTORS_SIZE 1020 VARIABLE_SCOPE GLOBAL 1021-VARIABLE_TYPE BIGINT UNSIGNED 1022+VARIABLE_TYPE INT UNSIGNED 1023 VARIABLE_COMMENT Maximum number of rows in SETUP_ACTORS. 1024 NUMERIC_MIN_VALUE 0 1025 NUMERIC_MAX_VALUE 1024 1026@@ -2685,7 +2685,7 @@ 1027 COMMAND_LINE_ARGUMENT REQUIRED 1028 VARIABLE_NAME PERFORMANCE_SCHEMA_SETUP_OBJECTS_SIZE 1029 VARIABLE_SCOPE GLOBAL 1030-VARIABLE_TYPE BIGINT UNSIGNED 1031+VARIABLE_TYPE INT UNSIGNED 1032 VARIABLE_COMMENT Maximum number of rows in SETUP_OBJECTS. 1033 NUMERIC_MIN_VALUE 0 1034 NUMERIC_MAX_VALUE 1048576 1035@@ -2695,7 +2695,7 @@ 1036 COMMAND_LINE_ARGUMENT REQUIRED 1037 VARIABLE_NAME PERFORMANCE_SCHEMA_USERS_SIZE 1038 VARIABLE_SCOPE GLOBAL 1039-VARIABLE_TYPE BIGINT 1040+VARIABLE_TYPE INT 1041 VARIABLE_COMMENT Maximum number of instrumented users. Use 0 to disable, -1 for automated sizing. 1042 NUMERIC_MIN_VALUE -1 1043 NUMERIC_MAX_VALUE 1048576 1044@@ -2745,7 +2745,7 @@ 1045 COMMAND_LINE_ARGUMENT REQUIRED 1046 VARIABLE_NAME PRELOAD_BUFFER_SIZE 1047 VARIABLE_SCOPE SESSION 1048-VARIABLE_TYPE BIGINT UNSIGNED 1049+VARIABLE_TYPE INT UNSIGNED 1050 VARIABLE_COMMENT The size of the buffer that is allocated when preloading indexes 1051 NUMERIC_MIN_VALUE 1024 1052 NUMERIC_MAX_VALUE 1073741824 1053@@ -2765,7 +2765,7 @@ 1054 COMMAND_LINE_ARGUMENT NULL 1055 VARIABLE_NAME PROFILING_HISTORY_SIZE 1056 VARIABLE_SCOPE SESSION 1057-VARIABLE_TYPE BIGINT UNSIGNED 1058+VARIABLE_TYPE INT UNSIGNED 1059 VARIABLE_COMMENT Number of statements about which profiling information is maintained. If set to 0, no profiles are stored. See SHOW PROFILES. 1060 NUMERIC_MIN_VALUE 0 1061 NUMERIC_MAX_VALUE 100 1062@@ -2775,7 +2775,7 @@ 1063 COMMAND_LINE_ARGUMENT REQUIRED 1064 VARIABLE_NAME PROGRESS_REPORT_TIME 1065 VARIABLE_SCOPE SESSION 1066-VARIABLE_TYPE BIGINT UNSIGNED 1067+VARIABLE_TYPE INT UNSIGNED 1068 VARIABLE_COMMENT Seconds between sending progress reports to the client for time-consuming statements. Set to 0 to disable progress reporting. 1069 NUMERIC_MIN_VALUE 0 1070 NUMERIC_MAX_VALUE 4294967295 1071@@ -2835,7 +2835,7 @@ 1072 COMMAND_LINE_ARGUMENT NULL 1073 VARIABLE_NAME QUERY_ALLOC_BLOCK_SIZE 1074 VARIABLE_SCOPE SESSION 1075-VARIABLE_TYPE BIGINT UNSIGNED 1076+VARIABLE_TYPE INT UNSIGNED 1077 VARIABLE_COMMENT Allocation block size for query parsing and execution 1078 NUMERIC_MIN_VALUE 1024 1079 NUMERIC_MAX_VALUE 4294967295 1080@@ -2845,7 +2845,7 @@ 1081 COMMAND_LINE_ARGUMENT REQUIRED 1082 VARIABLE_NAME QUERY_CACHE_LIMIT 1083 VARIABLE_SCOPE GLOBAL 1084-VARIABLE_TYPE BIGINT UNSIGNED 1085+VARIABLE_TYPE INT UNSIGNED 1086 VARIABLE_COMMENT Don't cache results that are bigger than this 1087 NUMERIC_MIN_VALUE 0 1088 NUMERIC_MAX_VALUE 4294967295 1089@@ -2855,7 +2855,7 @@ 1090 COMMAND_LINE_ARGUMENT REQUIRED 1091 VARIABLE_NAME QUERY_CACHE_MIN_RES_UNIT 1092 VARIABLE_SCOPE GLOBAL 1093-VARIABLE_TYPE BIGINT UNSIGNED 1094+VARIABLE_TYPE INT UNSIGNED 1095 VARIABLE_COMMENT The minimum size for blocks allocated by the query cache 1096 NUMERIC_MIN_VALUE 0 1097 NUMERIC_MAX_VALUE 4294967295 1098@@ -2868,7 +2868,7 @@ 1099 VARIABLE_TYPE BIGINT UNSIGNED 1100 VARIABLE_COMMENT The memory allocated to store results from old queries 1101 NUMERIC_MIN_VALUE 0 1102-NUMERIC_MAX_VALUE 18446744073709551615 1103+NUMERIC_MAX_VALUE 4294967295 1104 NUMERIC_BLOCK_SIZE 1024 1105 ENUM_VALUE_LIST NULL 1106 READ_ONLY NO 1107@@ -2905,7 +2905,7 @@ 1108 COMMAND_LINE_ARGUMENT OPTIONAL 1109 VARIABLE_NAME QUERY_PREALLOC_SIZE 1110 VARIABLE_SCOPE SESSION 1111-VARIABLE_TYPE BIGINT UNSIGNED 1112+VARIABLE_TYPE INT UNSIGNED 1113 VARIABLE_COMMENT Persistent buffer for query parsing and execution 1114 NUMERIC_MIN_VALUE 1024 1115 NUMERIC_MAX_VALUE 4294967295 1116@@ -2918,7 +2918,7 @@ 1117 VARIABLE_TYPE BIGINT UNSIGNED 1118 VARIABLE_COMMENT Sets the internal state of the RAND() generator for replication purposes 1119 NUMERIC_MIN_VALUE 0 1120-NUMERIC_MAX_VALUE 18446744073709551615 1121+NUMERIC_MAX_VALUE 4294967295 1122 NUMERIC_BLOCK_SIZE 1 1123 ENUM_VALUE_LIST NULL 1124 READ_ONLY NO 1125@@ -2928,14 +2928,14 @@ 1126 VARIABLE_TYPE BIGINT UNSIGNED 1127 VARIABLE_COMMENT Sets the internal state of the RAND() generator for replication purposes 1128 NUMERIC_MIN_VALUE 0 1129-NUMERIC_MAX_VALUE 18446744073709551615 1130+NUMERIC_MAX_VALUE 4294967295 1131 NUMERIC_BLOCK_SIZE 1 1132 ENUM_VALUE_LIST NULL 1133 READ_ONLY NO 1134 COMMAND_LINE_ARGUMENT NULL 1135 VARIABLE_NAME RANGE_ALLOC_BLOCK_SIZE 1136 VARIABLE_SCOPE SESSION 1137-VARIABLE_TYPE BIGINT UNSIGNED 1138+VARIABLE_TYPE INT UNSIGNED 1139 VARIABLE_COMMENT Allocation block size for storing ranges during optimization 1140 NUMERIC_MIN_VALUE 4096 1141 NUMERIC_MAX_VALUE 4294967295 1142@@ -2948,14 +2948,14 @@ 1143 VARIABLE_TYPE BIGINT UNSIGNED 1144 VARIABLE_COMMENT Maximum speed(KB/s) to read binlog from master (0 = no limit) 1145 NUMERIC_MIN_VALUE 0 1146-NUMERIC_MAX_VALUE 18446744073709551615 1147+NUMERIC_MAX_VALUE 4294967295 1148 NUMERIC_BLOCK_SIZE 1 1149 ENUM_VALUE_LIST NULL 1150 READ_ONLY NO 1151 COMMAND_LINE_ARGUMENT REQUIRED 1152 VARIABLE_NAME READ_BUFFER_SIZE 1153 VARIABLE_SCOPE SESSION 1154-VARIABLE_TYPE BIGINT UNSIGNED 1155+VARIABLE_TYPE INT UNSIGNED 1156 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 1157 NUMERIC_MIN_VALUE 8192 1158 NUMERIC_MAX_VALUE 2147483647 1159@@ -2975,7 +2975,7 @@ 1160 COMMAND_LINE_ARGUMENT OPTIONAL 1161 VARIABLE_NAME READ_RND_BUFFER_SIZE 1162 VARIABLE_SCOPE SESSION 1163-VARIABLE_TYPE BIGINT UNSIGNED 1164+VARIABLE_TYPE INT UNSIGNED 1165 VARIABLE_COMMENT When reading rows in sorted order after a sort, the rows are read through this buffer to avoid a disk seeks 1166 NUMERIC_MIN_VALUE 1 1167 NUMERIC_MAX_VALUE 2147483647 1168@@ -3175,10 +3175,10 @@ 1169 COMMAND_LINE_ARGUMENT REQUIRED 1170 VARIABLE_NAME ROWID_MERGE_BUFF_SIZE 1171 VARIABLE_SCOPE SESSION 1172-VARIABLE_TYPE BIGINT UNSIGNED 1173+VARIABLE_TYPE INT UNSIGNED 1174 VARIABLE_COMMENT The size of the buffers used [NOT] IN evaluation via partial matching 1175 NUMERIC_MIN_VALUE 0 1176-NUMERIC_MAX_VALUE 9223372036854775807 1177+NUMERIC_MAX_VALUE 2147483647 1178 NUMERIC_BLOCK_SIZE 1 1179 ENUM_VALUE_LIST NULL 1180 READ_ONLY NO 1181@@ -3195,20 +3195,20 @@ 1182 COMMAND_LINE_ARGUMENT OPTIONAL 1183 VARIABLE_NAME RPL_SEMI_SYNC_MASTER_TIMEOUT 1184 VARIABLE_SCOPE GLOBAL 1185-VARIABLE_TYPE BIGINT UNSIGNED 1186+VARIABLE_TYPE INT UNSIGNED 1187 VARIABLE_COMMENT The timeout value (in ms) for semi-synchronous replication in the master 1188 NUMERIC_MIN_VALUE 0 1189-NUMERIC_MAX_VALUE 18446744073709551615 1190+NUMERIC_MAX_VALUE 4294967295 1191 NUMERIC_BLOCK_SIZE 1 1192 ENUM_VALUE_LIST NULL 1193 READ_ONLY NO 1194 COMMAND_LINE_ARGUMENT REQUIRED 1195 VARIABLE_NAME RPL_SEMI_SYNC_MASTER_TRACE_LEVEL 1196 VARIABLE_SCOPE GLOBAL 1197-VARIABLE_TYPE BIGINT UNSIGNED 1198+VARIABLE_TYPE INT UNSIGNED 1199 VARIABLE_COMMENT The tracing level for semi-sync replication. 1200 NUMERIC_MIN_VALUE 0 1201-NUMERIC_MAX_VALUE 18446744073709551615 1202+NUMERIC_MAX_VALUE 4294967295 1203 NUMERIC_BLOCK_SIZE 1 1204 ENUM_VALUE_LIST NULL 1205 READ_ONLY NO 1206@@ -3265,10 +3265,10 @@ 1207 COMMAND_LINE_ARGUMENT OPTIONAL 1208 VARIABLE_NAME RPL_SEMI_SYNC_SLAVE_TRACE_LEVEL 1209 VARIABLE_SCOPE GLOBAL 1210-VARIABLE_TYPE BIGINT UNSIGNED 1211+VARIABLE_TYPE INT UNSIGNED 1212 VARIABLE_COMMENT The tracing level for semi-sync replication. 1213 NUMERIC_MIN_VALUE 0 1214-NUMERIC_MAX_VALUE 18446744073709551615 1215+NUMERIC_MAX_VALUE 4294967295 1216 NUMERIC_BLOCK_SIZE 1 1217 ENUM_VALUE_LIST NULL 1218 READ_ONLY NO 1219@@ -3305,7 +3305,7 @@ 1220 COMMAND_LINE_ARGUMENT REQUIRED 1221 VARIABLE_NAME SERVER_ID 1222 VARIABLE_SCOPE SESSION 1223-VARIABLE_TYPE BIGINT UNSIGNED 1224+VARIABLE_TYPE INT UNSIGNED 1225 VARIABLE_COMMENT Uniquely identifies the server instance in the community of replication partners 1226 NUMERIC_MIN_VALUE 1 1227 NUMERIC_MAX_VALUE 4294967295 1228@@ -3435,7 +3435,7 @@ 1229 COMMAND_LINE_ARGUMENT REQUIRED 1230 VARIABLE_NAME SLAVE_DOMAIN_PARALLEL_THREADS 1231 VARIABLE_SCOPE GLOBAL 1232-VARIABLE_TYPE BIGINT UNSIGNED 1233+VARIABLE_TYPE INT UNSIGNED 1234 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. 1235 NUMERIC_MIN_VALUE 0 1236 NUMERIC_MAX_VALUE 16383 1237@@ -3465,7 +3465,7 @@ 1238 COMMAND_LINE_ARGUMENT REQUIRED 1239 VARIABLE_NAME SLAVE_MAX_ALLOWED_PACKET 1240 VARIABLE_SCOPE GLOBAL 1241-VARIABLE_TYPE BIGINT UNSIGNED 1242+VARIABLE_TYPE INT UNSIGNED 1243 VARIABLE_COMMENT The maximum packet length to sent successfully from the master to slave. 1244 NUMERIC_MIN_VALUE 1024 1245 NUMERIC_MAX_VALUE 1073741824 1246@@ -3485,7 +3485,7 @@ 1247 COMMAND_LINE_ARGUMENT REQUIRED 1248 VARIABLE_NAME SLAVE_PARALLEL_MAX_QUEUED 1249 VARIABLE_SCOPE GLOBAL 1250-VARIABLE_TYPE BIGINT UNSIGNED 1251+VARIABLE_TYPE INT UNSIGNED 1252 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. 1253 NUMERIC_MIN_VALUE 0 1254 NUMERIC_MAX_VALUE 2147483647 1255@@ -3505,7 +3505,7 @@ 1256 COMMAND_LINE_ARGUMENT NULL 1257 VARIABLE_NAME SLAVE_PARALLEL_THREADS 1258 VARIABLE_SCOPE GLOBAL 1259-VARIABLE_TYPE BIGINT UNSIGNED 1260+VARIABLE_TYPE INT UNSIGNED 1261 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 1262 NUMERIC_MIN_VALUE 0 1263 NUMERIC_MAX_VALUE 16383 1264@@ -3515,7 +3515,7 @@ 1265 COMMAND_LINE_ARGUMENT REQUIRED 1266 VARIABLE_NAME SLAVE_PARALLEL_WORKERS 1267 VARIABLE_SCOPE GLOBAL 1268-VARIABLE_TYPE BIGINT UNSIGNED 1269+VARIABLE_TYPE INT UNSIGNED 1270 VARIABLE_COMMENT Alias for slave_parallel_threads 1271 NUMERIC_MIN_VALUE 0 1272 NUMERIC_MAX_VALUE 16383 1273@@ -3555,7 +3555,7 @@ 1274 COMMAND_LINE_ARGUMENT OPTIONAL 1275 VARIABLE_NAME SLAVE_TRANSACTION_RETRIES 1276 VARIABLE_SCOPE GLOBAL 1277-VARIABLE_TYPE BIGINT UNSIGNED 1278+VARIABLE_TYPE INT UNSIGNED 1279 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 1280 NUMERIC_MIN_VALUE 0 1281 NUMERIC_MAX_VALUE 4294967295 1282@@ -3575,7 +3575,7 @@ 1283 COMMAND_LINE_ARGUMENT REQUIRED 1284 VARIABLE_NAME SLAVE_TRANSACTION_RETRY_INTERVAL 1285 VARIABLE_SCOPE GLOBAL 1286-VARIABLE_TYPE BIGINT UNSIGNED 1287+VARIABLE_TYPE INT UNSIGNED 1288 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 1289 NUMERIC_MIN_VALUE 0 1290 NUMERIC_MAX_VALUE 3600 1291@@ -3595,7 +3595,7 @@ 1292 COMMAND_LINE_ARGUMENT REQUIRED 1293 VARIABLE_NAME SLOW_LAUNCH_TIME 1294 VARIABLE_SCOPE GLOBAL 1295-VARIABLE_TYPE BIGINT UNSIGNED 1296+VARIABLE_TYPE INT UNSIGNED 1297 VARIABLE_COMMENT If creating the thread takes longer than this value (in seconds), the Slow_launch_threads counter will be incremented 1298 NUMERIC_MIN_VALUE 0 1299 NUMERIC_MAX_VALUE 31536000 1300@@ -3638,7 +3638,7 @@ 1301 VARIABLE_TYPE BIGINT UNSIGNED 1302 VARIABLE_COMMENT Each thread that needs to do a sort allocates a buffer of this size 1303 NUMERIC_MIN_VALUE 1024 1304-NUMERIC_MAX_VALUE 18446744073709551615 1305+NUMERIC_MAX_VALUE 4294967295 1306 NUMERIC_BLOCK_SIZE 1 1307 ENUM_VALUE_LIST NULL 1308 READ_ONLY NO 1309@@ -3855,7 +3855,7 @@ 1310 COMMAND_LINE_ARGUMENT NULL 1311 VARIABLE_NAME STORED_PROGRAM_CACHE 1312 VARIABLE_SCOPE GLOBAL 1313-VARIABLE_TYPE BIGINT UNSIGNED 1314+VARIABLE_TYPE INT UNSIGNED 1315 VARIABLE_COMMENT The soft upper limit for number of cached stored routines for one connection. 1316 NUMERIC_MIN_VALUE 0 1317 NUMERIC_MAX_VALUE 524288 1318@@ -3955,7 +3955,7 @@ 1319 COMMAND_LINE_ARGUMENT NULL 1320 VARIABLE_NAME TABLE_DEFINITION_CACHE 1321 VARIABLE_SCOPE GLOBAL 1322-VARIABLE_TYPE BIGINT UNSIGNED 1323+VARIABLE_TYPE INT UNSIGNED 1324 VARIABLE_COMMENT The number of cached table definitions 1325 NUMERIC_MIN_VALUE 400 1326 NUMERIC_MAX_VALUE 2097152 1327@@ -3965,7 +3965,7 @@ 1328 COMMAND_LINE_ARGUMENT REQUIRED 1329 VARIABLE_NAME TABLE_OPEN_CACHE 1330 VARIABLE_SCOPE GLOBAL 1331-VARIABLE_TYPE BIGINT UNSIGNED 1332+VARIABLE_TYPE INT UNSIGNED 1333 VARIABLE_COMMENT The number of cached open tables 1334 NUMERIC_MIN_VALUE 10 1335 NUMERIC_MAX_VALUE 1048576 1336@@ -4015,7 +4015,7 @@ 1337 COMMAND_LINE_ARGUMENT REQUIRED 1338 VARIABLE_NAME THREAD_CACHE_SIZE 1339 VARIABLE_SCOPE GLOBAL 1340-VARIABLE_TYPE BIGINT UNSIGNED 1341+VARIABLE_TYPE INT UNSIGNED 1342 VARIABLE_COMMENT How many threads we should keep in a cache for reuse. These are freed after 5 minutes of idle time 1343 NUMERIC_MIN_VALUE 0 1344 NUMERIC_MAX_VALUE 16384 1345@@ -4025,7 +4025,7 @@ 1346 COMMAND_LINE_ARGUMENT REQUIRED 1347 VARIABLE_NAME THREAD_CONCURRENCY 1348 VARIABLE_SCOPE GLOBAL 1349-VARIABLE_TYPE BIGINT UNSIGNED 1350+VARIABLE_TYPE INT UNSIGNED 1351 VARIABLE_COMMENT Permits the application to give the threads system a hint for the desired number of threads that should be run at the same time.This variable has no effect, and is deprecated. It will be removed in a future release. 1352 NUMERIC_MIN_VALUE 1 1353 NUMERIC_MAX_VALUE 512 1354@@ -4178,7 +4178,7 @@ 1355 VARIABLE_TYPE BIGINT UNSIGNED 1356 VARIABLE_COMMENT Max size for data for an internal temporary on-disk MyISAM or Aria table. 1357 NUMERIC_MIN_VALUE 1024 1358-NUMERIC_MAX_VALUE 18446744073709551615 1359+NUMERIC_MAX_VALUE 4294967295 1360 NUMERIC_BLOCK_SIZE 1 1361 ENUM_VALUE_LIST NULL 1362 READ_ONLY NO 1363@@ -4188,7 +4188,7 @@ 1364 VARIABLE_TYPE BIGINT UNSIGNED 1365 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. 1366 NUMERIC_MIN_VALUE 1024 1367-NUMERIC_MAX_VALUE 18446744073709551615 1368+NUMERIC_MAX_VALUE 4294967295 1369 NUMERIC_BLOCK_SIZE 1 1370 ENUM_VALUE_LIST NULL 1371 READ_ONLY NO 1372@@ -4198,14 +4198,14 @@ 1373 VARIABLE_TYPE BIGINT UNSIGNED 1374 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. 1375 NUMERIC_MIN_VALUE 1024 1376-NUMERIC_MAX_VALUE 18446744073709551615 1377+NUMERIC_MAX_VALUE 4294967295 1378 NUMERIC_BLOCK_SIZE 1 1379 ENUM_VALUE_LIST NULL 1380 READ_ONLY NO 1381 COMMAND_LINE_ARGUMENT REQUIRED 1382 VARIABLE_NAME TRANSACTION_ALLOC_BLOCK_SIZE 1383 VARIABLE_SCOPE SESSION 1384-VARIABLE_TYPE BIGINT UNSIGNED 1385+VARIABLE_TYPE INT UNSIGNED 1386 VARIABLE_COMMENT Allocation block size for transactions to be stored in binary log 1387 NUMERIC_MIN_VALUE 1024 1388 NUMERIC_MAX_VALUE 134217728 1389@@ -4215,7 +4215,7 @@ 1390 COMMAND_LINE_ARGUMENT REQUIRED 1391 VARIABLE_NAME TRANSACTION_PREALLOC_SIZE 1392 VARIABLE_SCOPE SESSION 1393-VARIABLE_TYPE BIGINT UNSIGNED 1394+VARIABLE_TYPE INT UNSIGNED 1395 VARIABLE_COMMENT Persistent buffer for transactions to be stored in binary log 1396 NUMERIC_MIN_VALUE 1024 1397 NUMERIC_MAX_VALUE 134217728 1398@@ -4355,7 +4355,7 @@ 1399 COMMAND_LINE_ARGUMENT NULL 1400 VARIABLE_NAME WAIT_TIMEOUT 1401 VARIABLE_SCOPE SESSION 1402-VARIABLE_TYPE BIGINT UNSIGNED 1403+VARIABLE_TYPE INT UNSIGNED 1404 VARIABLE_COMMENT The number of seconds the server waits for activity on a connection before closing it 1405 NUMERIC_MIN_VALUE 1 1406 NUMERIC_MAX_VALUE 31536000 1407@@ -4382,7 +4382,7 @@ 1408 VARIABLE_NAME LOG_TC_SIZE 1409 GLOBAL_VALUE_ORIGIN AUTO 1410 VARIABLE_SCOPE GLOBAL 1411-VARIABLE_TYPE BIGINT UNSIGNED 1412+VARIABLE_TYPE INT UNSIGNED 1413 VARIABLE_COMMENT Size of transaction coordinator log. 1414 ENUM_VALUE_LIST NULL 1415 READ_ONLY YES 1416