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