Question : I am running optimize table on MySQL table size 340GB in size and storage engine is InnoDB. mysql> […]
Tag: online-operations
How to determine if an ALTER statement will be a metadata-only operation O(1) or a size of data operation O(n)?
Question : We are dealing with very large tables in Sql Azure. Size-of-data operations can lock tables for a very […]
onsite and offsite backup question
Question : We have an sql database of 165GB (includes filestreaming) and we do an onsite full backup every evening […]
MySQL Online DDL Index Creation
Question : I have a table with 25 million records and 10 columns on which I am trying to create […]
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 […]
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 […]