pt(Percona Toolkit)工具安裝
創(chuàng)新互聯(lián)主要從事成都做網(wǎng)站、網(wǎng)站建設(shè)、網(wǎng)頁設(shè)計、企業(yè)做網(wǎng)站、公司建網(wǎng)站等業(yè)務(wù)。立足成都服務(wù)遂川,十多年網(wǎng)站建設(shè)經(jīng)驗,價格優(yōu)惠、服務(wù)專業(yè),歡迎來電咨詢建站服務(wù):13518219792
一.pt(Percona Toolkit)工具是由Percona公司開發(fā)的一個用perl語言編寫的工具集,包含很多功能,例如在線更改數(shù)據(jù)表結(jié)構(gòu),校驗主從數(shù)據(jù),檢查數(shù)據(jù)庫狀態(tài),分析慢查詢等這些靠人手做起來比較麻煩的事情,功能強大,操作簡單
二.安裝依賴包
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-*
-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
這樣就算安裝完畢了,很簡單.
搞個測試,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 ################################################
后面一大串,在此省略,測試正常運行。
分享文章:pt(PerconaToolkit)工具安裝
轉(zhuǎn)載來于:http://m.newbst.com/article2/gpigic.html
成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián),為您提供用戶體驗、建站公司、云服務(wù)器、小程序開發(fā)、做網(wǎng)站、網(wǎng)站收錄
聲明:本網(wǎng)站發(fā)布的內(nèi)容(圖片、視頻和文字)以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主,如果涉及侵權(quán)請盡快告知,我們將會在第一時間刪除。文章觀點不代表本網(wǎng)站立場,如需處理請聯(lián)系客服。電話:028-86922220;郵箱:631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載,或轉(zhuǎn)載時需注明來源: 創(chuàng)新互聯(lián)