Bug #53443 Reasons for 'repair by keycache' Should be Logged

• Submitted: 5 May 2010 16:11
• Modified: 5 May 2010 16:18
• Reporter: James McKelvey
• Status: Verified
• Category: MySQL Server: Logging
• Severity: S4 (Feature request)
• Version: 5.1.36
• OS: Any
• CPU Architecture: Any

[5 May 2010 16:11] James McKelvey

Description:
If MYSQL has to use 'repair by keycache' instead of 'repair by filesort' it can take MUCH longer. But MYSQL does not log the reasons, making the users guess what needs to be changed.

It should log errors explaining why it had to resort to 'repair by keycache'.

How to repeat:
N/A.

Suggested fix:
It should log errors explaining why it had to resort to 'repair by keycache'.

[5 May 2010 16:18] Valeriy Kravchuk

Thank you for the feature request.

[5 May 2010 17:19] MySQL Verification Team

Related to bug #35620
"Fully log the decision process in the error log, stating
when and why a repair by keycache was chosen, and for which table."