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
scriptability.
Version: 7540
General Commands | |
| 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. |