命名空间
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.0.Name | ProxyNodeId | 数据库代理节点 ID 的维度名称（旧） | 输入String 类型维度名称：ProxyNodeId |
Instances.N.Dimensions.1.Value | ProxyNodeId | 数据库代理节点 ID（旧） | 输入 String 类型的数据库代理节点名称，
例如：cynosdbmysql-proxyNode-hdue1jhd |
Instances.N.Dimensions.0.Name | OssProxyNodeName | 数据库代理节点 ID 的维度名称（新） | 输入String 类型维度名称：OssProxyNodeName |
Instances.N.Dimensions.1.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 数据库中代理节点的名称
重要说明
说明：
只读分析引擎的指标名（可以用于调用）需要在普通实例的指标名前加 Libra，例如：QPS 的指标名为 Qps，只读分析引擎对应为 LibraDBQps。
通过接口获取只读分析引擎的监控指标数据时，调用示例如下，当前支持的只读分析引擎监控指标请参见 监控告警。
{"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}
