Maatkit: Tools for MySQL

Friday, June 18th, 2010

Maatkit is a suite of command-line tools for MySQL. It contains some rather nifty things for query analyses, replication, and other stuff. Some of the more interesting highlights:

• mk-deadlock-logger
  Extract and log MySQL deadlock information.
• mk-log-player
  Split and play MySQL slow logs.
• mk-error-log
  Find new and different MySQL error log entries.
• mk-index-usage
  Read queries from a log and analyze how they use indexes.
• And many more…

Found via databasejournal.com, which has two articles on Maatkit:

The Wonders of Maatkit for MySQL and
Even more Maatkit for MySQL.