altinity-expert-clickhouse-storage

Original：🇺🇸 English

Translated

Diagnose ClickHouse disk usage, compression efficiency, part sizes, and storage bottlenecks. Use for disk space issues and slow IO.

1installs

Added on2026-02-08

NPX Install

npx skill4agent add altinity/skills altinity-expert-clickhouse-storage

Diagnose disk usage, compression efficiency, part sizes, and storage bottlenecks.

Run all queries from the file checks.sql and analyze the results.

sql

-- Always limit results
limit 100

-- For part_log
where event_date >= today() - 1

Finding	Load Module	Reason
Poor compression	`altinity-expert-clickhouse-schema`	Codec recommendations
Many small parts	`altinity-expert-clickhouse-merges`	Merge backlog
High write IO	`altinity-expert-clickhouse-ingestion`	Batch sizing
System logs large	`altinity-expert-clickhouse-logs`	TTL configuration
Slow disk + merges	`altinity-expert-clickhouse-merges`	Merge optimization

Setting	Notes
`min_bytes_for_wide_part`	Threshold for Wide vs Compact parts
`min_rows_for_wide_part`	Row threshold for Wide parts
`max_bytes_to_merge_at_max_space_in_pool`	Max merge size
`prefer_not_to_merge`	Disable merges (emergency)