Differences
This shows you the differences between two versions of the page.
| — | pt-find [2016/01/20 20:17] (current) – created - external edit 127.0.0.1 | ||
|---|---|---|---|
| Line 1: | Line 1: | ||
| + | ====== pt-find ====== | ||
| + | * [[Percona Toolkit]] | ||
| + | |||
| + | Find MySQL tables and execute actions, like GNU find. | ||
| + | |||
| + | * [[http:// | ||
| + | |||
| + | == Find MyISAM tables: == | ||
| + | < | ||
| + | pt-find --engine MyISAM < | ||
| + | </ | ||
| + | |||
| + | == Convert MyISAM to InnoDB == | ||
| + | |||
| + | < | ||
| + | pt-find --engine MyISAM --exec "ALTER TABLE %D.%N ENGINE=InnoDB" | ||
| + | </ | ||
| + | |||
| + | == Find the largest tables and indexes, and sort by size: == | ||
| + | |||
| + | < | ||
| + | pt-find --printf " | ||
| + | </ | ||
