no way to compare when less than two revisions
Differences
This shows you the differences between two versions of the page.
— | percona_toolkit [2013/10/01 18:55] (current) – created - external edit 127.0.0.1 | ||
---|---|---|---|
Line 1: | Line 1: | ||
+ | ====== Percona Toolkit ====== | ||
+ | * [[MySQL]] | ||
+ | * [[Percona]] | ||
+ | * [[maatkit]] | ||
+ | * [[pt-find]] | ||
+ | |||
+ | * [[http:// | ||
+ | |||
+ | === pt-duplicate-key-checker === | ||
+ | |||
+ | Find duplicate indexes and foreign keys on MySQL tables. | ||
+ | |||
+ | * [[http:// | ||
+ | |||
+ | Find duplicate indexes on a database: | ||
+ | |||
+ | < | ||
+ | pt-duplicate-key-checker -d database | ||
+ | </ | ||
+ | |||
+ | === pt-index-usage === | ||
+ | |||
+ | Read queries from a log and analyze how they use indexes. | ||
+ | |||
+ | * [[http:// | ||
+ | |||
+ | < | ||
+ | pt-index-usage / | ||
+ | </ | ||
+ | |||
+ | === pt-mysql-summary === | ||
+ | |||
+ | * [[http:// | ||
+ | |||
+ | Summarize MySQL information nicely. | ||
+ | |||
+ | < | ||
+ | pt-mysql-summary | ||
+ | </ | ||
+ | |||
+ | === pt-variable-advisor === | ||
+ | |||
+ | * [[http:// | ||
+ | |||
+ | Check MySQL configuration for suggested changes. | ||
+ | |||
+ | === pt-query-advisor === | ||
+ | |||
+ | Analyze queries and advise on possible problems. | ||
+ | |||
+ | * [[http:// |