腾讯云可观测平台 NoSQL 数据库

这篇档详细介绍了腾讯云数据库(MySQL)的监控指标、命名空间、维度参数及入参说明。主要内容包括云盘版架构实例的监控指标命名规则、数据库代理相关指标的维度要求、各维度对应参数的说明,以及查询监控数据时的具体入参配置。监控指标:云盘版架构实例的指标英文名需在普通架构实例的指标英文名前加“Cluster”,调用时需传入InstanceId和NodeId以获取只读节点数据。数据库代理相关指标需指定InstanceType为。

相关产品
腾讯云可观测平台 产品页,含版本规格、价格与购买入口。

一、命名空间

Namespace = QCE/CDB

二、监控指标

注意:说明:

注意:{ "serviceType": "monitor","cmd": "GetMonitorData","regionId": 1,"data": { "Namespace": "QCE/CDB","MetricName": "ClusterCpuUseRate","Instances": [{"Dimensions": [{"Name": "InstanceId","Value": "cdb-2m***de7"},{"Name": "NodeId","Value": "dbn-12y***pg"}] } ],"Period": 5,"StartTime": "2026-01-20 10:47:55","EndTime": "2026-01-20 11:46:55","Version": "2018-07-24","Region": "ap-guangzhou" } }

指标英文名 指标中文名 说明 单位 维度 统计规则[period, statType]
AbortedClients 异常关闭的客户端连接数 由于客户端在没有正确关闭连接的情况下死亡而中止的连接数 Count InstanceTypeInstanceId [ 5s, sum ][ 60s, sum ][ 300s, sum ][ 3600s, sum ][ 86400s, sum ]
AbortedConnects 尝试连接的失败次数 尝试连接到 MySQL 服务器的失败次数 Count InstanceTypeInstanceId [ 5s, sum ][ 60s, sum ][ 300s, sum ][ 3600s, sum ][ 86400s, sum ]
BillingBackupVolume 收费空间 收费空间 byte productsubproduct [ 300s, max ]
BytesReceived 接受数据量 接受数据量 Bytes/s InstanceTypeInstanceId [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
BytesSent 发送数据量 发送数据量 Bytes/s InstanceTypeInstanceId [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
Capacity 磁盘占用空间 磁盘占用空间 MB InstanceIdInstanceType [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
ComCommit 提交数 提交数 times/s InstanceIdInstanceType [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
ComDelete 删除数 删除数 times/s InstanceIdInstanceType [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
ComInsert 插入数 插入数 times/s InstanceIdInstanceType [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
ComReplace 覆盖数 覆盖数 times/s InstanceIdInstanceType [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
ComRollback 回滚数 回滚数 times/s InstanceIdInstanceType [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
ComStmtClose close 命令执行次数 com_stmt_close 命令执行次数 Count InstanceIdInstanceType [ 5s, sum ][ 60s, sum ][ 300s, sum ][ 3600s, sum ][ 86400s, sum ]
Comstmtexecute execute 命令执行次数 com_stmt_execute 命令执行次数 Count InstanceTypeInstanceId [ 5s, sum ][ 60s, sum ][ 300s, sum ][ 3600s, sum ][ 86400s, sum ]
ComStmtPrepare prepare 命令执行次数 com_stmt_prepare 命令执行次数 Count InstanceIdInstanceType [ 5s, sum ][ 60s, sum ][ 300s, sum ][ 3600s, sum ][ 86400s, sum ]
ComUpdate 更新数 更新数 times/s InstanceIdInstanceType [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
ConnectionUseRate 连接数利用率 连接数利用率 % InstanceIdInstanceType [ 5s, max ][ 10s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
CpuUseRate CPU 利用率 CPU 利用率 % InstanceIdInstanceType [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
CreatedTmpDiskTables 磁盘临时表数量 磁盘临时表数量 times/s InstanceIdInstanceType [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
CreatedTmpFiles 临时文件数量 临时文件数量 times/s InstanceIdInstanceType [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
CreatedTmpTables 内存临时表数量 内存临时表数量 times/s InstanceIdInstanceType [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
CurrentBackupVolume 总备份 总备份 byte productsubproduct [ 300s, max ]
DangerCountOfGroup 审计组维度风险总数 审计组维度风险总数 Count GroupId [ 60s, sum ][ 300s, sum ][ 3600s, sum ][ 86400s, sum ]
DataVolume 数据备份 数据备份 byte productsubproduct [ 300s, max ]
DiskLogUsed 日志文件使用空间 日志文件使用空间 MBytes InstanceIdInstanceType [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
DiskRemaining 磁盘剩余量 磁盘剩余量 MBytes InstanceIdInstanceType [ 5s, max ][ 10s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
DiskTmpUsed 临时文件使用空间 临时文件使用空间 MiBytes InstanceTypeInstanceId [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
FreeBackupVolume 免费空间 免费空间 byte productsubproduct [ 300s, max ]
HandlerCommit 内部提交数 内部提交数 times/s InstanceIdInstanceType [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
HandlerReadRndNext 读下一行请求数 读下一行请求数 times/s InstanceIdInstanceType [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
HandlerRollback 内部回滚数 内部回滚数 times/s InstanceTypeInstanceId [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
HighDangerLvlOfGroup 审计组维度高风险数 审计组维度高风险数 Count GroupId [ 60s, sum ][ 300s, sum ][ 3600s, sum ][ 86400s, sum ]
InnodbBufferPoolPagesFree InnoDB 空页数 InnoDB 空页数 count InstanceIdInstanceType [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
InnodbBufferPoolPagesTotal InnoDB 总页数 InnoDB 总页数 Count InstanceIdInstanceType [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
InnodbBufferPoolReadRequests innodb 缓冲池预读页次数 innodb 缓冲池预读页次数 times/s InstanceIdInstanceType [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
InnodbBufferPoolReads innodb 磁盘读页次数 innodb 磁盘读页次数 times/s InstanceIdInstanceType [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
InnodbCacheHitRate innodb 缓存命中率 innodb 缓存命中率 % InstanceIdInstanceType [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
InnodbCacheUseRate innodb 缓存使用率 innodb 缓存使用率 % InstanceIdInstanceType [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
InnodbDataRead InnoDB 读取量 InnoDB 读取量 Bytes InstanceIdInstanceType [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
InnodbDataReads InnoDB 总读取量 InnoDB 总读取量 times/s InstanceIdInstanceType [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
InnodbDataWrites InnoDB 总写入量 InnoDB 总写入量 times/s InstanceIdInstanceType [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
InnodbDataWritten InnoDB 写入量 InnoDB 写入量 times/s InstanceIdInstanceType [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
InnodbLogWaits log 写入等待次数 log 写入等待次数 Count InstanceIdInstanceType [ 5s, max ][ 10s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
InnodbLogWrites 重做日志文件刷盘次数 InnoDB 重做日志文件写入硬盘的次数 Count InstanceIdInstanceType [ 5s, sum ][ 60s, sum ][ 300s, sum ][ 3600s, sum ][ 86400s, sum ]
InnodbNumOpenFiles 当前 InnoDB 打开表的数量 当前 InnoDB 打开表的数量 count InstanceIdInstanceType [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
InnodbOsFileReads innodb 读磁盘数量 innodb 读磁盘数量 times/s InstanceIdInstanceType [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
InnodbOsFileWrites innodb 写磁盘数量 innodb 写磁盘数量 times/s InstanceIdInstanceType [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
InnodbOsFsyncs innodbfsync 数量 innodbfsync 数量 times/s InstanceIdInstanceType [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
InnodbOsLogWritten 写入重做日志文件的数据量大小 写入 InnoDB 重做日志文件的字节数 Bytes InstanceTypeInstanceId [ 5s, sum ][ 60s, sum ][ 300s, sum ][ 3600s, sum ][ 86400s, sum ]
InnodbRowLockCurrentWaits 当前行锁数量 当前 InnoDB 表上的行锁数 Count InstanceTypeInstanceId [ 5s, last ][ 60s, last ][ 300s, last ][ 3600s, last ][ 86400s, last ]
InnodbRowLockTime 获取行锁所花费的总时间 获取 InnoDB 表行锁所花费的总时间 ms InstanceIdInstanceType [ 5s, sum ][ 60s, sum ][ 300s, sum ][ 3600s, sum ][ 86400s, sum ]
InnodbRowLockTimeAvg InnoDB 平均获取行锁时间 InnoDB 平均获取行锁时间(毫秒) ms InstanceIdInstanceType [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
InnodbRowLockTimeMax 获取行锁的最长时间 获取 InnoDB 表行锁的最长时间 ms InstanceTypeInstanceId [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
InnodbRowLockWaits InnoDB 等待行锁次数 InnoDB 等待行锁次数 Count/s InstanceTypeInstanceId [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
InnodbRowsDeleted InnoDB 行删除量 InnoDB 行删除量 times/s InstanceIdInstanceType [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
InnodbRowsInserted InnoDB 行插入量 InnoDB 行插入量 times/s InstanceIdInstanceType [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
InnodbRowsRead InnoDB 行读取量 InnoDB 行读取量 times/s InstanceIdInstanceType [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
InnodbRowsUpdated InnoDB 行更新量 InnoDB 行更新量 times/s InstanceTypeInstanceId [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
Iops 每秒的输入输出量 每秒的输入输出量 count/s InstanceTypeInstanceId [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
IopsRead IOPS 读次数 IOPS 读次数 Count/s InstanceIdInstanceType [ 5s, max ][ 10s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
IopsUseRate IOPS 利用率 IOPS 利用率 % InstanceIdInstanceType [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
IopsWrite IOPS 写次数 IOPS 写次数 Count/s InstanceIdInstanceType [ 5s, max ][ 10s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
KeyBlocksUnused 键缓存内未使用的块数量 键缓存内未使用的块数量 Count InstanceTypeInstanceId [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
KeyBlocksUsed 键缓存内使用的块数量 键缓存内使用的块数量 Count InstanceIdInstanceType [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
KeyCacheHitRate myisam 缓存命中率 myisam 缓存命中率 % InstanceIdInstanceType [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
KeyCacheUseRate myisam 缓存使用率 myisam 缓存使用率 % InstanceTypeInstanceId [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
KeyReadRequests 键缓存读取数据块次数 键缓存读取数据块次数 times/s InstanceIdInstanceType [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
KeyReads 硬盘读取数据块次数 硬盘读取数据块次数 times/s InstanceIdInstanceType [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
KeyWriteRequests 数据块写入键缓冲次数 数据块写入键缓冲次数 times/s InstanceIdInstanceType [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
KeyWrites 数据块写入磁盘次数 数据块写入磁盘次数 times/s InstanceIdInstanceType [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
Libradbactiveconnections 分析引擎活跃连接数 分析引擎活跃连接数 Count InstanceId [ 5s, max ][ 10s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
Libradbbytesreceived 分析引擎网络入流量 分析引擎网络入流量 MBytes/s InstanceIdNodeId [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
Libradbbytessent 分析引擎网络出流量 分析引擎网络出流量 MBytes/s NodeIdInstanceId [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
Libradbcached 分析引擎缓存使用量 分析引擎缓存使用量 MBytes InstanceIdNodeId [ 5s, last ][ 60s, last ][ 300s, last ][ 3600s, last ][ 86400s, last ]
Libradbcachehitsrate 分析引擎缓存命中率 分析引擎缓存命中率 % NodeIdInstanceId [ 5s, avg ][ 60s, avg ][ 300s, avg ][ 3600s, avg ][ 86400s, avg ]
Libradbcompactrowsets 分析引擎 CompactRowset 数量 分析引擎 CompactRowset 数量 Count InstanceIdNodeId [ 5s, last ][ 60s, last ][ 300s, last ][ 3600s, last ][ 86400s, last ]
Libradbconnections 分析引擎总连接数 分析引擎总连接数 Count InstanceId [ 5s, max ][ 10s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
Libradbcpuuserate 分析引擎 CPU 使用率 分析引擎 CPU 使用率 % NodeIdInstanceId [ 5s, last ][ 10s, last ][ 60s, last ][ 300s, last ][ 3600s, last ][ 86400s, last ]
Libradbdatafilesize 分析引擎数据文件大小 分析引擎数据文件大小 MBytes NodeIdInstanceId [ 5s, last ][ 10s, last ][ 60s, last ][ 300s, last ][ 3600s, last ][ 86400s, last ]
Libradbdumprowspersec 分析引擎全量加载时每秒写行数 分析引擎全量加载时每秒写行数 Count/s InstanceId [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
Libradbdumpsizepersec 分析引擎全量加载时每秒写数据大小 分析引擎全量加载时每秒写数据大小 MBytes/s InstanceId [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
Libradbduration 分析引擎平均响应时间 分析引擎平均响应时间 ms InstanceId [ 5s, avg ][ 60s, avg ][ 300s, avg ][ 3600s, avg ][ 86400s, avg ]
Libradberrorqueries 分析引擎错误请求数 分析引擎错误请求数 Count InstanceId [ 5s, sum ][ 10s, sum ][ 60s, sum ][ 300s, sum ][ 3600s, sum ][ 86400s, sum ]
Libradblatency 分析引擎数据延迟时间 分析引擎数据延迟时间 s InstanceId [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
Libradbmemuserate 分析引擎内存使用率 分析引擎内存使用率 % NodeIdInstanceId [ 5s, last ][ 60s, last ][ 300s, last ][ 3600s, last ][ 86400s, last ]
Libradbmpptasks 分析引擎接收到的 MppTask 数 分析引擎接收到的 MppTask 数 Count InstanceIdNodeId [ 5s, sum ][ 60s, sum ][ 300s, sum ][ 3600s, sum ][ 86400s, sum ]
Libradbnodedumprowspersec 分析引擎节点全量加载时每秒写行数 分析引擎节点全量加载时每秒写行数 Count/s NodeIdInstanceId [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
Libradbnodedumpsizepersec 分析引擎节点全量加载时每秒写数据大小 分析引擎节点全量加载时每秒写数据大小 MBytes/s NodeIdInstanceId [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
Libradbnodelatency 分析引擎节点延迟时间 分析引擎节点延迟时间 s NodeIdInstanceId [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
Libradbnodesinkrowspersec 分析引擎节点每秒同步处理行数 分析引擎节点每秒同步处理行数 Count/s NodeIdInstanceId [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
Libradbqps 分析引擎 QPS 分析引擎 QPS Count/s InstanceId [ 5s, max ][ 10s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
Libradbreadthroughput 分析引擎读吞吐 分析引擎读吞吐 MBytes/s NodeIdInstanceId [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
Libradbresultsize 分析引擎返回结果集大小 分析引擎返回结果集大小 MBytes InstanceId [ 5s, sum ][ 60s, sum ][ 300s, sum ][ 3600s, sum ][ 86400s, sum ]
Libradbrunningmpptasks 分析引擎正在运行的 MppTask 数 分析引擎正在运行的 MppTask 数 Count NodeIdInstanceId [ 5s, last ][ 60s, last ][ 300s, last ][ 3600s, last ][ 86400s, last ]
Libradbsinkrowspersec 分析引擎每秒同步处理行数 分析引擎每秒同步处理行数 Count/s InstanceId [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
Libradbstorageused 分析引擎存储使用量 分析引擎存储使用量 MBytes NodeIdInstanceId [ 5s, last ][ 60s, last ][ 300s, last ][ 3600s, last ][ 86400s, last ]
Libradbstorageuserate 分析引擎存储使用率 分析引擎存储使用率 % NodeIdInstanceId [ 5s, last ][ 60s, last ][ 300s, last ][ 3600s, last ][ 86400s, last ]
Libradbwritethroughput 分析引擎写吞吐 分析引擎写吞吐 MBytes/s NodeIdInstanceId [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
LogCapacity 日志使用空间 日志使用空间 MB InstanceIdInstanceType [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
LogVolume 日志备份 日志备份 byte subproductproduct [ 300s, max ]
LowDangerLvlOfGroup 审计组维度低风险数 审计组维度低风险数 Count GroupId [ 60s, sum ][ 300s, sum ][ 3600s, sum ][ 86400s, sum ]
MasterSlaveSyncDistance 主备不同步距离 主备不同步距离 MB InstanceIdInstanceType [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, avg ][ 86400s, avg ]
MaxConnections 最大连接数 最大连接数 Count InstanceIdInstanceType [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
MemoryUse 内存占用 内存占用 MBytes InstanceIdInstanceType [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
MemoryUseRate 内存利用率 内存利用率 % InstanceIdInstanceType [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
MidDangerLvlOfGroup 审计组维度中风险数 审计组维度中风险数 Count GroupId [ 60s, sum ][ 300s, sum ][ 3600s, sum ][ 86400s, sum ]
OpenedTables 已经打开的表数 已经打开的表数 Count InstanceTypeInstanceId [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
OpenFiles 打开文件数 打开文件数 times/s InstanceIdInstanceType [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
OperationCountOfGroup 审计组操作总次数 审计组操作总次数 Count GroupId [ 60s, sum ][ 300s, sum ][ 3600s, sum ][ 86400s, sum ]
ProxyCpuUseRate CPU 利用率 CPU 利用率 % InstanceTypeInstanceId [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
ProxyCurrentConnections 当前连接数 当前连接数 None InstanceTypeInstanceId [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
ProxyMemoryUse 内存占用 内存占用 MBytes InstanceTypeInstanceId [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
ProxyMemoryUseRate 内存利用率 内存利用率 % InstanceTypeInstanceId [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
ProxyQueries 请求数 请求数 None InstanceIdInstanceType [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
ProxyRouteMaster 写请求数 写请求数 None InstanceTypeInstanceId [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
ProxyRouteSlave 读请求数 读请求数 None InstanceTypeInstanceId [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
QcacheFreeBlocks 查询缓存空闲块 查询缓存空闲块 Count InstanceIdInstanceType [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
QcacheFreeMemory 缓存中空闲内存量 缓存中空闲内存量 MB InstanceIdInstanceType [ 5s, avg ][ 60s, avg ][ 300s, avg ][ 3600s, max ][ 86400s, max ]
QcacheHitRate 查询缓存命中率 查询缓存命中率 % InstanceIdInstanceType [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
QcacheHits 缓存命中次数 缓存命中次数 % InstanceIdInstanceType [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
QcacheInserts 缓存写入次数 缓存写入次数 times/s InstanceIdInstanceType [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
QcacheLowmemPrunes 因内存不足删除缓存次数 因内存不足删除缓存次数 Count InstanceIdInstanceType [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
QcacheNotCached 查询未被缓存次数 查询未被缓存次数 MB InstanceIdInstanceType [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
QcacheQueriesInCache 已注册到缓存内的查询数 已注册到缓存内的查询数 times/s InstanceIdInstanceType [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
QcacheTotalBlocks 查询缓存内的总块数 查询缓存内的总块数 Count InstanceIdInstanceType [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
QcacheUseRate 查询缓存使用率 查询缓存使用率 % InstanceIdInstanceType [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
Qps 每秒查询率 每秒查询率 times/s InstanceIdInstanceType [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
Queries 总 Query量 总 Query 量 times/s InstanceIdInstanceType [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
QueryRate 查询使用率 查询使用率 % InstanceIdInstanceType [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
QueryTotal 查询总量 当前粒度单位时间内查询量的总和 Count InstanceIdInstanceType [ 5s, last ][ 60s, last ][ 300s, last ][ 3600s, last ][ 86400s, last ]
ReadLatency 磁盘读取延迟时间 磁盘读取延迟时间 ms InstanceTypeInstanceId [ 5s, max ][ 10s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
RealCapacity 磁盘使用空间 磁盘使用空间 MB InstanceIdInstanceType [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
RocksdbBlockCacheBytesRead rocksdb 读数据块数 rocksdb 读数据块数 Bytes InstanceIdInstanceType [ 5s, max ][ 10s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
RocksdbBlockCacheBytesWrite rocksdb 写数据块数 rocksdb 写数据块数 Bytes InstanceIdInstanceType [ 5s, max ][ 10s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
RocksdbBytesRead rocksdb 读磁盘量 rocksdb 读磁盘量 Bytes InstanceIdInstanceType [ 5s, max ][ 10s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
RocksdbBytesWritten rocksdb 写磁盘量 rocksdb 写磁盘量 Bytes InstanceIdInstanceType [ 5s, max ][ 10s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
RocksdbWalLogCapacity rocksdb 写 WAL 日志大小 rocksdb 写 WAL 日志大小 MBytes InstanceIdInstanceType [ 5s, max ][ 10s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
RplSemiSyncMasterEnabled 半同步复制开启状态 半同步复制开启状态 Count InstanceTypeInstanceId [ 5s, max ][ 10s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
SecondsBehindMaster 主备差距时间 主备差距时间 s InstanceIdInstanceType [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
SelectCount 查询数 查询数 times/s InstanceIdInstanceType [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
SelectFullJoin Join 查询中全表扫描次数 由于不使用索引而执行全表扫描的查询次数 Count InstanceIdInstanceType [ 5s, sum ][ 60s, sum ][ 300s, sum ][ 3600s, sum ][ 86400s, sum ]
SelectFullRangeJoin Join 查询中范围搜索次数 Join 查询中对引用表使用范围搜索的查询次数 Count InstanceTypeInstanceId [ 5s, sum ][ 60s, sum ][ 300s, sum ][ 3600s, sum ][ 86400s, sum ]
SelectScan 全表扫描数 全表扫描数 count/s InstanceIdInstanceType [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
SessionCountOfGroup 审计组会话总量 审计组会话总量 Count GroupId [ 60s, sum ][ 300s, sum ][ 3600s, sum ][ 86400s, sum ]
SlaveIoRunning 主实例 IO 线程状态 主实例 IO 线程状态 None InstanceTypeInstanceId [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
SlaveSqlRunning 主实例 SQL 线程状态 主实例 SQL 线程状态 None InstanceIdInstanceType [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
SlowQueries 慢查询数 慢查询数 count InstanceIdInstanceType [ 5s, sum ][ 60s, sum ][ 300s, sum ][ 3600s, sum ][ 86400s, sum ]
SwitchTimes 主从切换次数 主从切换次数(次) Count InstanceIdInstanceType [ 5s, sum ][ 10s, sum ][ 60s, sum ][ 300s, sum ][ 3600s, sum ][ 86400s, sum ]
TableLocksImmediate 立即释放的表锁数 立即释放的表锁数 Count/s InstanceIdInstanceType [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
TableLocksWaited 需要等待的表锁数 需要等待的表锁数 times/s InstanceIdInstanceType [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
TableOpenCacheHits 表缓存命中次数 表缓存查找的命中数 Count InstanceIdInstanceType [ 5s, sum ][ 60s, sum ][ 300s, sum ][ 3600s, sum ][ 86400s, sum ]
TableOpenCacheMisses 表缓存未命中次数 表缓存查找的未命中数 Count InstanceIdInstanceType [ 5s, sum ][ 60s, sum ][ 300s, sum ][ 3600s, sum ][ 86400s, sum ]
TableOpenCacheOverflows 表缓存溢出次数 表缓存的溢出次数 Count InstanceIdInstanceType [ 5s, sum ][ 60s, sum ][ 300s, sum ][ 3600s, sum ][ 86400s, sum ]
ThreadsConnected 当前连接数 当前连接数 Count InstanceIdInstanceType [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
ThreadsCreated 已创建的线程数 已创建的线程数 Count/s InstanceIdInstanceType [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
ThreadsRunning 运行的线程数 运行的线程数 Count InstanceIdInstanceType [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
Tps 每秒执行事务数 每秒执行事务数 times/s InstanceTypeInstanceId [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
Uptime 已启动秒数 从上一次服务启动开始,服务存活的秒数 s InstanceIdInstanceType [ 5s, last ][ 60s, last ][ 300s, last ][ 3600s, last ][ 86400s, last ]
VolumeRate 磁盘利用率 磁盘利用率 % InstanceIdInstanceType [ 5s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]
WriteLatency 磁盘写入延迟时间 磁盘写入延迟时间 ms InstanceIdInstanceType [ 5s, max ][ 10s, max ][ 60s, max ][ 300s, max ][ 3600s, max ][ 86400s, max ]

注意:说明:

三、各维度对应参数总览

参数名称 维度名称 维度解释 格式
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.3.Name product 云数据库的产品类型的维度名称 输入 String 类型维度名称,例如:product
Instances.N.Dimensions.3.Value product 云数据库的产品类型 输入 String 类型的云数据库产品类型名称,例如:mysql
Instances.N.Dimensions.4.Name subproduct 云数据库 MySQL 的子产品码的维度名称 输入 String 类型维度名称,例如:subproduct
Instances.N.Dimensions.4.Value subproduct 云数据库 MySQL 的子产品码 输入子产品码,例如:sp_cdb_ro(只读实例)sp_cdb_sync(三节点实例)sp_cdb_replica(灾备实例)backup_mysql(备份)
Instances.N.Dimensions.5.Name NodeId 云数据库 MySQL 分析引擎的节点的维度名称 输入固定值,值为:NodeId
Instances.N.Dimensions.5.Value NodeId 云数据库 MySQL 分析引擎的节点 ID 值 输入节点 ID,例如:libradbn-0

注意:说明:

注意:InstanceType 说明:

四、入参说明

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

&Instances.N.Dimensions.2.Name=groupid

&Instances.N.Dimensions.2.Value=具体的审计组 ID

&Instances.N.Dimensions.3.Name=product

&Instances.N.Dimensions.3.Value=云数据库的产品类型

&Instances.N.Dimensions.4.Name=subproduct

&Instances.N.Dimensions.4.Value=云数据库 MySQL 的子产品码

&Instances.N.Dimensions.5.Name=NodeId

&Instances.N.Dimensions.5.Value=云数据库 MySQL 分析引擎的节点 ID 值

赞 (0)
上一篇 4天前
下一篇 4天前