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、比较两个文件得差异