1MK-CHECKSUM-FILTER(1) User Contributed Perl DocumentationMK-CHECKSUM-FILTER(1)
2
6 mk-checksum-filter - Filter checksums from mk-table-checksum.
7
9 mk-checksum-filter checksums.txt
10 mk-table-checksum host1 host2 | mk-checksum-filter
11 mk-checksum-filter db1-checksums.txt db2-checksums.txt --ignore-databases
12
14 The following section is included to inform users about the potential
15 risks, whether known or unknown, of using this tool. The two main
16 categories of risks are those created by the nature of the tool (e.g.
17 read-only tools vs. read-write tools) and those created by bugs.
18 mk-checksum-filter is read-only and very low-risk.
20 At the time of this release, we know of no bugs that could cause
22 serious harm to users.
23 The authoritative source for updated information is always the online
25 issue tracking system. Issues that affect this tool will be marked as
26 such. You can see a list of such issues at the following URL:
27 http://www.maatkit.org/bugs/mk-checksum-filter
28 <http://www.maatkit.org/bugs/mk-checksum-filter>.
29 See also "BUGS" for more information on filing bugs and getting help.
31
33 This program takes the unsorted, verbose output from mk-table-checksum
34 and sorts it, then filters it so you only see lines that have different
35 checksums or counts.
36 You can pipe input directly into it from mk-table-checksum, or you can
38 save the mk-table-checksum's output and run mk-checksum-filter on the
39 resulting file(s). If you run it against just one file, or pipe output
40 directly into it, it'll output results during processing. Processing
41 multiple files is slightly more expensive, and you won't see any output
42 until they're all read.
43
45 Exit status is 0 if no differences were found, 1 if any were.
46
48 "--ignore-databases" and "--equal-databases" are mutually exclusive.
49 --equal-databases
51 type: Hash
52 This comma-separated list of databases are equal.
54 These database names are always considered to have the same tables.
56 In other words, this makes "database1.table1.chunk1" equal to
57 "database2.table1.chunk1" if they have the same checksum.
58 This disables incremental processing, so you won't see any results
60 until all input is processed.
61 --header
63 short form: -h
64 Preserves headers output by mk-table-checksum.
66 --help
68 Show help and exit.
69 --ignore-databases
71 Ignore the database name when comparing lines.
72 This disables incremental processing, so you won't see any results
74 until all input is processed.
75 --master
77 type: string
78 The name of the master server.
80 Specifies which host is the replication master, and sorts lines for
82 that host first, so you can see the checksum values on the master
83 server before the slave.
84 --unique
86 type: string
87 Show unique differing host/db/table names.
89 The argument must be one of host, db, or table.
91 --verbose
93 short form: -v
94 Output all lines, even those that have no differences, except for
96 header lines.
97 --version
99 Show version and exit.
100
102 You can download Maatkit from Google Code at
103 <http://code.google.com/p/maatkit/>, or you can get any of the tools
104 easily with a command like the following:
105 wget http://www.maatkit.org/get/toolname
107 or
108 wget http://www.maatkit.org/trunk/toolname
109 Where "toolname" can be replaced with the name (or fragment of a name)
111 of any of the Maatkit tools. Once downloaded, they're ready to run; no
112 installation is needed. The first URL gets the latest released version
113 of the tool, and the second gets the latest trunk code from Subversion.
114
116 The environment variable "MKDEBUG" enables verbose debugging output in
117 all of the Maatkit tools:
118 MKDEBUG=1 mk-....
120
122 You need Perl and some core packages that ought to be installed in any
123 reasonably new version of Perl.
124
126 For list of known bugs see
127 http://www.maatkit.org/bugs/mk-checksum-filter
128 <http://www.maatkit.org/bugs/mk-checksum-filter>.
129 Please use Google Code Issues and Groups to report bugs or request
131 support: <http://code.google.com/p/maatkit/>. You can also join
132 #maatkit on Freenode to discuss Maatkit.
133 Please include the complete command-line used to reproduce the problem
135 you are seeing, the version of all MySQL servers involved, the complete
136 output of the tool when run with "--version", and if possible,
137 debugging output produced by running with the "MKDEBUG=1" environment
138 variable.
139
141 This program is copyright 2007-2010 Baron Schwartz. Feedback and
142 improvements are welcome.
143 THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
145 WARRANTIES, INCLUDING, WITHOUT LIMITATION, THE IMPLIED WARRANTIES OF
146 MERCHANTIBILITY AND FITNESS FOR A PARTICULAR PURPOSE.
147 This program is free software; you can redistribute it and/or modify it
149 under the terms of the GNU General Public License as published by the
150 Free Software Foundation, version 2; OR the Perl Artistic License. On
151 UNIX and similar systems, you can issue `man perlgpl' or `man
152 perlartistic' to read these licenses.
153 You should have received a copy of the GNU General Public License along
155 with this program; if not, write to the Free Software Foundation, Inc.,
156 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA.
157
159 Baron "Xaprb" Schwartz
160
162 This tool is part of Maatkit, a toolkit for power users of MySQL.
163 Maatkit was created by Baron Schwartz; Baron and Daniel Nichter are the
164 primary code contributors. Both are employed by Percona. Financial
165 support for Maatkit development is primarily provided by Percona and
166 its clients.
167
169 This manual page documents Ver 1.2.17 Distrib 6839 $Revision: 6811 $.
170perl v5.12.1 2010-08-01 MK-CHECKSUM-FILTER(1)