February 2018
Intermediate to advanced
510 pages
16h 10m
English
This is a checksum utility for InnoDB files. It reads InnoDB tablespace files, calculates checksums for them, and compares them with stored checksum values. If the comparison fails, it reports error with damaged page details. It was developed to verify integrity of the post-power outage but it can also be used after copying the files. It is very useful in the event of any damaged page found when running InnoDB. It will shut down the running server, so to avoid any production issue due to damaged pages.
If a tablespace file is open, it cannot be used by innochecksum. The execution syntax for the command will look as the following:
shell> innochecksum [options] file_name
innochecksum command ...
Read now
Unlock full access