How Didi Cut ClickHouse CPU Usage by 90%: Optimizing BgMoveProcPool Threads

This article details how Didi identified excessive CPU consumption by ClickHouse's BgMoveProcPool threads, traced the root cause to unnecessary part‑move checks, introduced a simple early‑exit guard in selectPartsForMove, and achieved a dramatic reduction in CPU load while contributing the fix upstream.

Background ThreadsCPUClickHouse

0 likes · 10 min read

How Didi Cut ClickHouse CPU Usage by 90%: Optimizing BgMoveProcPool Threads

New Oriental Technology

Jun 28, 2021 · Databases

InnoDB Architecture and Key Features: A Comprehensive Overview

This article provides a comprehensive overview of InnoDB architecture, covering its memory structures, background threads, and key features like checkpoint mechanisms, double write, and neighbor page flushing, essential for understanding MySQL's default storage engine.

Background ThreadsCheckpoint MechanismDatabase Architecture

0 likes · 12 min read

InnoDB Architecture and Key Features: A Comprehensive Overview

Tencent Database Technology

Jan 2, 2018 · Databases

Understanding SHOW ENGINE ROCKSDB STATUS: Statistics and Background Thread Implementation in MyRocks

This article explains the internal workings of the SHOW ENGINE ROCKSDB STATUS command in MyRocks, detailing how STATISTICS and BG_THREADS data are collected, the underlying RocksDB APIs, code structures, and how to extend these mechanisms for performance monitoring and debugging.

Background ThreadsDatabase MonitoringMyRocks

0 likes · 10 min read

Understanding SHOW ENGINE ROCKSDB STATUS: Statistics and Background Thread Implementation in MyRocks