指标英文名 | 说明 | 单位 | 维度 | 统计规则 [period, statType] |
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 | Count | InstanceId | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
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 ] |
Connectionuserate | 连接数利用率 | % | InstanceId | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
Cpuuserate | CPU 使用率 | % | InstanceId | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
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 ] |
CreatedTmpTables | 临时表的数量 | 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 ] |
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 ] |
Innodbbufferpoolpagesdirty | InnoDB 脏页数 | Count | InstanceId | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
Innodbbufferpoolpagesfree | InnoDB 空页数 | Count | InstanceId | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
Innodbbufferpoolpagestotal | InnoDB 总页数 | Count | InstanceId | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
InnodbBufferPoolReadRequests | InnoDB 缓冲池读取次数 | Count | InstanceId | [ 5s, sum ] [ 60s, sum ] [ 300s, sum ] [ 3600s, sum ] [ 86400s, sum ] |
Innodbbufferpoolreads | InnoDB 物理读 | Count | InstanceId | [ 5s, sum ] [ 60s, sum ] [ 300s, sum ] [ 3600s, sum ] [ 86400s, sum ] |
Innodbbufferpoolwriterequest | InnoDB 缓冲池写入次数 | Count | InstanceId | [ 5s, sum ] [ 60s, sum ] [ 300s, sum ] [ 3600s, sum ] [ 86400s, sum ] |
InnodbBufferPoolWriteRequests | InnoDB 引擎每秒已完成的逻辑写请求次数 | Count | InstanceId | [ 5s, sum ] [ 60s, sum ] [ 300s, sum ] [ 3600s, sum ] [ 86400s, sum ] |
InnodbCacheHitRate | InnoDB 引擎缓存命中率 | % | InstanceId | [ 5s, min ] [ 60s, min ] [ 300s, min ] [ 3600s, min ] [ 86400s, min ] |
InnodbCacheUseRate | InnoDB 引擎缓存使用率 | % | InstanceId | [ 5s, min ] [ 60s, min ] [ 300s, min ] [ 3600s, min ] [ 86400s, min ] |
Innodbdatapendingreads | InnoDB 挂起读取数 | Count | InstanceId | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
Innodbdatapendingwrites | InnoDB 挂起写入数 | Count | InstanceId | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
Innodbdataread | InnoDB 读取量 | Bytes | InstanceId | [ 5s, sum ] [ 60s, sum ] [ 300s, sum ] [ 3600s, sum ] [ 86400s, sum ] |
Innodbdatareads | InnoDB 总读取量 | Count | InstanceId | [ 5s, sum ] [ 60s, sum ] [ 300s, sum ] [ 3600s, sum ] [ 86400s, sum ] |
Innodbdatawrites | InnoDB 总写入量 | Count | InstanceId | [ 5s, sum ] [ 60s, sum ] [ 300s, sum ] [ 3600s, sum ] [ 86400s, sum ] |
Innodbdatawritten | InnoDB 写入量 | Bytes | InstanceId | [ 5s, sum ] [ 60s, sum ] [ 300s, sum ] [ 3600s, sum ] [ 86400s, sum ] |
Innodblogwaits | InnoDB 日志等待写入次数 | Count | InstanceId | [ 5s, sum ] [ 60s, sum ] [ 300s, sum ] [ 3600s, sum ] [ 86400s, sum ] |
Innodblogwriterequests | InnoDB 日志物理写请求次数 | Count | InstanceId | [ 5s, sum ] [ 60s, sum ] [ 300s, sum ] [ 3600s, sum ] [ 86400s, sum ] |
Innodblogwrites | InnoDB 日志物理写入次数 | Count | InstanceId | [ 5s, sum ] [ 60s, sum ] [ 300s, sum ] [ 3600s, sum ] [ 86400s, sum ] |
Innodbnumopenfiles | 当前 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 数 | Count | InstanceId | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
Innodbrowlocktimeavg | InnoDB 平均获取行锁时间 | ms | InstanceId | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
Innodbrowlockwaits | InnoDB 等待行锁次数 | Count | InstanceId | [ 5s, sum ] [ 60s, sum ] [ 300s, sum ] [ 3600s, sum ] [ 86400s, sum ] |
InnodbRowsDeleted | InnoDB 行删除量 | Count | InstanceId | [ 5s, sum ] [ 60s, sum ] [ 300s, sum ] [ 3600s, sum ] [ 86400s, sum ] |
InnodbRowsInserted | InnoDB 行插入量 | Count | InstanceId | [ 5s, sum ] [ 60s, sum ] [ 300s, sum ] [ 3600s, sum ] [ 86400s, sum ] |
InnodbRowsRead | InnoDB 行读取量 | Count | InstanceId | [ 5s, sum ] [ 60s, sum ] [ 300s, sum ] [ 3600s, sum ] [ 86400s, sum ] |
InnodbRowsUpdated | InnoDB 行更新量 | Count | InstanceId | [ 5s, sum ] [ 60s, sum ] [ 300s, sum ] [ 3600s, sum ] [ 86400s, sum ] |
MaxConnections | 最大连接数 | count | 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 ] |
Openedtables | 已经打开的表数 | Count | InstanceId | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
Openfiles | 打开文件总数 | Count | InstanceId | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
Proxycpuuserate | CPU 利用率 | % | ProxyNodeId | [ 5s, max ] [ 10s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
Proxycurrentconnections | 当前连接数 | Count/s | ProxyNodeId | [ 5s, 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 ] |
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 命中率 | % | InstanceId | [ 5s, min ] [ 60s, min ] [ 300s, min ] [ 3600s, min ] [ 86400s, min ] |
Qcacheuserate | Qcache 使用率 | % | InstanceId | [ 5s, min ] [ 60s, min ] [ 300s, min ] [ 3600s, min ] [ 86400s, min ] |
Qps | 每秒执行操作数 | Count/s | InstanceId | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
Queries | 总请求数 | Count | InstanceId | [ 5s, sum ] [ 60s, sum ] [ 300s, sum ] [ 3600s, sum ] [ 86400s, sum ] |
Readiops | 读请求 IOPS | Count/s | 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 距离 | 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 ] |
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 ] |
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 ] |
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 ] |
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 ] |
TmpVolumeUsage | 临时表空间使用量 | GB | 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 ] |
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 ] |
UndoVolumeUsage | undo 表空间使用量 | GB | InstanceId | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
Writeiops | 写请求 IOPS | Count/s | InstanceId | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
ClusterSlaveIoRunning | 跨可用区部署 IO 线程状态 | None | InstanceId | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
ClusterSlaveSqlRunning | 跨可用区部署 SQL 线程状态 | None | InstanceId | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
SecondsBehindMaster | 跨可用区延迟时间 | s | InstanceId | [ 5s, 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 | 输入具体实例 ID,例如:cynosdbmysql-ins-12ab34cd |
Instances.N.Dimensions.0.Name | ProxyNodeId | 数据库代理节点 ID 的维度名称 | 输入String 类型维度名称:ProxyNodeId |
Instances.N.Dimensions.1.Value | ProxyNodeId | 数据库代理节点 ID | 输入 String 类型的数据库代理节点名称, 例如:cynosdbmysql-proxyNode-hdue1jhd |
文档反馈