MySQL third party tools Percona-toolkit installation use

The Percona-toolkit toolkit, like Percona-xtrabackup, is a Perl-written toolkit, and the Percona-toolkit Toolkit is a set of advanced toolkit for managing MySQL, Can be used to perform a variety of manual execution of very complex and troublesome MySQL and system tasks, in the production environment can greatly improve efficiency, installation is very simple, can be in Percona's official website: https:// Www.percona.com Download the compilation package or RPM package, of course, because my local Yum source is well-equipped, I use Yum to install the RPM package, Yum can also automatically resolve the dependency, the installation steps are as follows:

[Email protected] src]# wget https://www.percona.com/downloads/percona-toolkit/3.0.1/binary/redhat/6/x86_64/ percona-toolkit-3.0.1-1.el6.x86_64.rpm

[Email protected] src]# yum-y install percona-toolkit-3.0.1-1.el6.x86_64.rpm

Installation 2:

Environment: centos6.5

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

Cd/opt

wget https://www.percona.com/downloads/percona-toolkit/3.0.2/binary/tarball/percona-toolkit-3.0.2_x86_64.tar.gz

TAR-ZXVF percona-toolkit-3.0.2_x86_64.tar.gz

CD percona-toolkit-3.0.2

Perl makefile.pl

If reported: BEGIN failed--compilation aborted at makefile.pl Line 1, need to be installed Perl-devel

Yum Install Perl-devel

After installation, the Perl makefile.pl may not be able to find Dbi,dbd-mysql,io-socket-ssl.noarch,perl-time-hires

Install it online using the following method:

Yum Install PERL-DBI

Yum Install Perl-dbd-mysql

Yum Install Perl-io-socket-ssl.noarch

Yum Install Perl-time-hires

And then:

Make

Make install

Pt-table-checksum--help See if it's successful.

2: Online installation: Yum install-y percona-toolkit

Tool description

Tool categories

	Tool commands	Tool function	Note
Development class	Pt-duplicate-key-checker	List and delete duplicate indexes and foreign keys
	Pt-online-schema-change	Modify Table Structure Online
	Pt-query-advisor	Parse query statements and give suggestions, bugs	IS obsolete
	Pt-show-grants	Normalize and Print permissions
	Pt-upgrade	Execute queries on multiple servers and compare different
Performance class	Pt-index-usage	Analyze index usage in logs and report
	Pt-pmp	Track the query results and summarize the trace results
	Pt-visual-explain	Formatting execution plans
	Pt-table-usage	Query and analyze table usage in the analysis log	PT 2.2 New command
Configuration class	Pt-config-diff	Comparing configuration files and parameters
	Pt-mysql-summary	Summarize MySQL configuration and status
	Pt-variable-advisor	Analyze the parameters and make recommendations
Monitoring class	Pt-deadlock-logger	Extracting and recording MySQL deadlock information
	Pt-fk-error-logger	Extracting and recording foreign key information
	Pt-mext	View status sample information in parallel
	Pt-query-digest	Analyze query logs and generate reports	Common commands
	Pt-trend	Read slow log information by time period	IS obsolete
Copy class	Pt-heartbeat	Monitoring MySQL Replication latency
	Pt-slave-delay	Set the time from the fallen master
	Pt-slave-find	Find and print all MySQL replication hierarchy relationships
	Pt-slave-restart	Monitor salve errors and try restarting Salve
	Pt-table-checksum	Verifying master-Slave Replication consistency
	Pt-table-sync	Efficient synchronization of table data
System class	Pt-diskstats	View system disk Status
	Pt-fifo-split	Simulate cutting files and outputting
	Pt-summary	Collection and display System overview
	Pt-stalk	Collect diagnostic data when a problem occurs
	Pt-sift	Browse for files created by Pt-stalk	PT 2.2 New command
	Pt-ioprofile	Querying the process IO and printing an IO activity table	PT 2.2 New command
Practical class	Pt-archiver	Archive table data to another table or file
	Pt-find	Find tables and Execute commands
	Pt-kill	Kill the Eligible SQL	Common commands
	Pt-align	Aligning the output of other tools	PT 2.2 New command
	Pt-fingerprint	Turn queries into ciphertext	PT 2.2 New command

Pt-online-schema-change Instructions for use http://seanlook.com/2016/05/27/mysql-pt-online-schema-change/

MySQL third party tools Percona-toolkit installation use