Open mdianjun opened 3 years ago
prometheus地址: http://10.0.0.11:9090
grafana地址:http://10.0.0.11:3000/d/MddcNtTWk/clickhouse-internal-exporter?orgId=1
指标名称 | 指标类型 | 含义 |
---|---|---|
ClickHouseProfileEvents_Query | counter | 总的查询次数,包括INSERT |
ClickHouseProfileEvents_SelectQuery | counter | 总的查询次数 |
ClickHouseProfileEvents_InsertQuery | counter | 总的插入次数 |
ClickHouseProfileEvents_FileOpen | counter | 总的文件句柄数 |
ClickHouseProfileEvents_CompressedReadBufferBytes | counter | |
ClickHouseProfileEvents_ReadBufferFromFileDescriptorRead | counter | |
ClickHouseProfileEvents_ReadBufferFromFileDescriptorReadBytes | counter | |
ClickHouseProfileEvents_MarkCacheMisses | counter | 总的MarkCache未命中次数 |
ClickHouseProfileEvents_ReplicatedPartMerges | counter | 总的副本数据part成功合并的次数 |
ClickHouseProfileEvents_ReplicatedPartMutations | counter | |
ClickHouseProfileEvents_SelectedRanges | counter | |
ClickHouseProfileEvents_SelectedMarks | counter | |
ClickHouseProfileEvents_Merge | counter | 总的Merge次数 |
ClickHouseProfileEvents_MergedRows | counter | 总的Merge行数 |
ClickHouseProfileEvents_MergesTimeMilliseconds | counter | 总的Merge耗时 |
--- | --- | --- |
ClickHouseMetrics_Merge | gauge | 当前合并数 |
ClickHouseMetrics_MemoryTracking | gauge | 当前分配给server的内存总数 |
ClickHouseMetrics_Read | gauge | 当前处理读请求数 |
ClickHouseMetrics_Write | gauge | 当前处理写请求数 |
ClickHouseMetrics_LeaderReplica | gauge | |
ClickHouseMetrics_ReadonlyReplica | gauge | 当前只读的副本数 |
ClickHouseMetrics_ReplicatedChecks | gauge | 当前的副本检查数 |
ClickHouseMetrics_TCPConnection | gauge | 当前的tcp连接数 |
ClickHouseMetrics_BackgroundPoolTask | gauge | 当前后台活跃的任务数,包含(merges, mutations, fetches or replication queue bookkeeping) |
监控
system.metrics
system.asynchronous_metrics
system.events
数据分布
system.parts
load,cpu,内存,磁盘io,网络io,磁盘容量(使用/剩余)等 node_exporter
insert,merge,select 等操作占用的使用资源情况,执行情况,连接情况,qps等 https://www.modb.pro/db/46948 ck prometheus
资源,znode_count,latency等 zk prometheus
Table Metrics(columns,Rows,Parts,Disk_space 等)
历史query慢查询分析(ck cluster级别?)、正在进行的query使用资源情况
使用资源情况,执行时间,查询次数...
参考: https://help.aliyun.com/document_detail/172413.html?spm=a2c4g.11186623.6.585.5b613635wp6pgj https://cloud.tencent.com/document/product/589/43539 https://github.com/tencentyun/qcloud-documents/blob/master/product/大数据与AI/弹性MapReduce/操作指南/集群监控及告警/监控指标/ClicKhouse集群监控指标.md https://www.sohu.com/a/449686317_411876 https://docs.datadoghq.com/integrations/clickhouse/?tab=host https://github.com/DataDog/integrations-core/blob/master/clickhouse/datadog_checks/clickhouse/queries.py