腾讯云可观测平台 关系型数据库 TDSQL

分布式数据库 TDSQL MySQL 版监控指标入参说明如下&Namespace=QCE/TDMYSQL
&Instances.N.Dimensions.0.Name=InstanceId
&Instances.N.Dimensions.0.Value=具体实例 ID
&Instances.N.Dimensions.1.Name=NodeId
&Instances.N.Dimensions.1.Value=具体节点 。

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

一、命名空间

Namespace = QCE/TDMYSQL

二、监控指标

指标英文名 指标中文名 说明 单位 维度 统计规则[period, statType]
ActiveThreadCount 汇总活跃线程数 实例级别监控指标, 计算方式为累加所有分片主备节点活跃线程数 Count InstanceId [ 5s, last ][ 60s, avg ][ 300s, avg ][ 3600s, avg ][ 86400s, avg ]
ActiveThreadCountNode 活跃线程数 DB 节点线程池活跃线程个数 Count NodeIdInstanceId [ 5s, last ][ 60s, avg ][ 300s, avg ][ 3600s, avg ][ 86400s, avg ]
ActiveThreadCountShard 汇总活跃线程数 实例分片级别监控指标, 累加当前分片主备节点活跃线程数 Count InstanceIdShardId [ 5s, last ][ 60s, avg ][ 300s, avg ][ 3600s, avg ][ 86400s, avg ]
BinlogDiskAvailable 汇总各分片最小剩余 Binlog 日志磁盘空间 实例级别监控指标, 计算方式为累加各个分片 BinlogDiskAvailableShard 指标监控值 GB InstanceId [ 5s, last ][ 60s, min ][ 300s, min ][ 3600s, min ][ 86400s, min ]
BinlogDiskAvailableNode 剩余 Binlog 日志磁盘空间 DB 节点剩余 Binlog 日志磁盘空间 GB NodeIdInstanceId [ 5s, last ][ 60s, min ][ 300s, min ][ 3600s, min ][ 86400s, min ]
BinlogDiskAvailableShard 最小剩余 Binlog 日志磁盘空间 实例分片级别监控指标, 取值为实例分片主备节点剩余 Binlog 日志磁盘空间最小值 GB InstanceIdShardId [ 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 InstanceIdNodeId [ 5s, last ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
BinlogUsedDiskShard 已用 Binlog 日志磁盘空间 实例分片级别监控指标, 取值为实例分片主节点已用 Binlog 日志磁盘空间 GB InstanceIdShardId [ 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 InstanceIdNodeId [ 5s, last ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
ConnMaxShard 汇总最大连接数 实例分片级别监控指标, 取值为累加当前分片所有主备节点最大连接数 Count InstanceIdShardId [ 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 % InstanceIdNodeId [ 5s, last ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
ConnUsageRateShard 最大 DB 连接使用率 实例分片级别监控指标,取值为当前分片所有主备节点 DB 连接使用率的最大值 % InstanceIdShardId [ 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 使用率 % InstanceIdNodeId [ 5s, last ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
CpuUsageRateShard CPU 利用率 实例分片级别监控指标,取值为当前分片主节点 CPU 利用率 % InstanceIdShardId [ 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 InstanceIdNodeId [ 5s, last ][ 60s, min ][ 300s, min ][ 3600s, min ][ 86400s, min ]
DataDiskAvailableShard 可用数据磁盘空间 实例分片级别监控指标,取值为当前分片主节点可用数据磁盘空间 GB InstanceIdShardId [ 5s, last ][ 60s, min ][ 300s, min ][ 3600s, min ][ 86400s, min ]
DataDiskUsedRate 最大主节点数据磁盘空间利用率 实例级别监控指标,取值为实例各个分片主节点数据磁盘空间利用率最大值 % InstanceId [ 5s, last ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
DataDiskUsedRateNode 数据磁盘空间利用率 DB 节点数据磁盘空间利用率 % InstanceIdNodeId [ 5s, last ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
DataDiskUsedRateShard 数据磁盘空间利用率 实例分片级别监控指标,取值为当前分片主节点数据磁盘空间利用率 % InstanceIdShardId [ 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 InstanceIdNodeId [ 5s, last ][ 60s, avg ][ 300s, avg ][ 3600s, avg ][ 86400s, avg ]
DeleteTotalShard DELETE 请求数 实例分片级别监控指标,取值为当前分片主节点 DELETE 请求数 Count/s InstanceIdShardId [ 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 InstanceIdNodeId [ 5s, last ][ 60s, sum ][ 300s, sum ][ 3600s, sum ][ 86400s, sum ]
InnodbBufferPoolReadAheadShard 汇总 innodb 缓冲池预读页次数 实例分片级别监控指标,计算方式为累加当前分片所有主备节点 innodb 缓冲池预读页次数 Count InstanceIdShardId [ 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 InstanceIdNodeId [ 5s, last ][ 60s, sum ][ 300s, sum ][ 3600s, sum ][ 86400s, sum ]
InnodbBufferPoolReadRequestsShard 汇总 innodb 缓冲池读页次数 实例分片级别监控指标,计算方式为累加当前分片所有主备节点 innodb 缓冲池读页次数 Count InstanceIdShardId [ 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 InstanceIdNodeId [ 5s, last ][ 60s, sum ][ 300s, sum ][ 3600s, sum ][ 86400s, sum ]
InnodbBufferPoolReadsShard 汇总 innodb 磁盘读页次数 实例分片级别监控指标,计算方式为累加当前分片所有主备节点 innodb 磁盘读页次数 Count InstanceIdShardId [ 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 缓存使用率 % InstanceIdNodeId [ 5s, last ][ 60s, min ][ 300s, min ][ 3600s, min ][ 86400s, min ]
Innodbbufferpoolusagerateshard innodb 缓存使用率 实例分片级别监控指标,取值为当前这个分片主节点 InnoDB 缓存使用率 % InstanceIdShardId [ 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 NodeIdInstanceId [ 5s, last ][ 60s, sum ][ 300s, sum ][ 3600s, sum ][ 86400s, sum ]
InnodbRowsDeletedShard innodb 执行 DELETE 行数 实例分片级别监控指标,取值为当前分片主节点 innodb 执行 DELETE 行数 Count InstanceIdShardId [ 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 InstanceIdNodeId [ 5s, last ][ 60s, sum ][ 300s, sum ][ 3600s, sum ][ 86400s, sum ]
InnodbRowsInsertedShard innodb 执行 INSERT 行数 实例分片级别监控指标,取值为当前分片主节点 innodb 执行 INSERT 行数 Count InstanceIdShardId [ 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 InstanceIdNodeId [ 5s, last ][ 60s, sum ][ 300s, sum ][ 3600s, sum ][ 86400s, sum ]
InnodbRowsReadShard 汇总 innodb 执行 READ 行数 实例分片级别监控指标,计算方式为累加当前分片所有主备节点 innodb 执行 READ 行数 Count ShardIdInstanceId [ 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 InstanceIdNodeId [ 5s, last ][ 60s, sum ][ 300s, sum ][ 3600s, sum ][ 86400s, sum ]
InnodbRowsUpdatedShard innodb 执行 UPDATE 行数 实例分片级别监控指标,取值为当前分片主节点 innodb 执行 UPDATE 行数 Count InstanceIdShardId [ 5s, last ][ 60s, sum ][ 300s, sum ][ 3600s, sum ][ 86400s, sum ]
InsertTotal 汇总主节点 INSERT 请求数 实例级别监控指标,计算方式为累加实例各个分片主节点的 INSERT 请求数 Count/s InstanceId [ 5s, last ][ 60s, avg ][ 300s, avg ][ 3600s, avg ][ 86400s, avg ]
InsertTotalNode INSERT 请求数 DB 节点 INSERT 请求数 Count/s InstanceIdNodeId [ 5s, last ][ 60s, avg ][ 300s, avg ][ 3600s, avg ][ 86400s, avg ]
InsertTotalShard INSERT 请求数 实例分片级别监控指标,取值为当前分片主节点 INSERT 请求数 Count/s InstanceIdShardId [ 5s, last ][ 60s, avg ][ 300s, avg ][ 3600s, avg ][ 86400s, avg ]
IsMaster 是否为主 DB 表示这个 DB 节点是否为主 DB None InstanceIdNodeId [ 5s, last ][ 60s, last ][ 300s, last ][ 3600s, last ][ 86400s, last ]
Keyblocksunused 键缓存内未使用的块数量 实例级别监控指标,取值为实例主节点键缓存内未使用的块数量 Count InstanceId [ 5s, last ][ 60s, min ][ 300s, min ][ 3600s, min ][ 86400s, min ]
Keyblocksunusednode 键缓存内未使用的块数量 DB 节点键缓存内未使用的块数量 Count InstanceIdNodeId [ 5s, last ][ 60s, min ][ 300s, min ][ 3600s, min ][ 86400s, min ]
Keyblocksunusedshard 键缓存内未使用的块数量 实例分片级别监控指标,取值为当前这个分片主节点键缓存内未使用的块数量 Count InstanceIdShardId [ 5s, last ][ 60s, min ][ 300s, min ][ 3600s, min ][ 86400s, min ]
Keyblocksused 键缓存内使用的块数量 实例级别监控指标,取值为实例主节点键缓存内使用的块数量 Count InstanceId [ 5s, last ][ 60s, min ][ 300s, min ][ 3600s, min ][ 86400s, min ]
Keyblocksusednode 键缓存内使用的块数量 DB 节点键缓存内使用的块数量 Count InstanceIdNodeId [ 5s, last ][ 60s, min ][ 300s, min ][ 3600s, min ][ 86400s, min ]
Keyblocksusedshard 键缓存内使用的块数量 实例分片级别监控指标,取值为当前这个分片主节点键缓存内使用的块数量 Count InstanceIdShardId [ 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 InstanceIdNodeId [ 5s, last ][ 60s, min ][ 300s, min ][ 3600s, min ][ 86400s, min ]
Keyreadrequestsshard 键缓存读取数据块次数 实例分片级别监控指标,取值为当前这个分片主节点键缓存读取数据块次数 Count InstanceIdShardId [ 5s, last ][ 60s, min ][ 300s, min ][ 3600s, min ][ 86400s, min ]
LongQueryCount 汇总主节点慢查询数 实例级别监控指标,计算方式为累加实例各个分片主节点的慢查询数 Count InstanceId [ 5s, last ][ 60s, sum ][ 300s, sum ][ 3600s, sum ][ 86400s, sum ]
LongQueryCountNode 慢查询数 DB 节点慢查询数 Count InstanceIdNodeId [ 5s, last ][ 60s, sum ][ 300s, sum ][ 3600s, sum ][ 86400s, sum ]
LongQueryCountShard 慢查询数 实例分片级别监控指标,取值为当前分片主节点慢查询数 Count InstanceIdShardId [ 5s, last ][ 60s, sum ][ 300s, sum ][ 3600s, sum ][ 86400s, sum ]
MasterSwitchedTotal 主从切换次数 实例级别监控指标,表示实例主从切换发生的次数 Count InstanceId [ 5s, last ][ 60s, sum ][ 300s, sum ][ 3600s, sum ][ 86400s, sum ]
MasterSwitchedTotalShard 主从切换次数 实例分片级别监控指标,表示当前这个分片主备切换发生的次数 Count InstanceIdShardId [ 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 最大备延迟 实例级别监控指标,先计算各个分片的最大备延迟,然后取 1 个最大值作为这个实例的最大备延迟。分片的最大备延迟为这个分片的所有备节点延迟的最大值 s InstanceId [ 5s, last ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
Maxslavedelayshard 最大备延迟 实例分片级别监控指标,取值为当前分片所有备机的备延迟最大值 s InstanceIdShardId [ 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 InstanceIdNodeId [ 5s, last ][ 60s, min ][ 300s, min ][ 3600s, min ][ 86400s, min ]
MemAvailableShard 内存可用 实例分片级别监控指标,取值为当前这个分片主节点可用内存空间 GB InstanceIdShardId [ 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 节点缓存命中率 % InstanceIdNodeId [ 5s, last ][ 60s, min ][ 300s, min ][ 3600s, min ][ 86400s, min ]
MemHitRateShard innodb 缓存命中率 实例分片级别监控指标,取值为当前这个分片主节点缓存命中率 % InstanceIdShardId [ 5s, last ][ 60s, min ][ 300s, min ][ 3600s, min ][ 86400s, min ]
Memusage 内存利用率 实例级别监控指标,取值为实例主节点内存利用率 % InstanceId [ 5s, last ][ 60s, min ][ 300s, min ][ 3600s, min ][ 86400s, min ]
Memusagenode 内存利用率 DB 节点内存利用率 % InstanceIdNodeId [ 5s, last ][ 60s, min ][ 300s, min ][ 3600s, min ][ 86400s, min ]
Memusageshard 内存利用率 实例分片级别监控指标,取值为当前这个分片主节点内存利用率 % InstanceIdShardId [ 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 InstanceIdNodeId [ 5s, last ][ 60s, min ][ 300s, min ][ 3600s, min ][ 86400s, min ]
Memusedshard 内存占用 实例分片级别监控指标,取值为当前这个分片主节点内存占用量 GBytes InstanceIdShardId [ 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 InstanceIdNodeId [ 5s, last ][ 60s, avg ][ 300s, avg ][ 3600s, avg ][ 86400s, avg ]
ReplaceSelectTotalShard REPLACE_SELECT 请求数 实例分片级别监控指标,取值为当前这个分片主节点 REPLACE_SELECT 请求数 Count/s InstanceIdShardId [ 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 节点总请求数 Count/s InstanceIdNodeId [ 5s, last ][ 60s, avg ][ 300s, avg ][ 3600s, avg ][ 86400s, avg ]
ReplaceTotalShard REPLACE 请求数 实例分片级别监控指标,取值为当前这个分片主节点 REPLACE 请求数 Count/s InstanceIdShardId [ 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 NodeIdInstanceId [ 5s, last ][ 60s, avg ][ 300s, avg ][ 3600s, avg ][ 86400s, avg ]
RequestTotalShard 汇总主备节点总请求数 实例分片级别监控指标,计算方式为累加当前分片主节点总请求数和所有备节点 Select 请求数 Count/s InstanceIdShardId [ 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 InstanceIdNodeId [ 5s, last ][ 60s, avg ][ 300s, avg ][ 3600s, avg ][ 86400s, avg ]
SelectTotalShard 汇总 SELECT 请求数 实例分片级别监控指标,计算方式为累加当前分片所有主备节点 SELECT 请求数 Count/s InstanceIdShardId [ 5s, last ][ 60s, avg ][ 300s, avg ][ 3600s, avg ][ 86400s, avg ]
SlaveDelay 最小备延迟 实例级别监控指标,先计算各个分片的备延迟,然后取 1 个最大值作为这个实例的备延迟。分片的备延迟为这个分片的所有备节点延迟的最小值 s InstanceId [ 5s, last ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
SlaveDelayNode 备延迟 DB 节点备延迟 s InstanceIdNodeId [ 5s, last ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
SlaveDelayShard 最小备延迟 实例分片级别监控指标,取值为当前分片所有备机的备延迟最小值 s InstanceIdShardId [ 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 InstanceIdNodeId [ 5s, last ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
ThreadsConnectedShard 汇总当前打开连接数 实例分片级别监控指标,计算方式为累加当前分片所有主备节点的当前打开连接数 Count ShardIdInstanceId [ 5s, last ][ 60s, avg ][ 300s, avg ][ 3600s, avg ][ 86400s, avg ]
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 InstanceIdNodeId [ 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 InstanceIdNodeId [ 5s, last ][ 60s, avg ][ 300s, avg ][ 3600s, avg ][ 86400s, avg ]
UpdateTotalShard UPDATE 请求数 实例分片级别监控指标,取值为当前分片主节点 UPDATE 请求数 Count/s InstanceIdShardId [ 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,例如:tdsqlshard-xxx*
Instances.N.Dimensions.1.Name NodeId 节点 ID 的维度名称 输入 String 类型维度名称:NodeId
Instances.N.Dimensions.1.Value NodeId 具体节点 ID 输入具体节点 ID,例如:877adc*
Instances.N.Dimensions.2.Name ShardId 分片 ID 的维度名称 输入 String 类型维度名称:ShardId
Instances.N.Dimensions.2.Value ShardId 具体分片 ID 输入分片 ID,例如:shard-xxx*

四、入参说明

&Instances.N.Dimensions.2.Name=ShardId
&Instances.N.Dimensions.2.Value=具体分片 ID

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