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:// | ||