In-place column renaming/resizing for InnoDB

Registered by Alexey Kopytov on 2011-06-04

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 on 2011-07-04

Related branches

Sprints

Whiteboard

This is already implemented in innodb_fast_alter_column.patch in the -rnt branch.

(?)

Work Items

This blueprint contains Public information 
Everyone can see this information.

Subscribers

No subscribers.