App-mycnfdiff
view release on metacpan or search on metacpan
t/samples/percona-compiled.txt view on Meta::CPAN
--ssl-capath=name CA directory (check OpenSSL docs, implies --ssl)
--ssl-cert=name X509 cert in PEM format (implies --ssl)
--ssl-cipher=name SSL cipher to use (implies --ssl)
--ssl-crl=name CRL file in PEM format (check OpenSSL docs, implies
--ssl)
--ssl-crlpath=name CRL directory (check OpenSSL docs, implies --ssl)
--ssl-key=name X509 key in PEM format (implies --ssl)
--stored-program-cache=#
The soft upper limit for number of cached stored routines
for one connection.
--super-large-pages Enable support for super large pages.
--super-read-only Make all non-temporary tables read-only, with the
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 =
( run in 2.705 seconds using v1.01-cache-2.11-cpan-c966e8aa7e8 )