pt-config-diff

对比配置文件与配置文件、服务器与服务器 或者 配置文件与服务器 之前的参数差异。

 

1、用法

 pt-config-diff [OPTION...] CONFIG CONFIG [CONFIG...]

 CONFIG可以是文件也可以是数据源名称，最少必须指定两个配置文件源，就像unix下面的diff命令一样，如果配置完全一样就不会输出任何东西

例1、比较本地和远程服务器配置差异

[root@slave159 test]# pt-config-diff h=192.168.60.159 --user=huang --password=huang  h=192.168.61.42 --user=huang --password=huang
35 config differences
Variable                  slave159                  kfpanda
========================= ========================= =========================
basedir                   /opt/mysql-5.5.41         /usr/local/mysql
character_sets_dir        /opt/mysql-5.5.41/shar... /usr/local/mysql/share...
datadir                   /u02/data_3307/           /home/opaqdata/data/
event_scheduler           ON                        OFF
expire_logs_days          3                         0
general_log               ON                        OFF
general_log_file          /u02/data_3307/slave15... /home/opaqdata/data/kf...
hostname                  slave159                  kfpanda
innodb_version            5.5.41-tokudb-7.5.5       5.5.30-tokudb-7.0.1
lc_messages_dir           /opt/mysql-5.5.41/share/  /usr/local/mysql/share/
log                       ON                        OFF
log_bin_trust_function... ON                        OFF
log_error                 /u02/data_3307/slave15... /home/opaqdata/data/kf...
max_allowed_packet        5242880                   1048576
max_long_data_size        5242880                   1048576
open_files_limit          65534                     2500
pid_file                  /u02/data_3307/slave15... /home/opaqdata/data/kf...
plugin_dir                /opt/mysql-5.5.41/lib/... /usr/local/mysql/lib/p...
query_cache_size          0                         33554432
query_cache_type          OFF                       ON
server_id                 159                       1
skip_name_resolve         ON                        OFF
slow_query_log_file       /u02/data_3307/slave15... /home/opaqdata/data/kf...
socket                    /tmp/mysqltwo.sock        /tmp/mysql.sock
sort_buffer_size          31457280                  2097152
thread_stack              262144                    512000
tokudb_analyze_time       5                         60
tokudb_cache_size         16817350656               980219904
tokudb_commit_sync        OFF                       ON
tokudb_load_save_space    ON                        OFF
tokudb_max_lock_memory    2102168832                122527488
tokudb_read_block_size    65536                     131072
tokudb_row_format         tokudb_fast               tokudb_default
tokudb_version            tokudb-7.5.5              7.0.1
version                   5.5.41-tokudb-7.5.5-log   5.5.30-tokudb-7.0.1-log

例2、比较配置文件和服务器配置

[root@slave159 test]# pt-config-diff /etc/my.cnf  h=192.168.60.159 --user=huang --password=huang
2 config differences
Variable                  /etc/my.cnf slave159
========================= =========== ========
sort_buffer_size          16777216    31457280
table_open_cache          510         512

例3、比较两个文件得差异

[root@slave159 test]# pt-config-diff /etc/my.cnf  /opt/mysql-5.5.41/my.cnf 
2 config differences
Variable                  /etc/my.cnf /opt/mysql-5.5.41/my.cnf
========================= =========== ========================
sort_buffer_size          16777216    31457280
table_open_cache          510         512

--help

[root@slave159 test]# pt-config-diff --help
pt-config-diff diffs MySQL configuration files and server variables. CONFIG can
be a filename or a DSN.  At least two CONFIG sources must be given.  Like
standard Unix diff, there is no output if there are no differences.  For more
details, please use the --help option, or try 'perldoc
/usr/local/bin/pt-config-diff' for complete documentation.

Usage: pt-config-diff [OPTIONS] CONFIG CONFIG [CONFIG...]

Options:

  --ask-pass            Prompt for a password when connecting to MySQL
  --charset=s       -A  Default character set
  --config=A            Read this comma-separated list of config files; if
                        specified, this must be the first option on the command
                        line. (This option does not specify a CONFIG; it's
                        equivalent to --defaults-file.)
  --database=s      -D  Connect to this database
  --defaults-file=s -F  Only read mysql options from the given file
  --help                Show help and exit
  --host=s          -h  Connect to host
  --[no]ignore-case     Compare the variables case-insensitively (default yes)
  --ignore-variables=a  Ignore, do not compare, these variables
  --password=s      -p  Password to use for connection
  --pid=s               Create the given PID file
  --port=i          -P  Port number to use for connection
  --[no]report          Print the MySQL config diff report to STDOUT (default
                        yes)
  --report-width=i      Truncate report lines to this many characters (default
                        78)
  --set-vars=A          Set the MySQL variables in this comma-separated list of
                        variable=value pairs
  --socket=s        -S  Socket file to use for connection
  --user=s          -u  MySQL user if not current user
  --version             Show version and exit
  --[no]version-check   Check for the latest version of Percona Toolkit, MySQL,
                        and other programs (default yes)

Option types: s=string, i=integer, f=float, h/H/a/A=comma-separated list, d=DSN, z=size, m=time

Rules:

  This tool accepts additional command-line arguments. Refer to the SYNOPSIS and usage information for details.

DSN syntax is key=value[,key=value...]  Allowable DSN keys:

  KEY  COPY  MEANING
  ===  ====  =============================================
  A    yes   Default character set
  D    yes   Default database
  F    yes   Only read default options from the given file
  P    yes   Port number to use for connection
  S    yes   Socket file to use for connection
  h    yes   Connect to host
  p    yes   Password to use when connecting
  u    yes   User for login if not current user

  If the DSN is a bareword, the word is treated as the 'h' key.

Options and values after processing arguments:

  --ask-pass            FALSE
  --charset             (No value)
  --config              /etc/percona-toolkit/percona-toolkit.conf,/etc/percona-toolkit/pt-config-diff.conf,/root/.percona-toolkit.conf,/root/.pt-config-diff.conf
  --database            (No value)
  --defaults-file       (No value)
  --help                TRUE
  --host                (No value)
  --ignore-case         TRUE
  --ignore-variables    (No value)
  --password            (No value)
  --pid                 (No value)
  --port                (No value)
  --report              TRUE
  --report-width        78
  --set-vars            
  --socket              (No value)
  --user                (No value)
  --version             FALSE
  --version-check       TRUE