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

Introduction to pt tools

Percona Toolkit, abbreviated as pt tool, is a tool developed by Percona Company for managing MySQL. Its functions include checking data consistency of master-slave replication, checking duplicate indexes, locating table files with high IO consumption, online DDL, etc. DBAs will greatly improve their work efficiency after they are familiar with it.

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

yum localinstall percona-toolkit-3.0.1-1.el7.x86_64.rpm

tool category

tool command

tool to function

remarks

development type

pt-duplicate-key-checker

List and remove duplicate indexes and foreign keys

pt-online-schema-change

Modify table structure online

pt-query-advisor

Analyze query statements and give suggestions, bugs

obsolete

pt-show-grants

Normalization 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 query results and summarize them

pt-visual-explain

Format the implementation plan

pt-table-usage

Query and analyze table usage in the analysis log

pt 2.2 New command

configuration class

pt-config-diff

Compare profiles and parameters

pt-mysql-summary

Summarize mysql configuration and status

pt-variable-advisor

Analyze parameters and make recommendations

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 query logs and generate reports

frequently used commands

pt-trend

Read slow log information by time period

obsolete

copy class

pt-heartbeat

Monitoring mysql replication latency

pt-slave-delay

Set the time for slave to lag behind master

pt-slave-find

Find and print all mysql copy hierarchies

pt-slave-restart

Monitor salve errors and try to restart salve

pt-table-checksum

Verify master-slave replication consistency

pt-table-sync

Efficient synchronization table data

system class

pt-diskstats

View system disk status

pt-fifo-split

Simulate cutting files and output

pt-summary

Collection and display of system profiles

pt-stalk

Collect diagnostic data when problems arise

pt-sift

Browse files created by pt-stalk

pt 2.2 New command

pt-ioprofile

Query IO process and print an IO activity table

pt 2.2 New command

utility class

pt-archiver

Archive table data into another table or file

pt-find

Look up tables and execute commands

pt-kill

Kill qualified sql

frequently used commands

pt-align

Align output from other tools

pt 2.2 New command

pt-fingerprint

Turn queries into ciphertext

pt 2.2 New command

Use command --help to see what each command does and how to use it.

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.