云服务器特惠 99/年起
  1. 腾讯云优惠网首页
  2. 腾讯云产品

腾讯云可观测平台 TDSQL-C MySQL 版监控指标

• 腾讯云产品

这篇档介绍了腾讯云数据库（CynosDB for MySQL）的监控指标查询方法，包括命名空间、监控指标维度及入参说明。重点说明了查询监控数据时所需的命名空间和实例维度参数。命名空间: 文档指定了查询CynosDB for MySQL监控数据时使用的命名空间为QCE/CYNOSDB_MYSQL。监控指标查询参数: 查询时需要提供实例ID（InstanceId）和代理节点名称（ProxyNodeId）作为维度参数，分别。

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

一、命名空间

Namespace = QCE/CYNOSDB_MYSQL

二、Buffer

指标名 指标中文名 说明 单位 维度 统计规则
Innodbbufferpoolpagesfree InnoDB 空页数 InnoDB 空页数 Count InstanceId [ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Innodbbufferpoolpagestotal InnoDB 总页数 InnoDB 总页数 Count InstanceId [ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
InnodbBufferPoolReadRequests InnoDB 缓冲池写入次数 InnoDB 缓冲池写入次数 Count InstanceId [ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
Innodbbufferpoolreads InnoDB 物理读 InnoDB 物理读 Count InstanceId [ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
Innodbbufferpoolwriterequest InnoDB 缓冲池写入次数 InnoDB 缓冲池写入次数 Count InstanceId [ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
InnodbBufferPoolWriteRequests InnoDB 引擎每秒已完成的逻辑写请求次数 InnoDB 引擎每秒已完成的逻辑写请求次数 Count InstanceId [ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]

三、Handler

指标名 指标中文名 说明 单位 维度 统计规则
HandlerCommit 内部提交数 内部提交数 Count InstanceId [ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
Handlerreadrndnext 读下一行请求数 读下一行请求数 Count InstanceId [ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
HandlerRollback 内部回滚数 内部回滚数 Count InstanceId [ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]

四、InnoDB

指标名 指标中文名 说明 单位 维度 统计规则
Innodbbufferpoolpagesdirty InnoDB 脏页数 InnoDB 脏页数 Count InstanceId [ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
InnodbCacheHitRate InnoDB 引擎缓存命中率 InnoDB 引擎缓存命中率 % InstanceId [ 5s, min ]
[ 60s, min ]
[ 300s, min ]
[ 3600s, min ]
[ 86400s, min ]
InnodbCacheUseRate InnoDB 引擎缓存使用率 InnoDB 引擎缓存使用率 % InstanceId [ 5s, min ]
[ 60s, min ]
[ 300s, min ]
[ 3600s, min ]
[ 86400s, min ]
Innodbdatapendingreads InnoDB 挂起读取数 InnoDB 挂起读取数 Count InstanceId [ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Innodbdatapendingwrites InnoDB 挂起写入数 InnoDB 挂起写入数 Count InstanceId [ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Innodbdataread InnoDB 读取量 InnoDB 读取量 Bytes InstanceId [ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
Innodbdatareads InnoDB 总读取量 InnoDB 总读取量 Count InstanceId [ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
Innodbdatawrites InnoDB 总写入量 InnoDB 总写入量 Count InstanceId [ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
Innodbdatawritten InnoDB 写入量 InnoDB 写入量 Bytes InstanceId [ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
Innodblogwaits InnoDB 日志等待写入次数 InnoDB 日志等待写入次数 Count InstanceId [ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
Innodblogwriterequests InnoDB 日志物理写请求次数 InnoDB 日志物理写请求次数 Count InstanceId [ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
Innodblogwrites InnoDB 日志物理写入次数 InnoDB 日志物理写入次数 Count InstanceId [ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
Innodbnumopenfiles 当前 InnoDB 打开表的数量 当前 InnoDB 打开表的数量 Count InstanceId [ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Innodbosfilereads 读磁盘数量 读磁盘数量 Count InstanceId [ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Innodbosfilewrites 写磁盘数量 写磁盘数量 Count InstanceId [ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Innodbosfsyncs InnoDB_fsyncs 数 InnoDB_fsyncs 数 Count InstanceId [ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Innodbrowlocktimeavg InnoDB 平均获取行锁时间 InnoDB 平均获取行锁时间 ms InstanceId [ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Innodbrowlockwaits InnoDB 等待行锁次数 InnoDB 等待行锁次数 Count InstanceId [ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
InnodbRowsDeleted InnoDB 行删除量 InnoDB 行删除量 Count InstanceId [ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
InnodbRowsInserted InnoDB 行插入量 InnoDB 行插入量 Count InstanceId [ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
InnodbRowsRead InnoDB 行读取量 InnoDB 行读取量 Count InstanceId [ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
InnodbRowsUpdated InnoDB 行更新量 InnoDB 行更新量 Count InstanceId [ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
Openfiles 打开文件总数 打开文件总数 Count InstanceId [ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]

五、Tmp

指标名 指标中文名 说明 单位 维度 统计规则
Createdtmpdisktables 临时表数量 临时表数量 Count InstanceId [ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
Createdtmpfiles 临时文件数量 临时文件数量 Count InstanceId [ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]

六、并行查询

指标名 指标中文名 说明 单位 维度 统计规则
Txsqlparallelstmterror 并行查询错误数 并行查询报错的语句数量 Count InstanceId [ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
Txsqlparallelstmtexecuted 已执行并行查询数 已执行的并行查询语句数量 Count InstanceId [ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
Txsqlparallelstmtfallback 回滚串行查询数 并行查询回滚到串行查询的语句数量 Count InstanceId [ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
Txsqlparallelthreadscurrentlyused 当前并行查询线程数 并行查询当前使用的线程数量 Count InstanceId [ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]

七、表

指标名 指标中文名 说明 单位 维度 统计规则
CreatedTmpTables 临时表的数量 临时表的数量 Count InstanceId [ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
Openedtables 已经打开的表数 已经打开的表数 Count InstanceId [ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Tablelocksimmediate 立即释放的表锁数 立即释放的表锁数 Count InstanceId [ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
Tablelockswaited 等待表锁次数 等待表锁次数 Count InstanceId [ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
Tableopencachehits 表打开缓存命中数 表打开缓存命中数 Count InstanceId [ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
Tableopencachemisses 表打开缓存未命中数 表打开缓存未命中数 Count InstanceId [ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]

八、访问

指标名 指标中文名 说明 单位 维度 统计规则
Comcommit 提交数 提交数 Count InstanceId [ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
ComDelete 删除数 删除数 Count InstanceId [ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
ComInsert 插入数 插入数 Count InstanceId [ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
Comreplace 覆盖数 覆盖数 Count InstanceId [ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
Comrollback 回滚数 回滚数 Count InstanceId [ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
ComSelect 查询数 查询数 Count InstanceId [ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
ComUpdate 更新数 更新数 Count InstanceId [ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
Proxyqueries 请求数 请求数 Count/s ProxyNodeId [ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Proxyroutemaster 写请求数 写请求数 Count/s ProxyNodeId [ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Proxyrouteslave 读请求数 读请求数 Count/s ProxyNodeId [ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Qcachehitrate Qcache 命中率 Qcache 命中率 % InstanceId [ 5s, min ]
[ 60s, min ]
[ 300s, min ]
[ 3600s, min ]
[ 86400s, min ]
Qcacheuserate Qcache 使用率 Qcache 使用率 % InstanceId [ 5s, min ]
[ 60s, min ]
[ 300s, min ]
[ 3600s, min ]
[ 86400s, min ]
Queries 总请求数 总请求数 Count InstanceId [ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
Selectfulljoin 全表扫描复合查询次数 全表扫描复合查询次数 Count InstanceId [ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
Selectfullrangejoin 范围扫描复合查询次数 范围扫描复合查询次数 Count InstanceId [ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
Selectscan 全表扫描数 全表扫描数 Count InstanceId [ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
SlowQueries 慢查询数 慢查询数 Count InstanceId [ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
Sortmergepasses 排序合并通过次数 排序合并通过次数 Count InstanceId [ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
Proxiesqueries 请求数 请求数 Count/s OssProxyNodeName [ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Proxiesroutemaster 写请求数 写请求数 Count/s OssProxyNodeName [ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Proxiesrouteslave 读请求数 读请求数 Count/s OssProxyNodeName [ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]

九、资源

指标名 指标中文名 说明 单位 维度 统计规则
Proxycpuuserate CPU 利用率 CPU 利用率 % ProxyNodeId [ 5s, max ]
[ 10s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Proxymemoryusage 内存占用 内存占用 MBytes ProxyNodeId [ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Proxymemoryuserate 内存利用率 内存利用率 % ProxyNodeId [ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Proxiesbytesreceived 数据库代理每秒接收客户端流量 数据库代理每秒接收客户端流量 MBytes/s OssProxyNodeName [ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Proxiesbytessent 数据库代理每秒发送客户端流量 数据库代理每秒发送客户端流量 MBytes/s OssProxyNodeName [ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Proxiescpuuserate CPU 利用率 CPU 利用率 % OssProxyNodeName [ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Proxiesmemoryusage 内存占用 内存占用 MBytes OssProxyNodeName [ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Proxiesmemoryuserate 内存利用率 内存利用率 % OssProxyNodeName [ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]

十、资源监控

指标名 指标中文名 说明 单位 维度 统计规则
BytesReceived 每秒接收客户端流量 每秒接收客户端流量 MB/s InstanceId [ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
BytesSent 每秒发送客户端流量 每秒发送客户端流量 MB/s InstanceId [ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Ccu CCU_仅对于 serverless CCU_仅对于 serverless Count InstanceId [ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Cpuuserate CPU 使用率 CPU 使用率 % InstanceId [ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
MemoryUse 内存使用量 内存使用量 MB InstanceId [ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Memoryuserate 内存使用率 内存使用率 % InstanceId [ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Readiops 读请求 IOPS 读请求 IOPS Count/s InstanceId [ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Storageuse 存储使用量 存储使用量 GBytes InstanceId [ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Storageuserate 存储使用率 存储使用率 % InstanceId [ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
TmpVolumeUsage 临时表空间使用量 临时表空间使用量 GB InstanceId [ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
UndoVolumeUsage undo 表空间使用量 undo 表空间使用量 GB InstanceId [ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Writeiops 写请求 IOPS 写请求 IOPS Count/s InstanceId [ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]

十一、连接

指标名 指标中文名 说明 单位 维度 统计规则
Connectionuserate 连接数利用率 连接数利用率 % InstanceId [ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
MaxConnections 最大连接数 最大连接数 count InstanceId [ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Proxycurrentconnections 当前连接数 当前连接数 Count/s ProxyNodeId [ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Qps 每秒执行操作数 每秒执行操作数 Count/s InstanceId [ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Threadsconnected 当前打开连接数 当前打开连接数 Count InstanceId [ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Threadscreated 已创建的线程数 已创建的线程数 Count InstanceId [ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
ThreadsRunning 运行的线程数 运行的线程数 Count InstanceId [ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Tps 每秒执行事务数 每秒执行事务数 Count/s InstanceId [ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Proxiescurrentconnections 当前连接数 当前连接数 Count/s OssProxyNodeName [ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]

十二、部署监控

指标名 指标中文名 说明 单位 维度 统计规则
Clusterslaveiorunning 跨可用区部署 IO 线程状态 跨可用区部署 IO 线程状态 None InstanceId [ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Clusterslavesqlrunning 跨可用区部署 SQL 线程状态 跨可用区部署 SQL 线程状态 None InstanceId [ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Masterslavesyncdistance 跨可用区备机主从同步差距 跨可用区备机主从同步差距 MB InstanceId [ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Replicationdelay 复制延迟 复制延迟 ms InstanceId [ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Replicationdelaydistance 复制落后的 lsn 距离 复制落后的 lsn 距离 Bytes InstanceId [ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Replicationstatus 复制状态 复制状态 None InstanceId [ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Rplsemisyncmastertxcurwaittime 事务等待跨可用区集群确认时间 事务等待跨可用区集群确认时间 us InstanceId [ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Secondsbehindmaster 跨可用区延迟时间 跨可用区延迟时间 s InstanceId [ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]

十三、其他

指标名 指标中文名 说明 单位 维度 统计规则
Comaltertable 改表数 改表数 Count InstanceId [ 5s, sum ]
[ 10s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
Comanalyze Analyze 命令数 Analyze 命令数 Count InstanceId [ 5s, sum ]
[ 10s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
Comcreatetable 建表数 建表数 Count InstanceId [ 5s, sum ]
[ 10s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
Comdropindex 删索引数 删索引数 Count InstanceId [ 5s, sum ]
[ 10s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
Comdroptable 删表数 删表数 Count InstanceId [ 5s, sum ]
[ 10s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
Comdropuser 删用户数 删用户数 Count InstanceId [ 5s, sum ]
[ 10s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
Comexecutesql 预处理语句累计执行频率 预处理语句累计执行频率 Count/s InstanceId [ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Cominsertselect INSERT_SELECT 数 INSERT_SELECT 数 Count InstanceId [ 5s, max ]
[ 10s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Comoptimize Optimize 命令数 Optimize 命令数 Count InstanceId [ 5s, sum ]
[ 10s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
Compreparesql 预处理语句累计准备频率 预处理语句累计准备频率 Count/s InstanceId [ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Comreplaceselect REPLACE_SELECT 数 REPLACE_SELECT 数 Count InstanceId [ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Comtruncate 清表数 清表数 Count InstanceId [ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
Connections 累计连接数 累计连接数 Count InstanceId [ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Ddltps DDL 吞吐量 DDL 吞吐量 Count InstanceId [ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
DataVolumeUsage 数据表空间使用量 数据表空间使用量 GB InstanceId [ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Innodbbufferpooldatapages InnoDB 数据页数 InnoDB 数据页数 Count InstanceId [ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Innodbbufferpoolwaitfree InnoDB 写等待页数 InnoDB 写等待页数 Count InstanceId [ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Innodbncdbreadpagenum InnoDB 每秒读页面数 InnoDB 每秒读页面数 Count/s InstanceId [ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Innodbncdbwritepagenum InnoDB 每秒写页面数 InnoDB 每秒写页面数 Count/s InstanceId [ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Memoryoom OOM 状态 OOM 状态 None InstanceId [ 5s, max ]
[ 10s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Proxydbrt DB 执行平均耗时 DB 执行平均耗时 us OssProxyNodeName [ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Proxyinternalrt Proxy 内部平均耗时 Proxy 内部平均耗时 us OssProxyNodeName [ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Proxysqlfullrt SQL 全链路平均耗时 SQL 全链路平均耗时 us OssProxyNodeName [ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Questions 客户端请求数 客户端请求数 Count InstanceId [ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
Replicalagmaxlog 待复制日志量_MB 待复制日志量_MB MB InstanceId [ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Replicalagmaxlsn 待复制日志量_LSN 待复制日志量_LSN Count InstanceId [ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Sortrows 已排序总行数 已排序总行数 Count InstanceId [ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Switchtimes HA 切换次数 HA 切换次数 Count InstanceId [ 5s, sum ]
[ 10s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
Tableopencacheoverflows 表打开缓存溢出次数 表打开缓存溢出次数 Count InstanceId [ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
Tmptablesrate 临时表利用率 临时表利用率 % InstanceId [ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Trxrseghistorylen 事务历史列表长度 事务历史列表长度 Count InstanceId [ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Uptime 累计启动时间 累计启动时间 s InstanceId [ 5s, max ]
[ 10s, last ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Memorystatcache 内存 Cache 使用量 内存 Cache 使用量 MBytes InstanceId [ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]

十四、各维度对应参数总览

注意：说明：

注意：proxy 视图能力升级，旧版的 ProxyNodeId 维度即将下线，建议尽快迁移到新版的 OssProxyNodeName 维度使用。

注意：{ "Namespace": "QCE/CYNOSDB_MYSQL", "MetricName": "Proxiescpuuserate", "Instances": [ { "Dimensions": [ { "Name": "OssProxyNodeName", "Value": "cynosdbmysql-proxyNode-hdu***" } ] } ], "Period": 300, "StartTime": "2026-08-03 11:00:00", "EndTime": "2026-08-06 11:00:00", "SpecifyStatistics": 2}

参数名称 维度名称 维度解释 格式
Instances.N.Dimensions.0.Name InstanceId 数据库实例 ID 的维度名称 输入String 类型维度名称：InstanceId
Instances.N.Dimensions.0.Value InstanceId 数据库的实例具体 ID 输入具体实例 ID，例如：cynosdbmysql-ins-12ab34cd
Instances.N.Dimensions.1.Name ProxyNodeId 数据库代理节点 ID 的维度名称（旧） 输入String 类型维度名称：ProxyNodeId
Instances.N.Dimensions.1.Value ProxyNodeId 数据库代理节点 ID（旧） 输入 String 类型的数据库代理节点名称，
例如：cynosdbmysql-proxyNode-hdue1jhd
Instances.N.Dimensions.2.Name OssProxyNodeName 数据库代理节点 ID 的维度名称（新） 输入String 类型维度名称：OssProxyNodeName
Instances.N.Dimensions.2.Value OssProxyNodeName 数据库代理节点 ID（新） 输入 String 类型的数据库代理节点名称，例如：cynosdbmysql-proxyNode-hdue1jhd

十五、入参说明

查询云数据库（TDSQL-C MySQL）产品监控数据，入参取值如下：

&Namespace=QCE/CYNOSDB_MYSQL
&Instances.N.Dimensions.0.Name=InstanceId
&Instances.N.Dimensions.0.Value=CynosDB 数据库中具体实例的 ID

&Instances.N.Dimensions.1.Name=ProxyNodeId（即将下线，推荐使用 OssProxyNodeName）
&Instances.N.Dimensions.1.Value=CynosDB 数据库中代理节点的名称

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

&Instances.N.Dimensions.2.Value=CynosDB 数据库中代理节点的名称

十六、重要说明

注意：说明：

注意：{ "Namespace": "QCE/CYNOSDB_MYSQL", "MetricName": "LibraDBQps", "Instances": [ { "Dimensions": [ { "Name": "InstanceId", "Value": "libradb-ins-7920****" } ] } ], "Period": 300, "StartTime": "2026-08-03 11:00:00", "EndTime": "2026-08-06 11:00:00", "SpecifyStatistics": 2}

相关内容：

  1. 腾讯云可观测平台 TDSQL-C PostgreSQL 版监控指标 这里说明了查询 TDSQL-C PostgreSQL 版监控数据的相关内容，包括命名空间、监控指标、各维度对应参数总览以及入参说明。入参说明: 查询 TDSQL-C PostgreSQL 版监控数据时，需设置入参，如 Namespace 为 QCE/CYNOSDB_POSTGRES ，Instances.N.Dimensions.0.Name 为 InstanceId ，Instances.N.Dimension。...
  2. 腾讯云可观测平台 消息队列 RabbitMQ 版监控指标 查询消息队列 RabbitMQ Serverless 版指标监控数据，入参取值如下&Instances.N.Dimensions.0.Name=instanceid。...
  3. 腾讯云可观测平台 消息队列 CKafka 版监控指标 查询 QCE/CKAFKA 监控数据，入参取值如下&Instances.N.Dimensions.0.Name=instanceId。...
  4. 腾讯云可观测平台 TDSQL-H LibraDB 监控指标 这篇列出了腾讯云TDSQL_A的监控指标，包括活跃分区目录数、每秒写入大小、CPU使用率、磁盘使用率、连接数等，并说明其单位、维度及统计规则。 指标覆盖资源使用（CPU/内存/磁盘）、数据库操作（写入/查询/合并）及ZooKeeper相关监控。 统计粒度支持60秒至86400秒，部分指标支持5秒高频采集。...
  5. 腾讯云可观测平台 关系型数据库 TDSQL 分布式数据库 TDSQL MySQL 版监控指标入参说明如下&Namespace=QCE/TDMYSQL &Instances.N.Dimensions.0.Name=InstanceId &Instances.N.Dimensions.0.Value=具体实例 ID &Instances.N.Dimensions.1.Name=NodeId &Instances.N.Dimensions.1.Value=具体节点 。...
  6. 腾讯云可观测平台 云数据库 MariaDB 监控指标 云数据库 MariaDB 监控指标入参说明如下&Namespace=QCE/MARIADB &Instances.N.Dimensions.0.Name= InstanceId &Instances.N.Dimensions.0.Value=具体实例 ID &Instances.N.Dimensions.1.Name=NodeId &Instances.N.Dimensions.1.Value=具体节点 ID。...
  7. 腾讯云可观测平台 CKV 版监控指标 查询云数据库 Redis 监控数据，入参取值如下： &Namespace= QCE/REDIS &Instances.N.Dimensions.0.Name=redis_uuid &Instances.N.Dimensions.0.Value 为实例的 uuid。...
  8. 腾讯云可观测平台 消息队列 MQTT 版监控指标 查询 QCE/MQTT 监控数据，入参取值如下&Instances.N.Dimensions.0.Name=instanceId。...
赞 (0)
上一篇 5天前
下一篇 5天前