Mapping of metrics used in system.dashboards to Prometheus metrics in `system.custom_metrics`
· 3 min read
Mapping of metrics used in system.dashboards to Prometheus metrics in system.custom_metrics
5 posts tagged with "System Tables"
View All TagsHow to Check Users Assigned to Roles and Vice Versa
· 3 min read
Learn how to query ClickHouse's `system.role_grants` to find users assigned to roles and roles assigned to specific users.
How do I view the number of active or queued mutations?
· One min read
Monitor the number of active or queued mutations in ClickHouse, especially when performing `ALTER` or `UPDATE` operations. Use the `system.mutations` table for tracking mutations.
DB::Exception: Part XXXXX intersects previous part YYYYY. It is a bug or a result of manual intervention in the ZooKeeper data.
· 2 min read
This article explains how to resolve the DB::Exception error related to intersecting parts in ClickHouse, often caused by a race condition or manual intervention in the ZooKeeper data.
How to Identify Queries Using Materialized Views in ClickHouse
· 2 min read
Learn how to query ClickHouse logs to identify all queries involving Materialized Views within a specified time range.