Description: 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.
It provides a collection of command-line utilities that provide missing functionality for MySQL. Some of the tools implement lacking server functionality, such as online consistency checks for master/slave replication; others are client-side utilities such as a query profiler.
Archive rows from a MySQL table into another table or a file.
Filter checksums from mk-table-checksum.
Extract and log MySQL deadlock information.
Find possible duplicate indexes and foreign keys on MySQL tables.
Find MySQL tables and execute actions, like GNU find.
Monitor MySQL replication delay.
Dump sets of MySQL tables in parallel.
Load files into MySQL in parallel.
Compact the output from mk-query-profiler.
Execute SQL statements and print statistics, or measure activity caused by other processes.
Canonicalize and print MySQL grants so you can effectively replicate, compare and version-control them.
Make a MySQL slave server lag behind its master.
Find MySQL replication slaves and execute commands on them.
Move a MySQL slave around in the replication hierarchy.
Pipeline relay logs on a MySQL slave to pre-warm caches.
Watch and restart MySQL replication after errors.
Perform an online replication consistency check, or checksum MySQL tables efficiently on one or many servers.
Synchronize MySQL tables efficiently.
Format EXPLAIN output as a tree.
Related: Mysql, Replication, Tables, slave, Server, Functionality, Online, Print, Execute, maatkit, output, Table, consistency, Utilities, Statistics, efficiently, Statements, Measure, Activity
O/S:BSD, Linux, Solaris, Mac OS X
File Size: 378.9 KB