altinity
8 skills with substantive source documentation and an official publisher or observed installation demand. Read each skill’s original documentation through its card.
altinityaltinity-expert-clickhouse-caches
Analyzes the ClickHouse mark cache, uncompressed cache, query cache and compiled expression cache, their hit ratios and their RAM footprint. Use when cache hit ratios are poor, caches take too much RAM, mark counts look excessive, or cache sizing needs tuning.
- 導入数
- 1
- GitHub Stars
- 17
- 更新日
- 9月17日
altinityaltinity-expert-clickhouse-index-analysis
Analyze whether ClickHouse indexes (PRIMARY KEY, ORDER BY, skipping indexes, projections) are effective for the actual query patterns. Use when investigating index effectiveness, ORDER BY key design, query-to-index alignment, or when queries scan far more data than expected.
- 導入数
- 1
- GitHub Stars
- 17
- 更新日
- 9月17日
altinityaltinity-expert-clickhouse-ingestion
Diagnoses ClickHouse INSERT performance, batch sizing, part creation patterns and materialized-view overhead on inserts. Use for slow inserts, failed inserts, micro-batching, high part creation rate, Buffer table flushes and data pipeline issues.
- 導入数
- 1
- GitHub Stars
- 17
- 更新日
- 9月17日
altinityaltinity-expert-clickhouse-kafka
Diagnose ClickHouse Kafka engine health, stuck consumers, thread pool capacity, consumer lag, slow materialized views, and Kafka rack-awareness or cross-AZ traffic. Use for Kafka lag, consumer errors, rebalances, thread starvation, or unexpected cross-AZ Kafka cost.
- 導入数
- 1
- GitHub Stars
- 17
- 更新日
- 9月17日
altinityaltinity-expert-clickhouse-memory
Diagnoses ClickHouse RAM usage, memory limits, OOM errors and the allocation breakdown across queries, caches, dictionaries and primary keys. Use when MEMORYLIMITEXCEEDED appears, the server is killed by the OOM killer, memory grows steadily, or GROUP BY and JOIN queries run out of memory.
- 導入数
- 1
- GitHub Stars
- 17
- 更新日
- 9月17日
altinityaltinity-expert-clickhouse-mutations
Diagnoses ClickHouse mutations - ALTER UPDATE, ALTER DELETE, MATERIALIZE and column changes. Use for stuck mutations, mutations that never finish, latestfailreason errors, growing mutation queues and slow ALTER operations.
- 導入数
- 1
- GitHub Stars
- 17
- 更新日
- 9月17日
altinityaltinity-expert-clickhouse-part-log
Diagnoses part lifecycle problems from system.partlog - part creation, merges, mutations, downloads, removals and moves. Use when there are too many parts or micro-batch inserts, merge backlog or slow merges, mutation storms from ALTER UPDATE or DELETE, unusual DownloadPart replication churn, unexpected RemovePart spikes, or Keeper znode growth tied to part activity.
- 導入数
- 1
- GitHub Stars
- 17
- 更新日
- 9月17日
altinityaltinity-expert-clickhouse-reporting
Diagnoses ClickHouse SELECT query performance, query patterns, slow queries, failures and optimization opportunities. Use for query latency, timeouts, high CPU queries, queries reading too much data and repeated expensive query patterns.
- 導入数
- 1
- GitHub Stars
- 17
- 更新日
- 9月17日