====== pt-find ======

  * [[Percona Toolkit]]

Find MySQL tables and execute actions, like GNU find.

  * [[http://www.percona.com/doc/percona-toolkit/2.1/pt-find.html|Documentation]]

== Find MyISAM tables: ==
<code>
pt-find --engine MyISAM <database>
</code>

== Convert MyISAM to InnoDB ==

<code>
pt-find --engine MyISAM --exec "ALTER TABLE %D.%N ENGINE=InnoDB"
</code>

== Find the largest tables and indexes, and sort by size: ==

<code>
pt-find --printf "%T\t%D.%N\n" <database> | sort -rn
</code>