“Percona Toolkit allows our large, transaction-based customers to make regular schema changes as their business evolves without interrupting their 24X7 operations.” — Hany Fahim,co-Founder and CEO of VM Farms ^1
Percona Toolkit is a collection of advanced command-line tools used by Percona) support staff to perform a variety of MySQL, MongoDB, and system tasks that are too difficult or complex to perform manually.
Version
Percona Toolkit 3.0.6
Dependence Package
安装依赖
DSN
DATA SOURCE NAME
Classify(34)
当前版本,该工具集共由34个工具组成,按状态、分析、监控、备份、在线变更、主从、实用小工具和MongoDB等功能分类,并做如下简单说明。
Status(5)
状态
pt-summary
系统状态
pt-diskstats
实时获取磁盘IO
pt-mysql-summary
获取mysql状态
pt-show-grants
查看mysql用户权限信息
pt-mext
/
获取全局状态信息
Analyze(9)
分析
pt-query-digest
分析慢查询/抓取tcp package,然后进行分析
pt-stalk
达到触发条件后,开始收集问题数据
pt-sift
分析产生的数据
pt-index-usage
依据分析index使用情况
pt-table-usage
pt-pmp
分析获取堆栈信息。慎用,有概率会hung住mysqld。
pt-duplicate-key-checker
检查重复Index
pt-upgrade
验证比较两个host的结果集一致性
pt-variable-advisor
分析变量配置的合理性
Monitor(4)
pt-deadlock-logger
监控死锁信息
pt-fk-error-logger
监控外键错误信息
pt-heartbeat
监控MySQL复制延迟
pt-ioprofile
跟踪监控IO状态。默认时间30s。
Backup(1)
备份
pt-archiver
归档数据
Online Change(1)
pt-online-schema-change
ALTER tables without locking them.
Master Slave(5)
pt-table-checksum
检查主从一致性。修复可使用
pt-table-sync
pt-slave-delay
pt-slave-find
pt-slave-restart
Utils(7)
pt-align
按列格式化并输出
pt-visual-explain
将的结果集转换为树结构
pt-config-diff
比较两个配置文件的差异
pt-kill
pt-find
pt-fifo-split
分隔大文件
pt-fingerprint
MongoDB(2)
pt-mongodb-query-digest
pt-mongodb-summary
Reference
https://www.percona.com/downloads/percona-toolkit/LATEST/
https://www.percona.com/doc/percona-toolkit/LATEST/index.html
https://learn.percona.com/hubfs/Manuals/Percona_Toolkit/Percona-Toolkit.-3.0.6.pdf?t=1516049974537
https://dev.mysql.com/doc/refman/5.7/en/innodb-create-index-overview.html
https://github.com/shawn0915/shawnoffice-toolkit/
Footnotes
-- END --
领取专属 10元无门槛券
私享最新 技术干货