Robert Harker Technical Wiki
Thoughts and Ideas About Large Sites

[ Prev ] [ Index ] [ Next ]


Percona Toolkit

Flags:
F=/etc/my.cfg
D=database_name
t=table_name
-u user
-p passwd
--print

pt-archiver

Copy data from one table into another table or file
Cleans up data of trash

pt-duplicate-key-checker

Find duplicate indexes and foreign keys on MySQL table

pt-mysql-summary

Show mysql configuration
info about host and mysql
Replication
10 second status info

pt-summary

finger print the OS

pt-online-schema-change

ALTER tables without locking them
Hot online ALTER TABLE
Creates and populate new table, switch tables

Test with --dry-run
Look for errors
Run with --execute

pt-query-digest

Analyze MySQL queries from logs process list or tcpdump
Analyze slow queries
Tool can generate more detailed output than default

pt-stalk

Collects forensic data about MySQL when problems occur
Runs as a damon

pt-table-checksum

Veriry MySQL replication integrity
Find slaves with incorrect data

pt-table-sync

Fixes slaves with incorrect data


Backlinks: index Start
Created with Zim desktop wiki