Differences

This shows you the differences between two versions of the page.

Link to this comparison view

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]]