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

Navigation
QR Code
QR Code percona_toolkit (generated for current page)