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 )