[MDEV-18926] Support ALTER TABLE…ADD COLUMN…ADD INDEX, ALGORITHM=NOCOPY Created: 2019-03-14  Updated: 2023-04-27

Status: Open
Project: MariaDB Server
Component/s: Storage Engine - InnoDB
Affects Version/s: 10.3.2, 10.4.0
Fix Version/s: 10.4

Type: Bug Priority: Major
Reporter: Marko Mäkelä Assignee: Marko Mäkelä
Resolution: Unresolved Votes: 0
Labels: ddl

Issue Links:
Blocks
blocks MDEV-16291 Allow ALGORITHM=NOCOPY for most ALTER... Open
Relates
relates to MDEV-11369 Instant add column for InnoDB Closed

 Description   

The scope of MDEV-11369 was reduced by introducing an artificial limitation: ADD COLUMN together with any ADD INDEX operation will require the table to be rebuilt. While ALGORITHM=INSTANT cannot support index creation, we could certainly support ALGORITHM=NOCOPY and create the requested indexes without rebuilding the entire table. This should be possible with LOCK=NONE or ALTER ONLINE TABLE as well.


Generated at Thu Feb 08 08:47:46 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.