阿里云监控云数据库RDS

云数据库SQLServer

产品线监控数据的servicecode:sqlserver。监控数据获取时,tags中的role赋值为M。

metric中文名称英文名称单位说明database.sqlserver.kvm.cpu.utilCPU使用率CPUUsage%database.sqlserver.kvm.memory.usage内存使用率MemoryUsage%database.sqlserver.kvm.disk1.used磁盘使用量UsedDiskMBdatabase.sqlserver.kvm.disk1.usedpercent硬盘使用率DiskUsage%database.sqlserver.kvm.network.bytes.incoming网络入速率NetworkInboundRateKbpsdatabase.sqlserver.kvm.network.bytes.outgoing网络出速率NetworkOutboundRateKbpsdatabase.sqlserver.kvm.disk1.counts.read硬盘读IODiskReadThroughput次/秒database.sqlserver.kvm.disk1.counts.write硬盘写IODiskReadThroughput次/秒database.sqlserver.CheckPoint每秒检查点写入Page数CheckPointWritePagePerSecond个database.sqlserver.Logins每秒登录次数LogInPerSecond次database.sqlserver.FullScans每秒全表扫描次数TableScanPerSecond次database.sqlserver.QPS平均每秒SQL执行次数SQLExecutionPerSecond次database.sqlserver.SQLCompilations每秒SQL编译数SQLCompilationPerSecond次database.sqlserver.LockTimeout每秒锁超时次数LockTimeoutPerSecond次database.sqlserver.Deadlock每秒死锁次数LockDeadPerSecond次database.sqlserver.LockWaits每秒锁等待次数LockWaitPerSecond次database.sqlserver.TPS每秒事务数TPS个database.sqlserver.BufferHit缓存命中率BufferHits%database.sqlserver.ConnectCount总连接数Connections个database.sqlserver.kvm.disk1.currentdiskqueuelength磁盘队列长度DiskQueueLength个database.sqlserver.BlockProcess阻塞进程数ProcessesBlocked个云数据库MySQL

产品线servicecode为database,主备阿里云和只读阿里云分属于不同的指标组(groupcode),查询监控数要求如下:

  • 主备阿里云:所属groupcode为database,监控数据获取时,tags中的role赋值为M。
  • 只读阿里云:所属groupcode为db_ro,监控数据获取时,tags中的role赋值为M。

监控指标数据如下:

metric中文名称英文名称单位说明database.docker.cpu.utilCPU使用率CPUUsage%database.docker.memory.pused内存使用率MemoryUsage%database.docker.disk1.used.kb硬盘空间总使用量UsedDiskMBdatabase.docker.network.incoming网络接收流量NetworkInboundTrafficKbpsdatabase.docker.network.outgoing网络发送流量NetworkOutboundTrafficKbpsdatabase.DBMonitor.ByteIO.Input阿里云每秒输入流量InstanceInTrafficbpsdatabase.DBMonitor.ByteIO.Output阿里云每秒输出流量InstanceOutTrafficbpsdatabase.DBMonitor.QPSTPS.QPS每秒SQL语句执行次数SQLExecutionPerSecond次database.DBMonitor.QPSTPS.TPS每秒事务数TPS个database.DBMonitor.ConnectCount当前总连接数Connections个database.DBMonitor.ConnectCount.Running当前活跃连接数CurrentActiveConnections个database.DBMonitor.TempTable.Count临时表数量TemporaryTables个database.DBMonitor.InnodbBuffer.ReadHitRatioInnoDB缓存池读命中率InnoDBBufferPoolHits%database.DBMonitor.InnodbBuffer.UsageInnoDB缓存池利用率InnoDBBufferPoolUsage%database.DBMonitor.InnodbBuffer.DirtyPagePercentInnoDB缓存池脏块率InnoDBBufferPoolDirtyBlock%database.DBMonitor.InnodbBytesRW.ReadInnoDB每秒读取量InnoDBReadThroughputPerSecondBytesdatabase.DBMonitor.InnodbBytesRW.WriteInnoDB每秒写入量IInnoDBWriteThroughputPerSecondBytesdatabase.DBMonitor.InnodbTimesRW.ReadInnoDB每秒向缓冲池的读次数InnoDBBufferPoolReadPerSecond次database.DBMonitor.InnodbTimesRW.WriteInnoDB每秒向缓冲池的写次数InnoDBBufferPoolWritePerSecond次database.DBMonitor.InnodbLog.WriteInnoDB日志每秒物理写次数InnoDBLogPhysicalWritePerSecond次database.DBMonitor.InnodbOSLog.FsyncsInnoDB日志每秒完成的fsync写数量InnoDBLogFsyncWritePerSecond个database.DBMonitor.CommitTimes.ComSelectSelectSelect次/每秒database.DBMonitor.CommitTimes.ComInsertInsertInsert次/每秒database.DBMonitor.CommitTimes.ComUpdateUpdateUpdate次/每秒database.DBMonitor.CommitTimes.ComDeleteDeleteDelete次/每秒database.DBMonitor.CommitTimes.ComReplaceReplaceReplace次/每秒database.DBMonitor.CommitTimes.ComReplaceSelectReplace_Select次/每秒database.DBMonitor.CommitTimes.ComInsertSelectInsert_SelectInsert_Select次/每秒database.DBMonitor.Stored.Userdata用户数据使用量UsedUserDataMBdatabase.DBMonitor.Stored.Sysdata系统数据使用量UsedSystemDataMBdatabase.DBMonitor.Stored.Logdata日志文件使用量UsedLogFilesMBdatabase.docker.disk.iops.read读IOPSReadIOPS次/秒database.docker.disk.iops.write写IOPSWriteIOPS次/秒database.DBMonitor.Innodb.table_locks_immediate表锁次数Tablelocksimmediate次/秒database.DBMonitor.Innodb.table_locks_waited等待表锁次数Tablelockswaited次/秒database.DBMonitor.Innodb.innodb_row_lock_waitsInnoDB等待行锁次数InnoDBrowlockwaits次/秒database.DBMonitor.Innodb.innodb_row_lock_time_avgInnoDB平均获取行锁时间InnoDBrowlocktimeavgmsdatabase.DBMonitor.slowlog_count慢查询Slowquery次database.DBMonitor.Seconds_Behind_Master只读延迟Readonlylatencys只读阿里云无此指标database.docker.disk1.used硬盘使用率DiskUsage%database.docker.disk1.total.kb硬盘总大小DiskSizeKB云数据库Percona

产品线servicecode为percona,主备阿里云和只读阿里云分属于不同的指标组(groupcode),查询监控数要求如下:

  • 主备阿里云:所属groupcode为percona,监控数据获取时,tags中的role赋值为M。
  • 只读阿里云:所属groupcode为percona_ro,监控数据获取时,tags中的role赋值为M。

监控指标数据如下:

metric中文名称英文名称单位说明database.docker.cpu.utilCPU使用率CPUUsage%database.docker.memory.pused内存使用率MemoryUsage%database.docker.disk1.used.kb硬盘空间总使用量UsedDiskMBdatabase.docker.network.incoming网络接收流量NetworkInboundTrafficKbpsdatabase.docker.network.outgoing网络发送流量NetworkOutboundTrafficKbpsdatabase.DBMonitor.ByteIO.Input阿里云每秒输入流量InstanceInTrafficbpsdatabase.DBMonitor.ByteIO.Output阿里云每秒输出流量InstanceOutTrafficbpsdatabase.DBMonitor.QPSTPS.QPS每秒SQL语句执行次数SQLExecutionPerSecond次database.DBMonitor.QPSTPS.TPS每秒事务数TPS个database.DBMonitor.ConnectCount当前总连接数Connections个database.DBMonitor.ConnectCount.Running当前活跃连接数CurrentActiveConnections个database.DBMonitor.TempTable.Count临时表数量TemporaryTables个database.DBMonitor.InnodbBuffer.ReadHitRatioInnoDB缓存池读命中率InnoDBBufferPoolHits%database.DBMonitor.InnodbBuffer.UsageInnoDB缓存池利用率InnoDBBufferPoolUsage%database.DBMonitor.InnodbBuffer.DirtyPagePercentInnoDB缓存池脏块率InnoDBBufferPoolDirtyBlock%database.DBMonitor.InnodbBytesRW.ReadInnoDB每秒读取量InnoDBReadThroughputPerSecondBytesdatabase.DBMonitor.InnodbBytesRW.WriteInnoDB每秒写入量IInnoDBWriteThroughputPerSecondBytesdatabase.DBMonitor.InnodbTimesRW.ReadInnoDB每秒向缓冲池的读次数InnoDBBufferPoolReadPerSecond次database.DBMonitor.InnodbTimesRW.WriteInnoDB每秒向缓冲池的写次数InnoDBBufferPoolWritePerSecond次database.DBMonitor.InnodbLog.WriteInnoDB日志每秒物理写次数InnoDBLogPhysicalWritePerSecond次database.DBMonitor.InnodbOSLog.FsyncsInnoDB日志每秒完成的fsync写数量InnoDBLogFsyncWritePerSecond个database.DBMonitor.CommitTimes.ComSelectSelectSelect次/每秒database.DBMonitor.CommitTimes.ComInsertInsertInsert次/每秒database.DBMonitor.CommitTimes.ComUpdateUpdateUpdate次/每秒database.DBMonitor.CommitTimes.ComDeleteDeleteDelete次/每秒database.DBMonitor.CommitTimes.ComReplaceReplaceReplace次/每秒database.DBMonitor.CommitTimes.ComReplaceSelectReplace_Select次/每秒database.DBMonitor.CommitTimes.ComInsertSelectInsert_SelectInsert_Select次/每秒database.DBMonitor.Stored.Userdata用户数据使用量UsedUserDataMBdatabase.DBMonitor.Stored.Sysdata系统数据使用量UsedSystemDataMBdatabase.DBMonitor.Stored.Logdata日志文件使用量UsedLogFilesMBdatabase.docker.disk.iops.read读IOPSReadIOPS次/秒database.docker.disk.iops.write写IOPSWriteIOPS次/秒database.DBMonitor.Innodb.table_locks_immediate表锁次数Tablelocksimmediate次/秒database.DBMonitor.Innodb.table_locks_waited等待表锁次数Tablelockswaited次/秒database.DBMonitor.Innodb.innodb_row_lock_waitsInnoDB等待行锁次数InnoDBrowlockwaits次/秒database.DBMonitor.Innodb.innodb_row_lock_time_avgInnoDB平均获取行锁时间InnoDBrowlocktimeavgmsdatabase.DBMonitor.slowlog_count慢查询Slowquery次database.DBMonitor.Seconds_Behind_Master只读延迟Readonlylatencys只读阿里云无此指标database.docker.disk1.used硬盘使用率DiskUsage%云数据库MariaDB

产品线servicecode为mariadb,主备阿里云和只读阿里云分属于不同的指标组(groupcode),查询监控数要求如下:

  • 主备阿里云:所属groupcode为mariadb,监控数据获取时,tags中的role赋值为M。
  • 只读阿里云:所属groupcode为mariadb_ro,监控数据获取时,tags中的role赋值为M。

监控指标数据如下:

metric中文名称英文名称单位说明database.docker.cpu.utilCPU使用率CPUUsage%database.docker.memory.pused内存使用率MemoryUsage%database.docker.disk1.used.kb硬盘空间总使用量UsedDiskMBdatabase.docker.network.incoming网络接收流量NetworkInboundTrafficKbpsdatabase.docker.network.outgoing网络发送流量NetworkOutboundTrafficKbpsdatabase.DBMonitor.ByteIO.Input阿里云每秒输入流量InstanceInTrafficbpsdatabase.DBMonitor.ByteIO.Output阿里云每秒输出流量InstanceOutTrafficbpsdatabase.DBMonitor.QPSTPS.QPS每秒SQL语句执行次数SQLExecutionPerSecond次database.DBMonitor.QPSTPS.TPS每秒事务数TPS个database.DBMonitor.ConnectCount当前总连接数Connections个database.DBMonitor.ConnectCount.Running当前活跃连接数CurrentActiveConnections个database.DBMonitor.TempTable.Count临时表数量TemporaryTables个database.DBMonitor.InnodbBuffer.ReadHitRatioInnoDB缓存池读命中率InnoDBBufferPoolHits%database.DBMonitor.InnodbBuffer.UsageInnoDB缓存池利用率InnoDBBufferPoolUsage%database.DBMonitor.InnodbBuffer.DirtyPagePercentInnoDB缓存池脏块率InnoDBBufferPoolDirtyBlock%database.DBMonitor.InnodbBytesRW.ReadInnoDB每秒读取量InnoDBReadThroughputPerSecondBytesdatabase.DBMonitor.InnodbBytesRW.WriteInnoDB每秒写入量IInnoDBWriteThroughputPerSecondBytesdatabase.DBMonitor.InnodbTimesRW.ReadInnoDB每秒向缓冲池的读次数InnoDBBufferPoolReadPerSecond次database.DBMonitor.InnodbTimesRW.WriteInnoDB每秒向缓冲池的写次数InnoDBBufferPoolWritePerSecond次database.DBMonitor.InnodbLog.WriteInnoDB日志每秒物理写次数InnoDBLogPhysicalWritePerSecond次database.DBMonitor.InnodbOSLog.FsyncsInnoDB日志每秒完成的fsync写数量InnoDBLogFsyncWritePerSecond个database.DBMonitor.CommitTimes.ComSelectSelectSelect次/每秒database.DBMonitor.CommitTimes.ComInsertInsertInsert次/每秒database.DBMonitor.CommitTimes.ComUpdateUpdateUpdate次/每秒database.DBMonitor.CommitTimes.ComDeleteDeleteDelete次/每秒database.DBMonitor.CommitTimes.ComReplaceReplaceReplace次/每秒database.DBMonitor.CommitTimes.ComReplaceSelectReplace_Select次/每秒database.DBMonitor.CommitTimes.ComInsertSelectInsert_SelectInsert_Select次/每秒database.DBMonitor.Stored.Userdata用户数据使用量UsedUserDataMBdatabase.DBMonitor.Stored.Sysdata系统数据使用量UsedSystemDataMBdatabase.DBMonitor.Stored.Logdata日志文件使用量UsedLogFilesMBdatabase.docker.disk.iops.read读IOPSReadIOPS次/秒database.docker.disk.iops.write写IOPSWriteIOPS次/秒database.DBMonitor.Innodb.table_locks_immediate表锁次数Tablelocksimmediate次/秒database.DBMonitor.Innodb.table_locks_waited等待表锁次数Tablelockswaited次/秒database.DBMonitor.Innodb.innodb_row_lock_waitsInnoDB等待行锁次数InnoDBrowlockwaits次/秒database.DBMonitor.Innodb.innodb_row_lock_time_avgInnoDB平均获取行锁时间InnoDBrowlocktimeavgmsdatabase.DBMonitor.slowlog_count慢查询Slowquery次database.DBMonitor.Seconds_Behind_Master只读延迟Readonlylatencys只读阿里云无此指标database.docker.disk1.used硬盘使用率DiskUsage%database.docker.disk1.used.kb硬盘空间总使用量UsedDiskMB云数据库PostgreSQL

产品线servicecode为pg,主备阿里云和只读阿里云分属于不同的指标组(groupcode),查询监控数要求如下:

  • 主备阿里云:所属groupcode为pg,监控数据获取时,tags中的role赋值为M。
  • 只读阿里云:所属groupcode为pg_ro,监控数据获取时,tags中的role赋值为M。

监控指标数据如下:

metric中文名称英文名称单位说明database.DBMonitor.ConnectCount当前总连接数Connections个database.DBMonitor.ConnectCount.Running当前活跃连接数CurrentActiveConnections个database.docker.memory.pused内存使用率MemoryUsage%database.docker.cpu.utilCPU使用率CPUUsage%database.DBMonitor.Stored.Userdata用户数据使用量UsedUserDataKBdatabase.DBMonitor.Stored.Logdata日志文件使用量UsedLogFilesKBdatabase.docker.disk1.usage硬盘空间使用率DiskUsage%database.docker.disk.iops.read读IOPSReadIOPS次/秒database.docker.disk.iops.write写IOPSWriteIOPS次/秒database.docker.network.bytes.incoming每秒输入流量NetworkInboundTrafficbpsdatabase.docker.network.bytes.outgoing每秒输出流量NetworkOutboundTrafficbpsdatabase.DBMonitor.Rows.Fetched扫描行数RowsFetched行/秒database.DBMonitor.Rows.Returned返回行数RowsReturned行/秒database.DBMonitor.Lock.AccessShare访问共享锁ACCESSSHARE个database.DBMonitor.Lock.RowShare行共享锁ROWSHARE个database.DBMonitor.Lock.RowExclusive行唯一锁ROWEXCLUSIVE个database.DBMonitor.Lock.ShareUpdateExclusive共享更新唯一锁SHAREUPDATEEXCLUSIVE个database.DBMonitor.Lock.Share共享锁SHARE个database.DBMonitor.Lock.ShareRowExclusive共享行唯一锁SHAREROWEXCLUSIVE个database.DBMonitor.Lock.Exclusive唯一锁EXCLUSIVE个