altinity-expert-clickhouse-logs
Compare original and translation side by side
🇺🇸
Original
English🇨🇳
Translation
ChineseDiagnostics
诊断
Run all queries from the file checks.sql and analyze the results.
运行checks.sql文件中的所有查询并分析结果。
TTL Recommendations
TTL建议
| 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 |
| 日志表 | 推荐TTL | 说明 |
|---|---|---|
| query_log | 7-30天 | 在调试需求与磁盘占用间取得平衡 |
| query_thread_log | 禁用或保留3天 | 日志内容非常详细 |
| part_log | 14-30天 | 对根本原因分析（RCA）至关重要 |
| trace_log | 3-7天 | 数据量大，主要用于调试 |
| text_log | 7-14天 | 对调试至关重要 |
| metric_log | 7-14天 | 适用于趋势分析 |
| asynchronous_metric_log | 7-14天 | 数据量小 |
| crash_log | 90天以上 | 出现频率低，建议保留更长时间 |