Installation and use of Percona-toolkit tools 2

[[email protected] ~]# CD/Usr/bin[[email protected] bin]# ls PT*PT-Align PT-Duplicate-Key-Checker PT-Ioprofile PT-Show-Grants PT-Table-Checksumptar PT-Fifo-Split PT-KillPt-Sift PT-Table-SYNCPT-Archiver PT-Find PT-Mext PT-Slave-Delay PT-Table-Usageptardiff PT-Fingerprint PT-Mysql-Summary PT-Slave-Find PT-upgradept-Config-Diff PT-Fk-Error-Logger PT-Online-Schema-Change PT-Slave-Restart PT-Variable-advisorpt-Deadlock-Logger PT-Heartbeat PT-PMP PT-Stalk PT-Visual-EXPLAINPT-Diskstats PT-Index-Usage PT-Query-Digest PT-Summary ptx

[[email protected] bin]# ./Mysql-Uroot-Paa@12345 -S/Tmp/Mysql.sock5-E "explainSelect *  fromMysql.User"|Pt-Visual-explainTablescanrows7+- Table   Table          User

Slow query Log analysis Statistics PT-Query-Digest/Data/Logs/Mysql/Mysql-Slow.Log  

Table Sync Tool, and MK-Tables-sync function, the usage is slightly different, –print results more detailed PT-Table-Sync--Execute--print--no-check-slave--database=world h= ' 127.0.0.1 '--user=root--password=123456 h= ' 192.168.0.212 '-- User=root--password=123456

Master-Slave status monitoring, provided to it a MySQL server IP user name password, you can analyze the entire master-slave architecture of each server information, including but not limited to MySQL version, IP address, server Id,mysql service startup time, role (main/from), Slave Status (lag behind the master server for how many seconds, there is no error, Slave is not running). Pt-Slave-Find--host=localhost--user=rhce6--password=rhce6
MySQL Deadlock monitoring pt-Deadlock-Logger h='127.0.0.1' --User=root--password=123456

PRIMARY key conflict Check PT-Duplicate-Key-Checker--database=world h= ' 127.0.0.1 '--user=root--password=123456

monitoring replication Latency from a library # # #经过测试 running this command causes the SQL thread exception from the library to hang up PT-Slave-Delay--host 192.168.0.206--user=root--password=123456

Installation and use of Percona-toolkit tools 2