MySQL Bugs: #69996: Implement DISABLE KEYS for InnoDB

Bug #69996	Implement DISABLE KEYS for InnoDB
Submitted:	12 Aug 2013 14:51
Reporter:	Oli Sennhauser	Email Updates:
Status:	Open	Impact on me:	None
Category:	MySQL Server: InnoDB storage engine	Severity:	S4 (Feature request)
Version:	any	OS:	Any
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
Implement DISABLE KEYS for InnoDB for restore purposes.

How to repeat:
According to MySQL documentation

ALTER TABLE DISABLE KEYS;

works only for MyISAM tables. It would be nice to have this feature implemented as well for InnoDB since we have fast index create feature (5.5).

Suggested fix:
ALTER TABLE DISABLE KEYS implemented by using fast index drop/create feature for InnoDB.