Aikesheng Open Source Community

Oct 28, 2025 · Databases

How to Identify SQL Statements Causing Frequent Mini Compactions in OceanBase

This article explains why a tenant in OceanBase may experience frequent mini compactions, shows how to locate the responsible DML statements by querying merge info and tablet IDs, demonstrates the process with test tables, and provides conclusions and references for further investigation.