一、命名空间
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 值