BestHub
search
Sign in
Tag

Plan Cache

1 views collected around this technical thread.

Aikesheng Open Source Community
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.

DatabaseOceanBasePerformance Tuning
0 likes · 10 min read
Diagnosing Slow Stored Procedure Execution in OceanBase: Trace ID Analysis and Plan Cache Issues
Aikesheng Open Source Community
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.

Database IndexOceanBasePerformance Tuning
0 likes · 19 min read
Analyzing and Resolving Slow Query Plan Issues in OceanBase 3.2.3
WeiLi Technology Team
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.

IndexingMongoDBPerformance Debugging
0 likes · 21 min read
Why Did MongoDB’s Query Planner Suddenly Slow Down? A Deep Dive into Index Cache Failures