Analyze cluster data and metrics using raw SQL recipes against system.query_log and system.parts when no dedicated tool exists.
Quellsprache: Englisch
Menü
SkillsMP hat 6 Skills aus terrylica/clickhouse-monitoring gesammelt. Öffne einen Skill, um Quelle und Details zu prüfen.
Es werden 6 von 6 gesammelten Skills angezeigt.
Analyze cluster data and metrics using raw SQL recipes against system.query_log and system.parts when no dedicated tool exists.
Quellsprache: Englisch
Structured triage recipes for common ClickHouse incidents: disk, errors, replication, mutations, cluster health, and slow queries.
Quellsprache: Englisch
Recommend table ORDER BY keys, partition strategies, column data-type right-sizing, codecs, skip indexes, and projections for ClickHouse tables.
Quellsprache: Englisch
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…
Quellsprache: Englisch
Schema migrations: ALTER patterns, engine changes, zero-downtime swaps, clickhouse-local offline migrations, and lightweight UPDATE/DELETE strategies.
Quellsprache: Englisch
Advanced query tuning: join algorithms, skip index selection, EXPLAIN interpretation, ProfileEvents profiling, and optimizer settings.
Quellsprache: Englisch