查找重复的索引和外键并生成删除重复索引的语句
pt-duplicate-key-checker –user=root –password=energy@db –port=3307
交互式的检查系统io工具
pt-diskstats –interval 5 –iterations 10
运行4小时，每次间隔30s，后台运行
pt-deadlock-logger u=root,p=energy@db –daemonize –run-time=4 –interval=30s
pt-table-checksum 检测mysql主从一致性
pt-table-checksum –user=user–password=password –host=host1–port=port –databases=db_name –tables=tablename –recursion-method=processlist
pt-table-sync 修复从库数据
pt-table-sync –execute –replicate percona.checksums –sync-to-master h=host2,P=3306,u=user,p=password
pt-find 查找表
pt-find –user=root –password=energy@db –tablesize +5G
pt-find –user=root –password=energy@db –printf "%T\t%D.%N\n" –tablesize +5G |sort -rn
