Bug #74497 innochecksum page type summary w/o locking
Submitted: 22 Oct 2014 8:28
Reporter: Daniël van Eeden (OCA) Email Updates:
Status: Open Impact on me:
None 
Category:MySQL Server: InnoDB storage engine Severity:S4 (Feature request)
Version:5.7 OS:Any
Assigned to: CPU Architecture:Any

[22 Oct 2014 8:28] Daniël van Eeden 
Description:
InnoChecksum does try to lock files. It would be nice to have it work without locking the file(s).

$ innochecksum --page-type-summary /var/lib/ibdata1
Error: Unable to lock file:: /opt/mysql/data/ibdata1
fcntl: Resource temporarily unavailable

How to repeat:
Run MySQL 5.6 with a datadir on NFSv3
Try to run innochecksum (from 5.7) to get a page type summary to find out what is in the ibdata1 file

Suggested fix:
Make it possible to run the utility w/o taking locks
[17 Jul 2015 14:14] Georgi Kodinov 
the innochecksum utility should into the Innodb category. Changing so that the Innodb team can pick this up.