Aikesheng Open Source Community
Mar 22, 2023 · Databases
Understanding and Optimizing BUFFER (Queuing) Tables in OceanBase
The article explains what OceanBase BUFFER (Queuing) tables are, why frequent bulk updates cause performance degradation, and provides three optimization methods—including binding execution plans, manual data transfer, and setting table_mode='queuing'—with concrete MySQL and Oracle examples and query scripts to monitor merges.
BUFFER tableDatabaseMySQL
0 likes · 7 min read