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
• Status: Verified
• Category: MySQL Server: InnoDB storage engine
• Severity: S4 (Feature request)
• OS: Any
• 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.