命名空间
Namespace=QCE/DCDB
监控指标
指标英文名 | 指标中文名 | 指标说明 | 单位 | 维度 | 统计规则 [period, statType] |
BinlogUsedDisk | 已用 Binlog 日志磁盘空间 | 已用日志磁盘空间 | GB | shardId, uuid | [60s, min]
[300s, min]
[3600s, min]
[86400s, min] |
ConnActive | 客户端连接总数 | 总连接数 | count | shardId, uuid | [60s, max]
[300s, avg]
[3600s, avg]
[86400s, avg] |
ConnRunning | 数据库服务器活跃连接数 | 活跃连接数 | count | shardId, uuid | [60s, max]
[300s, max]
[3600s, avg]
[86400s, avg] |
CpuUsageRate | CPU 利用率 | CPU 利用率 | % | shardId, uuid | [60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
DataDiskAvailable | 可用数据磁盘空间 | 可用磁盘空间 | GB | shardId, uuid | [60s, min]
[300s, min]
[3600s, min]
[86400s, min] |
DataDiskAvailableRate | 数据磁盘空间可用率 | 磁盘空间可用率 | % | shardId, uuid | [60s, avg]
[300s, avg]
[3600s, max]
[86400s, max] |
DataDiskUsedRate | 数据磁盘空间利用率 | 磁盘空间利用率 | % | shardId, uuid | [60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
DeleteTotal | DELETE 请求数 | 删除数 | count/s | shardId, uuid | [60s, max]
[300s, avg]
[3600s, avg]
[86400s, avg] |
DiskIops | IO 利用率 | IO 利用率 | % | shardId, uuid | [60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
InnodbBufferPoolReadAhead | Innodb 缓冲池预读页次数 | Innodb 缓冲池预读页次数 | count/s | shardId, uuid | [60s, max]
[300s, avg]
[3600s, avg]
[86400s, avg] |
InnodbBufferPoolReadRequests | Innodb 缓冲池读页次数 | Innodb 缓冲池读页次数 | count/s | shardId, uuid | [60s, max]
[300s, avg]
[3600s, avg]
[86400s, avg] |
InnodbBufferPoolReads | Innodb 磁盘读页次数 | Innodb 磁盘读页次数 | count/s | shardId, uuid | [60s, max]
[300s, avg]
[3600s, avg]
[86400s, avg] |
InnodbRowsDeleted | Innodb 执行 DELETE 行数 | Innodb 执行 DELETE 行数 | count/s | shardId, uuid | [60s, max]
[300s, avg]
[3600s, avg]
[86400s, avg] |
InnodbRowsInserted | Innodb 执行 INSERT 行数 | Innodb 执行 INSERT 行数 | count/s | shardId, uuid | [60s, max]
[300s, avg]
[3600s, avg]
[86400s, avg] |
InnodbRowsRead | Innodb 执行 READ 行数 | Innodb 执行 READ 行数 | count/s | shardId, uuid | [60s, max]
[300s, avg]
[3600s, avg]
[86400s, avg] |
InnodbRowsUpdated | Innodb 执行 UPDATE 行数 | Innodb 执行 UPDATE 行数 | count/s | shardId, uuid | [60s, max]
[300s, avg]
[3600s, avg]
[86400s, avg] |
InsertTotal | INSERT 请求数 | 插入数 | count/s | shardId, uuid | [60s, max]
[300s, avg]
[3600s, avg]
[86400s, avg] |
LongQuery | 慢查询数 | 慢查询数 | qps | shardId, uuid | [60s, max]
[300s, avg]
[3600s, avg]
[86400s, avg] |
MasterSwitchedTotal | 主从切换次数 | 主从切换次数 | qps | shardId, uuid | [60s, max]
[300s, sum]
[3600s, sum]
[86400s, sum] |
MemAvailable | 可用缓存空间 | 可用缓存空间 | GB | shardId, uuid | [60s, min]
[300s, min]
[3600s, min]
[86400s, min] |
MemHitRate | 缓存命中率 | 缓存命中率 | % | shardId, uuid | [60s, avg]
[300s, avg]
[3600s, max]
[86400s, max] |
ReplaceTotal | REPLACE 请求数 | 覆盖数 | count/s | shardId, uuid | [60s, avg]
[300s, avg]
[3600s, avg]
[86400s, avg] |
RequestTotal | 总请求数 | 总请求数(QPS) | count/s | shardId, uuid | [60s, avg]
[300s, avg]
[3600s, avg]
[86400s, avg] |
SelectTotal | SELECT 请求数 | 查询数 | count/s | shardId, uuid | [60s, max]
[300s, avg]
[3600s, avg]
[86400s, avg] |
SlaveDelay | 备延迟 | 主从延迟 | ms | shardId, uuid | [60s, avg]
[300s, avg]
[3600s, avg]
[86400s, avg] |
TimeRange0 | 耗时(<5ms)请求数 | 耗时(1-5ms)请求数 | count/s | shardId, uuid | [60s, sum]
[300s, sum]
[3600s, sum]
[86400s, sum] |
TimeRange1 | 耗时(5-20ms)请求数 | 耗时(5-20ms)请求数 | count/s | shardId, uuid | [60s, sum]
[300s, sum]
[3600s, sum]
[86400s, sum] |
TimeRange2 | 耗时(20-30ms)请求数 | 耗时(20-30ms)请求数 | count/s | shardId, uuid | [60s, sum]
[300s, sum]
[3600s, sum]
[86400s, sum] |
TimeRange3 | 耗时(大于30ms)请求数 | 耗时(大于30ms)请求数 | count/s | shardId, uuid | [60s, sum]
[300s, sum]
[3600s, sum]
[86400s, sum] |
TotalErrorSql | SQL 错误数 | SQL 错误数 | count/s | shardId, uuid | [60s, sum]
[300s, sum]
[3600s, sum]
[86400s, sum] |
TotalOrigSql | SQL 总数 | SQL 总数 | count/s | shardId, uuid | [60s, sum]
[300s, sum]
[3600s, sum]
[86400s, sum] |
TotalSuccessSql | SQL 成功数 | SQL 成功数 | count/s | shardId, uuid | [60s, sum]
[300s, sum]
[3600s, sum]
[86400s, sum] |
UpdateTotal | UPDATE 请求数 | 更新数 | count/s | shardId, uuid | [60s, max]
[300s, avg]
[3600s, avg]
[86400s, avg] |