Trace:

Differences

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

--- percona_toolkit [2013/10/01 12:55]
+++ 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]]