تشغيل أي مهارة في Manus بنقرة واحدة

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.

التثبيت

التثبيت باستخدام Codex أو Claude انسخ هذا Prompt والصقه في Codex أو Claude أو مساعد آخر ليراجع صفحة Skill ويثبّتها لك.

تشغيل في Manus

المصدر

Altinity

Altinity/altinity-skills

فتح مستودع GitHub عرض مستودعات المنشئ

تنزيل

تشغيل في Manus

المهن ذات الصلةSOC

استنادا إلى تصنيف SOC المهني

مطوّرو البرمجياتمهن الحاسوب والرياضيات·SOC 15-1252

مستكشف الملفات

2 ملفات

SKILL.md

readonly

name	altinity-expert-clickhouse-logs
description	Analyze ClickHouse system log table health including TTL configuration, disk usage, freshness, and cleanup. Use for system log issues and TTL configuration.
license	Apache-2.0

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

https://kb.altinity.com/altinity-kb-setup-and-maintenance/altinity-kb-system-tables-eat-my-disk/

المزيد من هذا المستودع

نفس المستودع

altinity-expert-clickhouse-security

Altinity/altinity-skills

Read-only ClickHouse security audit expert for live or exported systems. Use when assessing ClickHouse security posture, reviewing users, roles, grants, settings profiles, row policies, table functions, external sources, table engines, executable UDFs, audit logs, named collections, password hash hygiene, SQL SECURITY DEFINER, impersonation, TLS/network exposure, Keeper/interserver security, encryption at rest, backups, the HTTP interface surface, cluster security, or version-specific ClickHouse security behavior. Diagnoses from SQL/system tables, supplied configuration files, query logs, access metadata, and ClickHouse/Altinity documentation.

2026-06-0313

altinity-expert-clickhouse-grants

Altinity/altinity-skills

Diagnose and resolve ClickHouse grant and authentication errors, especially after upgrades. Use when queries fail with ACCESS_DENIED/NOT_ENOUGH_PRIVILEGES, AUTHENTICATION_FAILED/WRONG_PASSWORD/REQUIRED_PASSWORD, or ON CLUSTER privilege errors; when system.* or INFORMATION_SCHEMA access is denied; or when grant behavior changes after version upgrades.

2026-06-0313

altinity-expert-clickhouse-caches

Altinity/altinity-skills

Analyze ClickHouse cache systems including mark cache, uncompressed cache, and query cache. Use for cache hit ratio issues and cache tuning.

2026-06-0113

altinity-expert-clickhouse-connection

Altinity/altinity-skills

Establishes the ClickHouse connection mode, cluster macro, and default log timeframe for diagnostics. Use first, before any other altinity-expert-clickhouse skill, to verify connectivity and set shared analysis rules.

2026-06-0113

altinity-expert-clickhouse-dictionaries

Altinity/altinity-skills

Analyze ClickHouse external dictionaries including configuration, memory usage, reload status, and performance. Use for dictionary issues and load failures.

2026-06-0113

altinity-expert-clickhouse-index-analysis

Altinity/altinity-skills

Analyze whether ClickHouse indexes (PRIMARY KEY, ORDER BY, skipping indexes, projections) are being used effectively for actual query patterns. Use when investigating index effectiveness, ORDER BY key design, query-to-index alignment, or when queries scan more data than expected.

2026-06-0113

تشغيل أي مهارة بنقرة واحدة