Shulou(Shulou.com)06/01 Report--

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/

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.