数据库分析工具

https://www.percona.com/downloads/percona-toolkit/LATEST/

 

 pt(Percona Toolkit)工具安装

一．pt(Percona Toolkit)工具是由Percona公司开发的一个用perl语言编写的工具集,包含很多功能,例如在线更改数据表结构,校验主从数据,检查数据库状态,分析慢查询等这些靠人手做起来比较麻烦的事情,功能强大,操作简单

二.安装依赖包

yum install -y perl perl-IO-Socket-SSL perl-DBD-MySQL perl-Time-HiRes perl-Digest-MD5 perl-ExtUtils-MakeMaker

三 下载Percona Toolkit工具编译包

[root@node1 ~]# wget "https://www.percona.com/downloads/percona-toolkit/3.0.3/binary/tarball/percona-toolkit-3.0.3_x86_64.tar.gz"

解压

[root@node1 ~]# tar xf percona-toolkit-3.0.3_x86_64.tar.gz

进入目录安装

[root@node1 ~]# cd percona-toolkit-3.0.3

开始编译安装

[root@node1 percona-toolkit-3.0.3]# perl Makefile.PL

[root@node1 percona-toolkit-3.0.3]# make

[root@node1 percona-toolkit-3.0.3]# make install

就显示出一些常用的pt命令

[root@node1 ~]# ll /usr/local/bin/pt-*

 

这样就算安装完毕了,很简单.

搞个测试，MySQL服务状态显示：

 

[root@node1 ~]# pt-mysql-summary --user=root --password=‘abc123‘

mysql: [Warning] Using a password on the command line interface can be insecure.

# Percona Toolkit MySQL Summary Report #######################

              System time | 2017-10-03 05:03:34 UTC (local TZ: PDT -0700)

# Instances ##################################################

  Port  Data Directory             Nice OOM Socket

  ===== ========================== ==== === ======

        /var/lib/mysql             0    0   /var/lib/mysql/mysql.sock

# MySQL Executable ###########################################

       Path to executable | /usr/sbin/mysqld

              Has symbols | Yes

# Report On Port 3306 ########################################

                     User | root@localhost

                     Time | 2017-10-02 22:03:34 (PDT)

                 Hostname | node1

                  Version | 5.7.19-log MySQL Community Server (GPL)

                 Built On | Linux x86_64

                  Started | 2017-10-02 03:48 (up 0+18:15:33)

                Databases | 8

                  Datadir | /var/lib/mysql/

                Processes | 1 connected, 1 running

              Replication | Is not a slave, has 0 slaves connected

                  Pidfile | /var/run/mysqld/mysqld.pid (exists)

# Processlist ################################################

后面一大串，在此省略，测试正常运行。

 

本文出自 “Linux修仙之路” 博客，请务必保留此出处http://8999a.blog.51cto.com/11385098/1970303