📦 maatkit

M

• 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 transform queries for MySQL, PostgreSQL, memcached, and more.✨
• mk-query-profiler(1p)Execute SQL statements and print statistics, or measure activity caused by other processes.✨
• mk-show-grants(1p)Canonicalize and print MySQL grants so you can effectively replicate, compare and version-control them.✨
• 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 efficiently on one or many servers.✨
• 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.✨