Differences
This shows you the differences between two versions of the page.
| — |
percona_toolkit [2013/10/01 12:55] (current) |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| + | ====== Percona Toolkit ====== | ||
| + | * [[MySQL]] | ||
| + | * [[Percona]] | ||
| + | * [[maatkit]] | ||
| + | * [[pt-find]] | ||
| + | |||
| + | * [[http://www.percona.com/doc/percona-toolkit/2.2/|Documentation]] | ||
| + | |||
| + | === pt-duplicate-key-checker === | ||
| + | |||
| + | Find duplicate indexes and foreign keys on MySQL tables. | ||
| + | |||
| + | * [[http://www.percona.com/doc/percona-toolkit/2.1/pt-duplicate-key-checker.html|Documentation]] | ||
| + | |||
| + | Find duplicate indexes on a database: | ||
| + | |||
| + | <code> | ||
| + | pt-duplicate-key-checker -d database | ||
| + | </code> | ||
| + | |||
| + | === pt-index-usage === | ||
| + | |||
| + | Read queries from a log and analyze how they use indexes. | ||
| + | |||
| + | * [[http://www.percona.com/doc/percona-toolkit/2.1/pt-index-usage.html|Documentation]] | ||
| + | |||
| + | <code> | ||
| + | pt-index-usage /var/log/mysql/mysql-slow.log | ||
| + | </code> | ||
| + | |||
| + | === pt-mysql-summary === | ||
| + | |||
| + | * [[http://www.percona.com/doc/percona-toolkit/2.2/pt-mysql-summary.html|Documentation]] | ||
| + | |||
| + | Summarize MySQL information nicely. | ||
| + | |||
| + | <code> | ||
| + | pt-mysql-summary | ||
| + | </code> | ||
| + | |||
| + | === pt-variable-advisor === | ||
| + | |||
| + | * [[http://www.percona.com/doc/percona-toolkit/2.2/pt-variable-advisor.html|Documentation]] | ||
| + | |||
| + | Check MySQL configuration for suggested changes. | ||
| + | |||
| + | === pt-query-advisor === | ||
| + | |||
| + | Analyze queries and advise on possible problems. | ||
| + | |||
| + | * [[http://www.percona.com/doc/percona-toolkit/2.1/pt-query-advisor.html|Documentation]] | ||
