1@@ -49,7 +49,7 @@ 2 SESSION_VALUE NULL 3 DEFAULT_VALUE 8 4 VARIABLE_SCOPE GLOBAL 5-VARIABLE_TYPE BIGINT UNSIGNED 6+VARIABLE_TYPE INT UNSIGNED 7 VARIABLE_COMMENT Number of InnoDB Adaptive Hash Index Partitions (default 8) 8 NUMERIC_MIN_VALUE 1 9 NUMERIC_MAX_VALUE 512 10@@ -61,7 +61,7 @@ 11 SESSION_VALUE NULL 12 DEFAULT_VALUE 150000 13 VARIABLE_SCOPE GLOBAL 14-VARIABLE_TYPE BIGINT UNSIGNED 15+VARIABLE_TYPE INT UNSIGNED 16 VARIABLE_COMMENT The upper limit of the sleep delay in usec. Value of 0 disables it. 17 NUMERIC_MIN_VALUE 0 18 NUMERIC_MAX_VALUE 1000000 19@@ -73,7 +73,7 @@ 20 SESSION_VALUE NULL 21 DEFAULT_VALUE 64 22 VARIABLE_SCOPE GLOBAL 23-VARIABLE_TYPE BIGINT UNSIGNED 24+VARIABLE_TYPE INT UNSIGNED 25 VARIABLE_COMMENT Data file autoextend increment in megabytes 26 NUMERIC_MIN_VALUE 1 27 NUMERIC_MAX_VALUE 1000 28@@ -85,7 +85,7 @@ 29 SESSION_VALUE NULL 30 DEFAULT_VALUE 1 31 VARIABLE_SCOPE GLOBAL 32-VARIABLE_TYPE BIGINT 33+VARIABLE_TYPE INT 34 VARIABLE_COMMENT The AUTOINC lock modes supported by InnoDB: 0 => Old style AUTOINC locking (for backward compatibility); 1 => New style AUTOINC locking; 2 => No AUTOINC locking (unsafe for SBR) 35 NUMERIC_MIN_VALUE 0 36 NUMERIC_MAX_VALUE 2 37@@ -157,10 +157,10 @@ 38 SESSION_VALUE NULL 39 DEFAULT_VALUE 134217728 40 VARIABLE_SCOPE GLOBAL 41-VARIABLE_TYPE BIGINT UNSIGNED 42+VARIABLE_TYPE INT UNSIGNED 43 VARIABLE_COMMENT Size of a single memory chunk within each buffer pool instance for resizing buffer pool. Online buffer pool resizing happens at this granularity. 0 means disable resizing buffer pool. 44 NUMERIC_MIN_VALUE 1048576 45-NUMERIC_MAX_VALUE 9223372036854775807 46+NUMERIC_MAX_VALUE 2147483647 47 NUMERIC_BLOCK_SIZE 1048576 48 ENUM_VALUE_LIST NULL 49 READ_ONLY YES 50@@ -193,7 +193,7 @@ 51 SESSION_VALUE NULL 52 DEFAULT_VALUE 25 53 VARIABLE_SCOPE GLOBAL 54-VARIABLE_TYPE BIGINT UNSIGNED 55+VARIABLE_TYPE INT UNSIGNED 56 VARIABLE_COMMENT Dump only the hottest N% of each buffer pool, defaults to 25 57 NUMERIC_MIN_VALUE 1 58 NUMERIC_MAX_VALUE 100 59@@ -229,7 +229,7 @@ 60 SESSION_VALUE NULL 61 DEFAULT_VALUE 0 62 VARIABLE_SCOPE GLOBAL 63-VARIABLE_TYPE BIGINT UNSIGNED 64+VARIABLE_TYPE INT UNSIGNED 65 VARIABLE_COMMENT Number of buffer pool instances, set to higher value on high-end machines to increase scalability 66 NUMERIC_MIN_VALUE 0 67 NUMERIC_MAX_VALUE 64 68@@ -289,7 +289,7 @@ 69 SESSION_VALUE NULL 70 DEFAULT_VALUE 0 71 VARIABLE_SCOPE GLOBAL 72-VARIABLE_TYPE BIGINT UNSIGNED 73+VARIABLE_TYPE INT UNSIGNED 74 VARIABLE_COMMENT A number between [0, 100] that tells how oftern buffer pool dump status in percentages should be printed. E.g. 10 means that buffer pool dump status is printed when every 10% of number of buffer pool pages are dumped. Default is 0 (only start and end status is printed). 75 NUMERIC_MIN_VALUE 0 76 NUMERIC_MAX_VALUE 100 77@@ -397,7 +397,7 @@ 78 SESSION_VALUE NULL 79 DEFAULT_VALUE 0 80 VARIABLE_SCOPE GLOBAL 81-VARIABLE_TYPE BIGINT UNSIGNED 82+VARIABLE_TYPE INT UNSIGNED 83 VARIABLE_COMMENT Helps in performance tuning in heavily concurrent environments. 84 NUMERIC_MIN_VALUE 0 85 NUMERIC_MAX_VALUE 1000 86@@ -433,7 +433,7 @@ 87 SESSION_VALUE NULL 88 DEFAULT_VALUE 5 89 VARIABLE_SCOPE GLOBAL 90-VARIABLE_TYPE BIGINT UNSIGNED 91+VARIABLE_TYPE INT UNSIGNED 92 VARIABLE_COMMENT If the compression failure rate of a table is greater than this number more padding is added to the pages to reduce the failures. A value of zero implies no padding 93 NUMERIC_MIN_VALUE 0 94 NUMERIC_MAX_VALUE 100 95@@ -457,7 +457,7 @@ 96 SESSION_VALUE NULL 97 DEFAULT_VALUE 50 98 VARIABLE_SCOPE GLOBAL 99-VARIABLE_TYPE BIGINT UNSIGNED 100+VARIABLE_TYPE INT UNSIGNED 101 VARIABLE_COMMENT Percentage of empty space on a data page that can be reserved to make the page compressible. 102 NUMERIC_MIN_VALUE 0 103 NUMERIC_MAX_VALUE 75 104@@ -469,10 +469,10 @@ 105 SESSION_VALUE NULL 106 DEFAULT_VALUE 5000 107 VARIABLE_SCOPE GLOBAL 108-VARIABLE_TYPE BIGINT UNSIGNED 109+VARIABLE_TYPE INT UNSIGNED 110 VARIABLE_COMMENT Number of times a thread is allowed to enter InnoDB within the same SQL query after it has once got the ticket 111 NUMERIC_MIN_VALUE 1 112-NUMERIC_MAX_VALUE 18446744073709551615 113+NUMERIC_MAX_VALUE 4294967295 114 NUMERIC_BLOCK_SIZE 0 115 ENUM_VALUE_LIST NULL 116 READ_ONLY NO 117@@ -697,7 +697,7 @@ 118 SESSION_VALUE NULL 119 DEFAULT_VALUE 120 120 VARIABLE_SCOPE GLOBAL 121-VARIABLE_TYPE BIGINT UNSIGNED 122+VARIABLE_TYPE INT UNSIGNED 123 VARIABLE_COMMENT Number of pages reserved in doublewrite buffer for batch flushing 124 NUMERIC_MIN_VALUE 1 125 NUMERIC_MAX_VALUE 127 126@@ -793,7 +793,7 @@ 127 SESSION_VALUE NULL 128 DEFAULT_VALUE 600 129 VARIABLE_SCOPE GLOBAL 130-VARIABLE_TYPE BIGINT UNSIGNED 131+VARIABLE_TYPE INT UNSIGNED 132 VARIABLE_COMMENT Maximum number of seconds that semaphore times out in InnoDB. 133 NUMERIC_MIN_VALUE 1 134 NUMERIC_MAX_VALUE 4294967295 135@@ -841,7 +841,7 @@ 136 SESSION_VALUE NULL 137 DEFAULT_VALUE 0 138 VARIABLE_SCOPE GLOBAL 139-VARIABLE_TYPE BIGINT UNSIGNED 140+VARIABLE_TYPE INT UNSIGNED 141 VARIABLE_COMMENT Make the first page of the given tablespace dirty. 142 NUMERIC_MIN_VALUE 0 143 NUMERIC_MAX_VALUE 4294967295 144@@ -853,7 +853,7 @@ 145 SESSION_VALUE NULL 146 DEFAULT_VALUE 30 147 VARIABLE_SCOPE GLOBAL 148-VARIABLE_TYPE BIGINT UNSIGNED 149+VARIABLE_TYPE INT UNSIGNED 150 VARIABLE_COMMENT Number of iterations over which the background flushing is averaged. 151 NUMERIC_MIN_VALUE 1 152 NUMERIC_MAX_VALUE 1000 153@@ -877,7 +877,7 @@ 154 SESSION_VALUE NULL 155 DEFAULT_VALUE 1 156 VARIABLE_SCOPE GLOBAL 157-VARIABLE_TYPE BIGINT UNSIGNED 158+VARIABLE_TYPE INT UNSIGNED 159 VARIABLE_COMMENT Controls the durability/speed trade-off for commits. Set to 0 (write and flush redo log to disk only once per second), 1 (flush to disk at each commit), 2 (write to log at commit but flush to disk only once per second) or 3 (flush to disk at prepare and at commit, slower and usually redundant). 1 and 3 guarantees that after a crash, committed transactions will not be lost and will be consistent with the binlog and other transactional engines. 2 can get inconsistent and lose transactions if there is a power failure or kernel crash but not if mysqld crashes. 0 has no guarantees in case of crash. 0 and 2 can be faster than 1 or 3. 160 NUMERIC_MIN_VALUE 0 161 NUMERIC_MAX_VALUE 3 162@@ -901,7 +901,7 @@ 163 SESSION_VALUE NULL 164 DEFAULT_VALUE 1 165 VARIABLE_SCOPE GLOBAL 166-VARIABLE_TYPE BIGINT UNSIGNED 167+VARIABLE_TYPE INT UNSIGNED 168 VARIABLE_COMMENT Set to 0 (don't flush neighbors from buffer pool), 1 (flush contiguous neighbors from buffer pool) or 2 (flush neighbors from buffer pool), when flushing a block 169 NUMERIC_MIN_VALUE 0 170 NUMERIC_MAX_VALUE 2 171@@ -949,7 +949,7 @@ 172 SESSION_VALUE NULL 173 DEFAULT_VALUE 0 174 VARIABLE_SCOPE GLOBAL 175-VARIABLE_TYPE BIGINT UNSIGNED 176+VARIABLE_TYPE INT UNSIGNED 177 VARIABLE_COMMENT Helps to save your data in case the disk image of the database becomes corrupt. 178 NUMERIC_MIN_VALUE 0 179 NUMERIC_MAX_VALUE 6 180@@ -973,7 +973,7 @@ 181 SESSION_VALUE NULL 182 DEFAULT_VALUE 8000000 183 VARIABLE_SCOPE GLOBAL 184-VARIABLE_TYPE BIGINT UNSIGNED 185+VARIABLE_TYPE INT UNSIGNED 186 VARIABLE_COMMENT InnoDB Fulltext search cache size in bytes 187 NUMERIC_MIN_VALUE 1600000 188 NUMERIC_MAX_VALUE 80000000 189@@ -1009,7 +1009,7 @@ 190 SESSION_VALUE NULL 191 DEFAULT_VALUE 84 192 VARIABLE_SCOPE GLOBAL 193-VARIABLE_TYPE BIGINT UNSIGNED 194+VARIABLE_TYPE INT UNSIGNED 195 VARIABLE_COMMENT InnoDB Fulltext search maximum token size in characters 196 NUMERIC_MIN_VALUE 10 197 NUMERIC_MAX_VALUE 84 198@@ -1021,7 +1021,7 @@ 199 SESSION_VALUE NULL 200 DEFAULT_VALUE 3 201 VARIABLE_SCOPE GLOBAL 202-VARIABLE_TYPE BIGINT UNSIGNED 203+VARIABLE_TYPE INT UNSIGNED 204 VARIABLE_COMMENT InnoDB Fulltext search minimum token size in characters 205 NUMERIC_MIN_VALUE 0 206 NUMERIC_MAX_VALUE 16 207@@ -1033,7 +1033,7 @@ 208 SESSION_VALUE NULL 209 DEFAULT_VALUE 2000 210 VARIABLE_SCOPE GLOBAL 211-VARIABLE_TYPE BIGINT UNSIGNED 212+VARIABLE_TYPE INT UNSIGNED 213 VARIABLE_COMMENT InnoDB Fulltext search number of words to optimize for each optimize table call 214 NUMERIC_MIN_VALUE 1000 215 NUMERIC_MAX_VALUE 10000 216@@ -1045,10 +1045,10 @@ 217 SESSION_VALUE NULL 218 DEFAULT_VALUE 2000000000 219 VARIABLE_SCOPE GLOBAL 220-VARIABLE_TYPE BIGINT UNSIGNED 221+VARIABLE_TYPE INT UNSIGNED 222 VARIABLE_COMMENT InnoDB Fulltext search query result cache limit in bytes 223 NUMERIC_MIN_VALUE 1000000 224-NUMERIC_MAX_VALUE 18446744073709551615 225+NUMERIC_MAX_VALUE 4294967295 226 NUMERIC_BLOCK_SIZE 0 227 ENUM_VALUE_LIST NULL 228 READ_ONLY NO 229@@ -1069,7 +1069,7 @@ 230 SESSION_VALUE NULL 231 DEFAULT_VALUE 2 232 VARIABLE_SCOPE GLOBAL 233-VARIABLE_TYPE BIGINT UNSIGNED 234+VARIABLE_TYPE INT UNSIGNED 235 VARIABLE_COMMENT InnoDB Fulltext search parallel sort degree, will round up to nearest power of 2 number 236 NUMERIC_MIN_VALUE 1 237 NUMERIC_MAX_VALUE 16 238@@ -1081,7 +1081,7 @@ 239 SESSION_VALUE NULL 240 DEFAULT_VALUE 640000000 241 VARIABLE_SCOPE GLOBAL 242-VARIABLE_TYPE BIGINT UNSIGNED 243+VARIABLE_TYPE INT UNSIGNED 244 VARIABLE_COMMENT Total memory allocated for InnoDB Fulltext Search cache 245 NUMERIC_MIN_VALUE 32000000 246 NUMERIC_MAX_VALUE 1600000000 247@@ -1105,7 +1105,7 @@ 248 SESSION_VALUE NULL 249 DEFAULT_VALUE 100 250 VARIABLE_SCOPE GLOBAL 251-VARIABLE_TYPE BIGINT UNSIGNED 252+VARIABLE_TYPE INT UNSIGNED 253 VARIABLE_COMMENT DEPRECATED. This setting has no effect. 254 NUMERIC_MIN_VALUE 0 255 NUMERIC_MAX_VALUE 100 256@@ -1141,22 +1141,22 @@ 257 SESSION_VALUE NULL 258 DEFAULT_VALUE 200 259 VARIABLE_SCOPE GLOBAL 260-VARIABLE_TYPE BIGINT UNSIGNED 261+VARIABLE_TYPE INT UNSIGNED 262 VARIABLE_COMMENT Number of IOPs the server can do. Tunes the background IO rate 263 NUMERIC_MIN_VALUE 100 264-NUMERIC_MAX_VALUE 18446744073709551615 265+NUMERIC_MAX_VALUE 4294967295 266 NUMERIC_BLOCK_SIZE 0 267 ENUM_VALUE_LIST NULL 268 READ_ONLY NO 269 COMMAND_LINE_ARGUMENT REQUIRED 270 VARIABLE_NAME INNODB_IO_CAPACITY_MAX 271 SESSION_VALUE NULL 272-DEFAULT_VALUE 18446744073709551615 273+DEFAULT_VALUE 4294967295 274 VARIABLE_SCOPE GLOBAL 275-VARIABLE_TYPE BIGINT UNSIGNED 276+VARIABLE_TYPE INT UNSIGNED 277 VARIABLE_COMMENT Limit to which innodb_io_capacity can be inflated. 278 NUMERIC_MIN_VALUE 100 279-NUMERIC_MAX_VALUE 18446744073709551615 280+NUMERIC_MAX_VALUE 4294967295 281 NUMERIC_BLOCK_SIZE 0 282 ENUM_VALUE_LIST NULL 283 READ_ONLY NO 284@@ -1213,7 +1213,7 @@ 285 SESSION_VALUE 50 286 DEFAULT_VALUE 50 287 VARIABLE_SCOPE SESSION 288-VARIABLE_TYPE BIGINT UNSIGNED 289+VARIABLE_TYPE INT UNSIGNED 290 VARIABLE_COMMENT Timeout in seconds an InnoDB transaction may wait for a lock before being rolled back. Values above 100000000 disable the timeout. 291 NUMERIC_MIN_VALUE 0 292 NUMERIC_MAX_VALUE 1073741824 293@@ -1225,10 +1225,10 @@ 294 SESSION_VALUE NULL 295 DEFAULT_VALUE 16777216 296 VARIABLE_SCOPE GLOBAL 297-VARIABLE_TYPE BIGINT UNSIGNED 298+VARIABLE_TYPE INT UNSIGNED 299 VARIABLE_COMMENT The size of the buffer which InnoDB uses to write log to the log files on disk. 300 NUMERIC_MIN_VALUE 262144 301-NUMERIC_MAX_VALUE 9223372036854775807 302+NUMERIC_MAX_VALUE 2147483647 303 NUMERIC_BLOCK_SIZE 1024 304 ENUM_VALUE_LIST NULL 305 READ_ONLY YES 306@@ -1273,7 +1273,7 @@ 307 SESSION_VALUE NULL 308 DEFAULT_VALUE 2 309 VARIABLE_SCOPE GLOBAL 310-VARIABLE_TYPE BIGINT UNSIGNED 311+VARIABLE_TYPE INT UNSIGNED 312 VARIABLE_COMMENT Number of log files in the log group. InnoDB writes to the files in a circular fashion. 313 NUMERIC_MIN_VALUE 1 314 NUMERIC_MAX_VALUE 100 315@@ -1321,7 +1321,7 @@ 316 SESSION_VALUE NULL 317 DEFAULT_VALUE 8192 318 VARIABLE_SCOPE GLOBAL 319-VARIABLE_TYPE BIGINT UNSIGNED 320+VARIABLE_TYPE INT UNSIGNED 321 VARIABLE_COMMENT Redo log write ahead unit size to avoid read-on-write, it should match the OS cache block IO size 322 NUMERIC_MIN_VALUE 512 323 NUMERIC_MAX_VALUE 16384 324@@ -1333,10 +1333,10 @@ 325 SESSION_VALUE NULL 326 DEFAULT_VALUE 1024 327 VARIABLE_SCOPE GLOBAL 328-VARIABLE_TYPE BIGINT UNSIGNED 329+VARIABLE_TYPE INT UNSIGNED 330 VARIABLE_COMMENT How deep to scan LRU to keep it clean 331 NUMERIC_MIN_VALUE 100 332-NUMERIC_MAX_VALUE 18446744073709551615 333+NUMERIC_MAX_VALUE 4294967295 334 NUMERIC_BLOCK_SIZE 0 335 ENUM_VALUE_LIST NULL 336 READ_ONLY NO 337@@ -1381,10 +1381,10 @@ 338 SESSION_VALUE NULL 339 DEFAULT_VALUE 0 340 VARIABLE_SCOPE GLOBAL 341-VARIABLE_TYPE BIGINT UNSIGNED 342+VARIABLE_TYPE INT UNSIGNED 343 VARIABLE_COMMENT Desired maximum length of the purge queue (0 = no limit) 344 NUMERIC_MIN_VALUE 0 345-NUMERIC_MAX_VALUE 18446744073709551615 346+NUMERIC_MAX_VALUE 4294967295 347 NUMERIC_BLOCK_SIZE 0 348 ENUM_VALUE_LIST NULL 349 READ_ONLY NO 350@@ -1393,7 +1393,7 @@ 351 SESSION_VALUE NULL 352 DEFAULT_VALUE 0 353 VARIABLE_SCOPE GLOBAL 354-VARIABLE_TYPE BIGINT UNSIGNED 355+VARIABLE_TYPE INT UNSIGNED 356 VARIABLE_COMMENT Maximum delay of user threads in micro-seconds 357 NUMERIC_MIN_VALUE 0 358 NUMERIC_MAX_VALUE 10000000 359@@ -1525,10 +1525,10 @@ 360 SESSION_VALUE NULL 361 DEFAULT_VALUE 0 362 VARIABLE_SCOPE GLOBAL 363-VARIABLE_TYPE BIGINT UNSIGNED 364+VARIABLE_TYPE INT UNSIGNED 365 VARIABLE_COMMENT How many files at the maximum InnoDB keeps open at the same time. 366 NUMERIC_MIN_VALUE 0 367-NUMERIC_MAX_VALUE 9223372036854775807 368+NUMERIC_MAX_VALUE 2147483647 369 NUMERIC_BLOCK_SIZE 0 370 ENUM_VALUE_LIST NULL 371 READ_ONLY YES 372@@ -1549,7 +1549,7 @@ 373 SESSION_VALUE NULL 374 DEFAULT_VALUE 4 375 VARIABLE_SCOPE GLOBAL 376-VARIABLE_TYPE BIGINT UNSIGNED 377+VARIABLE_TYPE INT UNSIGNED 378 VARIABLE_COMMENT Page cleaner threads can be from 1 to 64. Default is 4. 379 NUMERIC_MIN_VALUE 1 380 NUMERIC_MAX_VALUE 64 381@@ -1573,7 +1573,7 @@ 382 SESSION_VALUE NULL 383 DEFAULT_VALUE 16 384 VARIABLE_SCOPE GLOBAL 385-VARIABLE_TYPE BIGINT UNSIGNED 386+VARIABLE_TYPE INT UNSIGNED 387 VARIABLE_COMMENT Number of rw_locks protecting buffer pool page_hash. Rounded up to the next power of 2 388 NUMERIC_MIN_VALUE 1 389 NUMERIC_MAX_VALUE 1024 390@@ -1585,7 +1585,7 @@ 391 SESSION_VALUE NULL 392 DEFAULT_VALUE 16384 393 VARIABLE_SCOPE GLOBAL 394-VARIABLE_TYPE BIGINT UNSIGNED 395+VARIABLE_TYPE INT UNSIGNED 396 VARIABLE_COMMENT Page size to use for all InnoDB tablespaces. 397 NUMERIC_MIN_VALUE 4096 398 NUMERIC_MAX_VALUE 65536 399@@ -1621,7 +1621,7 @@ 400 SESSION_VALUE NULL 401 DEFAULT_VALUE 300 402 VARIABLE_SCOPE GLOBAL 403-VARIABLE_TYPE BIGINT UNSIGNED 404+VARIABLE_TYPE INT UNSIGNED 405 VARIABLE_COMMENT Number of UNDO log pages to purge in one batch from the history list. 406 NUMERIC_MIN_VALUE 1 407 NUMERIC_MAX_VALUE 5000 408@@ -1633,7 +1633,7 @@ 409 SESSION_VALUE NULL 410 DEFAULT_VALUE 128 411 VARIABLE_SCOPE GLOBAL 412-VARIABLE_TYPE BIGINT UNSIGNED 413+VARIABLE_TYPE INT UNSIGNED 414 VARIABLE_COMMENT Dictates rate at which UNDO records are purged. Value N means purge rollback segment(s) on every Nth iteration of purge invocation 415 NUMERIC_MIN_VALUE 1 416 NUMERIC_MAX_VALUE 128 417@@ -1645,7 +1645,7 @@ 418 SESSION_VALUE NULL 419 DEFAULT_VALUE 4 420 VARIABLE_SCOPE GLOBAL 421-VARIABLE_TYPE BIGINT UNSIGNED 422+VARIABLE_TYPE INT UNSIGNED 423 VARIABLE_COMMENT Purge threads can be from 1 to 32. Default is 4. 424 NUMERIC_MIN_VALUE 1 425 NUMERIC_MAX_VALUE 32 426@@ -1669,7 +1669,7 @@ 427 SESSION_VALUE NULL 428 DEFAULT_VALUE 56 429 VARIABLE_SCOPE GLOBAL 430-VARIABLE_TYPE BIGINT UNSIGNED 431+VARIABLE_TYPE INT UNSIGNED 432 VARIABLE_COMMENT Number of pages that must be accessed sequentially for InnoDB to trigger a readahead. 433 NUMERIC_MIN_VALUE 0 434 NUMERIC_MAX_VALUE 64 435@@ -1681,7 +1681,7 @@ 436 SESSION_VALUE NULL 437 DEFAULT_VALUE 4 438 VARIABLE_SCOPE GLOBAL 439-VARIABLE_TYPE BIGINT UNSIGNED 440+VARIABLE_TYPE INT UNSIGNED 441 VARIABLE_COMMENT Number of background read I/O threads in InnoDB. 442 NUMERIC_MIN_VALUE 1 443 NUMERIC_MAX_VALUE 64 444@@ -1705,10 +1705,10 @@ 445 SESSION_VALUE NULL 446 DEFAULT_VALUE 0 447 VARIABLE_SCOPE GLOBAL 448-VARIABLE_TYPE BIGINT UNSIGNED 449+VARIABLE_TYPE INT UNSIGNED 450 VARIABLE_COMMENT Replication thread delay (ms) on the slave server if innodb_thread_concurrency is reached (0 by default) 451 NUMERIC_MIN_VALUE 0 452-NUMERIC_MAX_VALUE 18446744073709551615 453+NUMERIC_MAX_VALUE 4294967295 454 NUMERIC_BLOCK_SIZE 0 455 ENUM_VALUE_LIST NULL 456 READ_ONLY NO 457@@ -1729,7 +1729,7 @@ 458 SESSION_VALUE NULL 459 DEFAULT_VALUE 128 460 VARIABLE_SCOPE GLOBAL 461-VARIABLE_TYPE BIGINT UNSIGNED 462+VARIABLE_TYPE INT UNSIGNED 463 VARIABLE_COMMENT Number of undo logs to use (deprecated). 464 NUMERIC_MIN_VALUE 1 465 NUMERIC_MAX_VALUE 128 466@@ -1741,7 +1741,7 @@ 467 SESSION_VALUE NULL 468 DEFAULT_VALUE 0 469 VARIABLE_SCOPE GLOBAL 470-VARIABLE_TYPE BIGINT UNSIGNED 471+VARIABLE_TYPE INT UNSIGNED 472 VARIABLE_COMMENT An InnoDB page number. 473 NUMERIC_MIN_VALUE 0 474 NUMERIC_MAX_VALUE 4294967295 475@@ -1789,7 +1789,7 @@ 476 SESSION_VALUE NULL 477 DEFAULT_VALUE 1048576 478 VARIABLE_SCOPE GLOBAL 479-VARIABLE_TYPE BIGINT UNSIGNED 480+VARIABLE_TYPE INT UNSIGNED 481 VARIABLE_COMMENT Memory buffer size for index creation 482 NUMERIC_MIN_VALUE 65536 483 NUMERIC_MAX_VALUE 67108864 484@@ -1969,7 +1969,7 @@ 485 SESSION_VALUE NULL 486 DEFAULT_VALUE 1 487 VARIABLE_SCOPE GLOBAL 488-VARIABLE_TYPE BIGINT UNSIGNED 489+VARIABLE_TYPE INT UNSIGNED 490 VARIABLE_COMMENT Size of the mutex/lock wait array. 491 NUMERIC_MIN_VALUE 1 492 NUMERIC_MAX_VALUE 1024 493@@ -1993,10 +1993,10 @@ 494 SESSION_VALUE NULL 495 DEFAULT_VALUE 30 496 VARIABLE_SCOPE GLOBAL 497-VARIABLE_TYPE BIGINT UNSIGNED 498+VARIABLE_TYPE INT UNSIGNED 499 VARIABLE_COMMENT Count of spin-loop rounds in InnoDB mutexes (30 by default) 500 NUMERIC_MIN_VALUE 0 501-NUMERIC_MAX_VALUE 18446744073709551615 502+NUMERIC_MAX_VALUE 4294967295 503 NUMERIC_BLOCK_SIZE 0 504 ENUM_VALUE_LIST NULL 505 READ_ONLY NO 506@@ -2029,7 +2029,7 @@ 507 SESSION_VALUE NULL 508 DEFAULT_VALUE 0 509 VARIABLE_SCOPE GLOBAL 510-VARIABLE_TYPE BIGINT UNSIGNED 511+VARIABLE_TYPE INT UNSIGNED 512 VARIABLE_COMMENT Helps in performance tuning in heavily concurrent environments. Sets the maximum number of threads allowed inside InnoDB. Value 0 will disable the thread throttling. 513 NUMERIC_MIN_VALUE 0 514 NUMERIC_MAX_VALUE 1000 515@@ -2041,7 +2041,7 @@ 516 SESSION_VALUE NULL 517 DEFAULT_VALUE 10000 518 VARIABLE_SCOPE GLOBAL 519-VARIABLE_TYPE BIGINT UNSIGNED 520+VARIABLE_TYPE INT UNSIGNED 521 VARIABLE_COMMENT Time of innodb thread sleeping before joining InnoDB queue (usec). Value 0 disable a sleep 522 NUMERIC_MIN_VALUE 0 523 NUMERIC_MAX_VALUE 1000000 524@@ -2101,7 +2101,7 @@ 525 SESSION_VALUE NULL 526 DEFAULT_VALUE 128 527 VARIABLE_SCOPE GLOBAL 528-VARIABLE_TYPE BIGINT UNSIGNED 529+VARIABLE_TYPE INT UNSIGNED 530 VARIABLE_COMMENT Number of undo logs to use. 531 NUMERIC_MIN_VALUE 1 532 NUMERIC_MAX_VALUE 128 533@@ -2125,7 +2125,7 @@ 534 SESSION_VALUE NULL 535 DEFAULT_VALUE 0 536 VARIABLE_SCOPE GLOBAL 537-VARIABLE_TYPE BIGINT UNSIGNED 538+VARIABLE_TYPE INT UNSIGNED 539 VARIABLE_COMMENT Number of undo tablespaces to use. 540 NUMERIC_MIN_VALUE 0 541 NUMERIC_MAX_VALUE 127 542@@ -2149,7 +2149,7 @@ 543 SESSION_VALUE NULL 544 DEFAULT_VALUE 4 545 VARIABLE_SCOPE GLOBAL 546-VARIABLE_TYPE BIGINT UNSIGNED 547+VARIABLE_TYPE INT UNSIGNED 548 VARIABLE_COMMENT Number of background write I/O threads in InnoDB. 549 NUMERIC_MIN_VALUE 1 550 NUMERIC_MAX_VALUE 64 551