Maatkit: MySQL toolkit

Maatkit 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, much more. Features:

  • mk-archiver Archive rows from a MySQL table into another table or a file
  • mk-audit Analyze, summarize and report on MySQL config, schema and operation
  • mk-checksum-filter Filter checksums from mk-table-checksum
  • mk-deadlock-logger Extract and log MySQL deadlock information
  • mk-duplicate-key-checker Find possible duplicate indexes and foreign keys on MySQL tables
  • 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-log-parser Parse, transform and analyze MySQL logs
  • mk-log-player
  • mk-log-server Serve MySQL binary logs
  • mk-parallel-dump Dump sets of MySQL tables in parallel
  • mk-parallel-restore Load files into MySQL in parallel
  • mk-profile-compact Compact the output from mk-query-profiler
  • 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 MySQL replication slaves and execute commands on them
  • 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-visual-explain Format EXPLAIN output as a tree

Leave a Reply