腾讯云数据仓库 TCHouse-C 监控指标

最近更新时间:2024-08-16 15:02:21

我的收藏

命名空间

Namespace = QCE/CDWCH

监控指标

指标英文名
指标中文名
说明
单位
维度
统计规则
CkUp
上报节点数
1-存活,0-失活
None
InstanceId, ip
[60s, min] [300s, min]
ConnectionRejected
拒绝链接个数
拒绝链接个数
Count
InstanceId, ip
[60s, max] [300s, max]
Contextlockwait
上下文锁定等待个数
上下文锁等待
None
InstanceId, ip
[60s, max] [300s, max]
CpuLoadRate
CPU 负载比率
CPU 负载比率
%
InstanceId, ip
[60s, max] [300s, max]
CpuUsage
CPU 使用率
CPU 使用率
%
InstanceId, ip
[60s, max] [300s, max]
CpuUsageAvg
CPU 使用率
CPU 平均使用率
%
InstanceId, ip
[60s, avg] [300s, avg]
DiskUsage
磁盘使用率
数据盘使用率
%
InstanceId, ip
[60s, max] [300s, max]
Failedinsertquery
失败插入数
插入失败数
Count/s
InstanceId, ip
[60s, max] [300s, max]
Failedselectquery
失败查询数
查询失败数
Count/s
InstanceId, ip
[60s, max] [300s, max]
Fileopen
系统文件打开数速率
文件打开数
None
InstanceId, ip
[60s, max] [300s, max]
GlobalSessions
全局 session 个数
全局 session 个数
Count
InstanceId, ip
[60s, max] [300s, max]
Httpconnection
HTTP 连接数
HTTP 连接数
None
InstanceId, ip
[60s, max] [300s, max]
Insertquery
插入数
单位时间的insert执行次数
None
InstanceId, ip
[60s, max] [300s, max]
JvmMemoryPoolBytesUsed
Jvm 内存池使用
Jvm 内存池使用
MBytes
InstanceId, ip
[60s, max] [300s, max]
MemUsage
内存使用率
内存使用率
%
InstanceId, ip
[60s, max] [300s, max]
Merge
合并数
合并数
Count
InstanceId, ip
[60s, max] [300s, max]
Mergestimemilliseconds
merge 时长速率
merge 所消耗的时间(速率)
ms
InstanceId, ip
[60s, max] [300s, max]
Mysqlconnection
Mysql 连接数
Mysql 方式的连接数
Count
InstanceId, ip
[60s, max] [300s, max]
NodeLoad1
cpu1分钟负载
节点一分钟负载
None
InstanceId, ip
[60s, max] [300s, max]
NodeLoad15
15分钟负载
15分钟负载
None
InstanceId, ip
[60s, max] [300s, max]
NodeLoad5
5分钟负载
5分钟负载
None
InstanceId, ip
[60s, max] [300s, max]
NodeNetworkReceiveBytesTotal
接收流量
节点接收流量
MBytes/s
InstanceId, ip
[60s, max] [300s, max]
NodeNetworkTransmitBytesTotal
发送流量
节点流出流量
MBytes/s
InstanceId, ip
[60s, max] [300s, max]
PacketsReceived
接收传输包的速率
接收传输包的速率
Count/s
InstanceId, ip
[60s, max] [300s, max]
PacketsSent
发包个数
发包个数
Count
InstanceId, ip
[60s, max] [300s, max]
PrepProcessorQueueTimeMs
预处理队列等待时间
预处理队列等待时间
ms
InstanceId, ip
[60s, max] [300s, max]
PrepProcessTime
预处理时间
预处理时间
ms
InstanceId, ip
[60s, max] [300s, max]
Query
查询数
包含增删改查的 query 个数
Count/s
InstanceId, ip
[60s, max] [300s, max]
Querythread
查询线程数
查询线程数
None
InstanceId, ip
[60s, max] [300s, max]
Replicatedpartmerges
副本块合并个数
单位时间内的副本块合并个数
Count/s
InstanceId, ip
[60s, max] [300s, max]
Replicatedpartmutations
副本块的修改数
单位时间内的副本块修改数
Count/s
InstanceId, ip
[60s, max] [300s, max]
RequestCommitQueued
请求提交队列个数
请求提交队列个数
Count
InstanceId, ip
[60s, max] [300s, max]
SumCkUp
上报节点数
集群节点数
None
InstanceId
[60s, count] [300s, count]
SumCpuUsage
CPU 使用率
CPU 使用率
%
InstanceId
[60s, avg] [300s, avg]
SumDiskUsage
磁盘使用率
数据盘使用率
%
InstanceId
[60s, avg] [300s, avg]
SumFailedinsertquery
失败插入数
插入失败数
Count/s
InstanceId
[60s, sum] [300s, sum]
SumFailedselectquery
失败查询数
查询失败数
Count/s
InstanceId
[60s, sum] [300s, sum]
SumInsertquery
插入数
插入数
Count/s
InstanceId
[60s, sum] [300s, sum]
SumMemUsage
内存使用率
内存使用率
%
InstanceId
[60s, avg] [300s, avg]
SumNodeNetworkReceiveBytesTotal
接收流量
节点接收流量
MBytes/s
InstanceId
[60s, sum] [300s, sum]
SumNodeNetworkTransmitBytesTotal
发送流量
节点发送流量
MBytes/s
InstanceId
[60s, sum] [300s, sum]
SumQuery
查询数
总查询数
None
InstanceId
[60s, sum] [300s, sum]
Tcpconnection
Tcp 连接数
Tcp 连接数
None
InstanceId, ip
[60s, max] [300s, max]
Uptime
启动时间
启动时间
None
InstanceId, ip
[60s, min] [300s, min]
WatchCount
zk_watch 个数
zk_watch 个数
Count
InstanceId, ip
[60s, max] [300s, max]
ZkUp
zk 进程存活
zk 进程存活
None
InstanceId, ip
[60s, min] [300s, min]
ZnodeCount
znode 个数
znode 个数
Count
InstanceId, ip
[60s, max] [300s, max]
Zookeeperrequest
zk 请求个数
zk 请求数
Count
InstanceId, ip
[60s, max] [300s, max]
Zookeepersession
zk 链接个数
当前 zk session 个数
Count
InstanceId, ip
[60s, max] [300s, max]
Zookeeperwatch
zkwatch 个数
zkwatch 个数
Count
InstanceId, ip
[60s, max] [300s, max]

各维度对应参数总览

参数名称
维度名称
维度解释
格式
Instances.N.Dimensions.0.Name
InstanceId
集群 ID 的维度名称
输入 String 类型维度名称:InstanceId
Instances.N.Dimensions.0.Value
InstanceId
具体集群 ID
输入具体集群 ID,例如:cdwch-89d5vlvd
Instances.N.Dimensions.1.Name
ip
节点 ip 的维度名称
输入 String 类型维度名称:ip
Instances.N.Dimensions.1.Value
ip
具体节点 ip
输入具体节点 IP,例如:10.0.0.0

入参说明

查询 QCE/CDWCH 指标监控数据,入参取值如下: &Namespace=QCE/CDWCH &Instances.N.Dimensions.0.Name=InstanceId &Instances.N.Dimensions.0.Value=具体集群 ID &Instances.N.Dimensions.1.Name=ip &Instances.N.Dimensions.1.Value=具体节点 ip
说明:
不同监控指标维度不同,请根据对应指标维度填写入参。