腾讯云可观测平台 云数据库 MariaDB 监控指标

云数据库 MariaDB 监控指标入参说明如下&Namespace=QCE/MARIADB
&Instances.N.Dimensions.0.Name= InstanceId
&Instances.N.Dimensions.0.Value=具体实例 ID
&Instances.N.Dimensions.1.Name=NodeId
&Instances.N.Dimensions.1.Value=具体节点 ID。

相关产品
腾讯云可观测平台 产品页,含版本规格、价格与购买入口。

一、命名空间

Namespace = QCE/MARIADB

二、监控指标

指标英文名 指标中文名 说明 单位 维度 统计规则
[period, statType]
ActiveThreadCount 汇总活跃线程数 实例级别监控指标,计算方式为累加主备节点 DB 线程池活跃线程个数 Count InstanceId [5s, last]
[60s, avg]
[300s, avg]
[3600s, avg]
[86400s, avg]
ActiveThreadCountNode 活跃线程数 DB 节点线程池活跃线程个数 Count InstanceId,NodeId [5s, last]
[60s, avg]
[300s, avg]
[3600s, avg]
[86400s, avg]
BinlogDiskAvailable 最小剩余 Binlog 日志磁盘空间 实例级别监控指标,取值为实例主备节点剩余 Binlog 日志磁盘空间最小值 GB InstanceId [5s, last]
[60s, min]
[300s, min]
[3600s, min]
[86400s, min]
BinlogDiskAvailableNode 剩余 Binlog 日志磁盘空间 DB 节点剩余 Binlog 日志磁盘空间 GB NodeId,InstanceId [5s, last]
[60s, min]
[300s, min]
[3600s, min]
[86400s, min]
BinlogUsedDisk 已用 Binlog 日志磁盘空间 实例级别监控指标,取值为实例主节点已用 Binlog 日志磁盘空间 GB InstanceId [5s, last]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max]
BinlogUsedDiskNode 已用 Binlog 日志磁盘空间 DB 节点已用 Binlog 日志磁盘空间 GB InstanceId,NodeId [5s, last]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max]
ClientConnTotal 客户端总连接数 实例级别监控指标,计算方式为累加实例 Proxy 上的所有连接。这个指标真实展示了你有多少个客户端连到数据库实例上。当前指标暂不支持秒级监控 Count InstanceId [5s, last]
[60s, avg]
[300s, avg]
[3600s, avg]
[86400s, avg]
ConnMax 汇总最大连接数 实例级别监控指标,取值为累加实例所有主备节点最大连接数 Count InstanceId [5s, last]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max]
ConnMaxNode 最大连接数 DB 节点最大连接数 Count InstanceId,NodeId [5s, last]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max]
ConnUsageRate 最大 DB 连接使用率 实例级别监控指标,取值为实例主备所有节点的 DB 连接使用率的最大值 % InstanceId [5s, last]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max]
ConnUsageRateNode DB 连接使用率 DB 节点连接使用率,计算方式为 ThreadsConnected/ConnMax % InstanceId,NodeId [5s, last]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max]
CpuUsageRate CPU 利用率 实例级别监控指标,取值为实例主节点 CPU 使用率 % InstanceId [5s, last]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max]
CpuUsageRateNode CPU 利用率 DB 节点 CPU 使用率 % InstanceId,NodeId [5s, last]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max]
DataDiskAvailable 可用数据磁盘空间 实例级别监控指标,取值为实例主节点可用数据磁盘空间 GB InstanceId [5s, last]
[60s, min]
[300s, min]
[3600s, min]
[86400s, min]
DataDiskAvailableNode 可用数据磁盘空间 DB 节点可用数据磁盘空间 GB InstanceId,NodeId [5s, last]
[60s, min]
[300s, min]
[3600s, min]
[86400s, min]
DataDiskUsedRate 数据磁盘空间利用率 实例级别监控指标,取值为实例主节点的 DataDiskUsedRateNode 指标值 % InstanceId [5s, last]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max]
DataDiskUsedRateNode 数据磁盘空间利用率 DB 节点数据磁盘空间利用率 % NodeId,InstanceId [5s, last]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max]
DeleteTotal DELETE 请求数 实例级别监控指标,取值为实例主节点的 Delete 请求数监控值 Count/s InstanceId [5s, last]
[60s, avg]
[300s, avg]
[3600s, avg]
[86400s, avg]
DeleteTotalNode DELETE 请求数 DB 节点 Delete 请求数 Count/s InstanceId,NodeId [5s, last]
[60s, avg]
[300s, avg]
[3600s, avg]
[86400s, avg]
ErrorSQLTotal SQL 错误数 实例级别监控指标,表示有多少条 SQL 执行错误。当前指标暂不支持秒级监控 Count InstanceId [5s, last]
[60s, sum]
[300s, sum]
[3600s, sum]
[86400s, sum]
InnodbBufferPoolReadAhead 汇总 innodb 缓冲池预读页次数 实例级别监控指标,计算方式为累加实例所有主备节点 innodb 缓冲池预读页次数 Count InstanceId [5s, last]
[60s, sum]
[300s, sum]
[3600s, sum]
[86400s, sum]
InnodbBufferPoolReadAheadNode innodb 缓冲池预读页次数 DB 节点 innodb 缓冲池预读页次数 Count InstanceId,NodeId [5s, last]
[60s, sum]
[300s, sum]
[3600s, sum]
[86400s, sum]
InnodbBufferPoolReadRequests 汇总 innodb 缓冲池读页次数 实例级别监控指标,计算方式为累加实例所有主备节点 innodb 缓冲池读页次数 Count InstanceId [5s, last]
[60s, sum]
[300s, sum]
[3600s, sum]
[86400s, sum]
InnodbBufferPoolReadRequestsNode innodb 缓冲池读页次数 DB 节点 innodb 缓冲池读页次数 Count InstanceId,NodeId [5s, last]
[60s, sum]
[300s, sum]
[3600s, sum]
[86400s, sum]
InnodbBufferPoolReads 汇总 innodb 磁盘读页次数 实例级别监控指标,计算方式为累加实例所有主备节点的 innodb 磁盘读页次数 Count InstanceId [5s, last]
[60s, sum]
[300s, sum]
[3600s, sum]
[86400s, sum]
InnodbBufferPoolReadsNode innodb 磁盘读页次数 DB 节点 innodb 磁盘读页次数 Count InstanceId,NodeId [5s, last]
[60s, sum]
[300s, sum]
[3600s, sum]
[86400s, sum]
Innodbbufferpoolusagerate innodb 缓存使用率 实例级别监控指标,取值为实例主节点 InnoDB 缓存使用率 % InstanceId [5s, last]
[60s, min]
[300s, min]
[3600s, min]
[86400s, min]
Innodbbufferpoolusageratenode innodb 缓存使用率 DB 节点 InnoDB 缓存使用率 % InstanceId,NodeId [5s, last]
[60s, min]
[300s, min]
[3600s, min]
[86400s, min]
InnodbRowsDeleted innodb 执行 DELETE 行数 实例级别监控指标,取值为实例主节点的 innodb 执行 DELETE 行数监控值 Count InstanceId [5s, last]
[60s, sum]
[300s, sum]
[3600s, sum]
[86400s, sum]
InnodbRowsDeletedNode innodb 执行 DELETE 行数 DB 节点 innodb 执行 DELETE 行数 Count InstanceId,NodeId [5s, last]
[60s, sum]
[300s, sum]
[3600s, sum]
[86400s, sum]
InnodbRowsInserted innodb 执行 INSERT 行数 实例级别监控指标,取值为实例主节点的 innodb 执行 INSERT 行数监控值 Count InstanceId [5s, last]
[60s, sum]
[300s, sum]
[3600s, sum]
[86400s, sum]
InnodbRowsInsertedNode innodb 执行 INSERT 行数 DB 节点 innodb 执行 INSERT 行数 Count InstanceId,NodeId [5s, last]
[60s, sum]
[300s, sum]
[3600s, sum]
[86400s, sum]
InnodbRowsRead 汇总 innodb 执行 READ 行数 实例级别监控指标,计算方式为累加实例所有主备节点 innodb 执行 READ 行数 Count InstanceId [5s, last]
[60s, sum]
[300s, sum]
[3600s, sum]
[86400s, sum]
InnodbRowsReadNode innodb 执行 READ 行数 DB 节点 innodb 执行 READ 行数 Count InstanceId,NodeId [5s, last]
[60s, sum]
[300s, sum]
[3600s, sum]
[86400s, sum]
InnodbRowsUpdated innodb 执行 UPDATE 行数 实例级别监控指标,取值为实例主节点 innodb 执行 UPDATE 行数监控值 Count InstanceId [5s, last]
[60s, sum]
[300s, sum]
[3600s, sum]
[86400s, sum]
InnodbRowsUpdatedNode innodb 执行 UPDATE 行数 DB 节点 innodb 执行 UPDATE 行数 Count InstanceId,NodeId [5s, last]
[60s, sum]
[300s, sum]
[3600s, sum]
[86400s, sum]
Keyblocksunused 键缓存内未使用的块数量 实例级别监控指标,取值为实例主节点键缓存内未使用的块数量 Count InstanceId [5s, last]
[60s, min]
[300s, min]
[3600s, min]
[86400s, min]
Keyblocksunusednode 键缓存内未使用的块数量 DB 节点键缓存内未使用的块数量 Count InstanceId,NodeId [5s, last]
[60s, min]
[300s, min]
[3600s, min]
[86400s, min]
Keyblocksused 键缓存内使用的块数量 实例级别监控指标,取值为实例主节点键缓存内使用的块数量 Count InstanceId [5s, last]
[60s, max]
[300s, min]
[3600s, min]
[86400s, min]
Keyblocksusednode 键缓存内使用的块数量 DB 节点键缓存内使用的块数量 Count InstanceId,NodeId [5s, last]
[60s, min]
[300s, min]
[3600s, min]
[86400s, min]
Keyreadrequests 键缓存读取数据块次数 实例级别监控指标,取值为实例主节点键缓存读取数据块次数 Count InstanceId [5s, last]
[60s, min]
[300s, min]
[3600s, min]
[86400s, min]
Keyreadrequestsnode 键缓存读取数据块次数 DB 节点键缓存读取数据块次数 Count InstanceId,NodeId [5s, last]
[60s, min]
[300s, min]
[3600s, min]
[86400s, min]
InsertTotal INSERT 请求数 实例级别监控指标,取值为实例主节点 INSERT 请求数 Count/s InstanceId [5s, last]
[60s, avg]
[300s, avg]
[3600s, avg]
[86400s, avg]
InsertTotalNode INSERT 请求数 DB 节点 INSERT 请求数 Count/s InstanceId,NodeId [5s, last]
[60s, avg]
[300s, avg]
[3600s, avg]
[86400s, avg]
IsMaster 是否为主 DB 表示这个 DB 节点是否为主 DB None InstanceId,NodeId [5s, last]
[60s, last]
[300s, last]
[3600s, last]
[86400s, last]
LongQueryCount 慢查询数 实例级别监控指标,取值为实例主节点慢查询数 Count InstanceId [5s, last]
[60s, sum]
[300s, sum]
[3600s, sum]
[86400s, sum]
LongQueryCountNode 慢查询数 DB 节点慢查询数 Count InstanceId,NodeId [5s, last]
[60s, sum]
[300s, sum]
[3600s, sum]
[86400s, sum]
MasterSwitchedTotal 主从切换次数 实例级别监控指标,表示实例主从切换发生的次数 Count InstanceId [5s, last]
[60s, sum]
[300s, sum]
[3600s, sum]
[86400s, sum]
MaxSlaveCpuUsageRate 最大备节点 CPU 利用率 实例级别监控指标,取值为所有备节点 CPU 利用率的最大值 % InstanceId [5s, last]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max]
Maxslavedelay 最大备延迟 实例级别监控指标,取值为实例所有备机的备延迟最大值 s InstanceId [5s, last]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max]
MemAvailable 内存可用 实例级别监控指标,取值为实例主节点的可用内存空间 GB InstanceId [5s, last]
[60s, min]
[300s, min]
[3600s, min]
[86400s, min]
MemAvailableNode 内存可用 DB 节点可用内存空间 GB InstanceId,NodeId [5s, last]
[60s, min]
[300s, min]
[3600s, min]
[86400s, min]
MemHitRate innodb 缓存命中率 实例级别监控指标,取值为实例主节点的缓存命中率 % InstanceId [5s, last]
[60s, min]
[300s, min]
[3600s, min]
[86400s, min]
MemHitRateNode innodb 缓存命中率 DB 节点缓存命中率 % InstanceId,NodeId [5s, last]
[60s, min]
[300s, min]
[3600s, min]
[86400s, min]
Memusage 内存利用率 实例级别监控指标,取值为实例主节点内存利用率 % InstanceId [5s, last]
[60s, min]
[300s, min]
[3600s, min]
[86400s, min]
Memusagenode 内存利用率 DB 节点内存利用率 % InstanceId,NodeId [5s, last]
[60s, min]
[300s, min]
[3600s, min]
[86400s, min]
Memused 内存占用 实例级别监控指标,取值为实例主节点内存占用量 GBytes InstanceId [5s, last]
[60s, min]
[300s, min]
[3600s, min]
[86400s, min]
Memusednode 内存占用 DB 节点内存占用量 GBytes InstanceId,NodeId [5s, last]
[60s, min]
[300s, min]
[3600s, min]
[86400s, min]
ReplaceSelectTotal REPLACE_SELECT 请求数 实例级别监控指标,取值为实例主节点的 REPLACE-SELECT 请求数 Count/s InstanceId [5s, last]
[60s, avg]
[300s, avg]
[3600s, avg]
[86400s, avg]
ReplaceSelectTotalNode REPLACE_SELECT 请求数 DB 节点 REPLACE-SELECT 请求数 Count/s InstanceId,NodeId [5s, last]
[60s, avg]
[300s, avg]
[3600s, avg]
[86400s, avg]
ReplaceTotal REPLACE 请求数 实例级别监控指标,取值为实例主节点的 REPLACE 请求数 Count/s InstanceId [5s, last]
[60s, avg]
[300s, avg]
[3600s, avg]
[86400s, avg]
ReplaceTotalNode REPLACE 请求数 DB 节点 REPLACE 请求数 Count/s NodeId,InstanceId [5s, last]
[60s, avg]
[300s, avg]
[3600s, avg]
[86400s, avg]
RequestTotal 汇总主备节点总请求数 实例级别监控指标,取值为实例主节点总请求数和所有备节点 Select 请求数的和 Count/s InstanceId [5s, last]
[60s, avg]
[300s, avg]
[3600s, avg]
[86400s, avg]
RequestTotalNode 总请求数 DB 节点总请求数 Count/s InstanceId,NodeId [5s, last]
[60s, avg]
[300s, avg]
[3600s, avg]
[86400s, avg]
SelectTotal 汇总 SELECT 请求数 实例级别监控指标,计算方式为累加实例所有主备节点 SELECT 请求数 Count/s InstanceId [5s, last]
[60s, avg]
[300s, avg]
[3600s, avg]
[86400s, avg]
SelectTotalNode SELECT 请求数 DB 节点 SELECT 请求数 Count/s InstanceId,NodeId [5s, last]
[60s, avg]
[300s, avg]
[3600s, avg]
[86400s, avg]
SlaveDelay 最小备延迟 实例级别监控指标,取值为实例所有备机的备延迟最小值 s InstanceId [5s, last]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max]
SlaveDelayNode 备延迟 DB 节点备延迟 s InstanceId,NodeId [5s, last]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max]
SQLTotal SQL 总数 实例级别监控指标,表示你有多少条 SQL 发往数据库实例。当前指标暂不支持秒级监控 Count/s InstanceId [5s, last]
[60s, avg]
[300s, avg]
[3600s, avg]
[86400s, avg]
SuccessSQLTotal SQL 成功数 实例级别监控指标,表示成功执行的 SQL 数量。当前指标暂不支持秒级监控 Count/s InstanceId [5s, last]
[60s, avg]
[300s, avg]
[3600s, avg]
[86400s, avg]
ThreadsConnected 汇总当前打开连接数 实例级别监控指标,计算方式为累加实例所有主备节点当前打开连接数 Count InstanceId [5s, last]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max]
ThreadsConnectedNode 当前打开连接数 DB 节点连接数,计算方式为 show processlist 得到的 session 个数 Count InstanceId,NodeId [5s, last]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max]
ThreadsRunningCount 汇总运行线程数 实例级别监控指标,取值为累加实例所有节点 Threads_running 数值。Threads_running 为执行 show status like 'Threads_running' 得到的结果 Count InstanceId [5s, last]
[60s, avg]
[300s, avg]
[3600s, avg]
[86400s, avg]
ThreadsRunningCountNode 运行线程数 DB 节点 Thread_running 数值 Count InstanceId,NodeId [5s, last]
[60s, avg]
[300s, avg]
[3600s, avg]
[86400s, avg]
TimeRange0 耗时小于5ms 请求数 实例级别监控指标,表示执行时间小于5ms 的请求数。当前指标暂不支持秒级监控 Count/s InstanceId [5s, last]
[60s, avg]
[300s, avg]
[3600s, avg]
[86400s, avg]
TimeRange1 耗时5到20ms 请求数 实例级别监控指标,表示执行时间5-20ms 的请求数。当前指标暂不支持秒级监控 Count/s InstanceId [5s, last]
[60s, avg]
[300s, avg]
[3600s, avg]
[86400s, avg]
TimeRange2 耗时20到30ms 请求数 实例级别监控指标,表示执行时间20~30ms 的请求数。当前指标暂不支持秒级监控 Count/s InstanceId [5s, last]
[60s, avg]
[300s, avg]
[3600s, avg]
[86400s, avg]
TimeRange3 耗时大于30ms 请求数 实例级别监控指标,表示执行时间大于30ms 的请求数。当前指标暂不支持秒级监控 Count/s InstanceId [5s, last]
[60s, avg]
[300s, avg]
[3600s, avg]
[86400s, avg]
UpdateTotal UPDATE 请求数 实例级别监控指标,取值为实例主节点 UPDATE 请求数 Count/s InstanceId [5s, last]
[60s, avg]
[300s, avg]
[3600s, avg]
[86400s, avg]
UpdateTotalNode UPDATE 请求数 DB 节点 UPDATE 请求数 Count/s InstanceId,NodeId [5s, last]
[60s, avg]
[300s, avg]
[3600s, avg]
[86400s, avg]

三、各维度对应参数总览

参数名称 维度名称 维度解释 格式
Instances.N.Dimensions.0.Name InstanceId 实例 ID 的维度名称 输入 String 类型维度名称: InstanceId
Instances.N.Dimensions.0.Value InstanceId 具体实例 ID 输入具体实例 ID,例如:tdsql-9kjauqq1
Instances.N.Dimensions.1.Name NodeId 节点 ID 的维度名称 输入 String 类型维度名称:NodeId
Instances.N.Dimensions.1.Value NodeId 具体节点 ID 输入具体节点 ID,例如:877adc0ada3e

四、入参说明

云数据库 MariaDB 监控指标入参说明如下:

&Namespace=QCE/MARIADB
&Instances.N.Dimensions.0.Name= InstanceId
&Instances.N.Dimensions.0.Value=具体实例 ID
&Instances.N.Dimensions.1.Name=NodeId
&Instances.N.Dimensions.1.Value=具体节点 ID

赞 (0)
上一篇 4天前
下一篇 4天前