Question : If I call a CREATE NONCLUSTERED INDEX using DROP_EXISTING = ON and ONLINE = ON what order are […]
Tag: online-operations
Order of DROP_EXISTING and ONLINE for CREATE INDEX
Question : If I call a CREATE NONCLUSTERED INDEX using DROP_EXISTING = ON and ONLINE = ON what order are […]
Optimize table on large table online DDL Feature
Question : I am running optimize table on MySQL table size 340GB in size and storage engine is InnoDB. mysql> […]
Changing foreign key to ON DELETE CASCADE with least amount of impact
Question : I have an existing foreign key that has ON DELETE NO ACTION defined. I need to change this […]
Why would I ever prefer ALGORITHM=COPY to ALGORITHM=INPLACE?
Question : Since MySQL 5.6 introduced online DDL, the ALTER TABLE command can optionally have either ALGORITHM=INPLACE or ALGORITHM=COPY specified. […]
Adding column into MySQL table size 150GB
Question : I am trying to add column into MySQL table Table size 150GB Table storage engine= innodb MySQL version=5.6.34 […]