---
name: "maatkit"
section: "3pm"
platform: "linux"
package: "maatkit"
version: "1877-1"
release: "Debian 5.0 (Lenny)"
platforms: ["linux"]
url: "https://new.carta.tech/maatkit/3pm"
---

# maatkit(3pm)

Essential command-line utilities for MySQL.

## NAME

maatkit - Essential command-line utilities for MySQL.

## DESCRIPTION

maatkit, formerly MySQL Toolkit, is 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.

The following tools are included:

```
   $Revision: 1877 $
mk-archiver 1.0.8
mk-deadlock-logger 1.0.9
mk-duplicate-key-checker 1.1.5
mk-find 0.9.10
mk-heartbeat 1.0.8
mk-parallel-dump 1.0.7
mk-parallel-restore 1.0.6
mk-query-profiler 1.1.9
mk-show-grants 1.0.9
mk-slave-delay 1.0.6
mk-slave-find 1.0.0
mk-slave-move 0.9.0
mk-slave-prefetch 1.0.1
mk-slave-restart 1.0.6
mk-table-checksum 1.1.26
mk-table-sync 1.0.6
mk-visual-explain 1.0.7
```

- mk-archiver

  Archive rows from a MySQL table into another table or a file. See mk-archiver.

- mk-checksum-filter

  Filter checksums from mk-table-checksum. See mk-checksum-filter.

- mk-deadlock-logger

  Extract and log MySQL deadlock information. See mk-deadlock-logger.

- mk-duplicate-key-checker

  Find possible duplicate indexes and foreign keys on MySQL tables. See mk-duplicate-key-checker.

- mk-find

  Find MySQL tables and execute actions, like GNU find. See mk-find.

- mk-heartbeat

  Monitor MySQL replication delay. See mk-heartbeat.

- mk-parallel-dump

  Dump sets of MySQL tables in parallel. See mk-parallel-dump.

- mk-parallel-restore

  Load files into MySQL in parallel. See mk-parallel-restore.

- mk-profile-compact

  Compact the output from mk-query-profiler. See mk-profile-compact.

- mk-query-profiler

  Execute SQL statements and print statistics, or measure activity caused by other processes. See mk-query-profiler.

- mk-show-grants

  Canonicalize and print MySQL grants so you can effectively replicate, compare and version-control them. See mk-show-grants.

- mk-slave-delay

  Make a MySQL slave server lag behind its master. See mk-slave-delay.

- mk-slave-find

  Find MySQL replication slaves and execute commands on them. See mk-slave-find.

- mk-slave-move

  Move a MySQL slave around in the replication hierarchy. See mk-slave-move.

- mk-slave-prefetch

  Pipeline relay logs on a MySQL slave to pre-warm caches. See mk-slave-prefetch.

- mk-slave-restart

  Watch and restart MySQL replication after errors. See mk-slave-restart.

- mk-table-checksum

  Perform an online replication consistency check, or checksum MySQL tables efficiently on one or many servers. See mk-table-checksum.

- mk-table-sync

  Synchronize MySQL tables efficiently. See mk-table-sync.

- mk-visual-explain

  Format EXPLAIN output as a tree. See mk-visual-explain.

## SEE ALSO

See also the maatkitdsn documentation, which explains how to use DSNs to connect to MySQL.

## INSTALLATION

Strictly speaking these tools require no installation; you should be able to run them stand-alone.  However, on UNIX-ish systems you can use the standard Perl installation sequence:

```
   cd <package directory>
   perl Makefile.PL
   make install
```

## SYSTEM REQUIREMENTS

You need Perl, DBI, DBD::mysql, and some core packages that ought to be installed in any reasonably new version of Perl.

## BUGS

If you find bugs, need features, etc please use the bug tracker, forums, and mailing lists at http://sourceforge.net/projects/maatkit.

## COPYRIGHT, LICENSE AND WARRANTY

This program is copyright (c) 2007 Baron Schwartz and others.  Feedback and improvements are welcome.

THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, WITHOUT LIMITATION, THE IMPLIED WARRANTIES OF MERCHANTIBILITY AND FITNESS FOR A PARTICULAR PURPOSE.

This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation, version 2; OR the Perl Artistic License.  On UNIX and similar systems, you can issue \`man perlgpl' or \`man perlartistic' to read these licenses.

You should have received a copy of the GNU General Public License along with this program; if not, write to the Free Software Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA.

## AUTHOR

See the individual program's documentation for details.

## VERSION

This manual page documents Distrib 1877 `$Revision:` 534 $.