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
「System Tables」タグの投稿: 投稿 5 件
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分
