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