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 )