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