App-mycnfdiff
view release on metacpan or search on metacpan
t/samples/percona-compiled.txt view on Meta::CPAN
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
--ssl Enable SSL for connection (automatically enabled with
other flags).
(Defaults to on; use --skip-ssl to disable.)
--ssl-ca=name CA file in PEM format (check OpenSSL docs, implies --ssl)
--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.
( run in 0.816 second using v1.01-cache-2.11-cpan-ceb78f64989 )