BestHub
search
Sign in
Tag

Atomic DDL

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
Sep 3, 2020 · Databases

Is It Time to Upgrade to MySQL 8.0? – Highlights from the First Episode of “MySQL Chōng Chōng Chōng”

The first episode of the “MySQL Chōng Chōng Chōng” livestream discusses why now is an excellent time to upgrade to MySQL 8.0, covering fast add‑column, Atomic DDL, Hash Join, Group Replication, authentication changes, and includes thanks to sponsors and a preview of the next show.

Atomic DDLDatabase upgradeFast Add Column
0 likes · 9 min read
Is It Time to Upgrade to MySQL 8.0? – Highlights from the First Episode of “MySQL Chōng Chōng Chōng”
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
Tencent Database Technology
Tencent Database Technology
Mar 12, 2019 · Databases

Understanding MySQL 8.0 Data Dictionary, Atomic DDL, and Persistent Autoincrement

This article explains the evolution of MySQL's data dictionary from pre‑8.0 scattered metadata to the unified InnoDB dictionary tables in MySQL 8.0, covering storage structures, dictionary caching, information_schema changes, serialized dictionary information (SDI), atomic DDL mechanisms, persistent autoincrement handling, upgrade considerations, and provides practical code examples.

Atomic DDLData DictionaryInnoDB
0 likes · 22 min read
Understanding MySQL 8.0 Data Dictionary, Atomic DDL, and Persistent Autoincrement