1MK-CHECKSUM-FILTER(1) User Contributed Perl DocumentationMK-CHECKSUM-FILTER(1)
2
3
4

NAME

6       mk-checksum-filter - Filter checksums from mk-table-checksum.
7

SYNOPSIS

9       Usage: mk-checksum-filter [OPTION]... FILE
10
11       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
15       Examples:
16
17         mk-checksum-filter checksums.txt
18
19         mk-table-checksum host1 host2 | mk-checksum-filter
20
21         mk-checksum-filter db1-checksums.txt db2-checksums.txt --ignore-databases
22

RISKS

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
29       mk-checksum-filter is read-only and very low-risk.
30
31       At the time of this release, we know of no bugs that could cause
32       serious harm to users.
33
34       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
39       See also "BUGS" for more information on filing bugs and getting help.
40

DESCRIPTION

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
46       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

EXIT STATUS

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

OPTIONS

59       "--ignore-databases" and "--equal-databases" are mutually exclusive.
60
61       This tool accepts additional command-line arguments.  Refer to the
62       "SYNOPSIS" and usage information for details.
63
64       --equal-databases
65           type: Hash
66
67           This comma-separated list of databases are equal.
68
69           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
73           This disables incremental processing, so you won't see any results
74           until all input is processed.
75
76       --header
77           short form: -h
78
79           Preserves headers output by mk-table-checksum.
80
81       --help
82           Show help and exit.
83
84       --ignore-databases
85           Ignore the database name when comparing lines.
86
87           This disables incremental processing, so you won't see any results
88           until all input is processed.
89
90       --master
91           type: string
92
93           The name of the master server.
94
95           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
99       --unique
100           type: string
101
102           Show unique differing host/db/table names.
103
104           The argument must be one of host, db, or table.
105
106       --verbose
107           short form: -v
108
109           Output all lines, even those that have no differences, except for
110           header lines.
111
112       --version
113           Show version and exit.
114

DOWNLOADING

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
120          wget http://www.maatkit.org/get/toolname
121          or
122          wget http://www.maatkit.org/trunk/toolname
123
124       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

ENVIRONMENT

130       The environment variable "MKDEBUG" enables verbose debugging output in
131       all of the Maatkit tools:
132
133          MKDEBUG=1 mk-....
134

SYSTEM REQUIREMENTS

136       You need Perl and some core packages that ought to be installed in any
137       reasonably new version of Perl.
138

BUGS

140       For a list of known bugs see
141       <http://www.maatkit.org/bugs/mk-checksum-filter>.
142
143       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
147       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

COPYRIGHT, LICENSE AND WARRANTY

154       This program is copyright 2007-2011 Baron Schwartz.  Feedback and
155       improvements are welcome.
156
157       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
161       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
167       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

AUTHOR

172       Baron "Xaprb" Schwartz
173

ABOUT MAATKIT

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

VERSION

182       This manual page documents Ver 1.2.23 Distrib 7540 $Revision: 7477 $.
183
184
185
186perl v5.34.0                      2022-01-20             MK-CHECKSUM-FILTER(1)
Impressum