Installation and use of mysql third-party tools percona-toolkit
Like percona-xtrabackup, the percona-toolkit toolkit is written in Perl. The percona-toolkit toolkit is a set of advanced toolkits for managing mysql, which can be used to perform a variety of very complex and troublesome mysql and system tasks by hand. It can greatly improve efficiency in a production environment and is easy to install. You can download the compilation package or the rpm package on percona's official website: https://www.percona.com Of course, because my local yum source is equipped, I install the RPM package with yum, and yum can also automatically resolve dependencies. The installation steps are as follows:
[root@localhost 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
[root@localhost src] # yum-y install percona-toolkit-3.0.1-1.el6.x86_64.rpm
Installation 2:
Environment: centos6.5
Download address: 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 you report BEGIN failed--compilation aborted at Makefile.PL line 1, you need to install perl-devel
Yum install perl-devel
Executing perl Makefile.PL after installation may not report finding DBI,DBD-MySQL,IO-Socket-SSL.noarch,perl-Time-HiRes
Install online using the following methods:
Yum install perl-DBI
Yum install perl-DBD-MySQL
Yum install perl-IO-Socket-SSL.noarch
Yum install perl-Time-HiRes
Then:
Make
Make install
Pt-table-checksum-- help to see if the installation is successful.
2: online installation: yum install-y percona-toolkit
Tool description
Tool category
Tool command
Tool function
Remarks
Development class
Pt-duplicate-key-checker
List and delete duplicate indexes and foreign keys
Pt-online-schema-change
Modify the table structure online
Pt-query-advisor
Analyze the query statement and give some suggestions, including bug
Abandoned
Pt-show-grants
Normalization and print permissions
Pt-upgrade
Execute queries on multiple servers and compare the differences
Performance class
Pt-index-usage
Analyze the index usage in the log and report
Pt-pmp
Track the query results and summarize the tracking results
Pt-visual-explain
Format the execution plan
Pt-table-usage
Analyze query in log and analyze table usage
Pt 2.2 New commands
Configuration class
Pt-config-diff
Compare configuration files and parameters
Pt-mysql-summary
Summarize mysql configuration and status
Pt-variable-advisor
Analyze the parameters and make suggestions
Monitoring class
Pt-deadlock-logger
Extract and record mysql deadlock information
Pt-fk-error-logger
Extract and record foreign key information
Pt-mext
View status sample information in parallel
Pt-query-digest
Analyze the query log and generate a report
Common command
Pt-trend
Read slow log information by time period
Abandoned
Copy CLA
Pt-heartbeat
Monitoring mysql replication latency
Pt-slave-delay
Set the time to lag behind the master
Pt-slave-find
Find and print all mysql replication hierarchy relationships
Pt-slave-restart
Monitor salve errors and try to restart salve
Pt-table-checksum
Verify the consistency of master-slave replication
Pt-table-sync
Efficient synchronization of table data
System class
Pt-diskstats
View system disk status
Pt-fifo-split
Simulate the cutting file and output
Pt-summary
Collect 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 commands
Pt-ioprofile
Query the process IO and print an IO activity table
Pt 2.2 New commands
Crafts, Hobbies and Home
Pt-archiver
Archive table data to another table or file
Pt-find
Find the table and execute the command
Pt-kill
Kill drops the eligible sql.
Common command
Pt-align
Align the output of other tools
Pt 2.2 New commands
Pt-fingerprint
Convert a query into ciphertext
Pt 2.2 New commands
Instructions for using pt-online-schema-change http://seanlook.com/2016/05/27/mysql-pt-online-schema-change/
