Altinity Expert Clickhouse Logs

Analyze ClickHouse system log table health including TTL configuration, disk usage, freshness, and cleanup. Use for system log issues and TTL configuration.

altinity 1f888c5 2 files · 4.4 KB Updated

File contents

Diagnostics

Run all queries from checks.sql in this skill's directory and analyze the results.

TTL Recommendations

Log Table Recommended TTL Notes
query_log 7-30 days Balance debugging vs disk
query_thread_log Disable or 3 days Very verbose
part_log 14-30 days Important for RCA
trace_log 3-7 days Large, mostly for debugging
text_log 7-14 days Important for debugging
metric_log 7-14 days Useful for trending
asynchronous_metric_log 7-14 days Low volume
crash_log 90+ days Rare, keep longer

KB articles

altinity/altinity-skills/tree/main/altinity-expert-clickhouse/skills/altinity-expert-clickhouse-logs commit 1f888c5d11

Frequently asked questions

npx skillmds@latest add altinity/altinity-expert-clickhouse-logs