pt Percona Toolkit 工具安置

2024-09-12 20:30:13

字體：大中小

供稿：網(wǎng)友

pt(Percona Toolkit)工具安裝

一．pt(Percona Toolkit)工具是由Percona公司開發(fā)的一個(gè)用perl語言編寫的工具集,包含很多功能,例如在線更改數(shù)據(jù)表結(jié)構(gòu),校驗(yàn)主從數(shù)據(jù),檢查數(shù)據(jù)庫狀態(tài),分析慢查詢等這些靠人手做起來比較麻煩的事情,功能強(qiáng)大,操作簡(jiǎn)單

二.安裝依賴包

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

進(jìn)入目錄安裝

[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-*

-r-xr-xr-x 1 root root   41753 Oct 2 22:02 /usr/local/bin/pt-align

-r-xr-xr-x 1 root root 264365 Oct 2 22:02 /usr/local/bin/pt-archiver

-r-xr-xr-x 1 root root 169286 Oct 2 22:02 /usr/local/bin/pt-config-diff

-r-xr-xr-x 1 root root 166482 Oct 2 22:02 /usr/local/bin/pt-deadlock-logger

-r-xr-xr-x 1 root root 165199 Oct 2 22:02 /usr/local/bin/pt-diskstats

-r-xr-xr-x 1 root root 169478 Oct 2 22:02 /usr/local/bin/pt-duplicate-key-checker

-r-xr-xr-x 1 root root   50163 Oct 2 22:02 /usr/local/bin/pt-fifo-split

-r-xr-xr-x 1 root root 149999 Oct 2 22:02 /usr/local/bin/pt-find

-r-xr-xr-x 1 root root   67310 Oct 2 22:02 /usr/local/bin/pt-fingerprint

-r-xr-xr-x 1 root root 133459 Oct 2 22:02 /usr/local/bin/pt-fk-error-logger

-r-xr-xr-x 1 root root 219308 Oct 2 22:02 /usr/local/bin/pt-heartbeat

-r-xr-xr-x 1 root root 226592 Oct 2 22:02 /usr/local/bin/pt-index-usage

-r-xr-xr-x 1 root root   32411 Oct 2 22:02 /usr/local/bin/pt-ioprofile

-r-xr-xr-x 1 root root 250986 Oct 2 22:02 /usr/local/bin/pt-kill

-r-xr-xr-x 1 root root   21876 Oct 2 22:02 /usr/local/bin/pt-mext

-r-xr-xr-x 1 root root 6402784 Oct 2 22:02 /usr/local/bin/pt-mongodb-query-digest

-r-xr-xr-x 1 root root 6596000 Oct 2 22:02 /usr/local/bin/pt-mongodb-summary

-r-xr-xr-x 1 root root 102146 Oct 2 22:02 /usr/local/bin/pt-mysql-summary

-r-xr-xr-x 1 root root 399567 Oct 2 22:02 /usr/local/bin/pt-online-schema-change

-r-xr-xr-x 1 root root   24660 Oct 2 22:02 /usr/local/bin/pt-pmp

-r-xr-xr-x 1 root root 521606 Oct 2 22:02 /usr/local/bin/pt-query-digest

-r-xr-xr-x 1 root root   75986 Oct 2 22:02 /usr/local/bin/pt-show-grants

-r-xr-xr-x 1 root root   37790 Oct 2 22:02 /usr/local/bin/pt-sift

-r-xr-xr-x 1 root root 145825 Oct 2 22:02 /usr/local/bin/pt-slave-delay

-r-xr-xr-x 1 root root 129838 Oct 2 22:02 /usr/local/bin/pt-slave-find

-r-xr-xr-x 1 root root 182243 Oct 2 22:02 /usr/local/bin/pt-slave-restart

-r-xr-xr-x 1 root root   73082 Oct 2 22:02 /usr/local/bin/pt-stalk

-r-xr-xr-x 1 root root   90795 Oct 2 22:02 /usr/local/bin/pt-summary

-r-xr-xr-x 1 root root 424922 Oct 2 22:02 /usr/local/bin/pt-table-checksum

-r-xr-xr-x 1 root root 399440 Oct 2 22:02 /usr/local/bin/pt-table-sync

-r-xr-xr-x 1 root root 247137 Oct 2 22:02 /usr/local/bin/pt-table-usage

-r-xr-xr-x 1 root root 331255 Oct 2 22:02 /usr/local/bin/pt-upgrade

-r-xr-xr-x 1 root root 177292 Oct 2 22:02 /usr/local/bin/pt-variable-advisor

-r-xr-xr-x 1 root root 102551 Oct 2 22:02 /usr/local/bin/pt-visual-explain

這樣就算安裝完畢了,很簡(jiǎn)單.

搞個(gè)測(cè)試，MySQL服務(wù)狀態(tài)顯示：

[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 ################################################

后面一大串，在此省略，測(cè)試正常運(yùn)行。        pt(Percona Toolkit)工具安裝

一．pt(Percona Toolkit)工具是由Percona公司開發(fā)的一個(gè)用perl語言編寫的工具集,包含很多功能,例如在線更改數(shù)據(jù)表結(jié)構(gòu),校驗(yàn)主從數(shù)據(jù),檢查數(shù)據(jù)庫狀態(tài),分析慢查詢等這些靠人手做起來比較麻煩的事情,功能強(qiáng)大,操作簡(jiǎn)單

二.安裝依賴包

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

進(jìn)入目錄安裝

[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-*

-r-xr-xr-x 1 root root   41753 Oct 2 22:02 /usr/local/bin/pt-align

-r-xr-xr-x 1 root root 264365 Oct 2 22:02 /usr/local/bin/pt-archiver

-r-xr-xr-x 1 root root 169286 Oct 2 22:02 /usr/local/bin/pt-config-diff

-r-xr-xr-x 1 root root 166482 Oct 2 22:02 /usr/local/bin/pt-deadlock-logger

-r-xr-xr-x 1 root root 165199 Oct 2 22:02 /usr/local/bin/pt-diskstats

-r-xr-xr-x 1 root root 169478 Oct 2 22:02 /usr/local/bin/pt-duplicate-key-checker

-r-xr-xr-x 1 root root   50163 Oct 2 22:02 /usr/local/bin/pt-fifo-split

-r-xr-xr-x 1 root root 149999 Oct 2 22:02 /usr/local/bin/pt-find

-r-xr-xr-x 1 root root   67310 Oct 2 22:02 /usr/local/bin/pt-fingerprint

-r-xr-xr-x 1 root root 133459 Oct 2 22:02 /usr/local/bin/pt-fk-error-logger

-r-xr-xr-x 1 root root 219308 Oct 2 22:02 /usr/local/bin/pt-heartbeat

-r-xr-xr-x 1 root root 226592 Oct 2 22:02 /usr/local/bin/pt-index-usage

-r-xr-xr-x 1 root root   32411 Oct 2 22:02 /usr/local/bin/pt-ioprofile

-r-xr-xr-x 1 root root 250986 Oct 2 22:02 /usr/local/bin/pt-kill

-r-xr-xr-x 1 root root   21876 Oct 2 22:02 /usr/local/bin/pt-mext

-r-xr-xr-x 1 root root 6402784 Oct 2 22:02 /usr/local/bin/pt-mongodb-query-digest

-r-xr-xr-x 1 root root 6596000 Oct 2 22:02 /usr/local/bin/pt-mongodb-summary

-r-xr-xr-x 1 root root 102146 Oct 2 22:02 /usr/local/bin/pt-mysql-summary

-r-xr-xr-x 1 root root 399567 Oct 2 22:02 /usr/local/bin/pt-online-schema-change

-r-xr-xr-x 1 root root   24660 Oct 2 22:02 /usr/local/bin/pt-pmp

-r-xr-xr-x 1 root root 521606 Oct 2 22:02 /usr/local/bin/pt-query-digest

-r-xr-xr-x 1 root root   75986 Oct 2 22:02 /usr/local/bin/pt-show-grants

-r-xr-xr-x 1 root root   37790 Oct 2 22:02 /usr/local/bin/pt-sift

-r-xr-xr-x 1 root root 145825 Oct 2 22:02 /usr/local/bin/pt-slave-delay

-r-xr-xr-x 1 root root 129838 Oct 2 22:02 /usr/local/bin/pt-slave-find

-r-xr-xr-x 1 root root 182243 Oct 2 22:02 /usr/local/bin/pt-slave-restart

-r-xr-xr-x 1 root root   73082 Oct 2 22:02 /usr/local/bin/pt-stalk

-r-xr-xr-x 1 root root   90795 Oct 2 22:02 /usr/local/bin/pt-summary

-r-xr-xr-x 1 root root 424922 Oct 2 22:02 /usr/local/bin/pt-table-checksum

-r-xr-xr-x 1 root root 399440 Oct 2 22:02 /usr/local/bin/pt-table-sync

-r-xr-xr-x 1 root root 247137 Oct 2 22:02 /usr/local/bin/pt-table-usage

-r-xr-xr-x 1 root root 331255 Oct 2 22:02 /usr/local/bin/pt-upgrade

-r-xr-xr-x 1 root root 177292 Oct 2 22:02 /usr/local/bin/pt-variable-advisor

-r-xr-xr-x 1 root root 102551 Oct 2 22:02 /usr/local/bin/pt-visual-explain

這樣就算安裝完畢了,很簡(jiǎn)單.

搞個(gè)測(cè)試，MySQL服務(wù)狀態(tài)顯示：

[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 ################################################

后面一大串，在此省略，測(cè)試正常運(yùn)行。

（編輯：武林網(wǎng)）

上一篇：PXC5.7.21 for linux7.2安設(shè)

下一篇：Mycat的運(yùn)用 - 01.概念及安裝