App-mycnfdiff
view release on metacpan or search on metacpan
t/samples/percona-compiled.txt view on Meta::CPAN
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.
--max-digest-length=#
Maximum length considered for digest text.
--max-error-count=# Max number of errors/warnings to store for a statement
--max-execution-time=#
Kill SELECT statement that takes over the specified
number of milliseconds
--max-heap-table-size=#
Don't allow creation of heap tables bigger than this
--max-join-size=# Joins that are probably going to read more than
max_join_size records return an error
--max-length-for-sort-data=#
Max number of bytes in sorted records
--max-points-in-geometry[=#]
Maximum number of points in a geometry
--max-prepared-stmt-count=#
Maximum number of prepared statements in the server
--max-relay-log-size=#
If non-zero: relay log will be rotated automatically when
the size exceeds this value; if zero: when the size
exceeds max_binlog_size
--max-seeks-for-key=#
Limit assumed max number of seeks when looking up rows
based on a key
--max-slowlog-files=#
Maximum number of slow query log files. Used with
--max-slowlog-size this can be used to limit the total
amount of disk space used for the slow query log. Default
is 0, don't limit.
--max-slowlog-size=#
Slow query log will be rotated automatically when the
t/samples/percona-compiled.txt view on Meta::CPAN
'localhost'.
--skip-networking Don't allow connection with TCP/IP
--skip-new Don't use new, possibly wrong routines.
--skip-show-database
Don't allow 'SHOW DATABASE' commands
--skip-slave-start If set, slave is not autostarted.
--skip-stack-trace Don't print a stack trace on failure.
--slave-allow-batching
Allow slave to batch requests
--slave-checkpoint-group=#
Maximum number of processed transactions by
Multi-threaded slave before a checkpoint operation is
called to update progress status.
--slave-checkpoint-period=#
Gather workers' activities to Update progress status of
Multi-threaded slave and flush the relay log info to disk
after every #th milli-seconds.
--slave-compressed-protocol
Use compression on master/slave protocol
--slave-exec-mode=name
Modes for how replication events should be executed.
Legal values are STRICT (default) and IDEMPOTENT. In
IDEMPOTENT mode, replication will not stop for operations
that are idempotent. In STRICT mode, replication will
stop on any unexpected difference between the master and
the slave
--slave-load-tmpdir=name
The location where the slave should put its temporary
files when replicating a LOAD DATA INFILE command
--slave-max-allowed-packet=#
The maximum packet length to sent successfully from the
master to slave.
--slave-net-timeout=#
Number of seconds to wait for more data from a
master/slave connection before aborting the read
--slave-parallel-type=name
Specifies if the slave will use database partitioning or
information from master to parallelize
transactions.(Default: DATABASE).
--slave-parallel-workers=#
Number of worker threads for executing events in parallel
--slave-pending-jobs-size-max=#
Max size of Slave Worker queues holding yet not applied
events.The least possible value must be not less than the
master side max_allowed_packet.
--slave-preserve-commit-order
Force slave workers to make commits in the same order as
on the master. Disabled by default.
--slave-rows-search-algorithms=name
Set of searching algorithms that the slave will use while
searching for records from the storage engine to either
updated or deleted them. Possible values are: INDEX_SCAN,
TABLE_SCAN and HASH_SCAN. Any combination is allowed, and
the slave will always pick the most suitable algorithm
for any given scenario. (Default: INDEX_SCAN,
TABLE_SCAN).
--slave-skip-errors=name
Tells the slave thread to continue replication when a
query event returns an error from the provided list
--slave-sql-verify-checksum
Force checksum verification of replication events after
reading them from relay log. Note: Events are always
checksum-verified by slave on receiving them from the
network before writing them to the relay log. Enabled by
default.
(Defaults to on; use --skip-slave-sql-verify-checksum to disable.)
--slave-transaction-retries=#
Number of times the slave SQL thread will retry a
transaction in case it failed with a deadlock or elapsed
lock wait timeout, before giving up and stopping
--slave-type-conversions=name
Set of slave type conversions that are enabled. Legal
values are: ALL_LOSSY to enable lossy conversions,
ALL_NON_LOSSY to enable non-lossy conversions,
ALL_UNSIGNED to treat all integer column type data to be
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.
t/samples/percona-compiled.txt view on Meta::CPAN
innodb-track-changed-pages FALSE
innodb-undo-directory (No default value)
innodb-undo-log-truncate FALSE
innodb-undo-logs 128
innodb-undo-tablespaces 0
innodb-use-global-flush-log-at-trx-commit TRUE
innodb-use-native-aio TRUE
innodb-write-io-threads 4
interactive-timeout 28800
internal-tmp-disk-storage-engine InnoDB
join-buffer-size 262144
keep-files-on-create FALSE
key-buffer-size 8388608
key-cache-age-threshold 300
key-cache-block-size 1024
key-cache-division-limit 100
kill-idle-transaction 0
language /usr/share/mysql/
large-pages FALSE
lc-messages en_US
lc-messages-dir /usr/share/mysql/
lc-time-names en_US
local-infile TRUE
lock-wait-timeout 31536000
log-bin (No default value)
log-bin-index (No default value)
log-bin-trust-function-creators FALSE
log-bin-use-v1-row-events FALSE
log-builtin-as-identified-by-password FALSE
log-error stderr
log-error-verbosity 1
log-isam myisam.log
log-output FILE
log-queries-not-using-indexes FALSE
log-raw FALSE
log-short-format FALSE
log-slave-updates FALSE
log-slow-admin-statements FALSE
log-slow-filter
log-slow-rate-limit 1
log-slow-rate-type session
log-slow-slave-statements FALSE
log-slow-sp-statements ON
log-slow-verbosity
log-statements-unsafe-for-binlog TRUE
log-syslog FALSE
log-syslog-facility daemon
log-syslog-include-pid TRUE
log-syslog-tag
log-tc tc.log
log-tc-size 24576
log-throttle-queries-not-using-indexes 0
log-timestamps UTC
log-warnings 0
long-query-time 10
low-priority-updates FALSE
lower-case-table-names 0
master-info-file master.info
master-info-repository FILE
master-retry-count 86400
master-verify-checksum FALSE
max-allowed-packet 4194304
max-binlog-cache-size 18446744073709547520
max-binlog-dump-events 0
max-binlog-files 0
max-binlog-size 1073741824
max-binlog-stmt-cache-size 18446744073709547520
max-connect-errors 100
max-connections 151
max-delayed-threads 20
max-digest-length 1024
max-error-count 64
max-execution-time 0
max-heap-table-size 16777216
max-join-size 18446744073709551615
max-length-for-sort-data 1024
max-points-in-geometry 65536
max-prepared-stmt-count 16382
max-relay-log-size 0
max-seeks-for-key 18446744073709551615
max-slowlog-files 0
max-slowlog-size 0
max-sort-length 1024
max-sp-recursion-depth 0
max-tmp-tables 32
max-user-connections 0
max-write-lock-count 18446744073709551615
memlock FALSE
metadata-locks-cache-size 1024
metadata-locks-hash-instances 8
min-examined-row-limit 0
multi-range-count 256
myisam-block-size 1024
myisam-data-pointer-size 6
myisam-max-sort-file-size 9223372036853727232
myisam-mmap-size 18446744073709551615
myisam-recover-options OFF
myisam-repair-threads 1
myisam-sort-buffer-size 8388608
myisam-stats-method nulls_unequal
myisam-use-mmap FALSE
mysql-native-password-proxy-users FALSE
net-buffer-length 16384
net-read-timeout 30
net-retry-count 10
net-write-timeout 60
new FALSE
ngram ON
ngram-token-size 2
offline-mode FALSE
old FALSE
old-alter-table FALSE
old-passwords 0
old-style-user-limits FALSE
open-files-limit 1048576
optimizer-prune-level 1
optimizer-search-depth 62
optimizer-switch index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,engine_condition_pushdown=on,index_condition_pushdown=on,mrr=on,mrr_cost_based=on,block_nested_loop...
optimizer-trace
optimizer-trace-features greedy_search=on,range_optimizer=on,dynamic_range=on,repeated_subselect=on
optimizer-trace-limit 1
t/samples/percona-compiled.txt view on Meta::CPAN
query-cache-size 1048576
query-cache-strip-comments FALSE
query-cache-type OFF
query-cache-wlock-invalidate FALSE
query-prealloc-size 8192
range-alloc-block-size 4096
range-optimizer-max-mem-size 8388608
read-buffer-size 131072
read-only FALSE
read-rnd-buffer-size 262144
relay-log (No default value)
relay-log-index (No default value)
relay-log-info-file relay-log.info
relay-log-info-repository FILE
relay-log-purge TRUE
relay-log-recovery FALSE
relay-log-space-limit 0
replicate-same-server-id FALSE
report-host (No default value)
report-password (No default value)
report-port 0
report-user (No default value)
require-secure-transport FALSE
rpl-stop-slave-timeout 31536000
safe-user-create FALSE
secure-auth TRUE
secure-file-priv /var/lib/mysql-files/
server-id 0
server-id-bits 32
session-track-gtids OFF
session-track-schema TRUE
session-track-state-change FALSE
session-track-system-variables time_zone,autocommit,character_set_client,character_set_results,character_set_connection
session-track-transaction-info OFF
sha256-password-auto-generate-rsa-keys TRUE
sha256-password-private-key-path private_key.pem
sha256-password-proxy-users FALSE
sha256-password-public-key-path public_key.pem
show-compatibility-56 FALSE
show-old-temporals FALSE
show-slave-auth-info FALSE
skip-grant-tables FALSE
skip-name-resolve TRUE
skip-networking FALSE
skip-show-database FALSE
skip-slave-start FALSE
slave-allow-batching FALSE
slave-checkpoint-group 512
slave-checkpoint-period 300
slave-compressed-protocol FALSE
slave-exec-mode STRICT
slave-load-tmpdir /tmp
slave-max-allowed-packet 1073741824
slave-net-timeout 60
slave-parallel-type DATABASE
slave-parallel-workers 0
slave-pending-jobs-size-max 16777216
slave-preserve-commit-order FALSE
slave-rows-search-algorithms TABLE_SCAN,INDEX_SCAN
slave-skip-errors (No default value)
slave-sql-verify-checksum TRUE
slave-transaction-retries 10
slave-type-conversions
slow-launch-time 2
slow-query-log FALSE
slow-query-log-always-write-time 10
slow-query-log-file /var/lib/mysql/0a27320d5341-slow.log
slow-query-log-use-global-control
socket /var/run/mysqld/mysqld.sock
sort-buffer-size 262144
sporadic-binlog-dump-fail FALSE
sql-mode STRICT_ALL_TABLES,NO_ENGINE_SUBSTITUTION
ssl TRUE
ssl-ca (No default value)
ssl-capath (No default value)
ssl-cert (No default value)
ssl-cipher (No default value)
ssl-crl (No default value)
ssl-crlpath (No default value)
ssl-key (No default value)
stored-program-cache 256
super-large-pages FALSE
super-read-only FALSE
symbolic-links FALSE
sync-binlog 1
sync-frm TRUE
sync-master-info 10000
sync-relay-log 10000
sync-relay-log-info 10000
sysdate-is-now FALSE
table-definition-cache 1400
table-open-cache 2000
table-open-cache-instances 16
tc-heuristic-recover OFF
temp-pool TRUE
thread-cache-size 9
thread-handling one-thread-per-connection
thread-pool-high-prio-mode transactions
thread-pool-high-prio-tickets -1
thread-pool-idle-timeout 60
thread-pool-max-threads 100000
thread-pool-oversubscribe 3
thread-pool-size 4
thread-pool-stall-limit 500
thread-stack 262144
thread-statistics FALSE
time-format %H:%i:%s
tls-version TLSv1,TLSv1.1,TLSv1.2
tmp-table-size 16777216
tmpdir /tmp
transaction-alloc-block-size 8192
transaction-isolation REPEATABLE-READ
transaction-prealloc-size 4096
transaction-read-only FALSE
transaction-write-set-extraction OFF
updatable-views-with-limit YES
userstat FALSE
utility-user (No default value)
utility-user-password (No default value)
utility-user-privileges
utility-user-schema-access (No default value)
( run in 1.037 second using v1.01-cache-2.11-cpan-e1769b4cff6 )