命名空间
Namespace = QCE/CYNOSDB_MYSQL
监控指标
指标英文名 | 指标中文名 | 指标说明 | 单位 | 维度 | 统计规则
[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] |
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 使用率 | 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 脏页数 | InnoDB 脏页数 | Count | InstanceId | [5s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max] |
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] |
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] |
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 利用率 | 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 命中率 | 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] |
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] |
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] |
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 表空间使用量 | undo 表空间使用量 | GB | 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 |
入参说明
查询云数据库（CynosDB for MySQL）产品监控数据，入参取值如下：
&Namespace=QCE/CYNOSDB_MYSQL
&Instances.N.Dimensions.0.Name=InstanceId
&Instances.N.Dimensions.0.Value=CynosDB 数据库中具体实例的 ID
&Instances.N.Dimensions.1.Name=ProxyNodeId
&Instances.N.Dimensions.1.Value=CynosDB 数据库中代理节点的名称