Jan 19, 2023 · Databases

Atomic DDL Implementation in MySQL 8.0: Metadata Management and DDL Log Mechanisms

This article provides a comprehensive technical analysis of MySQL 8.0's atomic DDL implementation, detailing the transition from fragmented FRM-based metadata to a unified InnoDB Data Dictionary, and explaining how the DDL Log mechanism ensures crash-safe physical file operations during schema modifications.

Atomic DDLDDL LogInnoDB Engine

0 likes · 17 min read

Atomic DDL Implementation in MySQL 8.0: Metadata Management and DDL Log Mechanisms

Aikesheng Open Source Community

Jul 9, 2020 · Databases

Understanding Atomic DDL and the Data Dictionary in MySQL 8.0

This article explains how MySQL 8.0 introduces atomic DDL by moving the data dictionary into InnoDB system tables, describes the pre‑8.0 non‑atomic behavior, outlines the DDL execution phases, shows practical comparison results, and details how to view and configure DDL logs.

Atomic DDLDDL LogInnoDB

0 likes · 8 min read

Understanding Atomic DDL and the Data Dictionary in MySQL 8.0