Percona Toolkit


 

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

数据清理,归档数据

pt-config-diff

配置文件及服务器变量对比

pt-deadlock-logger

显示死锁日志信息

pt-diskstats

磁盘I/O统计信息

pt-duplicate-key-checker

查找表中重复的索引键和外键

pt-fifo-split

可以模拟切割文件,并通过管道传递给先入先出队列而不用真正的切割文件

pt-find

Find MySQL tables and execute actions, like GNU find.

pt-fingerprint

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.

pt-stalk

诊断mySql问题

pt-summary

汇总系统信息

pt-table-checksum

检验mysql复制完整性

pt-table-sync

数据同步

pt-table-usage

Analyze how queries use tables

pt-upgrade

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或阅读在线手册,再次只做简单的介绍。

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值