App-mycnfdiff

 view release on metacpan or  search on metacpan

t/samples/percona-compiled.txt  view on Meta::CPAN

  -u, --user=name     Run mysqld daemon as user.
  --userstat          Control USER_STATISTICS, CLIENT_STATISTICS,
                      THREAD_STATISTICS, INDEX_STATISTICS and TABLE_STATISTICS
                      running
  --utility-user=name Specifies a MySQL user that will be added to the internal
                      list of users and recognized as the utility user.
  --utility-user-password=name 
                      Specifies the password required for the utility user.
  --utility-user-privileges=name 
                      Specifies the privileges that the utility user will have
                      in a comma delimited list. See the manual for a complete
                      list of privileges.
  --utility-user-schema-access=name 
                      Specifies the schemas that the utility user has access to
                      in a comma delimited list.
  --validate-user-plugins 
                      Turns on additional validation of authentication plugins
                      assigned to user accounts. 
                      (Defaults to on; use --skip-validate-user-plugins to disable.)
  -v, --verbose       Used with --help option for detailed help.
  -V, --version       Output version information and exit.
  --wait-timeout=#    The number of seconds the server waits for activity on a
                      connection before closing it

Variables (--variable-name=value)
and boolean options {FALSE|TRUE}                             Value (after reading options)
------------------------------------------------------------ -------------
abort-slave-event-count                                      0
allow-suspicious-udfs                                        FALSE
archive                                                      ON
auto-generate-certs                                          TRUE
auto-increment-increment                                     1
auto-increment-offset                                        1
autocommit                                                   TRUE
automatic-sp-privileges                                      TRUE
avoid-temporal-upgrade                                       FALSE
back-log                                                     80
basedir                                                      /usr/
big-tables                                                   FALSE
bind-address                                                 *
binlog-cache-size                                            32768
binlog-checksum                                              CRC32
binlog-direct-non-transactional-updates                      FALSE
binlog-error-action                                          ABORT_SERVER
binlog-format                                                ROW
binlog-group-commit-sync-delay                               0
binlog-group-commit-sync-no-delay-count                      0
binlog-gtid-simple-recovery                                  TRUE
binlog-max-flush-queue-time                                  0
binlog-order-commits                                         TRUE
binlog-row-event-max-size                                    8192
binlog-row-image                                             FULL
binlog-rows-query-log-events                                 FALSE
binlog-stmt-cache-size                                       32768
blackhole                                                    ON
block-encryption-mode                                        aes-128-ecb
bulk-insert-buffer-size                                      8388608
character-set-client-handshake                               TRUE
character-set-filesystem                                     binary
character-set-server                                         latin1
character-sets-dir                                           /usr/share/mysql/charsets/
check-proxy-users                                            FALSE
chroot                                                       (No default value)
collation-server                                             latin1_swedish_ci
completion-type                                              NO_CHAIN
concurrent-insert                                            AUTO
connect-timeout                                              10
console                                                      FALSE
csv-mode                                                     
daemonize                                                    FALSE
datadir                                                      /var/lib/mysql/
date-format                                                  %Y-%m-%d
datetime-format                                              %Y-%m-%d %H:%i:%s
default-authentication-plugin                                mysql_native_password
default-password-lifetime                                    0
default-storage-engine                                       InnoDB
default-time-zone                                            (No default value)
default-tmp-storage-engine                                   InnoDB
default-week-format                                          0
delay-key-write                                              ON
delayed-insert-limit                                         100
delayed-insert-timeout                                       300
delayed-queue-size                                           1000
des-key-file                                                 (No default value)
disable-partition-engine-check                               FALSE
disabled-storage-engines                                     
disconnect-on-expired-password                               TRUE
disconnect-slave-event-count                                 0
div-precision-increment                                      4
end-markers-in-json                                          FALSE
enforce-gtid-consistency                                     FALSE
enforce-storage-engine                                       (No default value)
eq-range-index-dive-limit                                    200
event-scheduler                                              OFF
expand-fast-index-creation                                   FALSE
expire-logs-days                                             0
explicit-defaults-for-timestamp                              TRUE
external-locking                                             FALSE
extra-max-connections                                        1
extra-port                                                   0
federated                                                    ON
flush                                                        FALSE
flush-time                                                   0
ft-boolean-syntax                                            + -><()~*:""&|
ft-max-word-len                                              84
ft-min-word-len                                              4
ft-query-expansion-limit                                     20
ft-stopword-file                                             (No default value)
gdb                                                          FALSE
general-log                                                  FALSE
general-log-file                                             /var/lib/mysql/0a27320d5341.log
group-concat-max-len                                         1024
gtid-executed-compression-period                             1000
gtid-mode                                                    OFF
help                                                         TRUE
host-cache-size                                              279
ignore-builtin-innodb                                        FALSE
init-connect                                                 
init-file                                                    (No default value)
init-slave                                                   
initialize                                                   FALSE



( run in 0.521 second using v1.01-cache-2.11-cpan-8f98c5d2c55 )