In-place column renaming/resizing for InnoDB
Registered by
Alexey Kopytov
Server is currently unable to do in-place column renames for InnoDB tables because it has to be changed in the InnoDB data dictionary. So instead it executes ALTER TABLE through a temporary table. It can be optimized by making it possible to rename a column in the data dictionary directly without data copying.
Similarly, growing VARCHAR columns in a compatible way (that is, either old_length < new_length <= 255 or old_length < new_length <= 65535), can be done in-place without modifying data.
Blueprint information
- Status:
- Started
- Approver:
- None
- Priority:
- Not
- Drafter:
- Alexey Kopytov
- Direction:
- Needs approval
- Assignee:
- None
- Definition:
- Pending Approval
- Series goal:
- None
- Implementation:
- Needs Code Review
- Milestone target:
- None
- Started by
- Alexey Kopytov
- Completed by
Related branches
Related bugs
Sprints
Whiteboard
This is already implemented in innodb_
(?)