Debian Codegraph @

mysql-test/suite/sys_vars/r/sysvars_innodb.result

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