命名空间
Namespace = QCE/CDB
监控指标
指标英文名 | 指标中文名 | 说明 | 单位 | 维度 | 统计规则
[period, statType] |
AbortedClients | 异常关闭的客户端连接数 | 由于客户端在没有正确关闭连接的情况下死亡而中止的连接数 | Count | InstanceId
InstanceType | [5s, sum]
[60s, sum]
[300s, sum]
[3600s, sum]
[86400s, sum] |
AbortedConnects | 尝试连接的失败次数 | 尝试连接到 MySQL 服务器的失败次数 | Count | InstanceId
InstanceType | [5s, sum]
[60s, sum]
[300s, sum]
[3600s, sum]
[86400s, sum] |
BillingBackupVolume | 收费空间 | 收费空间 | byte | product
subproduct | [300s, max] |
BytesReceived | 接受数据量 | 接受数据量 | Bytes/s | InstanceId
InstanceType | [5s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
BytesSent | 发送数据量 | 发送数据量 | Bytes/s | InstanceId
InstanceType | [5s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
Capacity | 磁盘占用空间 | 磁盘占用空间 | MB | InstanceType
InstanceId | [5s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
ComCommit | 提交数 | 提交数 | times/s | InstanceId
InstanceType | [5s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
ComDelete | 删除数 | 删除数 | times/s | InstanceId
InstanceType | [5s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
ComInsert | 插入数 | 插入数 | times/s | InstanceId
InstanceType | [5s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
ComReplace | 覆盖数 | 覆盖数 | times/s | InstanceId
InstanceType | [5s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
ComRollback | 回滚数 | 回滚数 | times/s | InstanceId
InstanceType | [5s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
ComStmtClose | close 命令执行次数 | com_stmt_close 命令执行次数 | Count | InstanceType
InstanceId | [5s, sum]
[60s, sum]
[300s, sum]
[3600s, sum]
[86400s, sum] |
Comstmtexecute | execute 命令执行次数 | com_stmt_execute 命令执行次数 | Count | InstanceId
InstanceType | [5s, sum]
[60s, sum]
[300s, sum]
[3600s, sum]
[86400s, sum] |
ComStmtPrepare | prepare 命令执行次数 | com_stmt_prepare 命令执行次数 | Count | InstanceType
InstanceId | [5s, sum]
[60s, sum]
[300s, sum]
[3600s, sum]
[86400s, sum] |
ComUpdate | 更新数 | 更新数 | times/s | InstanceType
InstanceId | [5s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
ConnectionUseRate | 连接数利用率 | 连接数利用率 | % | InstanceType
InstanceId | [5s, max]
[10s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
CpuUseRate | CPU 利用率 | CPU 利用率 | % | InstanceId
InstanceType | [5s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
CreatedTmpDiskTables | 磁盘临时表数量 | 磁盘临时表数量 | times/s | InstanceId
InstanceType | [5s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
CreatedTmpFiles | 临时文件数量 | 临时文件数量 | times/s | InstanceId
InstanceType | [5s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
CreatedTmpTables | 内存临时表数量 | 内存临时表数量 | times/s | InstanceId
InstanceType | [5s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
CurrentBackupVolume | 总备份 | 总备份 | byte | product
subproduct | [300s, max] |
DangerCountOfGroup | 审计组维度风险总数 | 审计组维度风险总数 | Count | GroupId | [60s, sum]
[300s, sum]
[3600s, sum]
[86400s, sum] |
DangerCountOfInstance | 实例维度风险总数 | 实例维度风险总数 | Count | GroupId
InstanceId
Region | [60s, sum]
[300s, sum]
[3600s, sum]
[86400s, sum] |
DangerCountOfUser | 用户维度风险总数 | 用户维度风险总数 | Count | appid | [60s, sum]
[300s, sum]
[3600s, sum]
[86400s, sum] |
DataVolume | 数据备份 | 数据备份 | byte | product
subproduct | [300s, max] |
DiskLogUsed | 日志文件使用空间 | 日志文件使用空间 | MBytes | InstanceId
InstanceType | [5s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
DiskTmpUsed | 临时文件使用空间 | 临时文件使用空间 | MiBytes | InstanceId
InstanceType | [5s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
FreeBackupVolume | 免费空间 | 免费空间 | byte | product
subproduct | [300s, max] |
HandlerCommit | 内部提交数 | 内部提交数 | times/s | InstanceId
InstanceType | [5s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
HandlerReadRndNext | 读下一行请求数 | 读下一行请求数 | times/s | InstanceId
InstanceType | [5s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
HandlerRollback | 内部回滚数 | 内部回滚数 | times/s | InstanceId
InstanceType | [5s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
HighDangerLvlOfGroup | 审计组维度高风险数 | 审计组维度高风险数 | Count | GroupId | [60s, sum]
[300s, sum]
[3600s, sum]
[86400s, sum] |
HighDangerLvlOfInstance | 实例维度高风险数 | 实例维度高风险数 | Count | InstanceId
Region
GroupId | [60s, sum]
[300s, sum]
[3600s, sum]
[86400s, sum] |
HighDangerLvlOfUser | 用户维度高风险数 | 用户维度高风险数 | Count | appid | [60s, sum]
[300s, sum]
[3600s, sum]
[86400s, sum] |
InnodbBufferPoolPagesFree | InnoDB 空页数 | InnoDB 空页数 | count | InstanceId
InstanceType | [5s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
InnodbBufferPoolPagesTotal | InnoDB 总页数 | InnoDB 总页数 | Count | InstanceId
InstanceType | [5s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
InnodbBufferPoolReadRequests | InnoDB 缓冲池预读页次数 | InnoDB 缓冲池预读页次数 | times/s | InstanceId
InstanceType | [5s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
InnodbBufferPoolReads | InnoDB 磁盘读页次数 | InnoDB 磁盘读页次数 | times/s | InstanceId
InstanceType | [5s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
InnodbCacheHitRate | InnoDB 缓存命中率 | InnoDB 缓存命中率 | % | InstanceId
InstanceType | [5s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
InnodbCacheUseRate | InnoDB 缓存使用率 | InnoDB 缓存使用率 | % | InstanceId
InstanceType | [5s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
InnodbDataRead | InnoDB 读取量 | InnoDB 读取量 | Bytes | InstanceType
InstanceId | [5s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
InnodbDataReads | InnoDB 总读取量 | InnoDB 总读取量 | times/s | InstanceId
InstanceType | [5s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
InnodbDataWrites | InnoDB 总写入量 | InnoDB 总写入量 | times/s | InstanceType
InstanceId | [5s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
InnodbDataWritten | InnoDB 写入量 | InnoDB 写入量 | times/s | InstanceId
InstanceType | [5s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
InnodbLogWrites | 重做日志文件刷盘次数 | InnoDB 重做日志文件写入硬盘的次数 | Count | InstanceId
InstanceType | [5s, sum]
[60s, sum]
[300s, sum]
[3600s, sum]
[86400s, sum] |
InnodbNumOpenFiles | 当前 InnoDB 打开表的数量 | 当前 InnoDB 打开表的数量 | count | InstanceType
InstanceId | [5s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
InnodbOsFileReads | InnoDB 读磁盘数量 | InnoDB 读磁盘数量 | times/s | InstanceId
InstanceType | [5s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
InnodbOsFileWrites | InnoDB 写磁盘数量 | InnoDB 写磁盘数量 | times/s | InstanceId
InstanceType | [5s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
InnodbOsFsyncs | innodbfsync 数量 | innodbfsync 数量 | times/s | InstanceId
InstanceType | [5s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
InnodbOsLogWritten | 写入重做日志文件的数据量大小 | 写入 InnoDB 重做日志文件的字节数 | Bytes | InstanceId
InstanceType | [5s, sum]
[60s, sum]
[300s, sum]
[3600s, sum]
[86400s, sum] |
InnodbRowLockCurrentWaits | 当前行锁数量 | 当前 InnoDB 表上的行锁数 | Count | InstanceId
InstanceType | [5s, last]
[60s, last]
[300s, last]
[3600s, last]
[86400s, last] |
InnodbRowLockTime | 获取行锁所花费的总时间 | 获取 InnoDB 表行锁所花费的总时间 | ms | InstanceId
InstanceType | [5s, sum]
[60s, sum]
[300s, sum]
[3600s, sum]
[86400s, sum] |
InnodbRowLockTimeAvg | InnoDB 平均获取行锁时间 | InnoDB 平均获取行锁时间（毫秒） | ms | InstanceId
InstanceType | [5s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
InnodbRowLockTimeMax | 获取行锁的最长时间 | 获取 InnoDB 表 行锁的最长时间 | ms | InstanceId
InstanceType | [5s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
InnodbRowLockWaits | InnoDB 等待行锁次数 | InnoDB 等待行锁次数 | Count/s | InstanceId
InstanceType | [5s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
InnodbRowsDeleted | InnoDB 行删除量 | InnoDB 行删除量 | times/s | InstanceId
InstanceType | [5s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
InnodbRowsInserted | InnoDB 行插入量 | InnoDB 行插入量 | times/s | InstanceId
InstanceType | [5s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
InnodbRowsRead | InnoDB 行读取量 | InnoDB 行读取量 | times/s | InstanceId
InstanceType | [5s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
InnodbRowsUpdated | InnoDB 行更新量 | InnoDB 行更新量 | times/s | InstanceType
InstanceId | [5s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
Iops | 每秒的输入输出量 | 每秒的输入输出量 | count/s | InstanceId
InstanceType | [5s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
IopsUseRate | IOPS 利用率 | IOPS 利用率 | % | InstanceId
InstanceType | [5s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
KeyBlocksUnused | 键缓存内未使用的块数量 | 键缓存内未使用的块数量 | Count | InstanceId
InstanceType | [5s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
KeyBlocksUsed | 键缓存内使用的块数量 | 键缓存内使用的块数量 | Count | InstanceId
InstanceType | [5s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
KeyCacheHitRate | myisam 缓存命中率 | myisam 缓存命中率 | % | InstanceType
InstanceId | [5s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
KeyCacheUseRate | myisam 缓存使用率 | myisam 缓存使用率 | % | InstanceId
InstanceType | [5s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
KeyReadRequests | 键缓存读取数据块次数 | 键缓存读取数据块次数 | times/s | InstanceType
InstanceId | [5s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
KeyReads | 硬盘读取数据块次数 | 硬盘读取数据块次数 | times/s | InstanceType
InstanceId | [5s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
KeyWriteRequests | 数据块写入键缓冲次数 | 数据块写入键缓冲次数 | times/s | InstanceId
InstanceType | [5s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
KeyWrites | 数据块写入磁盘次数 | 数据块写入磁盘次数 | times/s | InstanceId
InstanceType | [5s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
LogCapacity | 日志使用空间 | 日志使用空间 | MB | InstanceId
InstanceType | [5s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
LogVolume | 日志备份 | 日志备份 | byte | product
subproduct | [300s, max] |
LowDangerLvlOfGroup | 审计组维度低风险数 | 审计组维度低风险数 | Count | GroupId | [60s, sum]
[300s, sum]
[3600s, sum]
[86400s, sum] |
LowDangerLvlOfInstance | 实例维度低风险数 | 实例维度低风险数 | Count | GroupId
InstanceId
Region | [60s, sum]
[300s, sum]
[3600s, sum]
[86400s, sum] |
LowDangerLvlOfUser | 用户维度低风险数 | 用户维度低风险数 | Count | appid | [60s, sum]
[300s, sum]
[3600s, sum]
[86400s, sum] |
MasterSlaveSyncDistance | 主备不同步距离 | 主备不同步距离 | MB | InstanceType
InstanceId | [5s, max]
[60s, max]
[300s, max]
[3600s, avg]
[86400s, avg] |
MaxConnections | 最大连接数 | 最大连接数 | Count | InstanceId
InstanceType | [5s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
MemoryUse | 内存占用 | 内存占用 | MBytes | InstanceType
InstanceId | [5s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
MemoryUseRate | 内存利用率 | 内存利用率 | % | InstanceType
InstanceId | [5s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
MidDangerLvlOfGroup | 审计组维度中风险数 | 审计组维度中风险数 | Count | GroupId | [60s, sum]
[300s, sum]
[3600s, sum]
[86400s, sum] |
MidDangerLvlOfInstance | 实例维度中风险数 | 实例维度中风险数 | Count | GroupId
InstanceId
Region | [60s, sum]
[300s, sum]
[3600s, sum]
[86400s, sum] |
MidDangerLvlOfUser | 用户维度中风险数 | 用户维度中风险数 | Count | appid | [60s, sum]
[300s, sum]
[3600s, sum]
[86400s, sum] |
OpenedTables | 已经打开的表数 | 已经打开的表数 | Count | InstanceType
InstanceId | [5s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
OpenFiles | 打开文件数 | 打开文件数 | times/s | InstanceId
InstanceType | [5s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
OperationCountOfGroup | 审计组操作总次数 | 审计组操作总次数 | Count | GroupId | [60s, sum]
[300s, sum]
[3600s, sum]
[86400s, sum] |
OperationCountOfInstance | 实例操作总次数 | 实例操作总次数 | Count | GroupId
InstanceId
Region | [60s, sum]
[300s, sum]
[3600s, sum]
[86400s, sum] |
OperationCountOfUser | 用户操作总次数 | 用户操作总次数 | Count | appid | [60s, sum]
[300s, sum]
[3600s, sum]
[86400s, sum] |
ProxyCpuUseRate | CPU 利用率 | CPU 利用率 | % | InstanceId
InstanceType | [5s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
ProxyCurrentConnections | 当前连接数 | 当前连接数 | None | InstanceType
InstanceId | [5s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
ProxyMemoryUse | 内存占用 | 内存占用 | MBytes | InstanceType
InstanceId | [5s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
ProxyMemoryUseRate | 内存利用率 | 内存利用率 | % | InstanceType
InstanceId | [5s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
ProxyQueries | 请求数 | 请求数 | None | InstanceType
InstanceId | [5s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
ProxyRouteMaster | 写请求数 | 写请求数 | None | InstanceId
InstanceType | [5s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
ProxyRouteSlave | 读请求数 | 读请求数 | None | InstanceType
InstanceId | [5s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
QcacheFreeBlocks | 查询缓存空闲块 | 查询缓存空闲块 | Count | InstanceId
InstanceType | [5s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
QcacheFreeMemory | 缓存中空闲内存量 | 缓存中空闲内存量 | MB | InstanceId
InstanceType | [5s, avg]
[60s, avg]
[300s, avg]
[3600s, max]
[86400s, max] |
QcacheHitRate | 查询缓存命中率 | 查询缓存命中率 | % | InstanceId
InstanceType | [5s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
QcacheHits | 缓存命中次数 | 缓存命中次数 | % | InstanceId
InstanceType | [5s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
QcacheInserts | 缓存写入次数 | 缓存写入次数 | times/s | InstanceId
InstanceType | [5s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
QcacheLowmemPrunes | 因内存不足删除缓存次数 | 因内存不足删除缓存次数 | Count | InstanceType
InstanceId | [5s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
QcacheNotCached | 查询未被缓存次数 | 查询未被缓存次数 | MB | InstanceId
InstanceType | [5s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
QcacheQueriesInCache | 以注册到缓存内的查询数 | 以注册到缓存内的查询数 | times/s | InstanceId
InstanceType | [5s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
QcacheTotalBlocks | 查询缓存内的总块数 | 查询缓存内的总块数 | Count | InstanceId
InstanceType | [5s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
QcacheUseRate | 查询缓存使用率 | 查询缓存使用率 | % | InstanceId
InstanceType | [5s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
Qps | 每秒查询率 | 每秒查询率 | times/s | InstanceType
InstanceId | [5s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
Queries | 总 Query 量 | 总 Query 量 | times/s | InstanceId
InstanceType | [5s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
QueryRate | 查询使用率 | 查询使用率 | % | InstanceId
InstanceType | [5s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
QueryTotal | 查询总量 | 当前粒度单位时间内查询量的总和 | Count | InstanceId
InstanceType | [5s, last]
[60s, last]
[300s, last]
[3600s, last]
[86400s, last] |
RealCapacity | 磁盘使用空间 | 磁盘使用空间 | MB | InstanceId
InstanceType | [5s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
RocksdbBlockCacheBytesRead | rocksdb 读数据块数 | rocksdb 读数据块数 | Bytes | InstanceId
InstanceType | [5s, max]
[10s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
RocksdbBlockCacheBytesWrite | rocksdb 写数据块数 | rocksdb 写数据块数 | Bytes | InstanceId
InstanceType | [5s, max]
[10s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
RocksdbBytesRead | rocksdb 读磁盘量 | rocksdb 读磁盘量 | KBytes | InstanceType
InstanceId | [5s, max]
[10s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
RocksdbBytesWritten | rocksdb 写磁盘量 | rocksdb 写磁盘量 | Bytes | InstanceId
InstanceType | [5s, max]
[10s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
RocksdbWalLogCapacity | rocksdb 写 WAL 日志大小 | rocksdb 写 WAL 日志大小 | MBytes | InstanceId
InstanceType | [5s, max]
[10s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
RplSemiSyncMasterEnabled | 半同步复制开启状态 | 半同步复制开启状态 | Count | InstanceId
InstanceType | [5s, max]
[10s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
SecondsBehindMaster | 主备差距时间 | 主备差距时间 | s | InstanceId
InstanceType | [5s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
SelectCount | 查询数 | 查询数 | times/s | InstanceId
InstanceType | [5s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
SelectFullJoin | Join查询中全表扫描次数 | 由于不使用索引而执行全表扫描的查询次数数 | Count | InstanceId
InstanceType | [5s, sum]
[60s, sum]
[300s, sum]
[3600s, sum]
[86400s, sum] |
SelectFullRangeJoin | Join查询中范围搜索次数 | Join查询中对引用表使用范围搜索的查询次数数 | Count | InstanceId
InstanceType | [5s, sum]
[60s, sum]
[300s, sum]
[3600s, sum]
[86400s, sum] |
SelectScan | 全表扫描数 | 全表扫描数 | count/s | InstanceId
InstanceType | [5s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
SessionCountOfGroup | 审计组会话总量 | 审计组会话总量 | Count | GroupId | [60s, sum]
[300s, sum]
[3600s, sum]
[86400s, sum] |
SessionCountOfInstance | 实例会话总量 | 实例会话总量 | Count | GroupId
InstanceId
Region | [60s, sum]
[300s, sum]
[3600s, sum]
[86400s, sum] |
SessionCountOfUser | 用户会话总量 | 用户会话总量 | Count | appid | [60s, sum]
[300s, sum]
[3600s, sum]
[86400s, sum] |
SlaveIoRunning | 主实例 IO 线程状态 | 主实例 IO 线程状态 | None | InstanceId
InstanceType | [5s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
SlaveSqlRunning | 主实例 SQL 线程状态 | 主实例 SQL 线程状态 | None | InstanceId
InstanceType | [5s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
SlowQueries | 慢查询数 | 慢查询数 | count | InstanceId
InstanceType | [5s, sum]
[60s, sum]
[300s, sum]
[3600s, sum]
[86400s, sum] |
TableLocksImmediate | 立即释放的表锁数 | 立即释放的表锁数 | Count/s | InstanceId
InstanceType | [5s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
TableLocksWaited | 需要等待的表锁数 | 需要等待的表锁数 | times/s | InstanceId
InstanceType | [5s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
TableOpenCacheHits | 表缓存命中次数 | 表缓存查找的命中数 | Count | InstanceType
InstanceId | [5s, sum]
[60s, sum]
[300s, sum]
[3600s, sum]
[86400s, sum] |
TableOpenCacheMisses | 表缓存未命中次数 | 表缓存查找的未命中数 | Count | InstanceId
InstanceType | [5s, sum]
[60s, sum]
[300s, sum]
[3600s, sum]
[86400s, sum] |
TableOpenCacheOverflows | 表缓存溢出次数 | 表缓存的溢出次数 | Count | InstanceId
InstanceType | [5s, sum]
[60s, sum]
[300s, sum]
[3600s, sum]
[86400s, sum] |
ThreadsConnected | 当前连接数数 | 当前连接数数 | Count | InstanceType
InstanceId | [5s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
ThreadsCreated | 已创建的线程数 | 已创建的线程数 | Count/s | InstanceId
InstanceType | [5s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
ThreadsRunning | 运行的线程数 | 运行的线程数 | Count | InstanceType
InstanceId | [5s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
Tps | 每秒执行事务数 | 每秒执行事务数 | times/s | InstanceType
InstanceId | [5s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
Uptime | 已启动秒数 | 从上一次服务启动开始，服务存活的秒数 | s | InstanceId
InstanceType | [5s, last]
[60s, last]
[300s, last]
[3600s, last]
[86400s, last] |
VolumeRate | 磁盘利用率 | 磁盘利用率 | % | InstanceId
InstanceType | [5s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
说明：
1. 数据库代理相关指标（Proxy）维度入参 InstanceType 为必填，取值为 proxy；其余类型指标维度入参 InstanceType 为选填。
2. 维度入参 InstanceId 需填写具体的数据库代理节点 ID。
各维度对应参数总览
参数名称 | 维度名称 | 维度解释 | 格式 |
Instances.N.Dimensions.0.Name | InstanceId | 数据库的实例 ID 名称 | 输入 String 类型维度名称，例如：InstanceId |
Instances.N.Dimensions.0.Value | InstanceId | 数据库的具体 ID 数据库代理相关指标（Proxy）取值为proxyid 其余指标取值为实例id | 输入具体实例 ID，例如：cdb-ebul6659；或输入数据库代理节点ID，例如：proxynode-fo023kda |
Instances.N.Dimensions.1.Name | InstanceType（选填） | 数据库实例类型 | 输入 String 类型维度名称，例如：InstanceType |
Instances.N.Dimensions.1.Value | InstanceType（选填） | 数据库实例类型，默认取值为1，详细取值如下： 1：表示拉取实例主机的监控数据 2：表示拉取实例从机的监控数据（仅支持单节点和双节点） 3：表示拉取只读实例的监控数据（InstanceId 需入参为只读实例 ID，否则仍默认取值为1） 4：表示拉取实例第二从机（仅金融版实例有第二从机）的监控数据 proxy：表示拉取数据库代理节点监控数据 | 输入实例类型，可不入参，默认取值为1 |
Instances.N.Dimensions.2.Name | groupid | 审计组 ID 的维度名称 | 输入 String 类型维度名称，例如：groupid |
Instances.N.Dimensions.2.Value | groupid | 具体的审计组 ID | 输入审计组 ID，例如：sag-01z37k3f |
Instances.N.Dimensions.4.Name | product | 云数据库的产品类型的维度名称 | 输入 String 类型维度名称，例如：product |
Instances.N.Dimensions.4.Value | product | 云数据库的产品类型 | 输入 String 类型的云数据库产品类型名称，例如：mysql |
Instances.N.Dimensions.5.Name | subproduct | 云数据库 MySQL 的子产品码的维度名称 | 输入 String 类型维度名称，例如：subproduct |
Instances.N.Dimensions.5.Value | subproduct | 云数据库 MySQL 的子产品码 | 输入子产品码，例如： sp_cdb_ro（只读实例）； sp_cdb_sync（三节点实例）； sp_cdb_replica（灾备实例）； backup_mysql（备份）； |
说明：
InstanceType 说明：
假设 InstanceId 入参值为主实例的 ID，仅 InstanceType 支持拉取主机（取值为1）、从机（取值为2）、只读实例（取值为3）、第二从机（取值为4）的监控数据。
假设 InstanceId 入参值为主实例的 ID，InstanceType 入参为 2 （从机），且该主实例是三节点（一主两从）。由于拉取从机监控数据仅支持单节点和双节点，会导致缺少一个监控节点数据。
若需要拉取只读实例监控数据，InstanceId 需入参为只读实例 ID。
入参说明
查询云数据库（MySQL）产品监控数据，入参说明如下：
&Namespace=QCE/CDB
&Instances.N.Dimensions.0.Name=InstanceId
&Instances.N.Dimensions.0.Value=数据库的具体 ID
&Instances.N.Dimensions.1.Name=InstanceType
&Instances.N.Dimensions.1.Value=数据库实例类型