App-mycnfdiff
view release on metacpan or search on metacpan
t/samples/percona-compiled.txt view on Meta::CPAN
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
query log. When you choose 'query' - every
%log_slow_rate_limit query will be processed to slow
query log. [session, query]
--log-slow-slave-statements
Log slow statements executed by slave thread to the slow
log if it is open.
--log-slow-sp-statements[=name]
Choice between logging slow CALL statements, logging
individual slow statements inside stored procedures or
skipping the logging of stored procedures into the slow
log entirely. Values are OFF, ON and OFF_NO_CALLS
respectively.
--log-slow-verbosity=name
Choose how verbose the messages to your slow log will be.
Multiple flags allowed in a comma-separated string.
[microtime, query_plan, innodb, profiling,
profiling_use_getrusage]
--log-statements-unsafe-for-binlog
Log statements considered unsafe when using statement
based binary logging.
(Defaults to on; use --skip-log-statements-unsafe-for-binlog to disable.)
--log-syslog Errors, warnings, and similar issues eligible for MySQL's
error log file may additionally be sent to the host
operating system's system log ("syslog").
--log-syslog-facility=name
When logging issues using the host operating system's
syslog, identify as a facility of the given type (to aid
in log filtering).
--log-syslog-include-pid
When logging issues using the host operating system's
syslog, include this MySQL server's process ID (PID).
This setting does not affect MySQL's own error log file.
(Defaults to on; use --skip-log-syslog-include-pid to disable.)
--log-syslog-tag=name
When logging issues using the host operating system's
syslog, tag the entries from this particular MySQL server
with this ident. This will help distinguish entries from
MySQL servers co-existing on the same host machine. A
non-empty tag will be appended to the default ident of
'mysqld', connected by a hyphen.
--log-tc=name Path to transaction coordinator log (used for
transactions that affect more than one storage engine,
when binary log is disabled).
--log-tc-size=# Size of transaction coordinator log.
--log-throttle-queries-not-using-indexes=#
Log at most this many 'not using index' warnings per
minute to the slow log. Any further warnings will be
condensed into a single summary line. A value of 0
disables throttling. Option has no effect unless
--log_queries_not_using_indexes is set.
--log-timestamps=name
UTC to timestamp log files in zulu time, for more concise
timestamps and easier correlation of logs from servers
from multiple time zones, or SYSTEM to use the system's
local time. This affects only log files, not log tables,
as the timestamp columns of the latter can be converted
at will.
-W, --log-warnings[=#]
Log some not critical warnings to the log file
--long-query-time=# Log all queries that have taken more than long_query_time
seconds to execute to file. The argument will be treated
as a decimal value with microsecond precision
--low-priority-updates
INSERT/DELETE/UPDATE has lower priority than selects
--lower-case-table-names[=#]
If set to 1 table names are stored in lowercase on disk
and table names will be case-insensitive. Should be set
to 2 if you are using a case insensitive file system
--master-info-file=name
The location and name of the file that remembers the
master and where the I/O replication thread is in the
master's binlogs.
--master-info-repository=name
Defines the type of the repository for the master
information.
--master-retry-count=#
The number of tries the slave will make to connect to the
master before giving up. Deprecated option, use 'CHANGE
MASTER TO master_retry_count = <num>' instead.
--master-verify-checksum
Force checksum verification of logged events in binary
log before sending them to slaves or printing them in
output of SHOW BINLOG EVENTS. Disabled by default.
--max-allowed-packet=#
Max packet length to send to or receive from the server
--max-binlog-cache-size=#
Sets the total size of the transactional cache
--max-binlog-dump-events=#
Option used by mysql-test for debugging and testing of
replication.
--max-binlog-files=#
Maximum number of binlog files. Used with
--max-binlog-size this can be used to limit the total
amount of disk space used for the binlog. Default is 0,
don't limit.
--max-binlog-size=# Binary log will be rotated automatically when the size
exceeds this value. Will also apply to relay logs if
max_relay_log_size is 0
--max-binlog-stmt-cache-size=#
Sets the total size of the statement cache
--max-connect-errors=#
If there is more than this number of interrupted
connections from a host this host will be blocked from
further connections
--max-connections=# The number of simultaneous clients allowed
--max-delayed-threads=#
Don't start more than this number of threads to handle
INSERT DELAYED statements. If set to zero INSERT DELAYED
will be not used. This variable is deprecated along with
INSERT DELAYED.
( run in 1.599 second using v1.01-cache-2.11-cpan-0d23b851a93 )