BestHub
Sign in
Tag

DDL Log

1 views collected around this technical thread.

Tencent Database Technology
Tencent Database Technology
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 LogData Dictionary
0 likes · 17 min read
Atomic DDL Implementation in MySQL 8.0: Metadata Management and DDL Log Mechanisms
Aikesheng Open Source Community
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 LogData Dictionary
0 likes · 8 min read
Understanding Atomic DDL and the Data Dictionary in MySQL 8.0