下载地址:http://maatkit.googlecode.com/files/maatkit-7540.tar.gz

Maatkit Essential command-line utilities for MySQL.
维护mysql的命令如下:
mk-archiver Archive rows from a MySQL table into another table or a file.
mk-checksum-filter Filter checksums from mk-table-checksum.
mk-config-diff Diff MySQL configuration files and server variables.
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 Replay MySQL query logs.
mk-merge-mqd-results Merge multiple mk-query-digest reports into one.
mk-parallel-dump (DEPRECATED) Dump MySQL tables in parallel.
mk-parallel-restore (DEPRECATED) 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-advisor Analyze queries and advise on possible problems.
mk-query-digest Analyze query execution logs and generate a query report, filter, replay, or transform queries for MySQL, PostgreSQL, memcached, and more.
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 table data efficiently.
mk-table-usage Read queries from a log and analyze how they use tables.
mk-tcp-model Transform tcpdump into metrics that permit performance and scalability modeling.
mk-upgrade Execute queries on multiple servers and check for differences.
mk-variable-advisor Analyze MySQL variables and advise on possible problems.
mk-visual-explain Format EXPLAIN output as a tree.

One thought on “Mysql的管理维护工具maatkit”

发表评论

电子邮件地址不会被公开。 必填项已用*标注