1、简介:
percona-toolkit是一组高级命令行工具的集合,用来执行各种通过手工执行非常复杂和麻烦的mysql和系统任务,这些任务包括:
检查master和slave数据的一致性
有效地对记录进行归档
查找重复的索引
对服务器信息进行汇总
分析来自日志和tcpdump的查询
当系统出问题的时候收集重要的系统信息
2、软件下载:
地址:https://www.percona.com/software/percona-toolkit
下载最新版本的Percona Toolkit
3、安装:
[root@localhost opt]# tar zxvf percona-toolkit-2.2.14.tar.gz
percona-toolkit-2.2.14/
percona-toolkit-2.2.14/MANIFEST
percona-toolkit-2.2.14/docs/
percona-toolkit-2.2.14/docs/percona-toolkit.pod
percona-toolkit-2.2.14/INSTALL
percona-toolkit-2.2.14/lib/
percona-toolkit-2.2.14/Changelog
percona-toolkit-2.2.14/README
percona-toolkit-2.2.14/COPYING
percona-toolkit-2.2.14/bin/
percona-toolkit-2.2.14/bin/pt-heartbeat
percona-toolkit-2.2.14/bin/pt-archiver
percona-toolkit-2.2.14/bin/pt-config-diff
percona-toolkit-2.2.14/bin/pt-mysql-summary
percona-toolkit-2.2.14/bin/pt-pmp
percona-toolkit-2.2.14/bin/pt-slave-restart
percona-toolkit-2.2.14/bin/pt-online-schema-change
percona-toolkit-2.2.14/bin/pt-table-checksum
percona-toolkit-2.2.14/bin/pt-deadlock-logger
percona-toolkit-2.2.14/bin/pt-find
percona-toolkit-2.2.14/bin/pt-slave-delay
percona-toolkit-2.2.14/bin/pt-ioprofile
percona-toolkit-2.2.14/bin/pt-sift
percona-toolkit-2.2.14/bin/pt-fingerprint
percona-toolkit-2.2.14/bin/pt-stalk
percona-toolkit-2.2.14/bin/pt-diskstats
percona-toolkit-2.2.14/bin/pt-kill
percona-toolkit-2.2.14/bin/pt-upgrade
percona-toolkit-2.2.14/bin/pt-slave-find
percona-toolkit-2.2.14/bin/pt-show-grants
percona-toolkit-2.2.14/bin/pt-query-digest
percona-toolkit-2.2.14/bin/pt-summary
percona-toolkit-2.2.14/bin/pt-align
percona-toolkit-2.2.14/bin/pt-fk-error-logger
percona-toolkit-2.2.14/bin/pt-table-sync
percona-toolkit-2.2.14/bin/pt-variable-advisor
percona-toolkit-2.2.14/bin/pt-table-usage
percona-toolkit-2.2.14/bin/pt-fifo-split
percona-toolkit-2.2.14/bin/pt-mext
percona-toolkit-2.2.14/bin/pt-visual-explain
percona-toolkit-2.2.14/bin/pt-duplicate-key-checker
percona-toolkit-2.2.14/bin/pt-index-usage
percona-toolkit-2.2.14/Makefile.PL
[root@localhost opt]# cd percona-toolkit-2.2.14
[root@localhost percona-toolkit-2.2.14]# perl Makefile.PL
Checking if your kit is complete...
Looks good
Warning: prerequisite DBD::mysql 3 not found.
Warning: prerequisite DBI 1.46 not found.
Writing Makefile for percona-toolkit
去http://dev.mysql.com/downloads/dbi.html
下载最新的DBI 和 DBD::mysql
1)安装DBI:
[root@localhost opt]# tar zxvf DBI-1.633.tar.gz
[root@localhost opt]# cd DBI-1.633
[root@localhost DBI-1.633]# perl Makefile.PL
[root@localhost DBI-1.633]# make
[root@localhost DBI-1.633]# makeinstall
2)安装DBD::mysql
[root@localhost opt]# tar zxvf DBD-mysql-4.031.tar.gz
[root@localhost DBD-mysql-4.031]# perl Makefile.PL
[root@localhost DBD-mysql-4.031]# make
[root@localhost DBD-mysql-4.031]# make test
[root@localhost DBD-mysql-4.031]# make install
3)重新安装percona-toolkit-2.2.14
[root@localhost DBD-mysql-4.031]# cd /opt/percona-toolkit-2.2.14
[root@localhost percona-toolkit-2.2.14]# perl Makefile.PL
Checking if your kit is complete...
Looks good
Writing Makefile for percona-toolkit
[root@localhost percona-toolkit-2.2.14]# make
cp bin/pt-mysql-summary blib/script/pt-mysql-summary
/usr/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/pt-mysql-summary
cp bin/pt-pmp blib/script/pt-pmp
/usr/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/pt-pmp
cp bin/pt-kill blib/script/pt-kill
/usr/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/pt-kill
cp bin/pt-online-schema-change blib/script/pt-online-schema-change
/usr/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/pt-online-schema-change
cp bin/pt-align blib/script/pt-align
/usr/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/pt-align
cp bin/pt-heartbeat blib/script/pt-heartbeat
/usr/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/pt-heartbeat
cp bin/pt-table-sync blib/script/pt-table-sync
/usr/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/pt-table-sync
cp bin/pt-upgrade blib/script/pt-upgrade
/usr/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/pt-upgrade
cp bin/pt-table-usage blib/script/pt-table-usage
/usr/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/pt-table-usage
cp bin/pt-slave-delay blib/script/pt-slave-delay
/usr/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/pt-slave-delay
cp bin/pt-sift blib/script/pt-sift
/usr/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/pt-sift
cp bin/pt-fifo-split blib/script/pt-fifo-split
/usr/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/pt-fifo-split
cp bin/pt-slave-find blib/script/pt-slave-find
/usr/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/pt-slave-find
cp bin/pt-ioprofile blib/script/pt-ioprofile
/usr/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/pt-ioprofile
cp bin/pt-diskstats blib/script/pt-diskstats
/usr/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/pt-diskstats
cp bin/pt-find blib/script/pt-find
/usr/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/pt-find
cp bin/pt-archiver blib/script/pt-archiver
/usr/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/pt-archiver
cp bin/pt-deadlock-logger blib/script/pt-deadlock-logger
/usr/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/pt-deadlock-logger
cp bin/pt-fingerprint blib/script/pt-fingerprint
/usr/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/pt-fingerprint
cp bin/pt-visual-explain blib/script/pt-visual-explain
/usr/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/pt-visual-explain
cp bin/pt-variable-advisor blib/script/pt-variable-advisor
/usr/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/pt-variable-advisor
cp bin/pt-mext blib/script/pt-mext
/usr/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/pt-mext
cp bin/pt-index-usage blib/script/pt-index-usage
/usr/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/pt-index-usage
cp bin/pt-slave-restart blib/script/pt-slave-restart
/usr/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/pt-slave-restart
cp bin/pt-summary blib/script/pt-summary
/usr/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/pt-summary
cp bin/pt-duplicate-key-checker blib/script/pt-duplicate-key-checker
/usr/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/pt-duplicate-key-checker
cp bin/pt-fk-error-logger blib/script/pt-fk-error-logger
/usr/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/pt-fk-error-logger
cp bin/pt-table-checksum blib/script/pt-table-checksum
/usr/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/pt-table-checksum
cp bin/pt-query-digest blib/script/pt-query-digest
/usr/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/pt-query-digest
cp bin/pt-show-grants blib/script/pt-show-grants
/usr/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/pt-show-grants
cp bin/pt-config-diff blib/script/pt-config-diff
/usr/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/pt-config-diff
cp bin/pt-stalk blib/script/pt-stalk
/usr/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/pt-stalk
Manifying blib/man1/pt-mysql-summary.1p
Manifying blib/man1/pt-kill.1p
Manifying blib/man1/pt-online-schema-change.1p
Manifying blib/man1/pt-table-sync.1p
Manifying blib/man1/pt-upgrade.1p
Manifying blib/man1/pt-table-usage.1p
Manifying blib/man1/pt-fifo-split.1p
Manifying blib/man1/pt-slave-find.1p
Manifying blib/man1/pt-ioprofile.1p
Manifying blib/man1/pt-find.1p
Manifying blib/man1/pt-archiver.1p
Manifying blib/man1/pt-deadlock-logger.1p
Manifying blib/man1/pt-fingerprint.1p
Manifying blib/man1/pt-mext.1p
Manifying blib/man1/pt-slave-restart.1p
Manifying blib/man1/pt-summary.1p
Manifying blib/man1/pt-fk-error-logger.1p
Manifying blib/man1/pt-table-checksum.1p
Manifying blib/man1/pt-query-digest.1p
Manifying blib/man1/pt-show-grants.1p
Manifying blib/man1/percona-toolkit.1p
Manifying blib/man1/pt-pmp.1p
Manifying blib/man1/pt-align.1p
Manifying blib/man1/pt-heartbeat.1p
Manifying blib/man1/pt-slave-delay.1p
Manifying blib/man1/pt-sift.1p
Manifying blib/man1/pt-diskstats.1p
Manifying blib/man1/pt-visual-explain.1p
Manifying blib/man1/pt-variable-advisor.1p
Manifying blib/man1/pt-index-usage.1p
Manifying blib/man1/pt-duplicate-key-checker.1p
Manifying blib/man1/pt-config-diff.1p
Manifying blib/man1/pt-stalk.1p
[root@localhost percona-toolkit-2.2.14]# make test
No tests defined for percona-toolkit extension.
[root@localhost percona-toolkit-2.2.14]# make install
Writing /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/auto/percona-toolkit/.packlist
Appending installation info to /usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi/perllocal.pod
4、Percona Toolkit包括的tools:
pt-align | 对文件格式进行格式化输出 |
pt-archiver | 数据清理,归档数据 |
配置文件及服务器变量对比 | |
显示死锁日志信息 | |
磁盘I/O统计信息 | |
查找表中重复的索引键和外键 | |
pt-fifo-split | 可以模拟切割文件,并通过管道传递给先入先出队列而不用真正的切割文件 |
pt-find | Find MySQL tables and execute actions, like GNU find. |
Convert queries into fingerprints | |
pt-fk-error-logger | 记录外键错误信息 |
pt-heartbeat | 监控主从延迟 |
pt-index-usage | 对查询中的索引进行分析 |
pt-ioprofile | 定位负载来源文件 |
pt-kill | 杀掉满足条件的查询 |
pt-mext | Look at many samples of MySQLSHOW GLOBAL STATUS side-by-side |
pt-mysql-summary - | Mysql信息汇总 |
pt-online-schema-change | ALTER tables without locking them |
pt-pmp | Aggregate GDB stack traces for a selected program. |
pt-query-digest | Analyze MySQL queries from lgs, processlist, and tcpdump. |
pt-show-grants | 权限管理的工具 |
pt-sift | 浏览由pt-stalk创建的文件 |
pt-slave-delay | 延迟复制工具 |
pt-slave-find | 查找并打印mysql所有从服务复制层级关系 |
pt-slave-restart | Watch and restart MySQL replication after errors. |
诊断mySql问题 | |
pt-summary | 汇总系统信息 |
pt-table-checksum | 检验mysql复制完整性 |
pt-table-sync | 数据同步 |
pt-table-usage | Analyze how queries use tables |
Verify that query results are identical on different servers. | |
pt-variable-advisor | Analyze MySQL variables and advise on possible problems |
pt-visual-explain | 格式化explain 输出 |
5、测试样例:
1) pt_archive
[root@localhost ~]# pt-archiver--sourceu=root,p=yhdb,h=172.19.200.1,D=test,t=test --dest u=root,p=yhdb,h=172.19.200.2 --no-delete --file=/root/test_pt_archive.txt --where "1=1" --no-check-charset
注:上test表的数据归档到172.19.100.2并保存到文件/root/test_pt_archive.txt
2) pt-config-diff
[root@localhost ~]# pt-config-diff/opt/mysql-5.6.24/support-files/my-default.cnf u=root,p=yhdb,h=172.19.200.1
3) pt-heartbeat
[root@localhost ~]# pt-heartbeat--host=172.19.200.1 --database=test--create-table--master-server-id=1 --user=root --password=yhdb --monitor
4) pt-summary
[root@localhost ~]# pt-summary
# Percona Toolkit System Summary Report ######################
Date | 2015-06-04 03:32:11 UTC (local TZ: CST +0800)
Hostname | localhost.localdomain
Uptime | 16 days, 18:46, 3 users,load average: 0.00, 0.00, 0.00
System | VMware, Inc.; VMware Virtual Platform; vNone (Other)
Service Tag | VMware-56 4d 00 a5 61 35 1b 6c-d9 db 97 2a f3 26 e4 9b
Platform | Linux
Release | Red Hat Enterprise Linux Server release 5.6 (Tikanga)
Kernel | 2.6.18-238.el5
Architecture | CPU = 64-bit, OS = 64-bit
Threading | NPTL 2.5
Compiler | GNU CC version 4.1.2 20080704 (Red Hat 4.1.2-50).
SELinux | Permissive
Virtualized | VMWare
# Processor ##################################################
Processors | physical = 1, cores = 0, virtual = 1, hyperthreading = no
Speeds | 1x2826.222
Models | 1xIntel(R) Core(TM)2 Quad CPU Q9500 @ 2.83GHz
Caches | 1x3072 KB
# Memory #####################################################
Total | 2.0G
Free | 45.5M
Used | physical = 1.9G, swap allocated = 3.9G, swap used = 12.0k, virtual = 1.9G
Buffers | 178.1M
Caches | 1.0G
Dirty | 196 kB
UsedRSS | 688.6M
Swappiness | 60
DirtyPolicy | 40, 10
DirtyStatus | 0, 0
LocatorSize Speed Form Factor TypeType Detail
========= ======== ================= ============= ============= ===========
RAM slot #0 2048 MB Unknown DIMM DRAM EDO
RAM slot #10 {EMPTY} Unknown DIMM DRAM Unknown
RAM slot #11 {EMPTY} Unknown DIMM DRAM Unknown
RAM slot #12 {EMPTY} Unknown DIMM DRAM Unknown
RAM slot #13 {EMPTY} Unknown DIMM DRAM Unknown
RAM slot #14 {EMPTY} Unknown DIMM DRAM Unknown
RAM slot #15 {EMPTY} Unknown DIMM DRAM Unknown
RAM slot #16 {EMPTY} Unknown DIMM DRAM Unknown
RAM slot #17 {EMPTY} Unknown DIMM DRAM Unknown
RAM slot #18 {EMPTY} Unknown DIMM DRAM Unknown
RAM slot #19 {EMPTY} Unknown DIMM DRAM Unknown
RAM slot #1 {EMPTY} Unknown DIMM DRAM Unknown
RAM slot #20 {EMPTY} Unknown DIMM DRAM Unknown
RAM slot #21 {EMPTY} Unknown DIMM DRAM Unknown
RAM slot #22 {EMPTY} Unknown DIMM DRAM Unknown
RAM slot #23 {EMPTY} Unknown DIMM DRAM Unknown
RAM slot #24 {EMPTY} Unknown DIMM DRAM Unknown
RAM slot #25 {EMPTY} Unknown DIMM DRAM Unknown
RAM slot #26 {EMPTY} Unknown DIMM DRAM Unknown
RAM slot #27 {EMPTY} Unknown DIMM DRAM Unknown
RAM slot #28 {EMPTY} Unknown DIMM DRAM Unknown
RAM slot #29 {EMPTY} Unknown DIMM DRAM Unknown
RAM slot #2 {EMPTY} Unknown DIMM DRAM Unknown
RAM slot #30 {EMPTY} Unknown DIMM DRAM Unknown
RAM slot #31 {EMPTY} Unknown DIMM DRAM Unknown
RAM slot #32 {EMPTY} Unknown DIMM DRAM Unknown
RAM slot #33 {EMPTY} Unknown DIMM DRAM Unknown
RAM slot #34 {EMPTY} Unknown DIMM DRAM Unknown
RAM slot #35 {EMPTY} Unknown DIMM DRAM Unknown
RAM slot #36 {EMPTY} Unknown DIMM DRAM Unknown
RAM slot #37 {EMPTY} Unknown DIMM DRAM Unknown
RAM slot #38 {EMPTY} Unknown DIMM DRAM Unknown
RAM slot #39 {EMPTY} Unknown DIMM DRAM Unknown
RAM slot #3 {EMPTY} Unknown DIMM DRAM Unknown
RAM slot #40 {EMPTY} Unknown DIMM DRAM Unknown
RAM slot #41 {EMPTY} Unknown DIMM DRAM Unknown
RAM slot #42 {EMPTY} Unknown DIMM DRAM Unknown
RAM slot #43 {EMPTY} Unknown DIMM DRAM Unknown
RAM slot #44 {EMPTY} Unknown DIMM DRAM Unknown
RAM slot #45 {EMPTY} Unknown DIMM DRAM Unknown
RAM slot #46 {EMPTY} Unknown DIMM DRAM Unknown
RAM slot #47 {EMPTY} Unknown DIMM DRAM Unknown
RAM slot #48 {EMPTY} Unknown DIMM DRAM Unknown
RAM slot #49 {EMPTY} Unknown DIMM DRAM Unknown
RAM slot #4 {EMPTY} Unknown DIMM DRAM Unknown
RAM slot #50 {EMPTY} Unknown DIMM DRAM Unknown
RAM slot #51 {EMPTY} Unknown DIMM DRAM Unknown
RAM slot #52 {EMPTY} Unknown DIMM DRAM Unknown
RAM slot #53 {EMPTY} Unknown DIMM DRAM Unknown
RAM slot #54 {EMPTY} Unknown DIMM DRAM Unknown
RAM slot #55 {EMPTY} Unknown DIMM DRAM Unknown
RAM slot #56 {EMPTY} Unknown DIMM DRAM Unknown
RAM slot #57 {EMPTY} Unknown DIMM DRAM Unknown
RAM slot #58 {EMPTY} Unknown DIMM DRAM Unknown
RAM slot #59 {EMPTY} Unknown DIMM DRAM Unknown
RAM slot #5 {EMPTY} Unknown DIMM DRAM Unknown
RAM slot #60 {EMPTY} Unknown DIMM DRAM Unknown
RAM slot #61 {EMPTY} Unknown DIMM DRAM Unknown
RAM slot #62 {EMPTY} Unknown DIMM DRAM Unknown
RAM slot #63 {EMPTY} Unknown DIMM DRAM Unknown
RAM slot #6 {EMPTY} Unknown DIMM DRAM Unknown
RAM slot #7 {EMPTY} Unknown DIMM DRAM Unknown
RAM slot #8 {EMPTY} Unknown DIMM DRAM Unknown
RAM slot #9 {EMPTY} Unknown DIMM DRAM Unknown
# Mounted Filesystems ########################################
Filesystem Size Used Type Opts Mountpoint
/dev/mapper/VolGroup00-LogVol00 142G20% ext3 rw /
/dev/sda1 99M 14% ext3rw /boot
tmpfs 1006M 0% tmpfs rw/dev/shm
# Disk Schedulers And Queue Size #############################
dm-0 | UNREADABLE
dm-1 | UNREADABLE
hdc | [cfq] 128
md0 | UNREADABLE
sda | [cfq] 128
# Disk Partioning ############################################
Device TypeStart End Size
============ ==== ========== ========== ==================
/dev/sda Disk 161061273600
/dev/sda1 Part 1 13 98703360
/dev/sda2 Part14 19581 160944053760
# Kernel Inode State #########################################
dentry-state | 60278 51810 45 0 0 0
file-nr | 1020 0 203346
inode-nr | 58984 9985
# LVM Volumes ################################################
LVVG Attr LSizeOrigin Snap% Move Log Copy% Convert
LogVol00 VolGroup00 -wi-ao 145.97G
LogVol01 VolGroup00 -wi-ao 3.91G
# LVM Volume Groups ##########################################
VGVSize VFree
VolGroup00 149.88G 0
# RAID Controller ############################################
Controller | No RAID controller detected
# Network Config #############################################
Controller | Intel Corporation 82545EM Gigabit Ethernet Controller (Copper) (rev 01)
Controller | VMware VMXNET3 Ethernet Controller (rev 01)
FIN Timeout | 60
Port Range | 61000
# Interface Statistics #######################################
interfacerx_bytes rx_packetsrx_errors tx_bytes tx_packets tx_errors
========= ========= ========== ========== ========== ========== ==========
lo3000000 3000 03000000 3000 0
eth11000000000 125000000 0250000000 3000000 0
# Network Devices ############################################
DeviceSpeed Duplex
========= ========= =========
eth11000Mb/s Full
# Network Connections ########################################
Connections from remote IP addresses
172.19.8.251 3
172.19.200.3 1
Connections to local IP addresses
172.19.200.1 4
Connections to top 10 local ports
22 3
3306 1
States of connections
ESTABLISHED 4
LISTEN 7
# Top Processes ##############################################
PID USERPR NI VIRTRES SHR S %CPU %MEM TIME+COMMAND
1 root15 0 10372 684576 S 0.0 0.00:00.88 init
2 rootRT -5 00 0 S 0.00.0 0:00.00 migration/0
3 root34 19 00 0 S 0.00.0 0:00.00 ksoftirqd/0
4 root10 -5 00 0 S 0.00.0 0:00.65 events/0
5 root10 -5 00 0 S 0.00.0 0:00.00 khelper
22 root11 -5 00 0 S 0.00.0 0:00.00 kthread
26 root10 -5 00 0 S 0.00.0 0:00.02 kblockd/0
27 root20 -5 00 0 S 0.00.0 0:00.00 kacpid
187 root18 -5 00 0 S 0.00.0 0:00.00 cqueue/0
# Notable Processes ##########################################
PIDOOM COMMAND
2687+0 sshd
# Simplified and fuzzy rounded vmstat (wait please) ##########
procs---swap-- -----io---- ---system---- --------cpu--------
r bsi so bibo ir csus sy ilwa st
10 0 01 4 620 0 0 1000 0
00 0 010 0 1250800 11 42 44 3 0
00 0 00 0 100090 0 0 1000 0
00 0 00 0 100060 0 0 1000 0
00 0 00 700 1250100 1 1 95 3 0
# The End ####################################################
具体的使用方法参见手册PerconaToolkit 2.2.14.pdf或阅读在线手册,再次只做简单的介绍。