BestHub
Discover
Artificial IntelligenceBackend DevelopmentMobile DevelopmentProduct ManagementCloud NativeFrontend DevelopmentFundamentalsBig DataCloud ComputingGame DevelopmentR&D ManagementOperationsDatabasesInformation SecurityBlockchainUser Experience DesignInterview ExperienceIndustry Insights
View all →
TopicsTagsTrendsRanking
Sign in
Discover
Artificial Intelligence Backend Development Mobile Development Product Management Cloud Native Frontend Development Fundamentals Big Data Cloud Computing Game Development R&D Management Operations Databases Information Security Blockchain User Experience Design Interview Experience Industry Insights View all →
TopicsTagsTrendsRanking
Sign in
  1. Home
  2. / Tags
  3. / Page Split
Xuanwu Backend Tech Stack
Xuanwu Backend Tech Stack
Dec 9, 2025 · Databases

Why UUID Primary Keys Trigger InnoDB Page Splits and How to Prevent Them

This article explains the internal mechanics of MySQL 8.0 InnoDB pages, how random primary keys such as UUID cause costly page splits and merges, and provides Java‑level best practices and MySQL commands to optimize primary‑key design for better performance and space utilization.

InnoDBMySQLPage Merge
0 likes · 14 min read
Why UUID Primary Keys Trigger InnoDB Page Splits and How to Prevent Them
DeWu Technology
DeWu Technology
Sep 17, 2025 · Databases

How a DDL Change Can Double MySQL Table Size: The Hidden B+Tree Page‑Split Bug

After a normal DDL change on the OneDBA platform, a table's storage grew nearly 100% and some queries slowed down, revealing a MySQL InnoDB B+Tree page‑split flaw that stores only one row per 16KB page when large records are inserted, which also corrupts statistics and leads to slow SQL.

B+TreeDDLInnoDB
0 likes · 24 min read
How a DDL Change Can Double MySQL Table Size: The Hidden B+Tree Page‑Split Bug
BestHub

Editorial precision for engineers who prefer signal over noise. Deep reads, careful curation, and sharper frontiers in software.

Best Hub for Dev. Power Your Build.
Navigation
Status Discover Tags Topics System Status Privacy Terms Rss Feed