WL#2745: Speed up ALTER TABLE (part 10: Online ALTER TABLE, InnoDB)
Affects: Server-7.1 — Status: Un-Assigned
See WL#2289 for task background. Overall description: - Online ALTER TABLE for InnoDB This will allow one to do reads, inserts and updates (not drop/rename) to the table while the ALTER TABLE is running. All changes will be applied to the copy of the table before the newly created ALTER TABLE replaces the old one. This will allow on to do any changes to the table except: - Rename table (Note that adding a new UNIQUE INDEX may be problematic, but not impossible)
Copyright (c) 2000, 2020, Oracle Corporation and/or its affiliates. All rights reserved.