wordpress微信网站模板凤凰军事新闻最新消息
1、用法
pt-config-diff [OPTION...] CONFIG CONFIG [CONFIG...]例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[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