Database Management MySQL Subjective
Oct 01, 2025

Explain MySQL's online DDL operations and their limitations.

Detailed Explanation

Online DDL allows schema changes without blocking DML operations.

Algorithms:
• INSTANT: Metadata only changes
• INPLACE: No table copy required
• COPY: Full table rebuild

Example:
ALTER TABLE users ADD COLUMN phone VARCHAR(20), ALGORITHM=INPLACE;

Limitations:
• Some operations still require table copy
• Increased disk space during operation
• Performance impact on concurrent queries

Discussion (0)

No comments yet. Be the first to share your thoughts!

Share Your Thoughts
Feedback