Skip to content
Tagged articles

query profiling

4 articles · Page 1 of 1
Lakehouse Research Base
Lakehouse Research Base
Oct 12, 2026 · Databases

Doris vs StarRocks: Which OLAP Engine Fits Your Workload and Team?

This article provides a practical decision framework for choosing between Apache Doris and StarRocks for real-time OLAP workloads, comparing their architectural origins, licensing, optimal use cases, and guiding teams through self-hosted versus managed deployment decisions based on organizational capacity and query profiles.

Apache DorisOLAPPoC checklist
0 likes · 13 min read
Doris vs StarRocks: Which OLAP Engine Fits Your Workload and Team?
DaTaobao Tech
DaTaobao Tech
Nov 19, 2025 · Databases

Mastering MySQL Slow Query Diagnosis and Index Optimization

This article walks through a real‑world slow‑SQL case on a massive e‑commerce order table, explains B+Tree index structures, index height estimation, index push‑down, sorting strategies, EXPLAIN and Query Profiler usage, and provides a step‑by‑step SOP for safe index changes and validation.

B+TreeIndex OptimizationMySQL
0 likes · 40 min read
Mastering MySQL Slow Query Diagnosis and Index Optimization
Programmer DD
Programmer DD
Mar 31, 2022 · Databases

Mastering MySQL: Proven Steps to Diagnose and Optimize Slow Queries

This guide walks through systematic MySQL query optimization—from identifying slow statements via logs and EXPLAIN analysis, to profiling, tracing, and applying targeted fixes such as index tuning, query rewrites, and handling special cases like left‑most matching, implicit conversion, large pagination, and IN‑order‑by pitfalls.

MySQLSQL Optimizationindex tuning
0 likes · 13 min read
Mastering MySQL: Proven Steps to Diagnose and Optimize Slow Queries