Implement OPTIMIZE TABLE for InnoDB

Registered by Vadim Tkachenko

How about making OPTIMIZE TABLE to Work In XtraDB ?
This could work as build table with just primary key internally and when
adding indexes by sort - same as It works for MyISAM.

Blueprint information

Status:
Complete
Approver:
None
Priority:
Low
Drafter:
Vadim Tkachenko
Direction:
Needs approval
Assignee:
Alexey Kopytov
Definition:
New
Series goal:
Accepted for 5.1
Implementation:
Implemented
Milestone target:
None
Started by
Alexey Kopytov
Completed by
Alexey Kopytov

Whiteboard

What is different from
"ALTER TABLE .... ENGINE=InnoDB" ?
-- Yasufumi

ALTER TABLE ENGINE=InnoDB rebuilds indexes by insert, not by sort.
That is main difference.
-- Vadim

This was implemented as a fix for bug #744103 "Make use of InnoDB fast index creation in mysqldump, ALTER TABLE and OPTIMIZE TABLE"
Released in 5.1.56-12.7 and 5.5.11-20.2
-- Alexey

(?)

Work Items

This blueprint contains Public information 
Everyone can see this information.