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
Related branches
Related bugs
Bug #744103: Make use of InnoDB fast index creation in mysqldump, ALTER TABLE and OPTIMIZE TABLE | Fix Released |
Sprints
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
(?)