Mapping of metrics used in system.dashboards to Prometheus metrics in `system.custom_metrics`
Mapping of metrics used in system.dashboards to Prometheus metrics in system.custom_metrics
· 3 мин. чтения
Knowledge Base
5 записей с тегом "System Tables"
How to Check Users Assigned to Roles and Vice Versa
Learn how to query ClickHouse's `system.role_grants` to find users assigned to roles and roles assigned to specific users.
· 3 мин. чтения
How do I view the number of active or queued mutations?
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.
· 1 мин. чтения
DB::Exception: Part XXXXX intersects previous part YYYYY. It is a bug or a result of manual intervention in the ZooKeeper data.
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.
· 2 мин. чтения
How to Identify Queries Using Materialized Views in ClickHouse
Learn how to query ClickHouse logs to identify all queries involving Materialized Views within a specified time range.
· 2 мин. чтения