Skip to content
DbaFix
Just share answer and question for fixing database problem
MENU
  • HOME

Tag: online-operations

Optimize table on large table online DDL Feature

By adminPosted on August 5, 2023

Question : I am running optimize table on MySQL table size 340GB in size and storage engine is InnoDB. mysql> […]

How to determine if an ALTER statement will be a metadata-only operation O(1) or a size of data operation O(n)?

By adminPosted on July 6, 2023

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

By adminPosted on June 3, 2023

Question : We have an sql database of 165GB (includes filestreaming) and we do an onsite full backup every evening […]

MySQL Online DDL Index Creation

By adminPosted on May 6, 2023

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

By adminPosted on June 7, 2022

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

By adminPosted on November 3, 2021

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

By adminPosted on October 17, 2021

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

By adminPosted on June 7, 2021

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?

By adminPosted on April 14, 2020

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

By adminPosted on January 25, 2020

Question : I am trying to add column into MySQL table Table size 150GB Table storage engine= innodb MySQL version=5.6.34 […]

Recent Posts

  • SQL Server Full-text population deadlock
  • Can sp_executesql be configured / used by default?
  • SQL Server Query Store – why does it not always use the forced plan? [duplicate]
  • Multiple query to columns indexed in MySql
  • cluster_database TRUE/FALSE what does it mean in Oracle RAC?
  • mysql – How to repair & backup archive table, also stop growing .ARN extension file?
  • How does the transactions interact if you set a different isolation level per connection?
  • Autovacuum in Postgresql database
  • MySQL Server 5.7.33 or upgrade
  • What are the performance implications of using uuid as primary key in Postgres 10.12? (need canonical answer) [duplicate]
  • How do I use subquery on the same table in MySQL?
  • Error on updating a field with binary values
  • Feasibility of a MSSQL Read Only Replicas as ephermal containers?
  • How to represent directed graph with multiple parents?
  • Promoting MySQL slave with unknown replication delay
  • Rules for Decomposition to 2 NF
  • Index with ops for `LIKE` and `=` queries
  • How many cores are used for serial plans in SQL Server?
  • MySQL read-write Master with many read-only Slaves over shared storage?
  • How to reference categories table in products table?

Categories

  • Database Backup
  • Database Design
  • Database Index
  • Database Optimization
  • InnoDB
  • Join
  • MariaDB
  • MongoDB
  • MySQL
  • Oracle
  • Performance
  • Permissions
  • Postgresql
  • Query Performance
  • Replication
  • Security
  • SQL Server
Proudly powered by WordPress / Support by: DizzyCoding