云数据库 MySQL 监控指标

最近更新时间:2024-04-03 10:41:41

我的收藏

命名空间

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=数据库实例类型