pt-config-diff

来源：互联网发布：fastdfs java 编辑：程序博客网时间：2024/06/06 09:43

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=huang35 config differencesVariable                  slave159                  kfpanda========================= ========================= =========================basedir                   /opt/mysql-5.5.41         /usr/local/mysqlcharacter_sets_dir        /opt/mysql-5.5.41/shar... /usr/local/mysql/share...datadir                   /u02/data_3307/           /home/opaqdata/data/event_scheduler           ON                        OFFexpire_logs_days          3                         0general_log               ON                        OFFgeneral_log_file          /u02/data_3307/slave15... /home/opaqdata/data/kf...hostname                  slave159                  kfpandainnodb_version            5.5.41-tokudb-7.5.5       5.5.30-tokudb-7.0.1lc_messages_dir           /opt/mysql-5.5.41/share/  /usr/local/mysql/share/log                       ON                        OFFlog_bin_trust_function... ON                        OFFlog_error                 /u02/data_3307/slave15... /home/opaqdata/data/kf...max_allowed_packet        5242880                   1048576max_long_data_size        5242880                   1048576open_files_limit          65534                     2500pid_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                         33554432query_cache_type          OFF                       ONserver_id                 159                       1skip_name_resolve         ON                        OFFslow_query_log_file       /u02/data_3307/slave15... /home/opaqdata/data/kf...socket                    /tmp/mysqltwo.sock        /tmp/mysql.socksort_buffer_size          31457280                  2097152thread_stack              262144                    512000tokudb_analyze_time       5                         60tokudb_cache_size         16817350656               980219904tokudb_commit_sync        OFF                       ONtokudb_load_save_space    ON                        OFFtokudb_max_lock_memory    2102168832                122527488tokudb_read_block_size    65536                     131072tokudb_row_format         tokudb_fast               tokudb_defaulttokudb_version            tokudb-7.5.5              7.0.1version                   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=huang2 config differencesVariable                  /etc/my.cnf slave159========================= =========== ========sort_buffer_size          16777216    31457280table_open_cache          510         512

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

0 0