Databases · By chmonitor

Drive chmonitor the way a user does: the Rust CLI/TUI (chm / chmonitor in rust/ch-monitor-cli) is the primary surface; the dashboard at apps/dashboard and https://dash.chmonitor.dev is secondary.

chmonitor/chmonitor

Prove the deployed chmonitor product actually works, not just that the Worker answers.

chmonitor/chmonitor

Detect cluster abnormalities by comparing recent activity (last 1h) to a baseline (preceding 24h) using the raw query tool.

chmonitor/chmonitor

Work on chmonitor's Cloud (SaaS) vs self-hosted (OSS) behaviour from ONE codebase.

chmonitor/chmonitor

Explains core ClickHouse concepts with accurate mental models — MergeTree, indexes, replication, sharding, and special engines.

chmonitor/chmonitor

Analyze cluster data and metrics using raw SQL recipes against system.querylog and system.parts when no dedicated tool exists.

chmonitor/chmonitor

Detect server cores/RAM/disk from system tables, then recommend ClickHouse settings sized to that hardware.

chmonitor/chmonitor

Structured triage recipes for common ClickHouse incidents: disk, errors, replication, mutations, cluster health, and slow queries.

chmonitor/chmonitor

Schema migrations: ALTER patterns, engine changes, zero-downtime swaps, clickhouse-local offline migrations, lightweight UPDATE/DELETE strategies, and Postgres→ClickHouse migration planning (type…

chmonitor/chmonitor

Diagnose a slow or expensive query with EXPLAIN and querylog, then propose concrete rewrites and better join strategies.

chmonitor/chmonitor

Recommend table ORDER BY keys, partition strategies, column data-type right-sizing, codecs, skip indexes, and projections for ClickHouse tables.

chmonitor/chmonitor

Exact column names for the system tables the agent queries most (processes, querylog, parts, merges, mutations, replicas, replicationqueue, disks, settings, zookeeper, users/grants, metrics) plus…

chmonitor/chmonitor

Diagnose and resolve ClickHouse issues: OOM, slow merges, stuck mutations, query failures with error codes, and systematic error clustering.

chmonitor/chmonitor

Advises whether and how to upgrade ClickHouse — versioning scheme, upgrade path, what you gain, pre/post-upgrade checklist.

chmonitor/chmonitor

Production operational practices: insert batching, async writes, query cache, connection pooling, and recommended settings.

chmonitor/chmonitor

Cluster management: distributed tables, ON CLUSTER DDL, node lifecycle, resharding, load balancing, and Keeper migration.

chmonitor/chmonitor

Advanced query tuning: join algorithms, skip index selection, EXPLAIN interpretation, ProfileEvents profiling, and optimizer settings.

chmonitor/chmonitor

ReplicatedMergeTree operations, failover procedures, lag diagnosis, quorum writes, and Keeper management.

chmonitor/chmonitor