Package maatkit

Essential command-line utilities for MySQL

This toolkit contains essential command-line utilities for MySQL, such as a
table checksum tool and query profiler. It provides missing features such as
checking slaves for data consistency, with emphasis on quality and

General Commands
Command Description
maatkit.1p Essential command-line utilities for MySQL.
mk-archiver.1p Archive rows from a MySQL table into another table or a file.
mk-checksum-filter.1p Filter checksums from mk-table-checksum.
mk-config-diff.1p Diff MySQL configuration files and server variables.
mk-deadlock-logger.1p Extract and log MySQL deadlock information.
mk-duplicate-key-checker.1p Find duplicate indexes and foreign keys on MySQL tables.
mk-error-log.1p Find new and different MySQL error log entries.
mk-fifo-split.1p Split files and pipe lines to a fifo without really splitting.
mk-find.1p Find MySQL tables and execute actions, like GNU find.
mk-heartbeat.1p Monitor MySQL replication delay.
mk-index-usage.1p Read queries from a log and analyze how they use indexes.
mk-kill.1p Kill MySQL queries that match certain criteria.
mk-loadavg.1p Watch MySQL load and take action when it gets too high.
mk-log-player.1p Replay MySQL query logs.
mk-merge-mqd-results.1p Merge multiple mk-query-digest reports into one.
mk-parallel-dump.1p (DEPRECATED) Dump MySQL tables in parallel.
mk-parallel-restore.1p (DEPRECATED) Load files into MySQL in parallel.
mk-profile-compact.1p Compact the output from mk-query-profiler.
mk-purge-logs.1p Purge binary logs on a master based on purge rules.
mk-query-advisor.1p Analyze queries and advise on possible problems.
mk-query-digest.1p Analyze query execution logs and generate a query report, filter, replay, or...
mk-query-profiler.1p Execute SQL statements and print statistics, or measure activity caused by other...
mk-show-grants.1p Canonicalize and print MySQL grants so you can effectively replicate, compare...
mk-slave-delay.1p Make a MySQL slave server lag behind its master.
mk-slave-find.1p Find and print replication hierarchy tree of MySQL slaves.
mk-slave-move.1p Move a MySQL slave around in the replication hierarchy.
mk-slave-prefetch.1p Pipeline relay logs on a MySQL slave to pre-warm caches.
mk-slave-restart.1p Watch and restart MySQL replication after errors.
mk-table-checksum.1p Perform an online replication consistency check, or checksum MySQL tables...
mk-table-sync.1p Synchronize MySQL table data efficiently.
mk-table-usage.1p Read queries from a log and analyze how they use tables.
mk-tcp-model.1p Transform tcpdump into metrics that permit performance and scalability modeling.
mk-upgrade.1p Execute queries on multiple servers and check for differences.
mk-variable-advisor.1p Analyze MySQL variables and advise on possible problems.
mk-visual-explain.1p Format EXPLAIN output as a tree.