App-mycnfdiff
view release on metacpan or search on metacpan
t/samples/percona-compiled.txt view on Meta::CPAN
Size of a single memory chunk within each buffer pool
instance for resizing buffer pool. Online buffer pool
resizing happens at this granularity. 0 means disable
resizing buffer pool.
--innodb-buffer-pool-dump-at-shutdown
Dump the buffer pool into a file named
@@innodb_buffer_pool_filename
(Defaults to on; use --skip-innodb-buffer-pool-dump-at-shutdown to disable.)
--innodb-buffer-pool-dump-now
Trigger an immediate dump of the buffer pool into a file
named @@innodb_buffer_pool_filename
--innodb-buffer-pool-dump-pct=#
Dump only the hottest N% of each buffer pool, defaults to
25
--innodb-buffer-pool-filename=name
Filename to/from which to dump/load the InnoDB buffer
pool
--innodb-buffer-pool-instances=#
Number of buffer pool instances, set to higher value on
high-end machines to increase scalability
--innodb-buffer-pool-load-abort
Abort a currently running load of the buffer pool
--innodb-buffer-pool-load-at-startup
Load the buffer pool from a file named
@@innodb_buffer_pool_filename
(Defaults to on; use --skip-innodb-buffer-pool-load-at-startup to disable.)
--innodb-buffer-pool-load-now
Trigger an immediate load of the buffer pool from a file
named @@innodb_buffer_pool_filename
--innodb-buffer-pool-size=#
The size of the memory buffer InnoDB uses to cache data
and indexes of its tables.
--innodb-change-buffer-max-size=#
Maximum on-disk size of change buffer in terms of
percentage of the buffer pool.
--innodb-change-buffering=name
Buffer changes to reduce random access: OFF, ON,
inserting, deleting, changing, or purging.
--innodb-checksum-algorithm=name
The algorithm InnoDB uses for page checksumming. Possible
values are CRC32 (hardware accelerated if the CPU
supports it) 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 (same as innodb_checksums=OFF);
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 MySQL versions older than 5.6.3
--innodb-checksums DEPRECATED. Use innodb_checksum_algorithm=NONE instead of
setting this to OFF. Enable InnoDB checksums validation
(enabled by default). Disable with
--skip-innodb-checksums.
(Defaults to on; use --skip-innodb-checksums to disable.)
--innodb-cleaner-lsn-age-factor[=name]
The formula for LSN age factor for page cleaner adaptive
flushing. LEGACY: Original Oracle MySQL 5.6 formula.
HIGH_CHECKPOINT: (the default) Percona Server 5.6
formula.
--innodb-cmp-per-index-enabled
Enable INFORMATION_SCHEMA.innodb_cmp_per_index, may have
negative impact on performance (off by default)
--innodb-commit-concurrency=#
Helps in performance tuning in heavily concurrent
environments.
--innodb-compressed-columns-threshold=#
Compress column data if its length exceeds this value.
Default is 96
--innodb-compressed-columns-zip-level=#
Compression level used for compressed columns. 0 is no
compression, 1 is fastest and 9 is best compression.
Default is 6.
--innodb-compression-failure-threshold-pct[=#]
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
--innodb-compression-level=#
Compression level used for compressed row format. 0 is
no compression, 1 is fastest, 9 is best compression and
default is 6.
--innodb-compression-pad-pct-max[=#]
Percentage of empty space on a data page that can be
reserved to make the page compressible.
--innodb-concurrency-tickets=#
Number of times a thread is allowed to enter InnoDB
within the same SQL query after it has once got the
ticket
--innodb-corrupt-table-action=name
Warn corruptions of user tables as 'corrupt table'
instead of not crashing itself, when used with
file_per_table. All file io for the datafile after
detected as corrupt are disabled, except for the
deletion.
--innodb-data-file-path=name
Path to individual files and their sizes.
--innodb-data-home-dir=name
The common part for InnoDB table spaces.
--innodb-deadlock-detect
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.
(Defaults to on; use --skip-innodb-deadlock-detect to disable.)
--innodb-default-row-format=name
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
--innodb-disable-sort-file-cache
Whether to disable OS system file cache for sort I/O
--innodb-doublewrite
Enable InnoDB doublewrite buffer (enabled by default).
Disable with --skip-innodb-doublewrite.
(Defaults to on; use --skip-innodb-doublewrite to disable.)
--innodb-empty-free-list-algorithm[=name]
The algorithm to use for empty free list handling.
Allowed values: LEGACY: (default) Original Oracle MySQL
5.6 handling with single page flushes; BACKOFF: Wait
until cleaner produces a free page.
--innodb-fast-shutdown[=#]
( run in 0.821 second using v1.01-cache-2.11-cpan-cd2fffc590a )