sysvars_innodb.result 52.1 KB
Newer Older
1
select VARIABLE_NAME, SESSION_VALUE, DEFAULT_VALUE, VARIABLE_SCOPE, VARIABLE_TYPE, VARIABLE_COMMENT, NUMERIC_MIN_VALUE, NUMERIC_MAX_VALUE, NUMERIC_BLOCK_SIZE, ENUM_VALUE_LIST, READ_ONLY, COMMAND_LINE_ARGUMENT from information_schema.system_variables
2 3
where variable_name like 'innodb%' and
variable_name not in (
4
'innodb_version',                   # always the same as the server version
5
'innodb_numa_interleave',           # only available WITH_NUMA
6
'innodb_evict_tables_on_commit_debug', # one may want to override this
7 8
'innodb_use_native_aio',            # default value depends on OS
'innodb_buffer_pool_load_pages_abort')            # debug build only, and is only for testing
9
order by variable_name;
10 11 12 13 14 15 16 17 18
VARIABLE_NAME	INNODB_ADAPTIVE_FLUSHING
SESSION_VALUE	NULL
DEFAULT_VALUE	ON
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BOOLEAN
VARIABLE_COMMENT	Attempt flushing dirty pages to avoid IO bursts at checkpoints.
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
19
ENUM_VALUE_LIST	OFF,ON
20 21 22 23
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	NONE
VARIABLE_NAME	INNODB_ADAPTIVE_FLUSHING_LWM
SESSION_VALUE	NULL
24
DEFAULT_VALUE	10.000000
25
VARIABLE_SCOPE	GLOBAL
26
VARIABLE_TYPE	DOUBLE
27 28 29
VARIABLE_COMMENT	Percentage of log capacity below which no adaptive flushing happens.
NUMERIC_MIN_VALUE	0
NUMERIC_MAX_VALUE	70
30
NUMERIC_BLOCK_SIZE	NULL
31 32 33 34 35
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
VARIABLE_NAME	INNODB_ADAPTIVE_HASH_INDEX
SESSION_VALUE	NULL
36
DEFAULT_VALUE	OFF
37 38
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BOOLEAN
39
VARIABLE_COMMENT	Enable InnoDB adaptive hash index (disabled by default).
40 41 42
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
43
ENUM_VALUE_LIST	OFF,ON
44 45
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	OPTIONAL
46 47 48 49 50
VARIABLE_NAME	INNODB_ADAPTIVE_HASH_INDEX_PARTS
SESSION_VALUE	NULL
DEFAULT_VALUE	8
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BIGINT UNSIGNED
51
VARIABLE_COMMENT	Number of InnoDB Adaptive Hash Index Partitions (default 8)
52 53 54 55 56 57
NUMERIC_MIN_VALUE	1
NUMERIC_MAX_VALUE	512
NUMERIC_BLOCK_SIZE	0
ENUM_VALUE_LIST	NULL
READ_ONLY	YES
COMMAND_LINE_ARGUMENT	OPTIONAL
58 59 60 61
VARIABLE_NAME	INNODB_AUTOEXTEND_INCREMENT
SESSION_VALUE	NULL
DEFAULT_VALUE	64
VARIABLE_SCOPE	GLOBAL
62
VARIABLE_TYPE	INT UNSIGNED
63 64 65 66 67 68 69 70 71 72 73 74
VARIABLE_COMMENT	Data file autoextend increment in megabytes
NUMERIC_MIN_VALUE	1
NUMERIC_MAX_VALUE	1000
NUMERIC_BLOCK_SIZE	0
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
VARIABLE_NAME	INNODB_AUTOINC_LOCK_MODE
SESSION_VALUE	NULL
DEFAULT_VALUE	1
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BIGINT
75
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)
76 77 78 79 80 81
NUMERIC_MIN_VALUE	0
NUMERIC_MAX_VALUE	2
NUMERIC_BLOCK_SIZE	0
ENUM_VALUE_LIST	NULL
READ_ONLY	YES
COMMAND_LINE_ARGUMENT	REQUIRED
82 83 84 85 86
VARIABLE_NAME	INNODB_BUFFER_POOL_CHUNK_SIZE
SESSION_VALUE	NULL
DEFAULT_VALUE	134217728
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BIGINT UNSIGNED
87
VARIABLE_COMMENT	Size of a single memory chunk for resizing buffer pool. Online buffer pool resizing happens at this granularity. 0 means disable resizing buffer pool.
88 89 90 91 92 93
NUMERIC_MIN_VALUE	1048576
NUMERIC_MAX_VALUE	9223372036854775807
NUMERIC_BLOCK_SIZE	1048576
ENUM_VALUE_LIST	NULL
READ_ONLY	YES
COMMAND_LINE_ARGUMENT	REQUIRED
94 95
VARIABLE_NAME	INNODB_BUFFER_POOL_DUMP_AT_SHUTDOWN
SESSION_VALUE	NULL
96
DEFAULT_VALUE	ON
97 98 99 100 101 102
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BOOLEAN
VARIABLE_COMMENT	Dump the buffer pool into a file named @@innodb_buffer_pool_filename
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
103
ENUM_VALUE_LIST	OFF,ON
104 105 106 107 108 109 110 111 112 113 114
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
VARIABLE_NAME	INNODB_BUFFER_POOL_DUMP_NOW
SESSION_VALUE	NULL
DEFAULT_VALUE	OFF
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BOOLEAN
VARIABLE_COMMENT	Trigger an immediate dump of the buffer pool into a file named @@innodb_buffer_pool_filename
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
115
ENUM_VALUE_LIST	OFF,ON
116 117
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
Jan Lindström's avatar
Jan Lindström committed
118 119
VARIABLE_NAME	INNODB_BUFFER_POOL_DUMP_PCT
SESSION_VALUE	NULL
120
DEFAULT_VALUE	25
Jan Lindström's avatar
Jan Lindström committed
121 122
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BIGINT UNSIGNED
123
VARIABLE_COMMENT	Dump only the hottest N% of each buffer pool, defaults to 25
Jan Lindström's avatar
Jan Lindström committed
124 125 126 127 128 129
NUMERIC_MIN_VALUE	1
NUMERIC_MAX_VALUE	100
NUMERIC_BLOCK_SIZE	0
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162
VARIABLE_NAME	INNODB_BUFFER_POOL_EVICT
SESSION_VALUE	NULL
DEFAULT_VALUE	
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	VARCHAR
VARIABLE_COMMENT	Evict pages from the buffer pool
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
VARIABLE_NAME	INNODB_BUFFER_POOL_FILENAME
SESSION_VALUE	NULL
DEFAULT_VALUE	ib_buffer_pool
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	VARCHAR
VARIABLE_COMMENT	Filename to/from which to dump/load the InnoDB buffer pool
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
VARIABLE_NAME	INNODB_BUFFER_POOL_LOAD_ABORT
SESSION_VALUE	NULL
DEFAULT_VALUE	OFF
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BOOLEAN
VARIABLE_COMMENT	Abort a currently running load of the buffer pool
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
163
ENUM_VALUE_LIST	OFF,ON
164 165 166 167
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
VARIABLE_NAME	INNODB_BUFFER_POOL_LOAD_AT_STARTUP
SESSION_VALUE	NULL
168
DEFAULT_VALUE	ON
169 170 171 172 173 174
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BOOLEAN
VARIABLE_COMMENT	Load the buffer pool from a file named @@innodb_buffer_pool_filename
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
175
ENUM_VALUE_LIST	OFF,ON
176 177 178 179 180 181 182 183 184 185 186
READ_ONLY	YES
COMMAND_LINE_ARGUMENT	REQUIRED
VARIABLE_NAME	INNODB_BUFFER_POOL_LOAD_NOW
SESSION_VALUE	NULL
DEFAULT_VALUE	OFF
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BOOLEAN
VARIABLE_COMMENT	Trigger an immediate load of the buffer pool from a file named @@innodb_buffer_pool_filename
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
187
ENUM_VALUE_LIST	OFF,ON
188 189 190 191 192 193
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
VARIABLE_NAME	INNODB_BUFFER_POOL_SIZE
SESSION_VALUE	NULL
DEFAULT_VALUE	134217728
VARIABLE_SCOPE	GLOBAL
194
VARIABLE_TYPE	BIGINT UNSIGNED
195
VARIABLE_COMMENT	The size of the memory buffer InnoDB uses to cache data and indexes of its tables.
196
NUMERIC_MIN_VALUE	2097152
197 198 199
NUMERIC_MAX_VALUE	9223372036854775807
NUMERIC_BLOCK_SIZE	1048576
ENUM_VALUE_LIST	NULL
200
READ_ONLY	NO
201
COMMAND_LINE_ARGUMENT	REQUIRED
Jan Lindström's avatar
Jan Lindström committed
202 203 204 205 206 207 208 209 210 211 212 213
VARIABLE_NAME	INNODB_BUF_DUMP_STATUS_FREQUENCY
SESSION_VALUE	NULL
DEFAULT_VALUE	0
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BIGINT UNSIGNED
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).
NUMERIC_MIN_VALUE	0
NUMERIC_MAX_VALUE	100
NUMERIC_BLOCK_SIZE	0
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
214 215 216 217 218 219 220 221 222
VARIABLE_NAME	INNODB_BUF_FLUSH_LIST_NOW
SESSION_VALUE	NULL
DEFAULT_VALUE	OFF
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BOOLEAN
VARIABLE_COMMENT	Force dirty page flush now
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
223
ENUM_VALUE_LIST	OFF,ON
224 225 226 227
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	OPTIONAL
VARIABLE_NAME	INNODB_CHANGE_BUFFERING
SESSION_VALUE	NULL
228
DEFAULT_VALUE	none
229
VARIABLE_SCOPE	GLOBAL
230 231
VARIABLE_TYPE	ENUM
VARIABLE_COMMENT	Buffer changes to secondary indexes.
232 233 234
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
235
ENUM_VALUE_LIST	none,inserts,deletes,changes,purges,all
236 237 238 239 240 241 242
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
VARIABLE_NAME	INNODB_CHANGE_BUFFERING_DEBUG
SESSION_VALUE	NULL
DEFAULT_VALUE	0
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	INT UNSIGNED
243
VARIABLE_COMMENT	Debug flags for InnoDB change buffering (0=none, 1=try to buffer)
244
NUMERIC_MIN_VALUE	0
245
NUMERIC_MAX_VALUE	1
246 247 248 249
NUMERIC_BLOCK_SIZE	0
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
250 251 252 253 254 255 256 257 258 259 260 261
VARIABLE_NAME	INNODB_CHANGE_BUFFER_DUMP
SESSION_VALUE	NULL
DEFAULT_VALUE	OFF
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BOOLEAN
VARIABLE_COMMENT	Dump the change buffer at startup.
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
ENUM_VALUE_LIST	OFF,ON
READ_ONLY	YES
COMMAND_LINE_ARGUMENT	NONE
262 263 264 265 266 267 268 269 270 271 272 273 274 275
VARIABLE_NAME	INNODB_CHANGE_BUFFER_MAX_SIZE
SESSION_VALUE	NULL
DEFAULT_VALUE	25
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	INT UNSIGNED
VARIABLE_COMMENT	Maximum on-disk size of change buffer in terms of percentage of the buffer pool.
NUMERIC_MIN_VALUE	0
NUMERIC_MAX_VALUE	50
NUMERIC_BLOCK_SIZE	0
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
VARIABLE_NAME	INNODB_CHECKSUM_ALGORITHM
SESSION_VALUE	NULL
276
DEFAULT_VALUE	full_crc32
277 278
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	ENUM
279
VARIABLE_COMMENT	The algorithm InnoDB uses for page checksumming. Possible values are FULL_CRC32 for new files, always use CRC-32C; for old, see CRC32 below; STRICT_FULL_CRC32 for new files, always use CRC-32C; for old, see STRICT_CRC32 below; CRC32 write crc32, allow any of the other checksums to match when reading; STRICT_CRC32 write crc32, do not allow other algorithms to match when reading; INNODB write a software calculated checksum, allow any other checksums to match when reading; STRICT_INNODB write a software calculated checksum, do not allow other algorithms to match when reading; NONE write a constant magic number, do not do any checksum verification when reading; STRICT_NONE write a constant magic number, do not allow values other than that magic number when reading; Files updated when this option is set to crc32 or strict_crc32 will not be readable by MariaDB versions older than 10.0.4; new files created with full_crc32 are readable by MariaDB 10.4.3+
280 281 282
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
283
ENUM_VALUE_LIST	crc32,strict_crc32,full_crc32,strict_full_crc32
284 285 286 287 288 289 290 291 292 293 294
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
VARIABLE_NAME	INNODB_CMP_PER_INDEX_ENABLED
SESSION_VALUE	NULL
DEFAULT_VALUE	OFF
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BOOLEAN
VARIABLE_COMMENT	Enable INFORMATION_SCHEMA.innodb_cmp_per_index, may have negative impact on performance (off by default)
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
295
ENUM_VALUE_LIST	OFF,ON
296 297 298 299
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	OPTIONAL
VARIABLE_NAME	INNODB_COMPRESSION_ALGORITHM
SESSION_VALUE	NULL
300
DEFAULT_VALUE	zlib
301 302
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	ENUM
303
VARIABLE_COMMENT	Compression algorithm used on page compression. One of: none, zlib, lz4, lzo, lzma, bzip2, or snappy
304 305 306
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
307
ENUM_VALUE_LIST	none,zlib,lz4,lzo,lzma,bzip2,snappy
308 309
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	OPTIONAL
310 311 312 313 314 315 316 317 318 319 320 321
VARIABLE_NAME	INNODB_COMPRESSION_DEFAULT
SESSION_VALUE	OFF
DEFAULT_VALUE	OFF
VARIABLE_SCOPE	SESSION
VARIABLE_TYPE	BOOLEAN
VARIABLE_COMMENT	Is compression the default for new tables
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
ENUM_VALUE_LIST	OFF,ON
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	OPTIONAL
322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351 352 353 354 355 356 357 358 359
VARIABLE_NAME	INNODB_COMPRESSION_FAILURE_THRESHOLD_PCT
SESSION_VALUE	NULL
DEFAULT_VALUE	5
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BIGINT UNSIGNED
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
NUMERIC_MIN_VALUE	0
NUMERIC_MAX_VALUE	100
NUMERIC_BLOCK_SIZE	0
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	OPTIONAL
VARIABLE_NAME	INNODB_COMPRESSION_LEVEL
SESSION_VALUE	NULL
DEFAULT_VALUE	6
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	INT UNSIGNED
VARIABLE_COMMENT	Compression level used for zlib compression.  0 is no compression, 1 is fastest, 9 is best compression and default is 6.
NUMERIC_MIN_VALUE	0
NUMERIC_MAX_VALUE	9
NUMERIC_BLOCK_SIZE	0
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
VARIABLE_NAME	INNODB_COMPRESSION_PAD_PCT_MAX
SESSION_VALUE	NULL
DEFAULT_VALUE	50
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BIGINT UNSIGNED
VARIABLE_COMMENT	Percentage of empty space on a data page that can be reserved to make the page compressible.
NUMERIC_MIN_VALUE	0
NUMERIC_MAX_VALUE	75
NUMERIC_BLOCK_SIZE	0
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	OPTIONAL
VARIABLE_NAME	INNODB_DATA_FILE_PATH
SESSION_VALUE	NULL
360
DEFAULT_VALUE	ibdata1:12M:autoextend
361 362 363 364 365 366 367 368 369
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	VARCHAR
VARIABLE_COMMENT	Path to individual files and their sizes.
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
ENUM_VALUE_LIST	NULL
READ_ONLY	YES
COMMAND_LINE_ARGUMENT	REQUIRED
370 371 372 373
VARIABLE_NAME	INNODB_DATA_FILE_SIZE_DEBUG
SESSION_VALUE	NULL
DEFAULT_VALUE	0
VARIABLE_SCOPE	GLOBAL
374
VARIABLE_TYPE	INT UNSIGNED
375 376
VARIABLE_COMMENT	InnoDB system tablespace size to be set in recovery.
NUMERIC_MIN_VALUE	0
377
NUMERIC_MAX_VALUE	268435456
378 379 380 381
NUMERIC_BLOCK_SIZE	0
ENUM_VALUE_LIST	NULL
READ_ONLY	YES
COMMAND_LINE_ARGUMENT	REQUIRED
382 383 384 385 386 387 388 389 390 391 392 393
VARIABLE_NAME	INNODB_DATA_HOME_DIR
SESSION_VALUE	NULL
DEFAULT_VALUE	
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	VARCHAR
VARIABLE_COMMENT	The common part for InnoDB table spaces.
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
ENUM_VALUE_LIST	NULL
READ_ONLY	YES
COMMAND_LINE_ARGUMENT	REQUIRED
394 395 396 397 398 399 400 401 402 403 404 405
VARIABLE_NAME	INNODB_DEADLOCK_DETECT
SESSION_VALUE	NULL
DEFAULT_VALUE	ON
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BOOLEAN
VARIABLE_COMMENT	Enable/disable InnoDB deadlock detector (default ON). if set to OFF, deadlock detection is skipped, and we rely on innodb_lock_wait_timeout in case of deadlock.
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
ENUM_VALUE_LIST	OFF,ON
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	NONE
406 407 408 409 410 411 412 413 414 415 416 417
VARIABLE_NAME	INNODB_DEADLOCK_REPORT
SESSION_VALUE	NULL
DEFAULT_VALUE	full
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	ENUM
VARIABLE_COMMENT	How to report deadlocks (if innodb_deadlock_detect=ON).
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
ENUM_VALUE_LIST	off,basic,full
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
418 419
VARIABLE_NAME	INNODB_DEFAULT_ENCRYPTION_KEY_ID
SESSION_VALUE	1
420
DEFAULT_VALUE	1
421
VARIABLE_SCOPE	SESSION
422
VARIABLE_TYPE	INT UNSIGNED
423
VARIABLE_COMMENT	Default encryption key id used for table encryption.
424
NUMERIC_MIN_VALUE	1
425
NUMERIC_MAX_VALUE	4294967295
426 427 428 429
NUMERIC_BLOCK_SIZE	0
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
430 431 432 433 434 435 436 437 438 439 440 441
VARIABLE_NAME	INNODB_DEFAULT_ROW_FORMAT
SESSION_VALUE	NULL
DEFAULT_VALUE	dynamic
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	ENUM
VARIABLE_COMMENT	The default ROW FORMAT for all innodb tables created without explicit ROW_FORMAT. Possible values are REDUNDANT, COMPACT, and DYNAMIC. The ROW_FORMAT value COMPRESSED is not allowed
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
ENUM_VALUE_LIST	redundant,compact,dynamic
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
442 443 444 445 446 447 448 449 450
VARIABLE_NAME	INNODB_DEFRAGMENT
SESSION_VALUE	NULL
DEFAULT_VALUE	OFF
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BOOLEAN
VARIABLE_COMMENT	Enable/disable InnoDB defragmentation (default FALSE). When set to FALSE, all existing defragmentation will be paused. And new defragmentation command will fail.Paused defragmentation commands will resume when this variable is set to true again.
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
451
ENUM_VALUE_LIST	OFF,ON
452 453 454 455 456 457 458 459 460 461 462 463 464 465 466 467 468 469 470 471 472 473 474 475 476 477 478 479 480 481 482 483 484 485 486 487 488 489 490 491 492 493 494 495 496 497 498 499 500 501 502 503 504 505 506 507 508 509 510 511 512 513 514 515 516 517 518 519 520 521 522
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
VARIABLE_NAME	INNODB_DEFRAGMENT_FILL_FACTOR
SESSION_VALUE	NULL
DEFAULT_VALUE	0.900000
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	DOUBLE
VARIABLE_COMMENT	A number between [0.7, 1] that tells defragmentation how full it should fill a page. Default is 0.9. Number below 0.7 won't make much sense.This variable, together with innodb_defragment_fill_factor_n_recs, is introduced so defragmentation won't pack the page too full and cause page split on the next insert on every page. The variable indicating more defragmentation gain is the one effective.
NUMERIC_MIN_VALUE	0.7
NUMERIC_MAX_VALUE	1
NUMERIC_BLOCK_SIZE	NULL
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
VARIABLE_NAME	INNODB_DEFRAGMENT_FILL_FACTOR_N_RECS
SESSION_VALUE	NULL
DEFAULT_VALUE	20
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	INT UNSIGNED
VARIABLE_COMMENT	How many records of space defragmentation should leave on the page. This variable, together with innodb_defragment_fill_factor, is introduced so defragmentation won't pack the page too full and cause page split on the next insert on every page. The variable indicating more defragmentation gain is the one effective.
NUMERIC_MIN_VALUE	1
NUMERIC_MAX_VALUE	100
NUMERIC_BLOCK_SIZE	0
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
VARIABLE_NAME	INNODB_DEFRAGMENT_FREQUENCY
SESSION_VALUE	NULL
DEFAULT_VALUE	40
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	INT UNSIGNED
VARIABLE_COMMENT	Do not defragment a single index more than this number of time per second.This controls the number of time defragmentation thread can request X_LOCK on an index. Defragmentation thread will check whether 1/defragment_frequency (s) has passed since it worked on this index last time, and put the index back to the queue if not enough time has passed. The actual frequency can only be lower than this given number.
NUMERIC_MIN_VALUE	1
NUMERIC_MAX_VALUE	1000
NUMERIC_BLOCK_SIZE	0
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
VARIABLE_NAME	INNODB_DEFRAGMENT_N_PAGES
SESSION_VALUE	NULL
DEFAULT_VALUE	7
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	INT UNSIGNED
VARIABLE_COMMENT	Number of pages considered at once when merging multiple pages to defragment
NUMERIC_MIN_VALUE	2
NUMERIC_MAX_VALUE	32
NUMERIC_BLOCK_SIZE	0
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
VARIABLE_NAME	INNODB_DEFRAGMENT_STATS_ACCURACY
SESSION_VALUE	NULL
DEFAULT_VALUE	0
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	INT UNSIGNED
VARIABLE_COMMENT	How many defragment stats changes there are before the stats are written to persistent storage. Set to 0 meaning disable defragment stats tracking.
NUMERIC_MIN_VALUE	0
NUMERIC_MAX_VALUE	4294967295
NUMERIC_BLOCK_SIZE	0
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
VARIABLE_NAME	INNODB_DISABLE_SORT_FILE_CACHE
SESSION_VALUE	NULL
DEFAULT_VALUE	OFF
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BOOLEAN
VARIABLE_COMMENT	Whether to disable OS system file cache for sort I/O
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
523
ENUM_VALUE_LIST	OFF,ON
524 525 526 527 528 529 530 531 532 533 534
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	OPTIONAL
VARIABLE_NAME	INNODB_DOUBLEWRITE
SESSION_VALUE	NULL
DEFAULT_VALUE	ON
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BOOLEAN
VARIABLE_COMMENT	Enable InnoDB doublewrite buffer (enabled by default). Disable with --skip-innodb-doublewrite.
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
535
ENUM_VALUE_LIST	OFF,ON
536 537
READ_ONLY	YES
COMMAND_LINE_ARGUMENT	NONE
Monty's avatar
Monty committed
538 539 540 541 542
VARIABLE_NAME	INNODB_ENCRYPTION_ROTATE_KEY_AGE
SESSION_VALUE	NULL
DEFAULT_VALUE	1
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	INT UNSIGNED
543
VARIABLE_COMMENT	Key rotation - re-encrypt in background all pages that were encrypted with a key that many (or more) versions behind. Value 0 indicates that key rotation is disabled.
Monty's avatar
Monty committed
544 545 546 547 548 549 550 551 552 553 554 555 556 557 558 559 560 561 562 563 564 565 566
NUMERIC_MIN_VALUE	0
NUMERIC_MAX_VALUE	4294967295
NUMERIC_BLOCK_SIZE	0
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
VARIABLE_NAME	INNODB_ENCRYPTION_ROTATION_IOPS
SESSION_VALUE	NULL
DEFAULT_VALUE	100
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	INT UNSIGNED
VARIABLE_COMMENT	Use this many iops for background key rotation
NUMERIC_MIN_VALUE	0
NUMERIC_MAX_VALUE	4294967295
NUMERIC_BLOCK_SIZE	0
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
VARIABLE_NAME	INNODB_ENCRYPTION_THREADS
SESSION_VALUE	NULL
DEFAULT_VALUE	0
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	INT UNSIGNED
567
VARIABLE_COMMENT	Number of threads performing background key rotation 
Monty's avatar
Monty committed
568
NUMERIC_MIN_VALUE	0
569
NUMERIC_MAX_VALUE	255
Monty's avatar
Monty committed
570 571 572 573 574 575 576 577 578
NUMERIC_BLOCK_SIZE	0
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
VARIABLE_NAME	INNODB_ENCRYPT_LOG
SESSION_VALUE	NULL
DEFAULT_VALUE	OFF
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BOOLEAN
579
VARIABLE_COMMENT	Enable redo log encryption
Monty's avatar
Monty committed
580 581 582
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
583
ENUM_VALUE_LIST	OFF,ON
Monty's avatar
Monty committed
584 585 586 587 588 589
READ_ONLY	YES
COMMAND_LINE_ARGUMENT	OPTIONAL
VARIABLE_NAME	INNODB_ENCRYPT_TABLES
SESSION_VALUE	NULL
DEFAULT_VALUE	OFF
VARIABLE_SCOPE	GLOBAL
590 591
VARIABLE_TYPE	ENUM
VARIABLE_COMMENT	Enable encryption for tables. Don't forget to enable --innodb-encrypt-log too
Monty's avatar
Monty committed
592 593 594
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
595
ENUM_VALUE_LIST	OFF,ON,FORCE
Monty's avatar
Monty committed
596
READ_ONLY	NO
597
COMMAND_LINE_ARGUMENT	OPTIONAL
598 599 600 601 602 603 604 605 606 607 608 609
VARIABLE_NAME	INNODB_ENCRYPT_TEMPORARY_TABLES
SESSION_VALUE	NULL
DEFAULT_VALUE	OFF
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BOOLEAN
VARIABLE_COMMENT	Enrypt the temporary table data.
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
ENUM_VALUE_LIST	OFF,ON
READ_ONLY	YES
COMMAND_LINE_ARGUMENT	OPTIONAL
610 611 612 613
VARIABLE_NAME	INNODB_FAST_SHUTDOWN
SESSION_VALUE	NULL
DEFAULT_VALUE	1
VARIABLE_SCOPE	GLOBAL
614
VARIABLE_TYPE	INT UNSIGNED
615
VARIABLE_COMMENT	Speeds up the shutdown process of the InnoDB storage engine. Possible values are 0, 1 (faster), 2 (crash-like), 3 (fastest clean).
616
NUMERIC_MIN_VALUE	0
617
NUMERIC_MAX_VALUE	3
618 619 620 621
NUMERIC_BLOCK_SIZE	0
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	OPTIONAL
622 623 624 625 626 627 628 629 630 631 632 633
VARIABLE_NAME	INNODB_FATAL_SEMAPHORE_WAIT_THRESHOLD
SESSION_VALUE	NULL
DEFAULT_VALUE	600
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BIGINT UNSIGNED
VARIABLE_COMMENT	Maximum number of seconds that semaphore times out in InnoDB.
NUMERIC_MIN_VALUE	1
NUMERIC_MAX_VALUE	4294967295
NUMERIC_BLOCK_SIZE	0
ENUM_VALUE_LIST	NULL
READ_ONLY	YES
COMMAND_LINE_ARGUMENT	REQUIRED
634 635 636 637 638 639 640 641 642
VARIABLE_NAME	INNODB_FILE_PER_TABLE
SESSION_VALUE	NULL
DEFAULT_VALUE	ON
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BOOLEAN
VARIABLE_COMMENT	Stores each InnoDB table to an .ibd file in the database dir.
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
643
ENUM_VALUE_LIST	OFF,ON
644 645
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	NONE
646 647 648 649
VARIABLE_NAME	INNODB_FILL_FACTOR
SESSION_VALUE	NULL
DEFAULT_VALUE	100
VARIABLE_SCOPE	GLOBAL
650
VARIABLE_TYPE	INT UNSIGNED
651 652 653 654 655 656 657
VARIABLE_COMMENT	Percentage of B-tree page filled during bulk insert
NUMERIC_MIN_VALUE	10
NUMERIC_MAX_VALUE	100
NUMERIC_BLOCK_SIZE	0
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
658 659 660 661
VARIABLE_NAME	INNODB_FIL_MAKE_PAGE_DIRTY_DEBUG
SESSION_VALUE	NULL
DEFAULT_VALUE	0
VARIABLE_SCOPE	GLOBAL
662
VARIABLE_TYPE	INT UNSIGNED
663 664 665 666 667 668 669 670 671 672 673 674 675 676 677 678 679 680 681 682 683 684 685 686 687 688 689 690 691 692 693 694 695 696 697 698 699 700 701 702 703 704 705 706 707
VARIABLE_COMMENT	Make the first page of the given tablespace dirty.
NUMERIC_MIN_VALUE	0
NUMERIC_MAX_VALUE	4294967295
NUMERIC_BLOCK_SIZE	0
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	OPTIONAL
VARIABLE_NAME	INNODB_FLUSHING_AVG_LOOPS
SESSION_VALUE	NULL
DEFAULT_VALUE	30
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BIGINT UNSIGNED
VARIABLE_COMMENT	Number of iterations over which the background flushing is averaged.
NUMERIC_MIN_VALUE	1
NUMERIC_MAX_VALUE	1000
NUMERIC_BLOCK_SIZE	0
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
VARIABLE_NAME	INNODB_FLUSH_LOG_AT_TIMEOUT
SESSION_VALUE	NULL
DEFAULT_VALUE	1
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	INT UNSIGNED
VARIABLE_COMMENT	Write and flush logs every (n) second.
NUMERIC_MIN_VALUE	0
NUMERIC_MAX_VALUE	2700
NUMERIC_BLOCK_SIZE	0
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	OPTIONAL
VARIABLE_NAME	INNODB_FLUSH_LOG_AT_TRX_COMMIT
SESSION_VALUE	NULL
DEFAULT_VALUE	1
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BIGINT UNSIGNED
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.
NUMERIC_MIN_VALUE	0
NUMERIC_MAX_VALUE	3
NUMERIC_BLOCK_SIZE	0
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	OPTIONAL
VARIABLE_NAME	INNODB_FLUSH_METHOD
SESSION_VALUE	NULL
708
DEFAULT_VALUE	O_DIRECT
709
VARIABLE_SCOPE	GLOBAL
710
VARIABLE_TYPE	ENUM
711 712 713 714
VARIABLE_COMMENT	With which method to flush data.
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
715
ENUM_VALUE_LIST	fsync,O_DSYNC,littlesync,nosync,O_DIRECT,O_DIRECT_NO_FSYNC
716 717 718 719 720 721 722 723 724 725 726 727 728 729
READ_ONLY	YES
COMMAND_LINE_ARGUMENT	REQUIRED
VARIABLE_NAME	INNODB_FLUSH_NEIGHBORS
SESSION_VALUE	NULL
DEFAULT_VALUE	1
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BIGINT UNSIGNED
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
NUMERIC_MIN_VALUE	0
NUMERIC_MAX_VALUE	2
NUMERIC_BLOCK_SIZE	0
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	OPTIONAL
730 731 732 733 734 735 736 737 738
VARIABLE_NAME	INNODB_FLUSH_SYNC
SESSION_VALUE	NULL
DEFAULT_VALUE	ON
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BOOLEAN
VARIABLE_COMMENT	Allow IO bursts at the checkpoints ignoring io_capacity setting.
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
739
ENUM_VALUE_LIST	OFF,ON
740 741
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	NONE
742 743 744 745 746
VARIABLE_NAME	INNODB_FORCE_PRIMARY_KEY
SESSION_VALUE	NULL
DEFAULT_VALUE	OFF
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BOOLEAN
747
VARIABLE_COMMENT	Do not allow creating a table without primary key (off by default)
748 749 750
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
751
ENUM_VALUE_LIST	OFF,ON
752 753 754 755 756 757 758
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	OPTIONAL
VARIABLE_NAME	INNODB_FORCE_RECOVERY
SESSION_VALUE	NULL
DEFAULT_VALUE	0
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BIGINT UNSIGNED
759
VARIABLE_COMMENT	Helps to save your data in case the disk image of the database becomes corrupt. Value 5 can return bogus data, and 6 can permanently corrupt data.
760 761 762 763 764 765 766 767 768 769 770 771 772 773 774 775 776
NUMERIC_MIN_VALUE	0
NUMERIC_MAX_VALUE	6
NUMERIC_BLOCK_SIZE	0
ENUM_VALUE_LIST	NULL
READ_ONLY	YES
COMMAND_LINE_ARGUMENT	REQUIRED
VARIABLE_NAME	INNODB_FT_AUX_TABLE
SESSION_VALUE	NULL
DEFAULT_VALUE	
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	VARCHAR
VARIABLE_COMMENT	FTS internal auxiliary table to be checked
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
777
COMMAND_LINE_ARGUMENT	REQUIRED
778 779 780 781 782 783 784
VARIABLE_NAME	INNODB_FT_CACHE_SIZE
SESSION_VALUE	NULL
DEFAULT_VALUE	8000000
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BIGINT UNSIGNED
VARIABLE_COMMENT	InnoDB Fulltext search cache size in bytes
NUMERIC_MIN_VALUE	1600000
785
NUMERIC_MAX_VALUE	1099511627776
786 787
NUMERIC_BLOCK_SIZE	0
ENUM_VALUE_LIST	NULL
788
READ_ONLY	NO
789 790 791 792 793 794 795 796 797 798
COMMAND_LINE_ARGUMENT	REQUIRED
VARIABLE_NAME	INNODB_FT_ENABLE_DIAG_PRINT
SESSION_VALUE	NULL
DEFAULT_VALUE	OFF
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BOOLEAN
VARIABLE_COMMENT	Whether to enable additional FTS diagnostic printout 
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
799
ENUM_VALUE_LIST	OFF,ON
800 801 802 803 804 805 806 807 808 809 810
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	OPTIONAL
VARIABLE_NAME	INNODB_FT_ENABLE_STOPWORD
SESSION_VALUE	ON
DEFAULT_VALUE	ON
VARIABLE_SCOPE	SESSION
VARIABLE_TYPE	BOOLEAN
VARIABLE_COMMENT	Create FTS index with stopword.
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
811
ENUM_VALUE_LIST	OFF,ON
812 813 814 815 816 817 818 819 820 821 822 823 824 825 826 827 828 829 830 831 832 833 834 835 836 837 838 839 840 841 842 843 844 845 846 847 848 849 850 851 852 853 854 855 856
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	OPTIONAL
VARIABLE_NAME	INNODB_FT_MAX_TOKEN_SIZE
SESSION_VALUE	NULL
DEFAULT_VALUE	84
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BIGINT UNSIGNED
VARIABLE_COMMENT	InnoDB Fulltext search maximum token size in characters
NUMERIC_MIN_VALUE	10
NUMERIC_MAX_VALUE	84
NUMERIC_BLOCK_SIZE	0
ENUM_VALUE_LIST	NULL
READ_ONLY	YES
COMMAND_LINE_ARGUMENT	REQUIRED
VARIABLE_NAME	INNODB_FT_MIN_TOKEN_SIZE
SESSION_VALUE	NULL
DEFAULT_VALUE	3
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BIGINT UNSIGNED
VARIABLE_COMMENT	InnoDB Fulltext search minimum token size in characters
NUMERIC_MIN_VALUE	0
NUMERIC_MAX_VALUE	16
NUMERIC_BLOCK_SIZE	0
ENUM_VALUE_LIST	NULL
READ_ONLY	YES
COMMAND_LINE_ARGUMENT	REQUIRED
VARIABLE_NAME	INNODB_FT_NUM_WORD_OPTIMIZE
SESSION_VALUE	NULL
DEFAULT_VALUE	2000
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BIGINT UNSIGNED
VARIABLE_COMMENT	InnoDB Fulltext search number of words to optimize for each optimize table call 
NUMERIC_MIN_VALUE	1000
NUMERIC_MAX_VALUE	10000
NUMERIC_BLOCK_SIZE	0
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	OPTIONAL
VARIABLE_NAME	INNODB_FT_RESULT_CACHE_LIMIT
SESSION_VALUE	NULL
DEFAULT_VALUE	2000000000
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BIGINT UNSIGNED
VARIABLE_COMMENT	InnoDB Fulltext search query result cache limit in bytes
NUMERIC_MIN_VALUE	1000000
857
NUMERIC_MAX_VALUE	18446744073709551615
858 859 860 861 862 863 864 865 866 867 868 869 870 871 872 873 874 875 876 877 878 879 880 881 882 883 884 885 886 887 888 889 890 891 892
NUMERIC_BLOCK_SIZE	0
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
VARIABLE_NAME	INNODB_FT_SERVER_STOPWORD_TABLE
SESSION_VALUE	NULL
DEFAULT_VALUE	
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	VARCHAR
VARIABLE_COMMENT	The user supplied stopword table name.
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	OPTIONAL
VARIABLE_NAME	INNODB_FT_SORT_PLL_DEGREE
SESSION_VALUE	NULL
DEFAULT_VALUE	2
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BIGINT UNSIGNED
VARIABLE_COMMENT	InnoDB Fulltext search parallel sort degree, will round up to nearest power of 2 number
NUMERIC_MIN_VALUE	1
NUMERIC_MAX_VALUE	16
NUMERIC_BLOCK_SIZE	0
ENUM_VALUE_LIST	NULL
READ_ONLY	YES
COMMAND_LINE_ARGUMENT	REQUIRED
VARIABLE_NAME	INNODB_FT_TOTAL_CACHE_SIZE
SESSION_VALUE	NULL
DEFAULT_VALUE	640000000
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BIGINT UNSIGNED
VARIABLE_COMMENT	Total memory allocated for InnoDB Fulltext Search cache
NUMERIC_MIN_VALUE	32000000
893
NUMERIC_MAX_VALUE	1099511627776
894 895
NUMERIC_BLOCK_SIZE	0
ENUM_VALUE_LIST	NULL
896
READ_ONLY	NO
897 898 899 900 901 902 903 904 905 906 907 908 909
COMMAND_LINE_ARGUMENT	REQUIRED
VARIABLE_NAME	INNODB_FT_USER_STOPWORD_TABLE
SESSION_VALUE	
DEFAULT_VALUE	
VARIABLE_SCOPE	SESSION
VARIABLE_TYPE	VARCHAR
VARIABLE_COMMENT	User supplied stopword table name, effective in the session level.
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	OPTIONAL
Monty's avatar
Monty committed
910 911 912 913 914 915 916 917 918
VARIABLE_NAME	INNODB_IMMEDIATE_SCRUB_DATA_UNCOMPRESSED
SESSION_VALUE	NULL
DEFAULT_VALUE	OFF
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BOOLEAN
VARIABLE_COMMENT	Enable scrubbing of data
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
919
ENUM_VALUE_LIST	OFF,ON
Monty's avatar
Monty committed
920 921
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
922 923
VARIABLE_NAME	INNODB_INSTANT_ALTER_COLUMN_ALLOWED
SESSION_VALUE	NULL
Marko Mäkelä's avatar
Marko Mäkelä committed
924
DEFAULT_VALUE	add_drop_reorder
925 926 927 928 929 930
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	ENUM
VARIABLE_COMMENT	File format constraint for ALTER TABLE
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
Marko Mäkelä's avatar
Marko Mäkelä committed
931
ENUM_VALUE_LIST	never,add_last,add_drop_reorder
932 933
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
934 935 936 937 938 939 940 941 942 943 944 945 946 947 948 949 950 951 952 953 954 955 956 957 958 959 960 961 962 963 964 965 966 967 968 969 970 971 972 973
VARIABLE_NAME	INNODB_IO_CAPACITY
SESSION_VALUE	NULL
DEFAULT_VALUE	200
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BIGINT UNSIGNED
VARIABLE_COMMENT	Number of IOPs the server can do. Tunes the background IO rate
NUMERIC_MIN_VALUE	100
NUMERIC_MAX_VALUE	18446744073709551615
NUMERIC_BLOCK_SIZE	0
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
VARIABLE_NAME	INNODB_IO_CAPACITY_MAX
SESSION_VALUE	NULL
DEFAULT_VALUE	18446744073709551615
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BIGINT UNSIGNED
VARIABLE_COMMENT	Limit to which innodb_io_capacity can be inflated.
NUMERIC_MIN_VALUE	100
NUMERIC_MAX_VALUE	18446744073709551615
NUMERIC_BLOCK_SIZE	0
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
VARIABLE_NAME	INNODB_LIMIT_OPTIMISTIC_INSERT_DEBUG
SESSION_VALUE	NULL
DEFAULT_VALUE	0
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	INT UNSIGNED
VARIABLE_COMMENT	Artificially limit the number of records per B-tree page (0=unlimited).
NUMERIC_MIN_VALUE	0
NUMERIC_MAX_VALUE	4294967295
NUMERIC_BLOCK_SIZE	0
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
VARIABLE_NAME	INNODB_LOCK_WAIT_TIMEOUT
SESSION_VALUE	50
DEFAULT_VALUE	50
VARIABLE_SCOPE	SESSION
974 975
VARIABLE_TYPE	INT UNSIGNED
VARIABLE_COMMENT	Timeout in seconds an InnoDB transaction may wait for a lock before being rolled back. The value 100000000 is infinite timeout.
976
NUMERIC_MIN_VALUE	0
977
NUMERIC_MAX_VALUE	100000000
978 979 980 981 982 983
NUMERIC_BLOCK_SIZE	0
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
VARIABLE_NAME	INNODB_LOG_BUFFER_SIZE
SESSION_VALUE	NULL
984
DEFAULT_VALUE	16777216
985
VARIABLE_SCOPE	GLOBAL
986
VARIABLE_TYPE	BIGINT UNSIGNED
987 988 989 990 991 992 993 994 995 996 997 998 999 1000 1001 1002
VARIABLE_COMMENT	The size of the buffer which InnoDB uses to write log to the log files on disk.
NUMERIC_MIN_VALUE	262144
NUMERIC_MAX_VALUE	9223372036854775807
NUMERIC_BLOCK_SIZE	1024
ENUM_VALUE_LIST	NULL
READ_ONLY	YES
COMMAND_LINE_ARGUMENT	REQUIRED
VARIABLE_NAME	INNODB_LOG_CHECKPOINT_NOW
SESSION_VALUE	NULL
DEFAULT_VALUE	OFF
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BOOLEAN
VARIABLE_COMMENT	Force checkpoint now
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
1003
ENUM_VALUE_LIST	OFF,ON
1004 1005 1006 1007
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	OPTIONAL
VARIABLE_NAME	INNODB_LOG_FILE_SIZE
SESSION_VALUE	NULL
1008
DEFAULT_VALUE	100663296
1009
VARIABLE_SCOPE	GLOBAL
1010
VARIABLE_TYPE	BIGINT UNSIGNED
1011 1012
VARIABLE_COMMENT	Size of each log file in a log group.
NUMERIC_MIN_VALUE	1048576
1013
NUMERIC_MAX_VALUE	18446744073709551615
1014
NUMERIC_BLOCK_SIZE	65536
1015 1016 1017 1018 1019 1020 1021 1022 1023 1024 1025 1026 1027 1028 1029
ENUM_VALUE_LIST	NULL
READ_ONLY	YES
COMMAND_LINE_ARGUMENT	REQUIRED
VARIABLE_NAME	INNODB_LOG_GROUP_HOME_DIR
SESSION_VALUE	NULL
DEFAULT_VALUE	
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	VARCHAR
VARIABLE_COMMENT	Path to InnoDB log files.
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
ENUM_VALUE_LIST	NULL
READ_ONLY	YES
COMMAND_LINE_ARGUMENT	REQUIRED
1030 1031 1032 1033 1034 1035 1036 1037 1038 1039 1040 1041
VARIABLE_NAME	INNODB_LOG_WRITE_AHEAD_SIZE
SESSION_VALUE	NULL
DEFAULT_VALUE	8192
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BIGINT UNSIGNED
VARIABLE_COMMENT	Redo log write ahead unit size to avoid read-on-write, it should match the OS cache block IO size
NUMERIC_MIN_VALUE	512
NUMERIC_MAX_VALUE	16384
NUMERIC_BLOCK_SIZE	512
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
1042 1043 1044 1045 1046 1047 1048 1049 1050 1051 1052 1053
VARIABLE_NAME	INNODB_LRU_FLUSH_SIZE
SESSION_VALUE	NULL
DEFAULT_VALUE	32
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BIGINT UNSIGNED
VARIABLE_COMMENT	How many pages to flush on LRU eviction
NUMERIC_MIN_VALUE	1
NUMERIC_MAX_VALUE	18446744073709551615
NUMERIC_BLOCK_SIZE	0
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
1054 1055
VARIABLE_NAME	INNODB_LRU_SCAN_DEPTH
SESSION_VALUE	NULL
1056
DEFAULT_VALUE	1536
1057 1058 1059 1060 1061 1062 1063 1064 1065 1066 1067
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BIGINT UNSIGNED
VARIABLE_COMMENT	How deep to scan LRU to keep it clean
NUMERIC_MIN_VALUE	100
NUMERIC_MAX_VALUE	18446744073709551615
NUMERIC_BLOCK_SIZE	0
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
VARIABLE_NAME	INNODB_MAX_DIRTY_PAGES_PCT
SESSION_VALUE	NULL
1068
DEFAULT_VALUE	90.000000
1069
VARIABLE_SCOPE	GLOBAL
1070
VARIABLE_TYPE	DOUBLE
1071
VARIABLE_COMMENT	Percentage of dirty pages allowed in bufferpool.
1072
NUMERIC_MIN_VALUE	0
1073 1074
NUMERIC_MAX_VALUE	99.999
NUMERIC_BLOCK_SIZE	NULL
1075 1076 1077 1078 1079
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
VARIABLE_NAME	INNODB_MAX_DIRTY_PAGES_PCT_LWM
SESSION_VALUE	NULL
1080
DEFAULT_VALUE	0.000000
1081
VARIABLE_SCOPE	GLOBAL
1082
VARIABLE_TYPE	DOUBLE
1083
VARIABLE_COMMENT	Percentage of dirty pages at which flushing kicks in. The value 0 (default) means 'refer to innodb_max_dirty_pages_pct'.
1084
NUMERIC_MIN_VALUE	0
1085 1086
NUMERIC_MAX_VALUE	99.999
NUMERIC_BLOCK_SIZE	NULL
1087 1088 1089 1090 1091 1092 1093 1094 1095 1096 1097 1098 1099 1100 1101 1102 1103 1104 1105 1106 1107 1108 1109 1110 1111 1112 1113
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
VARIABLE_NAME	INNODB_MAX_PURGE_LAG
SESSION_VALUE	NULL
DEFAULT_VALUE	0
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BIGINT UNSIGNED
VARIABLE_COMMENT	Desired maximum length of the purge queue (0 = no limit)
NUMERIC_MIN_VALUE	0
NUMERIC_MAX_VALUE	18446744073709551615
NUMERIC_BLOCK_SIZE	0
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
VARIABLE_NAME	INNODB_MAX_PURGE_LAG_DELAY
SESSION_VALUE	NULL
DEFAULT_VALUE	0
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BIGINT UNSIGNED
VARIABLE_COMMENT	Maximum delay of user threads in micro-seconds
NUMERIC_MIN_VALUE	0
NUMERIC_MAX_VALUE	10000000
NUMERIC_BLOCK_SIZE	0
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
1114 1115 1116 1117 1118 1119 1120 1121 1122 1123 1124 1125
VARIABLE_NAME	INNODB_MAX_PURGE_LAG_WAIT
SESSION_VALUE	NULL
DEFAULT_VALUE	4294967295
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	INT UNSIGNED
VARIABLE_COMMENT	Wait until History list length is below the specified limit
NUMERIC_MIN_VALUE	0
NUMERIC_MAX_VALUE	4294967295
NUMERIC_BLOCK_SIZE	0
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
1126
VARIABLE_NAME	INNODB_MAX_UNDO_LOG_SIZE
1127
SESSION_VALUE	NULL
1128
DEFAULT_VALUE	10485760
1129
VARIABLE_SCOPE	GLOBAL
1130
VARIABLE_TYPE	BIGINT UNSIGNED
1131
VARIABLE_COMMENT	Desired maximum UNDO tablespace size in bytes
1132
NUMERIC_MIN_VALUE	10485760
1133
NUMERIC_MAX_VALUE	281474976710656
1134 1135
NUMERIC_BLOCK_SIZE	0
ENUM_VALUE_LIST	NULL
1136 1137 1138 1139 1140 1141 1142 1143 1144 1145 1146 1147 1148
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	OPTIONAL
VARIABLE_NAME	INNODB_MERGE_THRESHOLD_SET_ALL_DEBUG
SESSION_VALUE	NULL
DEFAULT_VALUE	50
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	INT UNSIGNED
VARIABLE_COMMENT	Override current MERGE_THRESHOLD setting for all indexes at dictionary cache by the specified value dynamically, at the time.
NUMERIC_MIN_VALUE	1
NUMERIC_MAX_VALUE	50
NUMERIC_BLOCK_SIZE	0
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
1149 1150 1151 1152 1153 1154 1155 1156 1157 1158 1159 1160 1161 1162 1163 1164 1165 1166 1167 1168 1169 1170 1171 1172 1173 1174 1175 1176 1177 1178 1179 1180 1181 1182 1183 1184 1185 1186 1187 1188 1189 1190 1191 1192 1193 1194 1195 1196 1197 1198 1199 1200 1201 1202 1203 1204 1205 1206 1207 1208 1209 1210 1211 1212 1213 1214 1215 1216 1217 1218 1219 1220 1221 1222 1223 1224 1225 1226 1227 1228 1229 1230 1231 1232 1233 1234 1235 1236 1237
COMMAND_LINE_ARGUMENT	REQUIRED
VARIABLE_NAME	INNODB_MONITOR_DISABLE
SESSION_VALUE	NULL
DEFAULT_VALUE	
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	VARCHAR
VARIABLE_COMMENT	Turn off a monitor counter
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
VARIABLE_NAME	INNODB_MONITOR_ENABLE
SESSION_VALUE	NULL
DEFAULT_VALUE	
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	VARCHAR
VARIABLE_COMMENT	Turn on a monitor counter
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
VARIABLE_NAME	INNODB_MONITOR_RESET
SESSION_VALUE	NULL
DEFAULT_VALUE	
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	VARCHAR
VARIABLE_COMMENT	Reset a monitor counter
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
VARIABLE_NAME	INNODB_MONITOR_RESET_ALL
SESSION_VALUE	NULL
DEFAULT_VALUE	
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	VARCHAR
VARIABLE_COMMENT	Reset all values for a monitor counter
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
VARIABLE_NAME	INNODB_OLD_BLOCKS_PCT
SESSION_VALUE	NULL
DEFAULT_VALUE	37
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	INT UNSIGNED
VARIABLE_COMMENT	Percentage of the buffer pool to reserve for 'old' blocks.
NUMERIC_MIN_VALUE	5
NUMERIC_MAX_VALUE	95
NUMERIC_BLOCK_SIZE	0
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
VARIABLE_NAME	INNODB_OLD_BLOCKS_TIME
SESSION_VALUE	NULL
DEFAULT_VALUE	1000
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	INT UNSIGNED
VARIABLE_COMMENT	Move blocks to the 'new' end of the buffer pool if the first access was at least this many milliseconds ago. The timeout is disabled if 0.
NUMERIC_MIN_VALUE	0
NUMERIC_MAX_VALUE	4294967295
NUMERIC_BLOCK_SIZE	0
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
VARIABLE_NAME	INNODB_ONLINE_ALTER_LOG_MAX_SIZE
SESSION_VALUE	NULL
DEFAULT_VALUE	134217728
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BIGINT UNSIGNED
VARIABLE_COMMENT	Maximum modification log file size for online index creation
NUMERIC_MIN_VALUE	65536
NUMERIC_MAX_VALUE	18446744073709551615
NUMERIC_BLOCK_SIZE	0
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
VARIABLE_NAME	INNODB_OPEN_FILES
SESSION_VALUE	NULL
DEFAULT_VALUE	0
VARIABLE_SCOPE	GLOBAL
1238
VARIABLE_TYPE	BIGINT UNSIGNED
1239 1240 1241 1242 1243 1244 1245 1246 1247 1248 1249 1250 1251 1252 1253 1254
VARIABLE_COMMENT	How many files at the maximum InnoDB keeps open at the same time.
NUMERIC_MIN_VALUE	0
NUMERIC_MAX_VALUE	9223372036854775807
NUMERIC_BLOCK_SIZE	0
ENUM_VALUE_LIST	NULL
READ_ONLY	YES
COMMAND_LINE_ARGUMENT	REQUIRED
VARIABLE_NAME	INNODB_OPTIMIZE_FULLTEXT_ONLY
SESSION_VALUE	NULL
DEFAULT_VALUE	OFF
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BOOLEAN
VARIABLE_COMMENT	Only optimize the Fulltext index of the table
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
1255
ENUM_VALUE_LIST	OFF,ON
1256 1257 1258 1259 1260 1261 1262 1263 1264 1265 1266 1267 1268 1269
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	NONE
VARIABLE_NAME	INNODB_PAGE_SIZE
SESSION_VALUE	NULL
DEFAULT_VALUE	16384
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BIGINT UNSIGNED
VARIABLE_COMMENT	Page size to use for all InnoDB tablespaces.
NUMERIC_MIN_VALUE	4096
NUMERIC_MAX_VALUE	65536
NUMERIC_BLOCK_SIZE	0
ENUM_VALUE_LIST	NULL
READ_ONLY	YES
COMMAND_LINE_ARGUMENT	OPTIONAL
1270 1271 1272 1273 1274 1275 1276 1277 1278
VARIABLE_NAME	INNODB_PREFIX_INDEX_CLUSTER_OPTIMIZATION
SESSION_VALUE	NULL
DEFAULT_VALUE	OFF
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BOOLEAN
VARIABLE_COMMENT	Enable prefix optimization to sometimes avoid cluster index lookups.
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
1279
ENUM_VALUE_LIST	OFF,ON
1280 1281
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	OPTIONAL
1282 1283 1284 1285 1286
VARIABLE_NAME	INNODB_PRINT_ALL_DEADLOCKS
SESSION_VALUE	NULL
DEFAULT_VALUE	OFF
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BOOLEAN
1287
VARIABLE_COMMENT	Print all deadlocks to MariaDB error log (off by default)
1288 1289 1290
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
1291
ENUM_VALUE_LIST	OFF,ON
1292 1293 1294 1295 1296 1297 1298 1299 1300 1301 1302 1303 1304 1305
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	OPTIONAL
VARIABLE_NAME	INNODB_PURGE_BATCH_SIZE
SESSION_VALUE	NULL
DEFAULT_VALUE	300
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BIGINT UNSIGNED
VARIABLE_COMMENT	Number of UNDO log pages to purge in one batch from the history list.
NUMERIC_MIN_VALUE	1
NUMERIC_MAX_VALUE	5000
NUMERIC_BLOCK_SIZE	0
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	OPTIONAL
1306 1307 1308 1309 1310 1311 1312 1313 1314 1315 1316 1317
VARIABLE_NAME	INNODB_PURGE_RSEG_TRUNCATE_FREQUENCY
SESSION_VALUE	NULL
DEFAULT_VALUE	128
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BIGINT UNSIGNED
VARIABLE_COMMENT	Dictates rate at which UNDO records are purged. Value N means purge rollback segment(s) on every Nth iteration of purge invocation
NUMERIC_MIN_VALUE	1
NUMERIC_MAX_VALUE	128
NUMERIC_BLOCK_SIZE	0
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	OPTIONAL
1318 1319
VARIABLE_NAME	INNODB_PURGE_THREADS
SESSION_VALUE	NULL
1320
DEFAULT_VALUE	4
1321
VARIABLE_SCOPE	GLOBAL
1322 1323
VARIABLE_TYPE	INT UNSIGNED
VARIABLE_COMMENT	Number of tasks for purging transaction history
1324 1325 1326 1327 1328 1329 1330 1331 1332 1333 1334 1335 1336 1337 1338
NUMERIC_MIN_VALUE	1
NUMERIC_MAX_VALUE	32
NUMERIC_BLOCK_SIZE	0
ENUM_VALUE_LIST	NULL
READ_ONLY	YES
COMMAND_LINE_ARGUMENT	OPTIONAL
VARIABLE_NAME	INNODB_RANDOM_READ_AHEAD
SESSION_VALUE	NULL
DEFAULT_VALUE	OFF
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BOOLEAN
VARIABLE_COMMENT	Whether to use read ahead for random access within an extent.
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
1339
ENUM_VALUE_LIST	OFF,ON
1340 1341 1342 1343 1344 1345 1346 1347 1348 1349 1350 1351 1352 1353 1354 1355 1356 1357
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	NONE
VARIABLE_NAME	INNODB_READ_AHEAD_THRESHOLD
SESSION_VALUE	NULL
DEFAULT_VALUE	56
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BIGINT UNSIGNED
VARIABLE_COMMENT	Number of pages that must be accessed sequentially for InnoDB to trigger a readahead.
NUMERIC_MIN_VALUE	0
NUMERIC_MAX_VALUE	64
NUMERIC_BLOCK_SIZE	0
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
VARIABLE_NAME	INNODB_READ_IO_THREADS
SESSION_VALUE	NULL
DEFAULT_VALUE	4
VARIABLE_SCOPE	GLOBAL
1358
VARIABLE_TYPE	INT UNSIGNED
1359 1360 1361 1362 1363 1364 1365 1366 1367 1368 1369 1370 1371 1372 1373 1374
VARIABLE_COMMENT	Number of background read I/O threads in InnoDB.
NUMERIC_MIN_VALUE	1
NUMERIC_MAX_VALUE	64
NUMERIC_BLOCK_SIZE	0
ENUM_VALUE_LIST	NULL
READ_ONLY	YES
COMMAND_LINE_ARGUMENT	REQUIRED
VARIABLE_NAME	INNODB_READ_ONLY
SESSION_VALUE	NULL
DEFAULT_VALUE	OFF
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BOOLEAN
VARIABLE_COMMENT	Start InnoDB in read only mode (off by default)
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
1375
ENUM_VALUE_LIST	OFF,ON
1376 1377
READ_ONLY	YES
COMMAND_LINE_ARGUMENT	OPTIONAL
1378 1379
VARIABLE_NAME	INNODB_READ_ONLY_COMPRESSED
SESSION_VALUE	NULL
1380
DEFAULT_VALUE	OFF
1381 1382
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BOOLEAN
1383
VARIABLE_COMMENT	Make ROW_FORMAT=COMPRESSED tables read-only
1384 1385 1386 1387 1388 1389
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
ENUM_VALUE_LIST	OFF,ON
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	OPTIONAL
1390 1391 1392 1393 1394 1395 1396 1397 1398
VARIABLE_NAME	INNODB_ROLLBACK_ON_TIMEOUT
SESSION_VALUE	NULL
DEFAULT_VALUE	OFF
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BOOLEAN
VARIABLE_COMMENT	Roll back the complete transaction on lock wait timeout, for 4.x compatibility (disabled by default)
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
1399
ENUM_VALUE_LIST	OFF,ON
1400 1401 1402 1403 1404 1405
READ_ONLY	YES
COMMAND_LINE_ARGUMENT	OPTIONAL
VARIABLE_NAME	INNODB_SAVED_PAGE_NUMBER_DEBUG
SESSION_VALUE	NULL
DEFAULT_VALUE	0
VARIABLE_SCOPE	GLOBAL
1406
VARIABLE_TYPE	INT UNSIGNED
1407 1408 1409 1410 1411 1412 1413 1414 1415 1416 1417 1418 1419 1420 1421 1422 1423 1424 1425 1426 1427
VARIABLE_COMMENT	An InnoDB page number.
NUMERIC_MIN_VALUE	0
NUMERIC_MAX_VALUE	4294967295
NUMERIC_BLOCK_SIZE	0
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	OPTIONAL
VARIABLE_NAME	INNODB_SORT_BUFFER_SIZE
SESSION_VALUE	NULL
DEFAULT_VALUE	1048576
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BIGINT UNSIGNED
VARIABLE_COMMENT	Memory buffer size for index creation
NUMERIC_MIN_VALUE	65536
NUMERIC_MAX_VALUE	67108864
NUMERIC_BLOCK_SIZE	0
ENUM_VALUE_LIST	NULL
READ_ONLY	YES
COMMAND_LINE_ARGUMENT	REQUIRED
VARIABLE_NAME	INNODB_SPIN_WAIT_DELAY
SESSION_VALUE	NULL
1428
DEFAULT_VALUE	4
1429
VARIABLE_SCOPE	GLOBAL
1430
VARIABLE_TYPE	INT UNSIGNED
1431
VARIABLE_COMMENT	Maximum delay between polling for a spin lock (4 by default)
1432
NUMERIC_MIN_VALUE	0
1433
NUMERIC_MAX_VALUE	6000
1434 1435 1436 1437 1438 1439 1440 1441 1442 1443 1444 1445 1446
NUMERIC_BLOCK_SIZE	0
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	OPTIONAL
VARIABLE_NAME	INNODB_STATS_AUTO_RECALC
SESSION_VALUE	NULL
DEFAULT_VALUE	ON
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BOOLEAN
VARIABLE_COMMENT	InnoDB automatic recalculation of persistent statistics enabled for all tables unless overridden at table level (automatic recalculation is only done when InnoDB decides that the table has changed too much and needs a new statistics)
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
1447
ENUM_VALUE_LIST	OFF,ON
1448 1449
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	OPTIONAL
1450 1451 1452 1453 1454 1455 1456 1457 1458 1459 1460 1461
VARIABLE_NAME	INNODB_STATS_INCLUDE_DELETE_MARKED
SESSION_VALUE	NULL
DEFAULT_VALUE	OFF
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BOOLEAN
VARIABLE_COMMENT	Include delete marked records when calculating persistent statistics
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
ENUM_VALUE_LIST	OFF,ON
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	OPTIONAL
1462 1463 1464 1465 1466 1467 1468 1469 1470 1471 1472 1473
VARIABLE_NAME	INNODB_STATS_METHOD
SESSION_VALUE	NULL
DEFAULT_VALUE	nulls_equal
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	ENUM
VARIABLE_COMMENT	Specifies how InnoDB index statistics collection code should treat NULLs. Possible values are NULLS_EQUAL (default), NULLS_UNEQUAL and NULLS_IGNORED
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
ENUM_VALUE_LIST	nulls_equal,nulls_unequal,nulls_ignored
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
1474 1475 1476 1477 1478 1479 1480 1481 1482 1483 1484 1485
VARIABLE_NAME	INNODB_STATS_MODIFIED_COUNTER
SESSION_VALUE	NULL
DEFAULT_VALUE	0
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BIGINT UNSIGNED
VARIABLE_COMMENT	The number of rows modified before we calculate new statistics (default 0 = current limits)
NUMERIC_MIN_VALUE	0
NUMERIC_MAX_VALUE	18446744073709551615
NUMERIC_BLOCK_SIZE	0
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
1486 1487 1488 1489 1490 1491 1492 1493 1494
VARIABLE_NAME	INNODB_STATS_ON_METADATA
SESSION_VALUE	NULL
DEFAULT_VALUE	OFF
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BOOLEAN
VARIABLE_COMMENT	Enable statistics gathering for metadata commands such as SHOW TABLE STATUS for tables that use transient statistics (off by default)
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
1495
ENUM_VALUE_LIST	OFF,ON
1496 1497 1498 1499 1500 1501 1502 1503 1504 1505 1506
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	OPTIONAL
VARIABLE_NAME	INNODB_STATS_PERSISTENT
SESSION_VALUE	NULL
DEFAULT_VALUE	ON
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BOOLEAN
VARIABLE_COMMENT	InnoDB persistent statistics enabled for all tables unless overridden at table level
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
1507
ENUM_VALUE_LIST	OFF,ON
1508 1509 1510 1511 1512 1513 1514 1515 1516 1517 1518 1519 1520 1521
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	OPTIONAL
VARIABLE_NAME	INNODB_STATS_PERSISTENT_SAMPLE_PAGES
SESSION_VALUE	NULL
DEFAULT_VALUE	20
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BIGINT UNSIGNED
VARIABLE_COMMENT	The number of leaf index pages to sample when calculating persistent statistics (by ANALYZE, default 20)
NUMERIC_MIN_VALUE	1
NUMERIC_MAX_VALUE	18446744073709551615
NUMERIC_BLOCK_SIZE	0
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
1522 1523 1524 1525 1526 1527 1528 1529 1530
VARIABLE_NAME	INNODB_STATS_TRADITIONAL
SESSION_VALUE	NULL
DEFAULT_VALUE	ON
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BOOLEAN
VARIABLE_COMMENT	Enable traditional statistic calculation based on number of configured pages (default true)
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
1531
ENUM_VALUE_LIST	OFF,ON
1532 1533
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
1534 1535 1536 1537 1538 1539 1540 1541 1542 1543 1544 1545 1546 1547 1548 1549 1550 1551 1552 1553 1554
VARIABLE_NAME	INNODB_STATS_TRANSIENT_SAMPLE_PAGES
SESSION_VALUE	NULL
DEFAULT_VALUE	8
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BIGINT UNSIGNED
VARIABLE_COMMENT	The number of leaf index pages to sample when calculating transient statistics (if persistent statistics are not used, default 8)
NUMERIC_MIN_VALUE	1
NUMERIC_MAX_VALUE	18446744073709551615
NUMERIC_BLOCK_SIZE	0
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
VARIABLE_NAME	INNODB_STATUS_OUTPUT
SESSION_VALUE	NULL
DEFAULT_VALUE	OFF
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BOOLEAN
VARIABLE_COMMENT	Enable InnoDB monitor output to the error log.
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
1555
ENUM_VALUE_LIST	OFF,ON
1556 1557 1558 1559 1560 1561 1562 1563 1564 1565 1566
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	OPTIONAL
VARIABLE_NAME	INNODB_STATUS_OUTPUT_LOCKS
SESSION_VALUE	NULL
DEFAULT_VALUE	OFF
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BOOLEAN
VARIABLE_COMMENT	Enable InnoDB lock monitor output to the error log. Requires innodb_status_output=ON.
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
1567
ENUM_VALUE_LIST	OFF,ON
1568 1569 1570
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	OPTIONAL
VARIABLE_NAME	INNODB_STRICT_MODE
1571 1572
SESSION_VALUE	ON
DEFAULT_VALUE	ON
1573 1574 1575 1576 1577 1578
VARIABLE_SCOPE	SESSION
VARIABLE_TYPE	BOOLEAN
VARIABLE_COMMENT	Use strict mode when evaluating create options.
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
1579
ENUM_VALUE_LIST	OFF,ON
1580 1581 1582 1583 1584 1585 1586 1587 1588 1589 1590 1591 1592 1593 1594 1595 1596 1597 1598 1599 1600 1601 1602
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	OPTIONAL
VARIABLE_NAME	INNODB_SYNC_SPIN_LOOPS
SESSION_VALUE	NULL
DEFAULT_VALUE	30
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BIGINT UNSIGNED
VARIABLE_COMMENT	Count of spin-loop rounds in InnoDB mutexes (30 by default)
NUMERIC_MIN_VALUE	0
NUMERIC_MAX_VALUE	18446744073709551615
NUMERIC_BLOCK_SIZE	0
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
VARIABLE_NAME	INNODB_TABLE_LOCKS
SESSION_VALUE	ON
DEFAULT_VALUE	ON
VARIABLE_SCOPE	SESSION
VARIABLE_TYPE	BOOLEAN
VARIABLE_COMMENT	Enable InnoDB locking in LOCK TABLES
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
1603
ENUM_VALUE_LIST	OFF,ON
1604 1605
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	OPTIONAL
1606 1607
VARIABLE_NAME	INNODB_TEMP_DATA_FILE_PATH
SESSION_VALUE	NULL
1608
DEFAULT_VALUE	ibtmp1:12M:autoextend
1609 1610 1611 1612 1613 1614 1615 1616 1617
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	VARCHAR
VARIABLE_COMMENT	Path to files and their sizes making temp-tablespace.
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
ENUM_VALUE_LIST	NULL
READ_ONLY	YES
COMMAND_LINE_ARGUMENT	REQUIRED
1618 1619 1620 1621 1622 1623 1624 1625 1626 1627 1628 1629
VARIABLE_NAME	INNODB_TMPDIR
SESSION_VALUE	
DEFAULT_VALUE	
VARIABLE_SCOPE	SESSION
VARIABLE_TYPE	VARCHAR
VARIABLE_COMMENT	Directory for temporary non-tablespace files.
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	OPTIONAL
1630 1631 1632 1633 1634 1635 1636 1637 1638
VARIABLE_NAME	INNODB_TRX_PURGE_VIEW_UPDATE_ONLY_DEBUG
SESSION_VALUE	NULL
DEFAULT_VALUE	OFF
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BOOLEAN
VARIABLE_COMMENT	Pause actual purging any delete-marked records, but merely update the purge view. It is to create artificially the situation the purge view have been updated but the each purges were not done yet.
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
1639
ENUM_VALUE_LIST	OFF,ON
1640 1641 1642 1643 1644 1645 1646 1647 1648 1649 1650 1651 1652 1653 1654 1655
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	NULL
VARIABLE_NAME	INNODB_TRX_RSEG_N_SLOTS_DEBUG
SESSION_VALUE	NULL
DEFAULT_VALUE	0
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	INT UNSIGNED
VARIABLE_COMMENT	Debug flags for InnoDB to limit TRX_RSEG_N_SLOTS for trx_rsegf_undo_find_free()
NUMERIC_MIN_VALUE	0
NUMERIC_MAX_VALUE	1024
NUMERIC_BLOCK_SIZE	0
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	NULL
VARIABLE_NAME	INNODB_UNDO_DIRECTORY
SESSION_VALUE	NULL
1656
DEFAULT_VALUE	
1657 1658 1659 1660 1661 1662 1663 1664 1665
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	VARCHAR
VARIABLE_COMMENT	Directory where undo tablespace files live, this path can be absolute.
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
ENUM_VALUE_LIST	NULL
READ_ONLY	YES
COMMAND_LINE_ARGUMENT	REQUIRED
1666 1667 1668 1669 1670 1671 1672 1673 1674
VARIABLE_NAME	INNODB_UNDO_LOG_TRUNCATE
SESSION_VALUE	NULL
DEFAULT_VALUE	OFF
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BOOLEAN
VARIABLE_COMMENT	Enable or Disable Truncate of UNDO tablespace.
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
1675
ENUM_VALUE_LIST	OFF,ON
1676 1677
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	OPTIONAL
1678 1679 1680 1681 1682
VARIABLE_NAME	INNODB_UNDO_TABLESPACES
SESSION_VALUE	NULL
DEFAULT_VALUE	0
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BIGINT UNSIGNED
1683
VARIABLE_COMMENT	Number of undo tablespaces to use.
1684
NUMERIC_MIN_VALUE	0
1685
NUMERIC_MAX_VALUE	127
1686 1687 1688 1689 1690 1691
NUMERIC_BLOCK_SIZE	0
ENUM_VALUE_LIST	NULL
READ_ONLY	YES
COMMAND_LINE_ARGUMENT	REQUIRED
VARIABLE_NAME	INNODB_USE_ATOMIC_WRITES
SESSION_VALUE	NULL
1692
DEFAULT_VALUE	ON
1693 1694
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BOOLEAN
1695
VARIABLE_COMMENT	Enable atomic writes, instead of using the doublewrite buffer, for files on devices that supports atomic writes.
1696 1697 1698
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
1699
ENUM_VALUE_LIST	OFF,ON
1700 1701 1702 1703 1704 1705
READ_ONLY	YES
COMMAND_LINE_ARGUMENT	NONE
VARIABLE_NAME	INNODB_WRITE_IO_THREADS
SESSION_VALUE	NULL
DEFAULT_VALUE	4
VARIABLE_SCOPE	GLOBAL
1706
VARIABLE_TYPE	INT UNSIGNED
1707
VARIABLE_COMMENT	Number of background write I/O threads in InnoDB.
1708
NUMERIC_MIN_VALUE	2
1709 1710 1711 1712 1713
NUMERIC_MAX_VALUE	64
NUMERIC_BLOCK_SIZE	0
ENUM_VALUE_LIST	NULL
READ_ONLY	YES
COMMAND_LINE_ARGUMENT	REQUIRED