Percona Toolkit概览

“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 --