Press Space to continue
Discover how we debugged hidden lock contention in ClickHouse's
Press Space to continue
When a partitioning change to our petabyte-scale ClickHouse cluster caused critical billing jobs to stall, standard metrics showed no obvious errors. Here's how we identified severe lock contention in ClickHouse's query planner and built upstream patches to fix it. https://cfl.re/48WfsXl
Our billing pipeline was suddenly slow. The culprit was a hidden bottleneck in ClickHouse
open on xViews and clicks count once per visitor per day. Clicks are opens of this post on X.