App-mycnfdiff
view release on metacpan or search on metacpan
t/samples/percona-compiled.txt view on Meta::CPAN
--innodb-autoextend-increment=#
Data file autoextend increment in megabytes
--innodb-autoinc-lock-mode=#
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)
--innodb-buffer-pool-chunk-size=#
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
t/samples/percona-compiled.txt view on Meta::CPAN
be removed in a future release.
--show-slave-auth-info
Show user and password in SHOW SLAVE HOSTS on this
master.
--skip-grant-tables Start without grant tables. This gives all users FULL
ACCESS to all tables.
--skip-host-cache Don't cache host names.
--skip-name-resolve Don't resolve hostnames. All hostnames are IP's or
'localhost'.
--skip-networking Don't allow connection with TCP/IP
--skip-new Don't use new, possibly wrong routines.
--skip-show-database
Don't allow 'SHOW DATABASE' commands
--skip-slave-start If set, slave is not autostarted.
--skip-stack-trace Don't print a stack trace on failure.
--slave-allow-batching
Allow slave to batch requests
--slave-checkpoint-group=#
Maximum number of processed transactions by
Multi-threaded slave before a checkpoint operation is
called to update progress status.
--slave-checkpoint-period=#
Gather workers' activities to Update progress status of
Multi-threaded slave and flush the relay log info to disk
after every #th milli-seconds.
--slave-compressed-protocol
Use compression on master/slave protocol
--slave-exec-mode=name
Modes for how replication events should be executed.
Legal values are STRICT (default) and IDEMPOTENT. In
IDEMPOTENT mode, replication will not stop for operations
that are idempotent. In STRICT mode, replication will
stop on any unexpected difference between the master and
the slave
--slave-load-tmpdir=name
The location where the slave should put its temporary
files when replicating a LOAD DATA INFILE command
--slave-max-allowed-packet=#
The maximum packet length to sent successfully from the
master to slave.
--slave-net-timeout=#
Number of seconds to wait for more data from a
master/slave connection before aborting the read
--slave-parallel-type=name
Specifies if the slave will use database partitioning or
information from master to parallelize
transactions.(Default: DATABASE).
--slave-parallel-workers=#
Number of worker threads for executing events in parallel
--slave-pending-jobs-size-max=#
Max size of Slave Worker queues holding yet not applied
events.The least possible value must be not less than the
master side max_allowed_packet.
--slave-preserve-commit-order
Force slave workers to make commits in the same order as
on the master. Disabled by default.
--slave-rows-search-algorithms=name
Set of searching algorithms that the slave will use while
searching for records from the storage engine to either
updated or deleted them. Possible values are: INDEX_SCAN,
TABLE_SCAN and HASH_SCAN. Any combination is allowed, and
the slave will always pick the most suitable algorithm
for any given scenario. (Default: INDEX_SCAN,
TABLE_SCAN).
--slave-skip-errors=name
Tells the slave thread to continue replication when a
query event returns an error from the provided list
--slave-sql-verify-checksum
Force checksum verification of replication events after
reading them from relay log. Note: Events are always
checksum-verified by slave on receiving them from the
network before writing them to the relay log. Enabled by
default.
(Defaults to on; use --skip-slave-sql-verify-checksum to disable.)
--slave-transaction-retries=#
Number of times the slave SQL thread will retry a
transaction in case it failed with a deadlock or elapsed
lock wait timeout, before giving up and stopping
--slave-type-conversions=name
Set of slave type conversions that are enabled. Legal
values are: ALL_LOSSY to enable lossy conversions,
ALL_NON_LOSSY to enable non-lossy conversions,
ALL_UNSIGNED to treat all integer column type data to be
unsigned values, and ALL_SIGNED to treat all integer
column type data to be signed values. Default treatment
is ALL_SIGNED. If ALL_SIGNED and ALL_UNSIGNED both are
specified, ALL_SIGNED will take higher priority than
ALL_UNSIGNED. If the variable is assigned the empty set,
no conversions are allowed and it is expected that the
types match exactly.
--slow-launch-time=#
If creating the thread takes longer than this value (in
seconds), the Slow_launch_threads counter will be
incremented
--slow-query-log Log slow queries to a table or log file. Defaults logging
to a file hostname-slow.log or a table mysql.slow_log if
--log-output=TABLE is used. Must be enabled to activate
other slow log options
--slow-query-log-always-write-time=#
Log queries which run longer than specified by this value
regardless of the log_slow_rate_limit valiue.
--slow-query-log-file=name
Log slow queries to given log file. Defaults logging to
hostname-slow.log. Must be enabled to activate other slow
log options
--slow-query-log-use-global-control=name
Choose flags, wich always use the global variables.
Multiple flags allowed in a comma-separated string.
[none, log_slow_filter, log_slow_rate_limit,
log_slow_verbosity, long_query_time,
min_examined_row_limit, all]
--socket=name Socket file to use for connection
--sort-buffer-size=#
Each thread that needs to do a sort allocates a buffer of
this size
--sporadic-binlog-dump-fail
Option used by mysql-test for debugging and testing of
replication.
--sql-mode=name Syntax: sql-mode=mode[,mode[,mode...]]. See the manual
for the complete list of valid sql modes
( run in 0.802 second using v1.01-cache-2.11-cpan-97f6503c9c8 )