命名空间
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