Analyze cluster data and metrics using raw SQL recipes against system.query_log and system.parts when no dedicated tool exists.
原文语言:英语
菜单
SkillsMP 已收集 terrylica/clickhouse-monitoring 中的 6 个 Skill。打开任一 Skill 可查看来源和详情。
已展示 6 / 6 个已收集 Skill。
Analyze cluster data and metrics using raw SQL recipes against system.query_log and system.parts when no dedicated tool exists.
原文语言:英语
Structured triage recipes for common ClickHouse incidents: disk, errors, replication, mutations, cluster health, and slow queries.
原文语言:英语
Recommend table ORDER BY keys, partition strategies, column data-type right-sizing, codecs, skip indexes, and projections for ClickHouse tables.
原文语言:英语
Exact column names for the system tables the agent queries most (processes, query_log, parts, merges, mutations, replicas, replication_queue, disks, settings, zookeeper, users/grants, metrics) plus rules for choosing dedicated tools over raw SQL. Load before…
原文语言:英语
Schema migrations: ALTER patterns, engine changes, zero-downtime swaps, clickhouse-local offline migrations, and lightweight UPDATE/DELETE strategies.
原文语言:英语
Advanced query tuning: join algorithms, skip index selection, EXPLAIN interpretation, ProfileEvents profiling, and optimizer settings.
原文语言:英语