Tagged articles

Plan Cache

4 articles · Page 1 of 1

May 27, 2026 · Databases

DongSQL V1.2.0: Dual Performance and Stability Gains for Retail Databases

DongSQL V1.2.0 introduces a suite of kernel upgrades—including group‑commit unicast, semi‑sync replication tweaks, plan‑cache, single‑point query enhancements, massive‑table fast startup, SIMD acceleration, hotspot‑row updates and high‑volume testing support—delivering significant performance and stability improvements across diverse retail workloads.

Database PerformanceDongSQLHigh‑Volume Testing

0 likes · 24 min read

DongSQL V1.2.0: Dual Performance and Stability Gains for Retail Databases

Aikesheng Open Source Community

Sep 19, 2024 · Databases

Diagnosing Slow Stored Procedure Execution in OceanBase: Trace ID Analysis and Plan Cache Issues

This article explains how to troubleshoot a slow OceanBase stored procedure by locating its trace_id, analyzing audit logs to identify non‑cached UPDATE statements, revealing that preceding TRUNCATE operations invalidate the plan cache, and finally recommending replacing TRUNCATE with DELETE to restore performance.

DatabaseOceanBasePlan Cache

0 likes · 10 min read

Diagnosing Slow Stored Procedure Execution in OceanBase: Trace ID Analysis and Plan Cache Issues

Aikesheng Open Source Community

Dec 20, 2023 · Databases

Analyzing and Resolving Slow Query Plan Issues in OceanBase 3.2.3

This article presents a step‑by‑step investigation of a SELECT statement that became 1000× slower in OceanBase 3.2.3 BP8, explains why the optimizer chose an inefficient I5 index, describes the plan‑expiration logic, and provides reproducible scripts and practical recommendations for fixing the problem.

OceanBasePlan CacheSQL

0 likes · 19 min read

Analyzing and Resolving Slow Query Plan Issues in OceanBase 3.2.3

WeiLi Technology Team

Mar 29, 2023 · Databases

Why Did MongoDB’s Query Planner Suddenly Slow Down? A Deep Dive into Index Cache Failures

The article explains how null or empty query values caused MongoDB to ignore the intended index, leading to massive slow queries and service timeouts, and details the step‑by‑step investigation, plan‑cache invalidation, and the corrective addition of a compound index that restored normal performance.

IndexingMongoDBPlan Cache

0 likes · 21 min read

Why Did MongoDB’s Query Planner Suddenly Slow Down? A Deep Dive into Index Cache Failures