Fast CPU Performance Evaluation on Domestic Servers & OceanBase Optimization

This article explains why domestic Haiguang/Kunpeng servers lag behind Intel CPUs, presents a quick stored‑procedure method to benchmark CPU performance, details OceanBase tenant CPU specifications and tuning parameters, and offers concrete optimization techniques for high‑concurrency TP and massive‑data AP scenarios, including queuing tables, sequence cache, and index redesign.

CPU performanceDatabase OptimizationOceanBase

0 likes · 21 min read

Fast CPU Performance Evaluation on Domestic Servers & OceanBase Optimization

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.

LSM‑TreeMajor FreezeOceanBase

0 likes · 16 min read

Performance Degradation After Data Updates in OceanBase and Its Optimization Techniques