Bug #70344 innochecksum doesn't support crc32 in 5.6
Submitted: 14 Sep 2013 16:10 Modified: 10 Dec 2013 19:37
Reporter: Mark Callaghan Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: InnoDB storage engine Severity:S4 (Feature request)
Version: OS:Any
Assigned to: CPU Architecture:Any

[14 Sep 2013 16:10] Mark Callaghan
Description:
I want to use innochecksum for tables that use innodb_checksum_algorithm=CRC32

It is supported in 5.7:
 http://dev.mysql.com/doc/refman/5.7/en/innodb-other-changes-enhanced-innochecksum-capabili...

crc32 isn't supported in 5.6.12:
InnoDB offline file checksum utility.
Fail;  page 0 invalid (fails old style checksum)

How to repeat:
1) load table when innodb uses innodb_checksum_algorithm=CRC32
2) run innochecksum

Suggested fix:
backport changes from 5.7
[19 Sep 2013 9:29] MySQL Verification Team
Hello Mark,

Thank you for the valid feature request!

Thanks,
Umehs
[10 Dec 2013 18:00] Sveta Smirnova
Mark,

afaik innochecksum from version 5.7 can work with InnoDB tables, created in version 5.6 Why can't you simply use this utility from version 5.7?
[10 Dec 2013 19:37] Mark Callaghan
I can but many other users won't have a 5.7 build, or a 5.6 build with backports from 5.7
[8 Apr 2014 19:07] Sveta Smirnova
Bug #72273 was marked as duplicate of this one.