App-mycnfdiff
view release on metacpan or search on metacpan
t/samples/percona-compiled.txt view on Meta::CPAN
--innodb-flush-method=name
With which method to flush data.
--innodb-flush-neighbors[=#]
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
--innodb-flush-sync Allow IO bursts at the checkpoints ignoring io_capacity
setting.
(Defaults to on; use --skip-innodb-flush-sync to disable.)
--innodb-flushing-avg-loops=#
Number of iterations over which the background flushing
is averaged.
--innodb-force-load-corrupted
Force InnoDB to load metadata of corrupted table.
--innodb-force-recovery=#
Helps to save your data in case the disk image of the
database becomes corrupt.
--innodb-ft-aux-table
FTS internal auxiliary table to be checked
--innodb-ft-cache-size=#
InnoDB Fulltext search cache size in bytes
--innodb-ft-enable-diag-print
Whether to enable additional FTS diagnostic printout
--innodb-ft-enable-stopword
Create FTS index with stopword.
(Defaults to on; use --skip-innodb-ft-enable-stopword to disable.)
--innodb-ft-ignore-stopwords
Instruct FTS to ignore stopwords.
--innodb-ft-max-token-size=#
InnoDB Fulltext search maximum token size in characters
--innodb-ft-min-token-size=#
InnoDB Fulltext search minimum token size in characters
--innodb-ft-num-word-optimize[=#]
InnoDB Fulltext search number of words to optimize for
each optimize table call
--innodb-ft-result-cache-limit=#
InnoDB Fulltext search query result cache limit in bytes
--innodb-ft-server-stopword-table[=name]
The user supplied stopword table name.
--innodb-ft-sort-pll-degree=#
InnoDB Fulltext search parallel sort degree, will round
up to nearest power of 2 number
--innodb-ft-total-cache-size=#
Total memory allocated for InnoDB Fulltext Search cache
--innodb-ft-user-stopword-table[=name]
User supplied stopword table name, effective in the
session level.
--innodb-io-capacity=#
Number of IOPs the server can do. Tunes the background IO
rate
--innodb-io-capacity-max=#
Limit to which innodb_io_capacity can be inflated.
--innodb-kill-idle-transaction=#
A deprecated alias of kill_idle_transaction server
variable.
--innodb-large-prefix
Support large index prefix length of
REC_VERSION_56_MAX_INDEX_COL_LEN (3072) bytes.
(Defaults to on; use --skip-innodb-large-prefix to disable.)
--innodb-lock-wait-timeout=#
Timeout in seconds an InnoDB transaction may wait for a
lock before being rolled back. Values above 100000000
disable the timeout.
--innodb-locks-unsafe-for-binlog
DEPRECATED. This option may be removed in future
releases. Please use READ COMMITTED transaction isolation
level instead. Force InnoDB to not use next-key locking,
to use only row-level locking.
--innodb-log-buffer-size=#
The size of the buffer which InnoDB uses to write log to
the log files on disk.
--innodb-log-checksums
Whether to compute and require checksums for InnoDB redo
log blocks
(Defaults to on; use --skip-innodb-log-checksums to disable.)
--innodb-log-compressed-pages
Enables/disables the logging of entire compressed page
images. InnoDB logs the compressed pages to prevent
corruption if the zlib compression algorithm changes.
When turned OFF, InnoDB will assume that the zlib
compression algorithm doesn't change.
(Defaults to on; use --skip-innodb-log-compressed-pages to disable.)
--innodb-log-file-size=#
Size of each log file in a log group.
--innodb-log-files-in-group=#
Number of log files in the log group. InnoDB writes to
the files in a circular fashion.
--innodb-log-group-home-dir=name
Path to InnoDB log files.
--innodb-log-write-ahead-size=#
Redo log write ahead unit size to avoid read-on-write, it
should match the OS cache block IO size
--innodb-lru-scan-depth=#
How deep to scan LRU to keep it clean
--innodb-max-bitmap-file-size=#
The maximum size of changed page bitmap files
--innodb-max-changed-pages=#
The maximum number of rows for
INFORMATION_SCHEMA.INNODB_CHANGED_PAGES table, 0 -
unlimited
--innodb-max-dirty-pages-pct=#
Percentage of dirty pages allowed in bufferpool.
--innodb-max-dirty-pages-pct-lwm=#
Percentage of dirty pages at which flushing kicks in.
--innodb-max-purge-lag=#
Desired maximum length of the purge queue (0 = no limit)
--innodb-max-purge-lag-delay=#
Maximum delay of user threads in micro-seconds
--innodb-max-undo-log-size[=#]
Maximum size of UNDO tablespace in MB (If UNDO tablespace
grows beyond this size it will be truncated in due
course).
--innodb-monitor-disable=name
Turn off a monitor counter
--innodb-monitor-enable=name
Turn on a monitor counter
--innodb-monitor-reset=name
Reset a monitor counter
--innodb-monitor-reset-all=name
Reset all values for a monitor counter
--innodb-numa-interleave
t/samples/percona-compiled.txt view on Meta::CPAN
Track the redo log for changed pages and output a changed
page bitmap
--innodb-undo-directory=name
Directory where undo tablespace files live, this path can
be absolute.
--innodb-undo-log-truncate
Enable or Disable Truncate of UNDO tablespace.
--innodb-undo-logs[=#]
Number of rollback segments to use for storing undo logs.
(deprecated)
--innodb-undo-tablespaces=#
Number of undo tablespaces to use.
--innodb-use-global-flush-log-at-trx-commit
Use global innodb_flush_log_at_trx_commit value.
(default: ON).
(Defaults to on; use --skip-innodb-use-global-flush-log-at-trx-commit to disable.)
--innodb-use-native-aio
Use native AIO if supported on this platform.
(Defaults to on; use --skip-innodb-use-native-aio to disable.)
--innodb-write-io-threads=#
Number of background write I/O threads in InnoDB.
--interactive-timeout=#
The number of seconds the server waits for activity on an
interactive connection before closing it
--internal-tmp-disk-storage-engine[=name]
The default storage engine for on-disk internal tmp table
--join-buffer-size=#
The size of the buffer that is used for full joins
--keep-files-on-create
Don't overwrite stale .MYD and .MYI even if no directory
is specified
--key-buffer-size=# The size of the buffer used for index blocks for MyISAM
tables. Increase this to get better index handling (for
all reads and multiple writes) to as much as you can
afford
--key-cache-age-threshold=#
This characterizes the number of hits a hot block has to
be untouched until it is considered aged enough to be
downgraded to a warm block. This specifies the percentage
ratio of that number of hits to the total number of
blocks in key cache
--key-cache-block-size=#
The default size of key cache blocks
--key-cache-division-limit=#
The minimum percentage of warm blocks in key cache
--kill-idle-transaction=#
If non-zero, number of seconds to wait before killing
idle connections that have open transactions
-L, --language=name Client error messages in given language. May be given as
a full path. Deprecated. Use --lc-messages-dir instead.
--large-pages Enable support for large pages
--lc-messages=name Set the language used for the error messages.
--lc-messages-dir=name
Directory where error messages are
--lc-time-names=name
Set the language used for the month names and the days of
the week.
--local-infile Enable LOAD DATA LOCAL INFILE
(Defaults to on; use --skip-local-infile to disable.)
--lock-wait-timeout=#
Timeout in seconds to wait for a lock before returning an
error.
--log-bin[=name] Log update queries in binary format. Optional (but
strongly recommended to avoid replication problems if
server's hostname changes) argument should be the chosen
location for the binary log files.
--log-bin-index=name
File that holds the names for binary log files.
--log-bin-trust-function-creators
If set to FALSE (the default), then when --log-bin is
used, creation of a stored function (or trigger) is
allowed only to users having the SUPER privilege and only
if this stored function (trigger) may not break binary
logging. Note that if ALL connections to this server
ALWAYS use row-based binary logging, the security issues
do not exist and the binary logging cannot break, so you
can safely set this to TRUE
--log-bin-use-v1-row-events
If equal to 1 then version 1 row events are written to a
row based binary log. If equal to 0, then the latest
version of events are written. This option is useful
during some upgrades.
--log-builtin-as-identified-by-password
Controls logging of CREATE/ALTER/GRANT and SET PASSWORD
user statements in replication binlogs, general query
logs and audit logs.
--log-error[=name] Error log file
--log-error-verbosity=#
How detailed the error log should be. 1, log errors only.
2, log errors and warnings. 3, log errors, warnings, and
notes. Messages sent to the client are unaffected by this
setting.
--log-isam[=name] Log all MyISAM changes to file.
--log-output=name Syntax: log-output=value[,value...], where "value" could
be TABLE, FILE or NONE
--log-queries-not-using-indexes
Log queries that are executed without benefit of any
index to the slow log if it is open
--log-raw Log to general log before any rewriting of the query. For
use in debugging, not production as sensitive information
may be logged.
--log-short-format Don't log extra information to update and slow-query
logs.
--log-slave-updates Tells the slave to log the updates from the slave thread
to the binary log. You will need to turn it on if you
plan to daisy-chain the slaves
--log-slow-admin-statements
Log slow OPTIMIZE, ANALYZE, ALTER and other
administrative statements to the slow log if it is open.
--log-slow-filter=name
Log only the queries that followed certain execution
plan. Multiple flags allowed in a comma-separated string.
[qc_miss, full_scan, full_join, tmp_table,
tmp_table_on_disk, filesort, filesort_on_disk]
--log-slow-rate-limit=#
Rate limit statement writes to slow log to only those
from every (1/log_slow_rate_limit) session.
--log-slow-rate-type=name
Choose the log_slow_rate_limit behavior: session or
query. When you choose 'session' - every
%log_slow_rate_limit connection will be processed to slow
t/samples/percona-compiled.txt view on Meta::CPAN
updates. If you need cross database updates to work, make
sure you have 3.23.28 or later, and use
replicate-wild-ignore-table=db_name.%.
--replicate-ignore-table=name
Tells the slave thread to not replicate to the specified
table. To specify more than one table to ignore, use the
directive multiple times, once for each table. This will
work for cross-database updates, in contrast to
replicate-ignore-db.
--replicate-rewrite-db=name
Updates to a database with a different name than the
original. Example:
replicate-rewrite-db=master_db_name->slave_db_name.
--replicate-same-server-id
In replication, if set to 1, do not skip events having
our server id. Default value is 0 (to break infinite
loops in circular replication). Can't be set to 1 if
--log-slave-updates is used.
--replicate-wild-do-table=name
Tells the slave thread to restrict replication to the
tables that match the specified wildcard pattern. To
specify more than one table, use the directive multiple
times, once for each table. This will work for
cross-database updates. Example:
replicate-wild-do-table=foo%.bar% will replicate only
updates to tables in all databases that start with foo
and whose table names start with bar.
--replicate-wild-ignore-table=name
Tells the slave thread to not replicate to the tables
that match the given wildcard pattern. To specify more
than one table to ignore, use the directive multiple
times, once for each table. This will work for
cross-database updates. Example:
replicate-wild-ignore-table=foo%.bar% will not do updates
to tables in databases that start with foo and whose
table names start with bar.
--report-host=name Hostname or IP of the slave to be reported to the master
during slave registration. Will appear in the output of
SHOW SLAVE HOSTS. Leave unset if you do not want the
slave to register itself with the master. Note that it is
not sufficient for the master to simply read the IP of
the slave off the socket once the slave connects. Due to
NAT and other routing issues, that IP may not be valid
for connecting to the slave from the master or other
hosts
--report-password=name
The account password of the slave to be reported to the
master during slave registration
--report-port=# Port for connecting to slave reported to the master
during slave registration. Set it only if the slave is
listening on a non-default port or if you have a special
tunnel from the master or other clients to the slave. If
not sure, leave this option unset
--report-user=name The account user name of the slave to be reported to the
master during slave registration
--require-secure-transport
When this option is enabled, connections attempted using
insecure transport will be rejected. Secure transports
are SSL/TLS, Unix socket or Shared Memory (on Windows).
--rpl-stop-slave-timeout=#
Timeout in seconds to wait for slave to stop before
returning a warning.
--safe-user-create Don't allow new user creation by the user who has no
write privileges to the mysql.user table.
--secure-auth Disallow authentication for accounts that have old
(pre-4.1) passwords. Deprecated. Always TRUE.
(Defaults to on; use --skip-secure-auth to disable.)
--secure-file-priv=name
Limit LOAD DATA, SELECT ... OUTFILE, and LOAD_FILE() to
files within specified directory
--server-id=# Uniquely identifies the server instance in the community
of replication partners
--server-id-bits=# Set number of significant bits in server-id
--session-track-gtids=name
Controls the amount of global transaction ids to be
included in the response packet sent by the
server.(Default: OFF).
--session-track-schema
Track changes to the 'default schema'.
(Defaults to on; use --skip-session-track-schema to disable.)
--session-track-state-change
Track changes to the 'session state'.
--session-track-system-variables=name
Track changes in registered system variables.
--session-track-transaction-info=name
Track changes to the transaction attributes. OFF to
disable; STATE to track just transaction state (Is there
an active transaction? Does it have any data? etc.);
CHARACTERISTICS to track transaction state and report all
statements needed to start a transaction with the same
characteristics (isolation level, read only/read write,
snapshot - but not any work done / data modified within
the transaction).
--sha256-password-auto-generate-rsa-keys
Auto generate RSA keys at server startup if correpsonding
system variables are not specified and key files are not
present at the default location.
(Defaults to on; use --skip-sha256-password-auto-generate-rsa-keys to disable.)
--sha256-password-private-key-path=name
A fully qualified path to the private RSA key used for
authentication
--sha256-password-proxy-users
If set to FALSE (the default), then the sha256_password
authentication plugin will not signal for authenticated
users to be checked for mapping to proxy users. When set
to TRUE, the plugin will flag associated authenticated
accounts to be mapped to proxy users when the server
option check_proxy_users is enabled.
--sha256-password-public-key-path=name
A fully qualified path to the public RSA key used for
authentication
--show-compatibility-56
SHOW commands / INFORMATION_SCHEMA tables compatible with
MySQL 5.6
--show-old-temporals
When this option is enabled, the pre-5.6.4 temporal types
will be marked in the 'SHOW CREATE TABLE' and
'INFORMATION_SCHEMA.COLUMNS' table as a comment in
COLUMN_TYPE field. This variable is deprecated and will
be removed in a future release.
--show-slave-auth-info
t/samples/percona-compiled.txt view on Meta::CPAN
exception for replication (slave) threads. Users with
the SUPER privilege are affected, unlike read_only.
Setting super_read_only to ON also sets read_only to ON.
-s, --symbolic-links
Enable symbolic link support.
(Defaults to on; use --skip-symbolic-links to disable.)
--sync-binlog=# Synchronously flush binary log to disk after every #th
write to the file. Use 0 to disable synchronous flushing
--sync-frm Sync .frm files to disk on creation
(Defaults to on; use --skip-sync-frm to disable.)
--sync-master-info=#
Synchronously flush master info to disk after every #th
event. Use 0 to disable synchronous flushing
--sync-relay-log=# Synchronously flush relay log to disk after every #th
event. Use 0 to disable synchronous flushing
--sync-relay-log-info=#
Synchronously flush relay log info to disk after every
#th transaction. Use 0 to disable synchronous flushing
--sysdate-is-now Non-default option to alias SYSDATE() to NOW() to make it
safe-replicable. Since 5.0, SYSDATE() returns a `dynamic'
value different for different invocations, even within
the same statement.
--table-definition-cache=#
The number of cached table definitions
--table-open-cache=#
The number of cached open tables (total for all table
cache instances)
--table-open-cache-instances=#
The number of table cache instances
--tc-heuristic-recover=name
Decision to use in heuristic recover process. Possible
values are OFF, COMMIT or ROLLBACK.
--temp-pool This option is deprecated and will be removed in a future
version. Using this option will cause most temporary
files created to use a small set of names, rather than a
unique name for each new file.
(Defaults to on; use --skip-temp-pool to disable.)
--thread-cache-size=#
How many threads we should keep in a cache for reuse
--thread-handling=name
Define threads usage for handling queries, one of
one-thread-per-connection, no-threads, pool-of-threads
--thread-pool-high-prio-mode=name
High priority queue mode: one of 'transactions',
'statements' or 'none'. In the 'transactions' mode the
thread pool uses both high- and low-priority queues
depending on whether an event is generated by an already
started transaction or a connection holding a MDL, table,
user, or a global read or backup lock and whether it has
any high priority tickets (see
thread_pool_high_prio_tickets). In the 'statements' mode
all events (i.e. individual statements) always go to the
high priority queue, regardless of the current
transaction and lock state and high priority tickets.
'none' is the opposite of 'statements', i.e. disables the
high priority queue completely.
--thread-pool-high-prio-tickets=#
Number of tickets to enter the high priority event queue
for each transaction.
--thread-pool-idle-timeout=#
Timeout in seconds for an idle thread in the thread
pool.Worker thread will be shut down after timeout
--thread-pool-max-threads=#
Maximum allowed number of worker threads in the thread
pool
--thread-pool-oversubscribe=#
How many additional active worker threads in a group are
allowed.
--thread-pool-size=#
Number of thread groups in the pool. This parameter is
roughly equivalent to maximum number of concurrently
executing threads (threads in a waiting state do not
count as executing).
--thread-pool-stall-limit=#
Maximum query execution time in milliseconds,before an
executing non-yielding thread is considered stalled.If a
worker thread is stalled, additional worker thread may be
created to handle remaining clients.
--thread-stack=# The stack size for each thread
--thread-statistics Control TABLE_STATISTICS running, when userstat is
enabled
--time-format=name The TIME format (ignored)
--tls-version=name TLS version, permitted values are TLSv1, TLSv1.1,
TLSv1.2(Only for openssl)
--tmp-table-size=# If an internal in-memory temporary table exceeds this
size, MySQL will automatically convert it to an on-disk
MyISAM table
-t, --tmpdir=name Path for temporary files. Several paths may be specified,
separated by a colon (:), in this case they are used in a
round-robin fashion
--transaction-alloc-block-size=#
Allocation block size for transactions to be stored in
binary log
--transaction-isolation=name
Default transaction isolation level.
--transaction-prealloc-size=#
Persistent buffer for transactions to be stored in binary
log
--transaction-read-only
Default transaction access mode. True if transactions are
read-only.
--transaction-write-set-extraction[=name]
This option is used to let the server know when to
extract the write set which will be used for various
purposes.
--updatable-views-with-limit=name
YES = Don't issue an error message (warning only) if a
VIEW without presence of a key of the underlying table is
used in queries with a LIMIT clause for updating. NO =
Prohibit update of a VIEW, which does not contain a key
of the underlying table and the query uses a LIMIT clause
(usually get from GUI tools)
-u, --user=name Run mysqld daemon as user.
--userstat Control USER_STATISTICS, CLIENT_STATISTICS,
THREAD_STATISTICS, INDEX_STATISTICS and TABLE_STATISTICS
running
--utility-user=name Specifies a MySQL user that will be added to the internal
list of users and recognized as the utility user.
--utility-user-password=name
Specifies the password required for the utility user.
--utility-user-privileges=name
( run in 1.792 second using v1.01-cache-2.11-cpan-39bf76dae61 )