Maatkit

Maatkit

Developer(s)	Baron Schwartz
Written in	Perl
Operating system	Cross-platform
Type	Database Administration
License	GPL, Artistic License
Website	www.maatkit.org

Maatkit is a toolkit for users, developers, and administrators of MySQL an open-source database. All tools are standalone, with minimal dependencies and no need for installation. You can simply download them and use them. It 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 more.

Maatkit now ships by default with several GNU/Linux distributions such as CentOS and Debian and packages are available for Fedora and Ubuntu as well.

Included 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 duplicate indexes and foreign keys on MySQL tables.
• mk-error-log Find new and different MySQL error log entries.
• mk-fifo-split Split files and pipe lines to a fifo without really splitting.
• mk-find Find MySQL tables and execute actions, like GNU find.
• mk-heartbeat Monitor MySQL replication delay.
• mk-index-usage Read queries from a log and analyze how they use indexes.
• mk-kill Kill MySQL queries that match certain criteria.
• mk-loadavg Watch MySQL load and take action when it gets too high.
• mk-log-player Split and play MySQL slow logs.
• mk-merge-mqd-results Merge multiple mk-query-digest reports into one.
• mk-parallel-dump Dump MySQL tables in parallel.
• mk-parallel-restore Load files into MySQL in parallel.
• mk-profile-compact Compact the output from mk-query-profiler.
• mk-purge-logs Purge binary logs on a master based on purge rules.
• mk-query-digest Parses logs and more. Analyze, transform, filter, review and report on queries.
• 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 and print replication hierarchy tree of MySQL slaves.
• 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-upgrade Execute queries on multiple servers and check for differences.
• mk-visual-explain Format EXPLAIN output as a tree.