extension table

Architect

Jun 1, 2025 · Databases

Dynamic Extension of Fields in Billion‑Row Core Tables: Architecture and Implementation

To avoid lock, page split, and index degradation when adding fields to billion‑row core tables, this article presents a practical solution that uses dynamic field extension via configurable management, JSON‑based extension fields, and an extension‑table architecture integrated with Elasticsearch for storage and retrieval.

ElasticsearchMySQLSchema Design

0 likes · 10 min read

Dynamic Extension of Fields in Billion‑Row Core Tables: Architecture and Implementation

Zhuanzhuan Tech

May 15, 2025 · Databases

Dynamic Extension of Fields in Billion‑Row Tables: Challenges and Practical Solutions

This article examines the difficulties of adding new fields to a core billion‑row MySQL table—including locking, page splitting, and index degradation—and presents a configuration‑driven, three‑layer architecture that uses JSON extension fields, extension tables, and Elasticsearch to achieve safe, scalable dynamic schema evolution.

Database DesignDynamic SchemaJSON Field

0 likes · 8 min read

Dynamic Extension of Fields in Billion‑Row Tables: Challenges and Practical Solutions