altinity-expert-clickhouse-mutations

What problem does it solve?

Mutations in ClickHouse can become long-running or stuck, leading to degraded write performance and potential data inconsistencies. This skill provides actionable diagnostics to monitor, diagnose, and remediate mutation-related issues across a cluster.

Core Features & Use Cases

• Current Mutations Status: quickly view all ongoing mutations with status and age.
• Mutation History & Performance: review completed and in-flight mutations to identify trends and bottlenecks.
• Stuck Mutations Detection & Remediation Guidance: detect aging mutations and provide practical steps to resolve them.
• Cross-Module Context: correlate mutations with merges, replication, and resource usage to diagnose root causes.

Quick Start

Identify active and pending mutations by querying system.mutations and related views, then assess their impact and plan remediation.