altinity-expert-clickhouse-merges
Diagnostics
Run all queries from checks.sql (cluster-wide) one by one and produce a decision-ready report.
Triage Order (Mandatory)
- Check current active merges from
system.merges. - Check merge success/failure trend from
system.part_log. - Check table-level status (
merge_ok,merge_failed, last success/failure). - Check merge reason + algorithm (
merge_reason,merge_algorithm). - Check merge RAM now + historical peak RAM (
system.merges.memory_usage,system.part_log.peak_memory_usage). - Check part-count offenders with split:
database = 'system'database != 'system'
- Check relevant settings, including TTL merge concurrency.
Decision Rules
More from altinity/skills
altinity-expert-clickhouse-schema
Analyze ClickHouse table structure, partitioning, ORDER BY keys, materialized views, and identify schema design anti-patterns. Use for table design issues and optimization.
66altinity-expert-clickhouse-logs
Analyze ClickHouse system log table health including TTL configuration, disk usage, freshness, and cleanup. Use for system log issues and TTL configuration.
59altinity-expert-clickhouse-ingestion
Diagnose ClickHouse INSERT performance, batch sizing, part creation patterns, and ingestion bottlenecks. Use for slow inserts and data pipeline issues.
58altinity-expert-clickhouse-overview
Runs a quick overview of Clickhouse server health.
55altinity-expert-clickhouse-dictionaries
Analyze ClickHouse external dictionaries including configuration, memory usage, reload status, and performance. Use for dictionary issues and load failures.
55altinity-expert-clickhouse-mutations
Track and diagnose ClickHouse ALTER UPDATE, ALTER DELETE, and other mutation operations. Use for stuck mutations and mutation performance issues.
55