Maatkit

Maatkit makes MySQL easier and safer to manage.

It provides simple, predictable ways to do things you cannot otherwise do.You can use Maatkit to prove replication is working correctly, fix corrupted data, automate repetitive tasks, speed up your servers, and much, much more.

It provides a collection of command-line utilities that provide missing functionality for MySQL. Some of the tools implement lacking server functionality, such as online consistency checks for master/slave replication; others are client-side utilities such as a query profiler.

Tools:

mk-archiver
Archive rows from a MySQL table into another table or a file. 

mk-checksum-filter
Filter checksums from mk-table-checksum.

mk-deadlock-logger
Extract and log MySQL deadlock information.

mk-duplicate-key-checker
Find possible duplicate indexes and foreign keys on MySQL tables.

mk-find
Find MySQL tables and execute actions, like GNU find.

mk-heartbeat
Monitor MySQL replication delay.

mk-parallel-dump
Dump sets of MySQL tables in parallel.

mk-parallel-restore
Load files into MySQL in parallel.

mk-profile-compact
Compact the output from mk-query-profiler.

mk-query-profiler
Execute SQL statements and print statistics, or measure activity caused by other processes.

mk-show-grants
Canonicalize and print MySQL grants so you can effectively replicate, compare and version-control them.

mk-slave-delay
Make a MySQL slave server lag behind its master.

mk-slave-find
Find MySQL replication slaves and execute commands on them.

mk-slave-move
Move a MySQL slave around in the replication hierarchy.

mk-slave-prefetch
Pipeline relay logs on a MySQL slave to pre-warm caches.

mk-slave-restart
Watch and restart MySQL replication after errors.

mk-table-checksum
Perform an online replication consistency check, or checksum MySQL tables efficiently on one or many servers.

mk-table-sync
Synchronize MySQL tables efficiently.

mk-visual-explain
Format EXPLAIN output as a tree.