Aikesheng Open Source Community
May 15, 2023 · Databases
Performance Degradation After Data Updates in OceanBase and Its Optimization Techniques
The article investigates why pure‑read QPS drops significantly after bulk updates in OceanBase, reproduces the issue with a sysbench workload, analyses flame‑graph and SQL audit data, explains the LSM‑Tree read‑amplification mechanism, and proposes practical mitigation steps such as major freeze, plan binding, index creation, and the queuing‑table feature.
Flame GraphLSM TreeMajor Freeze
0 likes · 16 min read