.\" Automatically generated by Pod::Man v1.37, Pod::Parser v1.32
.\"
.\" Standard preamble:
.\" ========================================================================
.de Sh \" Subsection heading
.br
.if t .Sp
.ne 5
.PP
\fB\\$1\fR
.PP
..
.de Sp \" Vertical space (when we can't use .PP)
.if t .sp .5v
.if n .sp
..
.de Vb \" Begin verbatim text
.ft CW
.nf
.ne \\$1
..
.de Ve \" End verbatim text
.ft R
.fi
..
.\" Set up some character translations and predefined strings.  \*(-- will
.\" give an unbreakable dash, \*(PI will give pi, \*(L" will give a left
.\" double quote, and \*(R" will give a right double quote.  | will give a
.\" real vertical bar.  \*(C+ will give a nicer C++.  Capital omega is used to
.\" do unbreakable dashes and therefore won't be available.  \*(C` and \*(C'
.\" expand to `' in nroff, nothing in troff, for use with C<>.
.tr \(*W-|\(bv\*(Tr
.ds C+ C\v'-.1v'\h'-1p'\s-2+\h'-1p'+\s0\v'.1v'\h'-1p'
.ie n \{\
.    ds -- \(*W-
.    ds PI pi
.    if (\n(.H=4u)&(1m=24u) .ds -- \(*W\h'-12u'\(*W\h'-12u'-\" diablo 10 pitch
.    if (\n(.H=4u)&(1m=20u) .ds -- \(*W\h'-12u'\(*W\h'-8u'-\"  diablo 12 pitch
.    ds L" ""
.    ds R" ""
.    ds C` ""
.    ds C' ""
'br\}
.el\{\
.    ds -- \|\(em\|
.    ds PI \(*p
.    ds L" ``
.    ds R" ''
'br\}
.\"
.\" If the F register is turned on, we'll generate index entries on stderr for
.\" titles (.TH), headers (.SH), subsections (.Sh), items (.Ip), and index
.\" entries marked with X<> in POD.  Of course, you'll have to process the
.\" output yourself in some meaningful fashion.
.if \nF \{\
.    de IX
.    tm Index:\\$1\t\\n%\t"\\$2"
..
.    nr % 0
.    rr F
.\}
.\"
.\" For nroff, turn off justification.  Always turn off hyphenation; it makes
.\" way too many mistakes in technical documents.
.hy 0
.if n .na
.\"
.\" Accent mark definitions (@(#)ms.acc 1.5 88/02/08 SMI; from UCB 4.2).
.\" Fear.  Run.  Save yourself.  No user-serviceable parts.
.    \" fudge factors for nroff and troff
.if n \{\
.    ds #H 0
.    ds #V .8m
.    ds #F .3m
.    ds #[ \f1
.    ds #] \fP
.\}
.if t \{\
.    ds #H ((1u-(\\\\n(.fu%2u))*.13m)
.    ds #V .6m
.    ds #F 0
.    ds #[ \&
.    ds #] \&
.\}
.    \" simple accents for nroff and troff
.if n \{\
.    ds ' \&
.    ds ` \&
.    ds ^ \&
.    ds , \&
.    ds ~ ~
.    ds /
.\}
.if t \{\
.    ds ' \\k:\h'-(\\n(.wu*8/10-\*(#H)'\'\h"|\\n:u"
.    ds ` \\k:\h'-(\\n(.wu*8/10-\*(#H)'\`\h'|\\n:u'
.    ds ^ \\k:\h'-(\\n(.wu*10/11-\*(#H)'^\h'|\\n:u'
.    ds , \\k:\h'-(\\n(.wu*8/10)',\h'|\\n:u'
.    ds ~ \\k:\h'-(\\n(.wu-\*(#H-.1m)'~\h'|\\n:u'
.    ds / \\k:\h'-(\\n(.wu*8/10-\*(#H)'\z\(sl\h'|\\n:u'
.\}
.    \" troff and (daisy-wheel) nroff accents
.ds : \\k:\h'-(\\n(.wu*8/10-\*(#H+.1m+\*(#F)'\v'-\*(#V'\z.\h'.2m+\*(#F'.\h'|\\n:u'\v'\*(#V'
.ds 8 \h'\*(#H'\(*b\h'-\*(#H'
.ds o \\k:\h'-(\\n(.wu+\w'\(de'u-\*(#H)/2u'\v'-.3n'\*(#[\z\(de\v'.3n'\h'|\\n:u'\*(#]
.ds d- \h'\*(#H'\(pd\h'-\w'~'u'\v'-.25m'\f2\(hy\fP\v'.25m'\h'-\*(#H'
.ds D- D\\k:\h'-\w'D'u'\v'-.11m'\z\(hy\v'.11m'\h'|\\n:u'
.ds th \*(#[\v'.3m'\s+1I\s-1\v'-.3m'\h'-(\w'I'u*2/3)'\s-1o\s+1\*(#]
.ds Th \*(#[\s+2I\s-2\h'-\w'I'u*3/5'\v'-.3m'o\v'.3m'\*(#]
.ds ae a\h'-(\w'a'u*4/10)'e
.ds Ae A\h'-(\w'A'u*4/10)'E
.    \" corrections for vroff
.if v .ds ~ \\k:\h'-(\\n(.wu*9/10-\*(#H)'\s-2\u~\d\s+2\h'|\\n:u'
.if v .ds ^ \\k:\h'-(\\n(.wu*10/11-\*(#H)'\v'-.4m'^\v'.4m'\h'|\\n:u'
.    \" for low resolution devices (crt and lpr)
.if \n(.H>23 .if \n(.V>19 \
\{\
.    ds : e
.    ds 8 ss
.    ds o a
.    ds d- d\h'-1'\(ga
.    ds D- D\h'-1'\(hy
.    ds th \o'bp'
.    ds Th \o'LP'
.    ds ae ae
.    ds Ae AE
.\}
.rm #[ #] #H #V #F C
.\" ========================================================================
.\"
.IX Title "mysqltoolkit 3"
.TH mysqltoolkit 3 "2007-10-15" "perl v5.8.8" "User Contributed Perl Documentation"
.SH "NAME"
mysqltoolkit \- Essential command\-line utilities for MySQL.
.SH "DESCRIPTION"
.IX Header "DESCRIPTION"
mysqltoolkit, or 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.
.PP
The following tools are included:
.PP
.Vb 15
\&   $Revision: 1053 $
\&   mysql-archiver-1.0.1
\&   mysql-deadlock-logger-1.0.4
\&   mysql-duplicate-key-checker-1.1.1
\&   mysql-find-0.9.5
\&   mysql-heartbeat-1.0.1
\&   mysql-parallel-dump-0.9.10
\&   mysql-parallel-restore-0.9.0
\&   mysql-query-profiler-1.1.5
\&   mysql-show-grants-1.0.3
\&   mysql-slave-delay-1.0.1
\&   mysql-slave-restart-1.0.1
\&   mysql-table-checksum-1.1.16
\&   mysql-table-sync-0.9.7
\&   mysql-visual-explain-1.0.3
.Ve
.IP "mysql-archiver" 4
.IX Item "mysql-archiver"
Archive rows from a MySQL table into another table or a file. See mysql-archiver.
.IP "mysql-checksum-filter" 4
.IX Item "mysql-checksum-filter"
Filter checksums from mysql\-table\-checksum. See mysql-checksum-filter.
.IP "mysql-deadlock-logger" 4
.IX Item "mysql-deadlock-logger"
Extract and log MySQL deadlock information. See mysql-deadlock-logger.
.IP "mysql-duplicate-key-checker" 4
.IX Item "mysql-duplicate-key-checker"
Find possible duplicate indexes and foreign keys on
MySQL tables. See mysql-duplicate-key-checker.
.IP "mysql-find" 4
.IX Item "mysql-find"
Find MySQL tables and execute actions, like \s-1GNU\s0 find. See mysql-find.
.IP "mysql-heartbeat" 4
.IX Item "mysql-heartbeat"
Monitor MySQL replication delay. See mysql-heartbeat.
.IP "mysql-parallel-dump" 4
.IX Item "mysql-parallel-dump"
Dump sets of MySQL tables in parallel. See mysql-parallel-dump.
.IP "mysql-parallel-restore" 4
.IX Item "mysql-parallel-restore"
Load files into MySQL in parallel. See mysql-parallel-restore.
.IP "mysql-profile-compact" 4
.IX Item "mysql-profile-compact"
Compact the output from mysql\-query\-profiler. See mysql-profile-compact.
.IP "mysql-query-profiler" 4
.IX Item "mysql-query-profiler"
Execute \s-1SQL\s0 statements and print statistics, or measure
activity caused by other processes. See mysql-query-profiler.
.IP "mysql-show-grants" 4
.IX Item "mysql-show-grants"
Canonicalize and print MySQL grants so you can effectively
replicate, compare and version-control them. See mysql-show-grants.
.IP "mysql-slave-delay" 4
.IX Item "mysql-slave-delay"
Make a MySQL slave server lag behind its master. See mysql-slave-delay.
.IP "mysql-slave-restart" 4
.IX Item "mysql-slave-restart"
Watch and restart MySQL replication after errors. See mysql-slave-restart.
.IP "mysql-table-checksum" 4
.IX Item "mysql-table-checksum"
Perform an online replication consistency check, or
efficiently checksum MySQL tables on one or many servers. See mysql-table-checksum.
.IP "mysql-table-sync" 4
.IX Item "mysql-table-sync"
Efficiently synchronize data between two MySQL tables. See mysql-table-sync.
.IP "mysql-visual-explain" 4
.IX Item "mysql-visual-explain"
Format \s-1EXPLAIN\s0 output as a tree. See mysql-visual-explain.
.SH "INSTALLATION"
.IX Header "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:
.PP
.Vb 3
\&   cd <package directory>
\&   perl Makefile.PL
\&   make install
.Ve
.SH "SYSTEM REQUIREMENTS"
.IX Header "SYSTEM REQUIREMENTS"
You need Perl, \s-1DBI\s0, DBD::mysql, and some core packages that ought to be
installed in any reasonably new version of Perl.
.SH "BUGS"
.IX Header "BUGS"
If you find bugs, need features, etc please use the bug tracker, forums, and
mailing lists at http://sourceforge.net/projects/mysqltoolkit.
.SH "COPYRIGHT, LICENSE AND WARRANTY"
.IX Header "COPYRIGHT, LICENSE AND WARRANTY"
This program is copyright (c) 2007 Baron Schwartz and others.  Feedback and
improvements are welcome.
.PP
\&\s-1THIS\s0 \s-1PROGRAM\s0 \s-1IS\s0 \s-1PROVIDED\s0 \*(L"\s-1AS\s0 \s-1IS\s0\*(R" \s-1AND\s0 \s-1WITHOUT\s0 \s-1ANY\s0 \s-1EXPRESS\s0 \s-1OR\s0 \s-1IMPLIED\s0
\&\s-1WARRANTIES\s0, \s-1INCLUDING\s0, \s-1WITHOUT\s0 \s-1LIMITATION\s0, \s-1THE\s0 \s-1IMPLIED\s0 \s-1WARRANTIES\s0 \s-1OF\s0
\&\s-1MERCHANTIBILITY\s0 \s-1AND\s0 \s-1FITNESS\s0 \s-1FOR\s0 A \s-1PARTICULAR\s0 \s-1PURPOSE\s0.
.PP
This program is free software; you can redistribute it and/or modify it under
the terms of the \s-1GNU\s0 General Public License as published by the Free Software
Foundation, version 2; \s-1OR\s0 the Perl Artistic License.  On \s-1UNIX\s0 and similar
systems, you can issue `man perlgpl' or `man perlartistic' to read these
licenses.
.PP
You should have received a copy of the \s-1GNU\s0 General Public License along with
this program; if not, write to the Free Software Foundation, Inc., 59 Temple
Place, Suite 330, Boston, \s-1MA\s0  02111\-1307  \s-1USA\s0.
.SH "AUTHOR"
.IX Header "AUTHOR"
See the individual program's documentation for details.
.SH "VERSION"
.IX Header "VERSION"
This manual page documents Distrib 1053 \f(CW$Revision:\fR 534 $.