命名空间
Namespace = QCE/TDMYSQL
监控指标
指标英文名 | 指标中文名 | 说明 | 单位 | 维度 | 统计规则
[period, statType] |
ActiveThreadCount | 汇总活跃线程数 | 实例级别监控指标，计算方式为累加所有分片主备节点活跃线程数 | 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] |
ActiveThreadCountShard | 汇总活跃线程数 | 实例分片级别监控指标，累加当前分片主备节点活跃线程数 | Count | InstanceId
ShardId | [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 | InstanceId
NodeId | [5s, last]
[60s, min]
[300s, min]
[3600s, min]
[86400s, min] |
BinlogDiskAvailableShard | 最小剩余 Binlog 日志磁盘空间 | 实例分片级别监控指标，取值为实例分片主备节点剩余 Binlog 日志磁盘空间最小值 | GB | InstanceId
ShardId | [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] |
BinlogUsedDiskShard | 已用 Binlog 日志磁盘空间 | 实例分片级别监控指标，取值为实例分片主节点已用 Binlog 日志磁盘空间 | GB | InstanceId
ShardId | [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] |
ConnMaxShard | 汇总最大连接数 | 实例分片级别监控指标，取值为累加当前分片所有主备节点最大连接数 | Count | InstanceId
ShardId | [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] |
ConnUsageRateShard | 最大 DB 连接使用率 | 实例分片级别监控指标，取值为当前分片所有主备节点 DB 连接使用率的最大值 | % | InstanceId
ShardId | [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] |
CpuUsageRateShard | CPU 利用率 | 实例分片级别监控指标，取值为当前分片主节点 CPU 利用率 | % | InstanceId
ShardId | [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] |
DataDiskAvailableShard | 可用数据磁盘空间 | 实例分片级别监控指标，取值为当前分片主节点可用数据磁盘空间 | GB | ShardId
InstanceId | [5s, last]
[60s, min]
[300s, min]
[3600s, min]
[86400s, min] |
DataDiskUsedRate | 最大主节点数据磁盘空间利用率 | 实例级别监控指标，取值为实例各个分片主节点数据磁盘空间利用率最大值 | % | InstanceId | [5s, last]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
DataDiskUsedRateNode | 数据磁盘空间利用率 | DB 节点数据磁盘空间利用率 | % | InstanceId
NodeId | [5s, last]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
DataDiskUsedRateShard | 数据磁盘空间利用率 | 实例分片级别监控指标，取值为当前分片主节点数据磁盘空间利用率 | % | ShardId
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] |
DeleteTotalShard | DELETE 请求数 | 实例分片级别监控指标，取值为当前分片主节点 DELETE 请求数 | Count/s | InstanceId
ShardId | [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, avg]
[300s, avg]
[3600s, avg]
[86400s, avg] |
InnodbBufferPoolReadAheadNode | innodb 缓冲池预读页次数 | DB 节点 innodb 缓冲池预读页次数 | Count | InstanceId
NodeId | [5s, last]
[60s, avg]
[300s, avg]
[3600s, avg]
[86400s, avg] |
InnodbBufferPoolReadAheadShard | 汇总 innodb 缓冲池预读页次数 | 实例分片级别监控指标，计算方式为累加当前分片所有主备节点 innodb 缓冲池预读页次数 | Count | ShardId
InstanceId | [5s, last]
[60s, avg]
[300s, avg]
[3600s, avg]
[86400s, avg] |
InnodbBufferPoolReadRequests | 汇总 innodb 缓冲池读页次数 | 实例级别监控指标，计算方式为累加实例所有分片主备节点 innodb 缓冲池读页次数 | Count | InstanceId | [5s, last]
[60s, avg]
[300s, avg]
[3600s, avg]
[86400s, avg] |
InnodbBufferPoolReadRequestsNode | innodb 缓冲池读页次数 | DB 节点 innodb 缓冲池读页次数 | Count | InstanceId
NodeId | [5s, last]
[60s, avg]
[300s, avg]
[3600s, avg]
[86400s, avg] |
InnodbBufferPoolReadRequestsShard | 汇总 innodb 缓冲池读页次数 | 实例分片级别监控指标，计算方式为累加当前分片所有主备节点 innodb 缓冲池读页次数 | Count | InstanceId
ShardId | [5s, last]
[60s, avg]
[300s, avg]
[3600s, avg]
[86400s, avg] |
InnodbBufferPoolReads | 汇总 innodb 磁盘读页次数 | 实例级别监控指标，计算方式为累加实例所有分片主备节点 innodb 磁盘读页次数 | Count | InstanceId | [5s, last]
[60s, avg]
[300s, avg]
[3600s, avg]
[86400s, avg] |
InnodbBufferPoolReadsNode | innodb 磁盘读页次数 | DB 节点 innodb 磁盘读页次数 | Count | InstanceId
NodeId | [5s, last]
[60s, avg]
[300s, avg]
[3600s, avg]
[86400s, avg] |
InnodbBufferPoolReadsShard | 汇总 innodb 磁盘读页次数 | 实例分片级别监控指标，计算方式为累加当前分片所有主备节点 innodb 磁盘读页次数 | Count | ShardId
InstanceId | [5s, last]
[60s, avg]
[300s, avg]
[3600s, avg]
[86400s, avg] |
InnodbRowsDeleted | 汇总主节点 innodb 执行 DELETE 行数 | 实例级别监控指标，计算方式为累加实例各个分片主节点 innodb 执行 DELETE 行数 | Count | InstanceId | [5s, last]
[60s, avg]
[300s, avg]
[3600s, avg]
[86400s, avg] |
InnodbRowsDeletedNode | innodb 执行 DELETE 行数 | DB 节点 innodb 执行 DELETE 行数 | Count | InstanceId
NodeId | [5s, last]
[60s, avg]
[300s, avg]
[3600s, avg]
[86400s, avg] |
InnodbRowsDeletedShard | innodb 执行 DELETE 行数 | 实例分片级别监控指标，取值为当前分片主节点 innodb 执行 DELETE 行数 | Count | InstanceId
ShardId | [5s, last]
[60s, avg]
[300s, avg]
[3600s, avg]
[86400s, avg] |
InnodbRowsInserted | 汇总主节点 innodb 执行 INSERT 行数 | 实例级别监控指标，计算方式为累加实例各个分片主节点 innodb 执行 INSERT 行数 | Count | InstanceId | [5s, last]
[60s, avg]
[300s, avg]
[3600s, avg]
[86400s, avg] |
InnodbRowsInsertedNode | innodb 执行 INSERT 行数 | DB 节点 innodb 执行 INSERT 行数 | Count | InstanceId
NodeId | [5s, last]
[60s, avg]
[300s, avg]
[3600s, avg]
[86400s, avg] |
InnodbRowsInsertedShard | innodb 执行 INSERT 行数 | 实例分片级别监控指标，取值为当前分片主节点 innodb 执行 INSERT 行数 | Count | InstanceId
ShardId | [5s, last]
[60s, avg]
[300s, avg]
[3600s, avg]
[86400s, avg] |
InnodbRowsRead | 汇总 innodb 执行 READ 行数 | 实例级别监控指标，计算方式为累加实例所有分片主备节点 innodb 执行 READ 行数 | Count | InstanceId | [5s, last]
[60s, avg]
[300s, avg]
[3600s, avg]
[86400s, avg] |
InnodbRowsReadNode | innodb 执行 READ 行数 | DB 节点 innodb 执行 READ 行数 | Count | InstanceId
NodeId | [5s, last]
[60s, avg]
[300s, avg]
[3600s, avg]
[86400s, avg] |
InnodbRowsReadShard | 汇总 innodb 执行 READ 行数 | 实例分片级别监控指标，计算方式为累加当前分片所有主备节点 innodb 执行 READ 行数 | Count | InstanceId
ShardId | [5s, last]
[60s, avg]
[300s, avg]
[3600s, avg]
[86400s, avg] |
InnodbRowsUpdated | 汇总主节点 innodb 执行 UPDATE 行数 | 实例级别监控指标，计算方式为累加实例各个分片主节点 innodb 执行 UPDATE 行数 | Count | InstanceId | [5s, last]
[60s, avg]
[300s, avg]
[3600s, avg]
[86400s, avg] |
InnodbRowsUpdatedNode | innodb 执行 UPDATE 行数 | DB 节点 innodb 执行 UPDATE 行数 | Count | InstanceId
NodeId | [5s, last]
[60s, avg]
[300s, avg]
[3600s, avg]
[86400s, avg] |
InnodbRowsUpdatedShard | innodb 执行 UPDATE 行数 | 实例分片级别监控指标，取值为当前分片主节点 innodb 执行 UPDATE 行数 | Count | ShardId
InstanceId | [5s, last]
[60s, avg]
[300s, avg]
[3600s, avg]
[86400s, avg] |
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] |
InsertTotalShard | INSERT 请求数 | 实例分片级别监控指标，取值为当前分片主节点 INSERT 请求数 | Count/s | InstanceId
ShardId | [5s, last]
[60s, avg]
[300s, avg]
[3600s, avg]
[86400s, avg] |
IOUsageRate | 最大主节点 IO 利用率 | 实例级别监控指标，取值为实例各个分片主节点 IO 利用率的最大值 | % | InstanceId | [5s, last]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
IOUsageRateNode | IO 利用率 | IO 利用率 | % | NodeId
InstanceId | [5s, last]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
IOUsageRateShard | IO 利用率 | 实例分片级别监控指标，取值为当前分片主节点 IO 利用率 | % | InstanceId
ShardId | [5s, last]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
IsMaster | 是否为主 DB | 表示这个 DB 节点是否为主 DB | None | InstanceId
NodeId | [5s, last]
[60s, max] |
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] |
LongQueryCountShard | 慢查询数 | 实例分片级别监控指标，取值为当前分片主节点慢查询数 | Count | InstanceId
ShardId | [5s, last]
[60s, sum]
[300s, sum]
[3600s, sum]
[86400s, sum] |
MasterSwitchedTotal | 主从切换次数 | 实例级别监控指标，表示实例主从切换发生的次数 | Count | InstanceId | [5s, last]
[60s, last]
[300s, sum]
[3600s, sum]
[86400s, sum] |
MasterSwitchedTotalShard | 主从切换次数 | 实例分片级别监控指标，表示当前这个分片主备切换发生的次数 | Count | InstanceId
ShardId | [5s, last]
[60s, last]
[300s, sum]
[3600s, sum]
[86400s, sum] |
MaxSlaveCpuUsageRate | 最大备节点 CPU 利用率 | 实例级别监控指标，取值为所有备节点 CPU 利用率的最大值 | % | 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] |
MemAvailableShard | 可用缓存空间 | 实例分片级别监控指标，取值为当前这个分片主节点可用缓存空间 | GB | InstanceId
ShardId | [5s, last]
[60s, min]
[300s, min]
[3600s, min]
[86400s, min] |
MemHitRate | 最小主节点缓存命中率 | 实例级别监控指标，取值为实例各个分片主节点的缓存命中率最小值 | % | InstanceId | [5s, last]
[60s, min]
[300s, min]
[3600s, min]
[86400s, min] |
MemHitRateNode | DB 节点缓存命中率 | DB 节点缓存命中率 | % | InstanceId
NodeId | [5s, last]
[60s, min]
[300s, min]
[3600s, min]
[86400s, min] |
MemHitRateShard | 缓存命中率 | 实例分片级别监控指标，取值为当前这个分片主节点缓存命中率 | % | InstanceId
ShardId | [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] |
ReplaceSelectTotalShard | REPLACE_SELECT 请求数 | 实例分片级别监控指标，取值为当前这个分片主节点 REPLACE_SELECT 请求数 | Count/s | ShardId
InstanceId | [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 | InstanceId
NodeId | [5s, last]
[60s, avg]
[300s, avg]
[3600s, avg]
[86400s, avg] |
ReplaceTotalShard | REPLACE 请求数 | 实例分片级别监控指标，取值为当前这个分片主节点 REPLACE 请求数 | Count/s | InstanceId
ShardId | [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] |
RequestTotalShard | 汇总主备节点总请求数 | 实例分片级别监控指标，计算方式为累加当前分片主节点总请求数和所有备节点 Select 请求数 | Count/s | InstanceId
ShardId | [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] |
SelectTotalShard | 汇总 SELECT 请求数 | 实例分片级别监控指标，计算方式为累加当前分片所有主备节点 SELECT 请求数 | Count/s | InstanceId
ShardId | [5s, last]
[60s, avg]
[300s, avg]
[3600s, avg]
[86400s, avg] |
SlaveDelay | 备延迟 | 实例级别监控指标，先计算各个分片的备延迟，然后取1个最大值作为这个实例的备延迟。分片的备延迟为这个分片的所有备节点延迟的最小值 | s | InstanceId | [60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
SlaveDelayNode | 备延迟 | DB 节点备延迟 | s | InstanceId
NodeId | [5s, last]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
SlaveDelayShard | 最小备延迟 | 实例分片级别监控指标，取值为当前分片所有备机的备延迟最小值 | s | ShardId
InstanceId | [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] |
ThreadsConnectedShard | 汇总当前打开连接数 | 实例分片级别监控指标，计算方式为累加当前分片所有主备节点的当前打开连接数 | Count | ShardId
InstanceId | [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 | 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] |
UpdateTotalShard | UPDAT E请求数 | 实例分片级别监控指标，取值为当前分片主节点 UPDATE 请求数 | Count/s | InstanceId
ShardId | [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-9kjauqq1 |
Instances.N.Dimensions.1.Name | NodeId | 节点 ID 的维度名称 | 输入 String 类型维度名称：NodeId |
Instances.N.Dimensions.1.Value | NodeId | 具体节点 ID | 输入具体节点 ID，例如：877adc0ada3e |
Instances.N.Dimensions.2.Name | ShardId | 分片 ID 的维度名称 | 输入 String 类型维度名称：ShardId |
Instances.N.Dimensions.2.Value | ShardId | 具体分片 ID | 输入分片 ID，例如：shard-i6f4sf12 |
入参说明
分布式数据库 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=具体节点 ID
&Instances.N.Dimensions.2.Name=ShardId
&Instances.N.Dimensions.2.Value=具体分片 ID