命名空间
Namespace = QCE/CDB
监控指标
指标英文名 | 指标中文名 | 说明 | 单位 | 维度 | 统计规则 [period, statType] |
AbortedClients | 异常关闭的客户端连接数 | 由于客户端在没有正确关闭连接的情况下死亡而中止的连接数 | Count | InstanceType InstanceId | [ 5s, sum ] [ 60s, sum ] [ 300s, sum ] [ 3600s, sum ] [ 86400s, sum ] |
AbortedConnects | 尝试连接的失败次数 | 尝试连接到 MySQL 服务器的失败次数 | Count | InstanceType InstanceId | [ 5s, sum ] [ 60s, sum ] [ 300s, sum ] [ 3600s, sum ] [ 86400s, sum ] |
BillingBackupVolume | 收费空间 | 收费空间 | byte | product subproduct | [ 300s, max ] |
BytesReceived | 接受数据量 | 接受数据量 | Bytes/s | InstanceType InstanceId | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
BytesSent | 发送数据量 | 发送数据量 | Bytes/s | InstanceType InstanceId | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
Capacity | 磁盘占用空间 | 磁盘占用空间 | MB | InstanceId InstanceType | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
ComCommit | 提交数 | 提交数 | times/s | InstanceId InstanceType | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
ComDelete | 删除数 | 删除数 | times/s | InstanceId InstanceType | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
ComInsert | 插入数 | 插入数 | times/s | InstanceId InstanceType | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
ComReplace | 覆盖数 | 覆盖数 | times/s | InstanceId InstanceType | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
ComRollback | 回滚数 | 回滚数 | times/s | InstanceId InstanceType | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
ComStmtClose | close 命令执行次数 | com_stmt_close 命令执行次数 | Count | InstanceId InstanceType | [ 5s, sum ] [ 60s, sum ] [ 300s, sum ] [ 3600s, sum ] [ 86400s, sum ] |
Comstmtexecute | execute 命令执行次数 | com_stmt_execute 命令执行次数 | Count | InstanceType InstanceId | [ 5s, sum ] [ 60s, sum ] [ 300s, sum ] [ 3600s, sum ] [ 86400s, sum ] |
ComStmtPrepare | prepare 命令执行次数 | com_stmt_prepare 命令执行次数 | Count | InstanceId InstanceType | [ 5s, sum ] [ 60s, sum ] [ 300s, sum ] [ 3600s, sum ] [ 86400s, sum ] |
ComUpdate | 更新数 | 更新数 | times/s | InstanceId InstanceType | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
ConnectionUseRate | 连接数利用率 | 连接数利用率 | % | InstanceId InstanceType | [ 5s, max ] [ 10s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
CpuUseRate | CPU 利用率 | CPU 利用率 | % | InstanceId InstanceType | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
CreatedTmpDiskTables | 磁盘临时表数量 | 磁盘临时表数量 | times/s | InstanceId InstanceType | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
CreatedTmpFiles | 临时文件数量 | 临时文件数量 | times/s | InstanceId InstanceType | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
CreatedTmpTables | 内存临时表数量 | 内存临时表数量 | times/s | InstanceId InstanceType | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
CurrentBackupVolume | 总备份 | 总备份 | byte | product subproduct | [ 300s, max ] |
DangerCountOfGroup | 审计组维度风险总数 | 审计组维度风险总数 | Count | GroupId | [ 60s, sum ] [ 300s, sum ] [ 3600s, sum ] [ 86400s, sum ] |
DataVolume | 数据备份 | 数据备份 | byte | product subproduct | [ 300s, max ] |
DiskLogUsed | 日志文件使用空间 | 日志文件使用空间 | MBytes | InstanceId InstanceType | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
DiskRemaining | 磁盘剩余量 | 磁盘剩余量 | MBytes | InstanceId InstanceType | [ 5s, max ] [ 10s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
DiskTmpUsed | 临时文件使用空间 | 临时文件使用空间 | MiBytes | InstanceType InstanceId | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
FreeBackupVolume | 免费空间 | 免费空间 | byte | product subproduct | [ 300s, max ] |
HandlerCommit | 内部提交数 | 内部提交数 | times/s | InstanceId InstanceType | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
HandlerReadRndNext | 读下一行请求数 | 读下一行请求数 | times/s | InstanceId InstanceType | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
HandlerRollback | 内部回滚数 | 内部回滚数 | times/s | InstanceType InstanceId | [ 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 | InstanceId InstanceType | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
InnodbBufferPoolPagesTotal | InnoDB 总页数 | InnoDB 总页数 | Count | InstanceId InstanceType | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
InnodbBufferPoolReadRequests | innodb 缓冲池预读页次数 | innodb 缓冲池预读页次数 | times/s | InstanceId InstanceType | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
InnodbBufferPoolReads | innodb 磁盘读页次数 | innodb 磁盘读页次数 | times/s | InstanceId InstanceType | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
InnodbCacheHitRate | innodb 缓存命中率 | innodb 缓存命中率 | % | InstanceId InstanceType | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
InnodbCacheUseRate | innodb 缓存使用率 | innodb 缓存使用率 | % | InstanceId InstanceType | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
InnodbDataRead | InnoDB 读取量 | InnoDB 读取量 | Bytes | InstanceId InstanceType | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
InnodbDataReads | InnoDB 总读取量 | InnoDB 总读取量 | times/s | InstanceId InstanceType | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
InnodbDataWrites | InnoDB 总写入量 | InnoDB 总写入量 | times/s | InstanceId InstanceType | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
InnodbDataWritten | InnoDB 写入量 | InnoDB 写入量 | times/s | InstanceId InstanceType | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
InnodbLogWaits | log 写入等待次数 | log 写入等待次数 | Count | InstanceId InstanceType | [ 5s, max ] [ 10s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
InnodbLogWrites | 重做日志文件刷盘次数 | InnoDB 重做日志文件写入硬盘的次数 | Count | InstanceId InstanceType | [ 5s, sum ] [ 60s, sum ] [ 300s, sum ] [ 3600s, sum ] [ 86400s, sum ] |
InnodbNumOpenFiles | 当前 InnoDB 打开表的数量 | 当前 InnoDB 打开表的数量 | count | InstanceId InstanceType | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
InnodbOsFileReads | innodb 读磁盘数量 | innodb 读磁盘数量 | times/s | InstanceId InstanceType | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
InnodbOsFileWrites | innodb 写磁盘数量 | innodb 写磁盘数量 | times/s | InstanceId InstanceType | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
InnodbOsFsyncs | innodbfsync 数量 | innodbfsync 数量 | times/s | InstanceId InstanceType | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
InnodbOsLogWritten | 写入重做日志文件的数据量大小 | 写入 InnoDB 重做日志文件的字节数 | Bytes | InstanceType InstanceId | [ 5s, sum ] [ 60s, sum ] [ 300s, sum ] [ 3600s, sum ] [ 86400s, sum ] |
InnodbRowLockCurrentWaits | 当前行锁数量 | 当前 InnoDB 表上的行锁数 | Count | InstanceType InstanceId | [ 5s, last ] [ 60s, last ] [ 300s, last ] [ 3600s, last ] [ 86400s, last ] |
InnodbRowLockTime | 获取行锁所花费的总时间 | 获取 InnoDB 表行锁所花费的总时间 | ms | InstanceId InstanceType | [ 5s, sum ] [ 60s, sum ] [ 300s, sum ] [ 3600s, sum ] [ 86400s, sum ] |
InnodbRowLockTimeAvg | InnoDB 平均获取行锁时间 | InnoDB 平均获取行锁时间（毫秒） | ms | InstanceId InstanceType | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
InnodbRowLockTimeMax | 获取行锁的最长时间 | 获取 InnoDB 表行锁的最长时间 | ms | InstanceType InstanceId | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
InnodbRowLockWaits | InnoDB 等待行锁次数 | InnoDB 等待行锁次数 | Count/s | InstanceType InstanceId | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
InnodbRowsDeleted | InnoDB 行删除量 | InnoDB 行删除量 | times/s | InstanceId InstanceType | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
InnodbRowsInserted | InnoDB 行插入量 | InnoDB 行插入量 | times/s | InstanceId InstanceType | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
InnodbRowsRead | InnoDB 行读取量 | InnoDB 行读取量 | times/s | InstanceId InstanceType | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
InnodbRowsUpdated | InnoDB 行更新量 | InnoDB 行更新量 | times/s | InstanceType InstanceId | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
Iops | 每秒的输入输出量 | 每秒的输入输出量 | count/s | InstanceType InstanceId | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
IopsRead | IOPS 读次数 | IOPS 读次数 | Count/s | InstanceId InstanceType | [ 5s, max ] [ 10s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
IopsUseRate | IOPS 利用率 | IOPS 利用率 | % | InstanceId InstanceType | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
IopsWrite | IOPS 写次数 | IOPS 写次数 | Count/s | InstanceId InstanceType | [ 5s, max ] [ 10s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
KeyBlocksUnused | 键缓存内未使用的块数量 | 键缓存内未使用的块数量 | Count | InstanceType InstanceId | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
KeyBlocksUsed | 键缓存内使用的块数量 | 键缓存内使用的块数量 | Count | InstanceId InstanceType | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
KeyCacheHitRate | myisam 缓存命中率 | myisam 缓存命中率 | % | InstanceId InstanceType | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
KeyCacheUseRate | myisam 缓存使用率 | myisam 缓存使用率 | % | InstanceType InstanceId | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
KeyReadRequests | 键缓存读取数据块次数 | 键缓存读取数据块次数 | times/s | InstanceId InstanceType | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
KeyReads | 硬盘读取数据块次数 | 硬盘读取数据块次数 | times/s | InstanceId InstanceType | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
KeyWriteRequests | 数据块写入键缓冲次数 | 数据块写入键缓冲次数 | times/s | InstanceId InstanceType | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
KeyWrites | 数据块写入磁盘次数 | 数据块写入磁盘次数 | times/s | InstanceId InstanceType | [ 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 | InstanceId NodeId | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
Libradbbytessent | 分析引擎网络出流量 | 分析引擎网络出流量 | MBytes/s | NodeId InstanceId | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
Libradbcached | 分析引擎缓存使用量 | 分析引擎缓存使用量 | MBytes | InstanceId NodeId | [ 5s, last ] [ 60s, last ] [ 300s, last ] [ 3600s, last ] [ 86400s, last ] |
Libradbcachehitsrate | 分析引擎缓存命中率 | 分析引擎缓存命中率 | % | NodeId InstanceId | [ 5s, avg ] [ 60s, avg ] [ 300s, avg ] [ 3600s, avg ] [ 86400s, avg ] |
Libradbcompactrowsets | 分析引擎 CompactRowset 数量 | 分析引擎 CompactRowset 数量 | Count | InstanceId NodeId | [ 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 使用率 | % | NodeId InstanceId | [ 5s, last ] [ 10s, last ] [ 60s, last ] [ 300s, last ] [ 3600s, last ] [ 86400s, last ] |
Libradbdatafilesize | 分析引擎数据文件大小 | 分析引擎数据文件大小 | MBytes | NodeId InstanceId | [ 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 | 分析引擎内存使用率 | 分析引擎内存使用率 | % | NodeId InstanceId | [ 5s, last ] [ 60s, last ] [ 300s, last ] [ 3600s, last ] [ 86400s, last ] |
Libradbmpptasks | 分析引擎接收到的 MppTask 数 | 分析引擎接收到的 MppTask 数 | Count | InstanceId NodeId | [ 5s, sum ] [ 60s, sum ] [ 300s, sum ] [ 3600s, sum ] [ 86400s, sum ] |
Libradbnodedumprowspersec | 分析引擎节点全量加载时每秒写行数 | 分析引擎节点全量加载时每秒写行数 | Count/s | NodeId InstanceId | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
Libradbnodedumpsizepersec | 分析引擎节点全量加载时每秒写数据大小 | 分析引擎节点全量加载时每秒写数据大小 | MBytes/s | NodeId InstanceId | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
Libradbnodelatency | 分析引擎节点延迟时间 | 分析引擎节点延迟时间 | s | NodeId InstanceId | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
Libradbnodesinkrowspersec | 分析引擎节点每秒同步处理行数 | 分析引擎节点每秒同步处理行数 | Count/s | NodeId InstanceId | [ 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 | NodeId InstanceId | [ 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 | NodeId InstanceId | [ 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 | NodeId InstanceId | [ 5s, last ] [ 60s, last ] [ 300s, last ] [ 3600s, last ] [ 86400s, last ] |
Libradbstorageuserate | 分析引擎存储使用率 | 分析引擎存储使用率 | % | NodeId InstanceId | [ 5s, last ] [ 60s, last ] [ 300s, last ] [ 3600s, last ] [ 86400s, last ] |
Libradbwritethroughput | 分析引擎写吞吐 | 分析引擎写吞吐 | MBytes/s | NodeId InstanceId | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
LogCapacity | 日志使用空间 | 日志使用空间 | MB | InstanceId InstanceType | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
LogVolume | 日志备份 | 日志备份 | byte | subproduct product | [ 300s, max ] |
LowDangerLvlOfGroup | 审计组维度低风险数 | 审计组维度低风险数 | Count | GroupId | [ 60s, sum ] [ 300s, sum ] [ 3600s, sum ] [ 86400s, sum ] |
MasterSlaveSyncDistance | 主备不同步距离 | 主备不同步距离 | MB | InstanceId InstanceType | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, avg ] [ 86400s, avg ] |
MaxConnections | 最大连接数 | 最大连接数 | Count | InstanceId InstanceType | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
MemoryUse | 内存占用 | 内存占用 | MBytes | InstanceId InstanceType | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
MemoryUseRate | 内存利用率 | 内存利用率 | % | InstanceId InstanceType | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
MidDangerLvlOfGroup | 审计组维度中风险数 | 审计组维度中风险数 | Count | GroupId | [ 60s, sum ] [ 300s, sum ] [ 3600s, sum ] [ 86400s, sum ] |
OpenedTables | 已经打开的表数 | 已经打开的表数 | Count | InstanceType InstanceId | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
OpenFiles | 打开文件数 | 打开文件数 | times/s | InstanceId InstanceType | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
OperationCountOfGroup | 审计组操作总次数 | 审计组操作总次数 | Count | GroupId | [ 60s, sum ] [ 300s, sum ] [ 3600s, sum ] [ 86400s, sum ] |
ProxyCpuUseRate | CPU 利用率 | CPU 利用率 | % | InstanceType InstanceId | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
ProxyCurrentConnections | 当前连接数 | 当前连接数 | None | InstanceType InstanceId | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
ProxyMemoryUse | 内存占用 | 内存占用 | MBytes | InstanceType InstanceId | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
ProxyMemoryUseRate | 内存利用率 | 内存利用率 | % | InstanceType InstanceId | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
ProxyQueries | 请求数 | 请求数 | None | InstanceId InstanceType | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
ProxyRouteMaster | 写请求数 | 写请求数 | None | InstanceType InstanceId | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
ProxyRouteSlave | 读请求数 | 读请求数 | None | InstanceType InstanceId | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
QcacheFreeBlocks | 查询缓存空闲块 | 查询缓存空闲块 | Count | InstanceId InstanceType | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
QcacheFreeMemory | 缓存中空闲内存量 | 缓存中空闲内存量 | MB | InstanceId InstanceType | [ 5s, avg ] [ 60s, avg ] [ 300s, avg ] [ 3600s, max ] [ 86400s, max ] |
QcacheHitRate | 查询缓存命中率 | 查询缓存命中率 | % | InstanceId InstanceType | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
QcacheHits | 缓存命中次数 | 缓存命中次数 | % | InstanceId InstanceType | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
QcacheInserts | 缓存写入次数 | 缓存写入次数 | times/s | InstanceId InstanceType | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
QcacheLowmemPrunes | 因内存不足删除缓存次数 | 因内存不足删除缓存次数 | Count | InstanceId InstanceType | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
QcacheNotCached | 查询未被缓存次数 | 查询未被缓存次数 | MB | InstanceId InstanceType | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
QcacheQueriesInCache | 已注册到缓存内的查询数 | 已注册到缓存内的查询数 | times/s | InstanceId InstanceType | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
QcacheTotalBlocks | 查询缓存内的总块数 | 查询缓存内的总块数 | Count | InstanceId InstanceType | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
QcacheUseRate | 查询缓存使用率 | 查询缓存使用率 | % | InstanceId InstanceType | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
Qps | 每秒查询率 | 每秒查询率 | times/s | InstanceId InstanceType | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
Queries | 总 Query量 | 总 Query 量 | times/s | InstanceId InstanceType | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
QueryRate | 查询使用率 | 查询使用率 | % | InstanceId InstanceType | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
QueryTotal | 查询总量 | 当前粒度单位时间内查询量的总和 | Count | InstanceId InstanceType | [ 5s, last ] [ 60s, last ] [ 300s, last ] [ 3600s, last ] [ 86400s, last ] |
ReadLatency | 磁盘读取延迟时间 | 磁盘读取延迟时间 | ms | InstanceType InstanceId | [ 5s, max ] [ 10s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
RealCapacity | 磁盘使用空间 | 磁盘使用空间 | MB | InstanceId InstanceType | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
RocksdbBlockCacheBytesRead | rocksdb 读数据块数 | rocksdb 读数据块数 | Bytes | InstanceId InstanceType | [ 5s, max ] [ 10s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
RocksdbBlockCacheBytesWrite | rocksdb 写数据块数 | rocksdb 写数据块数 | Bytes | InstanceId InstanceType | [ 5s, max ] [ 10s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
RocksdbBytesRead | rocksdb 读磁盘量 | rocksdb 读磁盘量 | Bytes | InstanceId InstanceType | [ 5s, max ] [ 10s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
RocksdbBytesWritten | rocksdb 写磁盘量 | rocksdb 写磁盘量 | Bytes | InstanceId InstanceType | [ 5s, max ] [ 10s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
RocksdbWalLogCapacity | rocksdb 写 WAL 日志大小 | rocksdb 写 WAL 日志大小 | MBytes | InstanceId InstanceType | [ 5s, max ] [ 10s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
RplSemiSyncMasterEnabled | 半同步复制开启状态 | 半同步复制开启状态 | Count | InstanceType InstanceId | [ 5s, max ] [ 10s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
SecondsBehindMaster | 主备差距时间 | 主备差距时间 | s | InstanceId InstanceType | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
SelectCount | 查询数 | 查询数 | times/s | InstanceId InstanceType | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
SelectFullJoin | Join 查询中全表扫描次数 | 由于不使用索引而执行全表扫描的查询次数 | Count | InstanceId InstanceType | [ 5s, sum ] [ 60s, sum ] [ 300s, sum ] [ 3600s, sum ] [ 86400s, sum ] |
SelectFullRangeJoin | Join 查询中范围搜索次数 | Join 查询中对引用表使用范围搜索的查询次数 | Count | InstanceType InstanceId | [ 5s, sum ] [ 60s, sum ] [ 300s, sum ] [ 3600s, sum ] [ 86400s, sum ] |
SelectScan | 全表扫描数 | 全表扫描数 | count/s | InstanceId InstanceType | [ 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 | InstanceType InstanceId | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
SlaveSqlRunning | 主实例 SQL 线程状态 | 主实例 SQL 线程状态 | None | InstanceId InstanceType | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
SlowQueries | 慢查询数 | 慢查询数 | count | InstanceId InstanceType | [ 5s, sum ] [ 60s, sum ] [ 300s, sum ] [ 3600s, sum ] [ 86400s, sum ] |
SwitchTimes | 主从切换次数 | 主从切换次数(次) | Count | InstanceId InstanceType | [ 5s, sum ] [ 10s, sum ] [ 60s, sum ] [ 300s, sum ] [ 3600s, sum ] [ 86400s, sum ] |
TableLocksImmediate | 立即释放的表锁数 | 立即释放的表锁数 | Count/s | InstanceId InstanceType | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
TableLocksWaited | 需要等待的表锁数 | 需要等待的表锁数 | times/s | InstanceId InstanceType | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
TableOpenCacheHits | 表缓存命中次数 | 表缓存查找的命中数 | Count | InstanceId InstanceType | [ 5s, sum ] [ 60s, sum ] [ 300s, sum ] [ 3600s, sum ] [ 86400s, sum ] |
TableOpenCacheMisses | 表缓存未命中次数 | 表缓存查找的未命中数 | Count | InstanceId InstanceType | [ 5s, sum ] [ 60s, sum ] [ 300s, sum ] [ 3600s, sum ] [ 86400s, sum ] |
TableOpenCacheOverflows | 表缓存溢出次数 | 表缓存的溢出次数 | Count | InstanceId InstanceType | [ 5s, sum ] [ 60s, sum ] [ 300s, sum ] [ 3600s, sum ] [ 86400s, sum ] |
ThreadsConnected | 当前连接数 | 当前连接数 | Count | InstanceId InstanceType | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
ThreadsCreated | 已创建的线程数 | 已创建的线程数 | Count/s | InstanceId InstanceType | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
ThreadsRunning | 运行的线程数 | 运行的线程数 | Count | InstanceId InstanceType | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
Tps | 每秒执行事务数 | 每秒执行事务数 | times/s | InstanceType InstanceId | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
Uptime | 已启动秒数 | 从上一次服务启动开始，服务存活的秒数 | s | InstanceId InstanceType | [ 5s, last ] [ 60s, last ] [ 300s, last ] [ 3600s, last ] [ 86400s, last ] |
VolumeRate | 磁盘利用率 | 磁盘利用率 | % | InstanceId InstanceType | [ 5s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
WriteLatency | 磁盘写入延迟时间 | 磁盘写入延迟时间 | ms | InstanceId InstanceType | [ 5s, max ] [ 10s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ] |
说明：
数据库代理相关指标（Proxy）维度入参 InstanceType 为必填，取值为 proxy；其余类型指标维度入参 InstanceType 为选填。
维度入参 InstanceId 需填写具体的数据库代理节点 ID。
各维度对应参数总览
参数名称 | 维度名称 | 维度解释 | 格式 |
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 说明：
假设 InstanceId 入参值为主实例的 ID，仅 InstanceType 支持拉取主机（取值为1）、从机（取值为2）、只读实例（取值为3）、第二从机（取值为4）的监控数据。
假设 InstanceId 入参值为主实例的 ID，InstanceType 入参为 2 （从机），且该主实例是三节点（一主两从）。由于拉取从机监控数据仅支持单节点和双节点，会导致缺少一个监控节点数据。
若需要拉取只读实例监控数据，InstanceId 需入参为只读实例 ID。
入参说明
查询云数据库（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 值
