1INNOCHECKSUM(1)             MariaDB Database System            INNOCHECKSUM(1)
2
3
4

NAME

6       innochecksum - offline InnoDB file checksum utility
7

SYNOPSIS

9       innochecksum [options] file_name
10

DESCRIPTION

12       innochecksum prints checksums for InnoDB files. This tool reads an
13       InnoDB tablespace file, calculates the checksum for each page, compares
14       the calculated checksum to the stored checksum, and reports mismatches,
15       which indicate damaged pages. It was originally developed to speed up
16       verifying the integrity of tablespace files after power outages but can
17       also be used after file copies. Because checksum mismatches will cause
18       InnoDB to deliberately shut down a running server, it can be preferable
19       to use this tool rather than waiting for a server in production usage
20       to encounter the damaged pages.
21
22       innochecksum cannot be used on tablespace files that the server already
23       has open. For such files, you should use CHECK TABLE to check tables
24       within the tablespace.
25
26       If checksum mismatches are found, you would normally restore the
27       tablespace from backup or start the server and attempt to use mariadb-
28       dump to make a backup of the tables within the tablespace.
29
30       Invoke innochecksum like this:
31
32           shell> innochecksum [options] file_name
33
34       innochecksum supports the following options. For options that refer to
35       page numbers, the numbers are zero-based.
36
37       •   -?, --help
38
39           Displays help and exits.
40
41       •   -a num, --allow-mismatches=#
42
43           Maximum checksum mismatch allowed before innochecksum terminates.
44           Defaults to 0, which terminates on the first mismatch.
45
46       •   -c, --count
47
48           Print a count of the number of pages in the file.
49
50       •   -e num, --end-page=#
51
52           End at this page number.
53
54       •   -i, --per-page-details
55
56           Print out per-page detail information.
57
58       •   -I, --info
59
60           Synonym for --help.
61
62       •   -f, --leaf
63
64           Examine leaf index pages.
65
66       •   -l fn, --log=fn
67
68           Log output to the specified filename, fn.
69
70       •   -m num, --merge=#
71
72           Leaf page count if merge given number of consecutive pages.
73
74       •   -n, --no-check
75
76           Ignore the checksum verification. Until MariaDB 10.6, must be used
77           with the --write option.
78
79       •   -p num, --page-num=#
80
81           Check only this page number.
82
83       •   -D name, --page-type-dump=name
84
85           Dump the page type info for each page in a tablespace.
86
87       •   -S, --page-type-summary
88
89           Display a count of each page type in a tablespace.
90
91       •   -s num, --start-page
92
93           Start at this page number.
94
95       •   -u, --skip-corrupt
96
97           Skip corrupt pages.
98
99       •   -C name, --strict-check=name
100
101           Specify the strict checksum algorithm. One of: crc32, innodb, none.
102           If not specified, validates against innodb, crc32 and none. Removed
103           in MariaDB 10.6.
104
105       •   -w name, --write=name
106
107           Rewrite the checksum algorithm. One of crc32, innodb, none. An
108           exclusive lock is obtained during use. Use in conjunction with the
109           -no-check option to rewrite an invalid checksum. Removed in MariaDB
110           10.6.
111
112       •   -v, --verbose
113
114           Verbose mode; print a progress indicator every five seconds.
115
116       •   -V, --version
117
118           Displays version information and exits.
119

121       Copyright 2007-2008 MySQL AB, 2008-2010 Sun Microsystems, Inc.,
122       2010-2023 MariaDB Foundation
123
124       This documentation is free software; you can redistribute it and/or
125       modify it only under the terms of the GNU General Public License as
126       published by the Free Software Foundation; version 2 of the License.
127
128       This documentation is distributed in the hope that it will be useful,
129       but WITHOUT ANY WARRANTY; without even the implied warranty of
130       MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
131       General Public License for more details.
132
133       You should have received a copy of the GNU General Public License along
134       with the program; if not, write to the Free Software Foundation, Inc.,
135       51 Franklin Street, Fifth Floor, Boston, MA 02110-1335 USA or see
136       http://www.gnu.org/licenses/.
137
138

SEE ALSO

140       For more information, please refer to the MariaDB Knowledge Base,
141       available online at https://mariadb.com/kb/
142

AUTHOR

144       MariaDB Foundation (http://www.mariadb.org/).
145
146
147
148MariaDB 10.5                     27 June 2019                  INNOCHECKSUM(1)
Impressum