Install and Use Percona Toolkit on Centos 7

The Percona Toolkit is a group of cutting-edge open-source command-line tools that were build and used by Percona technical staff, build to perform a variety of MySQL® and MongoDB® server and system tasks automatically that perform manually are very difficult or complicated to do.

Install Percona Toolkit on Centos 7:

Percona toolkit rpm can be downloaded from Percona repository:

wget https://www.percona.com/downloads/percona-toolkit/3.2.0/binary/redhat/7/x86_64/percona-toolkit-3.2.0-1.el7.x86_64.rpm

you can install the percona-toolkit rpm using yum it will solve all the dependencies from Percona repository

yum install -y percona-toolkit-3.2.0-1.el7.x86_64.rpm

Once the installation is done you will find all the below list of tools installed on your server.

you can check below if percona tools have been installed or not in /usr/bin/ directory

[root@localhost bin]# ll /usr/bin/pt-*
-rwxr-xr-x. 1 root root    41747 Apr 23 20:41 /usr/bin/pt-align
-rwxr-xr-x. 1 root root   272634 Apr 23 20:41 /usr/bin/pt-archiver
-rwxr-xr-x. 1 root root   171698 Apr 23 20:41 /usr/bin/pt-config-diff
-rwxr-xr-x. 1 root root   168893 Apr 23 20:41 /usr/bin/pt-deadlock-logger
-rwxr-xr-x. 1 root root   166450 Apr 23 20:41 /usr/bin/pt-diskstats
-rwxr-xr-x. 1 root root   172014 Apr 23 20:41 /usr/bin/pt-duplicate-key-checker
-rwxr-xr-x. 1 root root    50157 Apr 23 20:41 /usr/bin/pt-fifo-split
-rwxr-xr-x. 1 root root   152724 Apr 23 20:41 /usr/bin/pt-find
-rwxr-xr-x. 1 root root    67304 Apr 23 20:41 /usr/bin/pt-fingerprint
-rwxr-xr-x. 1 root root   135870 Apr 23 20:41 /usr/bin/pt-fk-error-logger
-rwxr-xr-x. 1 root root   225525 Apr 23 20:41 /usr/bin/pt-heartbeat
-rwxr-xr-x. 1 root root   229128 Apr 23 20:41 /usr/bin/pt-index-usage
-rwxr-xr-x. 1 root root    32405 Apr 23 20:41 /usr/bin/pt-ioprofile
-rwxr-xr-x. 1 root root   257728 Apr 23 20:41 /usr/bin/pt-kill
-rwxr-xr-x. 1 root root    21913 Apr 23 20:41 /usr/bin/pt-mext
-rwxr-xr-x. 1 root root  9908136 Apr 23 20:42 /usr/bin/pt-mongodb-query-digest
-rwxr-xr-x. 1 root root 10307464 Apr 23 20:42 /usr/bin/pt-mongodb-summary
-rwxr-xr-x. 1 root root   108113 Apr 23 20:41 /usr/bin/pt-mysql-summary
-rwxr-xr-x. 1 root root   431516 Apr 23 20:41 /usr/bin/pt-online-schema-change
-rwxr-xr-x. 1 root root  5889136 Apr 23 20:42 /usr/bin/pt-pg-summary
-rwxr-xr-x. 1 root root    24598 Apr 23 20:41 /usr/bin/pt-pmp
-rwxr-xr-x. 1 root root   529350 Apr 23 20:41 /usr/bin/pt-query-digest
-rwxr-xr-x. 1 root root  4412272 Apr 23 20:42 /usr/bin/pt-secure-collect
-rwxr-xr-x. 1 root root    79159 Apr 23 20:41 /usr/bin/pt-show-grants
-rwxr-xr-x. 1 root root    37784 Apr 23 20:41 /usr/bin/pt-sift
-rwxr-xr-x. 1 root root   147867 Apr 23 20:41 /usr/bin/pt-slave-delay
-rwxr-xr-x. 1 root root   133040 Apr 23 20:41 /usr/bin/pt-slave-find
-rwxr-xr-x. 1 root root   186580 Apr 23 20:41 /usr/bin/pt-slave-restart
-rwxr-xr-x. 1 root root    76185 Apr 23 20:41 /usr/bin/pt-stalk
-rwxr-xr-x. 1 root root    90816 Apr 23 20:41 /usr/bin/pt-summary
-rwxr-xr-x. 1 root root   461826 Apr 23 20:41 /usr/bin/pt-table-checksum
-rwxr-xr-x. 1 root root   406316 Apr 23 20:41 /usr/bin/pt-table-sync
-rwxr-xr-x. 1 root root   248658 Apr 23 20:41 /usr/bin/pt-table-usage
-rwxr-xr-x. 1 root root   334033 Apr 23 20:41 /usr/bin/pt-upgrade
-rwxr-xr-x. 1 root root   179330 Apr 23 20:41 /usr/bin/pt-variable-advisor
-rwxr-xr-x. 1 root root   103460 Apr 23 20:41 /usr/bin/pt-visual-explain

Tools

[root@localhost ~]# pt-summary

# Percona Toolkit System Summary Report ######################
Date | 2020-06-22 16:07:15 UTC (local TZ: +03 +0300)
Hostname | localhost.localdomain
Uptime | 8:06, 4 users, load average: 0.02, 0.02, 0.05
System | innotek GmbH; VirtualBox; v1.2 (Other)
Service Tag | 0
Platform | Linux
Release | CentOS Linux release 7.8.2003 (Core)
Kernel | 3.10.0-1127.10.1.el7.x86_64
Architecture | CPU = 64-bit, OS = 64-bit
Threading | NPTL 2.17
SELinux | Enforcing
Virtualized | KVM
# Processor ##################################################
Processors | physical = 1, cores = 1, virtual = 1, hyperthreading = no
Speeds | 1x2394.466
Models | 1xIntel(R) Core(TM) i7-5500U CPU @ 2.40GHz
Caches | 1x4096 KB
# Memory #####################################################
Total | 3.7G
Free | 648.4M
Used | physical = 1.1G, swap allocated = 2.5G, swap used = 0.0, virtual = 1.1G
Shared | 18.7M
Buffers | 2.0G
Caches | 2.3G
Dirty | 112 kB
UsedRSS | 1.5G
Swappiness | 30
DirtyPolicy | 30, 10
DirtyStatus | 0, 0
Locator Size Speed Form Factor Type Type Detail
========= ======== ================= ============= ============= ===========
# Mounted Filesystems ########################################
Filesystem Size Used Type Opts Mountpoint
/dev/mapper/centos-root 37G 22% xfs rw,relatime,seclabel,attr2,inode64,noquota /
/dev/sda1 1014M 24% xfs rw,relatime,seclabel,attr2,inode64,noquota /boot
.
.
.
tmpfs 377M 1% tmpfs ro,nosuid,nodev,noexec,seclabel,mode=755 /run/user/0
# Disk Schedulers And Queue Size #############################
dm-0 | 128
dm-1 | 128
sda | [deadline] 128
sr0 | [deadline] 128
# Disk Partioning ############################################
Device Type Start End Size
============ ==== ========== ========== ==================
/dev/dm-0 Disk 39183187968
/dev/dm-1 Disk 2684354560
/dev/sda Disk 42949672960
/dev/sda1 Part 2048 2099199 1073741312
/dev/sda2 Part 2099200 83886079 41874882048
# Kernel Inode State #########################################
dentry-state | 50193 30566 45 0 3904 0
file-nr | 8672 0 378007
inode-nr | 64170 21818
# LVM Volumes ################################################
LV VG Attr LSize Pool Origin Data% Meta% Move Log Cpy%Sync Convert
root centos -wi-ao---- 36.49g
swap centos -wi-ao---- 2.50g
# LVM Volume Groups ##########################################
VG VSize VFree
centos <39.00g 4.00m
# RAID Controller ############################################
Controller | No RAID controller detected
# Network Config #############################################
Controller | Intel Corporation 82540EM Gigabit Ethernet Controller (rev 02)
Controller | Intel Corporation 82540EM Gigabit Ethernet Controller (rev 02)
FIN Timeout | 60
Port Range | 60999
# Interface Statistics #######################################
interface rx_bytes rx_packets rx_errors tx_bytes tx_packets tx_errors
========= ========= ========== ========== ========== ========== ==========
lo 5000 60 0 5000 60 0
enp0s3 300000 3000 0 600000 3000 0
enp0s8 600000000 450000 0 3500000 60000 0
virbr0 0 0 0 0 0 0
virbr0-nic 0 0 0 0 0 0
vboxnet0 0 0 0 3500 20 0
# Network Devices ############################################
Device Speed Duplex
========= ========= =========
virbr0-nic 10Mb/s Full
vboxnet0 10Mb/s Full
enp0s3 1000Mb/s Full
virbr0
enp0s8 1000Mb/s Full
# Network Connections ########################################

22 1
States of connections
ESTABLISHED 1
LISTEN 10
# Top Processes ##############################################
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
15551 root 20 0 162128 2188 1516 R 18.8 0.1 0:00.04 top
.
.
10 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 lru-add-dra+
# Notable Processes ##########################################
PID OOM COMMAND
1231 -17 sshd
# Memory mamagement ##########################################
Transparent huge pages are enabled.
# The End ####################################################

pt-mysql-summary can be used as mention in below example

[root@localhost ~]# pt-mysql-summary --host localhost --user root --ask-pass

 

Below example show the usage of disks stats at OS level:

[root@localhost ~]#pt-diskstats

# A software update is available:
#ts device rd_s rd_avkb rd_mb_s rd_mrg rd_cnc rd_rt wr_s wr_avkb wr_mb_s wr_mrg wr_cnc wr_rt busy in_prg io_s qtime stime
1.0 sda 0.0 0.0 0.0 0% 0.0 0.0 7.0 10.8 0.1 12% 0.0 2.2 1% 0 7.0 1.5 0.8
1.0 sda2 0.0 0.0 0.0 0% 0.0 0.0 6.0 12.6 0.1 14% 0.0 2.4 1% 0 6.0 1.7 0.7
1.0 dm-0 0.0 0.0 0.0 0% 0.0 0.0 7.0 10.8 0.1 0% 0.0 2.9 1% 0 7.0 2.0 0.9

1.0 sda 0.0 0.0 0.0 0% 0.0 0.0 0.0 0.0 0.0 0% 0.0 0.0 0% 0 0.0 0.0 0.0
1.0 sda2 0.0 0.0 0.0 0% 0.0 0.0 0.0 0.0 0.0 0% 0.0 0.0 0% 0 0.0 0.0 0.0
1.0 dm-0 0.0 0.0 0.0 0% 0.0 0.0 0.0 0.0 0.0 0% 0.0 0.0 0% 0 0.0 0.0 0.0

 

 347 views last month,  2 views today

About Mughees Ahmed

Over 2-year experience of Administration in Oracle, SQL Server, and MySQL databases using various tools and technologies. Keen on learning new database technologies having very good analytical skills. Working knowledge of Red Hat Linux, UNIX, Solaris and Windows Server 2012 is a valuable addition to my knowledge desk. KNOWLEDGE & SKILLS • Oracle Database Server 10g/11g/12c. • Oracle RAC, Data guard. • Oracle Golden Gate (Oracle to Oracle, Oracle to MySQL and MySQL to Oracle) • Oracle Enterprise Manager Grid Control, Toad, SQL developer. • SQL Server 2005/2008/2012/2016. • SQL Server Failover clustering, mirroring & log shipping, Always On availability groups. • MySQL 5 Administration, MySQL Workbench, MySQL Enterprise Monitor, SQLyog • MySQL NDB Cluster Installation,Administration. • MySQL Asynchronous/Semi-synchronous replication. • Oracle OEM Contact me on mughees52@gmail.com

Check Also

Roll Back to Traditional Replication From GTID

If you want to roll back to old : # Now, we are going to …

Leave a Reply