Resolving ClickHouse “too many mutations” Errors by Cleaning Mutations and Switching to ReplacingMergeTree

The article describes a real‑world ClickHouse incident where excessive UPDATE‑style mutations caused a “too many mutations(1036)” error, explains the cluster’s configuration, and details a step‑by‑step recovery process that clears pending mutations and migrates tables to the ReplacingMergeTree engine to restore service.

ClickHouseReplacingMergeTreeTable Engine

0 likes · 7 min read

Resolving ClickHouse “too many mutations” Errors by Cleaning Mutations and Switching to ReplacingMergeTree

dbaplus Community

Oct 18, 2022 · Databases

Mastering ClickHouse: Practical Table Engine Choices and Cluster Best Practices

This guide explains ClickHouse’s core concepts, application scenarios, table engine families, detailed engine configurations, SQL development standards, cluster architecture, ZooKeeper’s role, chproxy usage, client tool options, availability considerations, and performance‑tuning parameters for high‑throughput OLAP workloads.

ClickHouseClusterSQL

0 likes · 26 min read

Mastering ClickHouse: Practical Table Engine Choices and Cluster Best Practices

DataFunTalk

Jul 6, 2022 · Databases

From ClickHouse to ByteHouse: Technical Optimizations and Production Practices

The whitepaper “From ClickHouse to ByteHouse” details ByteDance’s large‑scale deployment of ClickHouse, the challenges of moving it to production, and the key optimizations ByteHouse introduces—including custom table engines, a revamped query optimizer, and elastic compute‑storage separation—to achieve petabyte‑level OLAP performance.

Analytical DatabasesByteHouseClickHouse

0 likes · 6 min read

From ClickHouse to ByteHouse: Technical Optimizations and Production Practices