A platform for sharing and discussing tech knowledge, guiding you toward the cloud of technology.
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.
This article explains how InnoDB stores data in 16 KB pages, how B+Tree indexes work, derives the formula for the maximum number of rows a single MySQL table can hold, and why the practical limit of about twenty million rows exists, along with performance implications and optimization tips.
This article explains the core principles of Hessian, a Java‑optimized binary serialization protocol, covering object graph traversal, encoding formats, data‑block tags, repeated‑object reuse, small‑integer inlining, and integer compression, and shows why it offers higher efficiency and compression than text‑based alternatives.
This article details how a modern frontend logging system was dramatically improved by implementing intelligent database cleanup, asynchronous module loading, dynamic JSZip imports, log queue throttling, and Rollup build‑time fixes, resulting in a much smaller bundle and smoother user experience.
This article explains the background, supported scenarios, overall and evolving architecture, script hot‑deployment, CI/CD workflow, and future plans of a DAG‑driven word distribution platform that unifies keyword recommendation across dozens of e‑commerce use cases, improving flexibility, development cost, and user experience.
This article explains how R8’s ApiModel optimization can generate a redundant new‑instance bytecode that triggers class initialization failures, why synchronized or try‑catch blocks also cause the issue, and presents four practical solutions including disabling ApiModel, official patches, custom fixes, and business‑level refactoring.
This article explains why scalable systems are essential, outlines core design principles such as the open‑closed and modular approaches, demonstrates Go implementations of strategy, middleware, plugin, and configuration‑driven architectures, and provides validation metrics and an evolution roadmap for building extensible backend services.
This article details Dewu's shift from manual product checks to an AI‑driven, dynamically configurable audit system that improves review speed, accuracy, and scalability while reducing manual effort through rule engines, HTTP‑based algorithm calls, and extensive data analysis.
This article analyzes the three major challenges of e‑commerce marketing venue configuration—multi‑goal coupling, verification lag, and cross‑team inefficiency—and presents a full‑link "pain‑point traversal" solution that simulates future time, user groups, and AB experiments to enable pre‑launch validation, dramatically improving efficiency and risk control.
This article details the design and implementation of a self‑built customer service knowledge base, covering background needs, the selection of TinyMCE as the rich‑text editor, system architecture, solutions for image migration, lazy loading, template thumbnails, global find/replace, and RAG‑based intelligent Q&A.
