Mx.Load document
Toggle Dark/Light/Auto mode Toggle Dark/Light/Auto mode Toggle Dark/Light/Auto mode Back to homepage
  2. /
  3. 2. Installation
  4. /
  5. 2.6.RDS Monitoring
  6. /
  7. 2.6.2 RDS Monitoring Metrics

2.6.2 RDS Monitoring Metrics

Overview

The metrics available for monitoring in RDS vary depending on the RDS engine. Here, we list the metrics that can be monitored for each engine.

aurora-mysql

Cpu (%)

  • os.cpuUtilization.total.avg
  • os.cpuUtilization.user.avg
  • os.cpuUtilization.wait.avg
  • os.cpuUtilization.guest.avg
  • os.cpuUtilization.idle.avg
  • os.cpuUtilization.irq.avg
  • os.cpuUtilization.nice.avg
  • os.cpuUtilization.steal.avg
  • os.cpuUtilization.system.avg

Memory (byte)

  • os.memory.free.avg
  • os.memory.active.avg
  • os.memory.buffers.avg
  • os.memory.db.cache.avg
  • os.memory.db.swap.avg
  • os.memory.dirty.avg

Disk Latency (millisecond)

  • os.diskIO.auroraStorage.readLatency.avg
  • os.diskIO.auroraStorage.writeLatency.avg

Query (/sec)

  • db.SQL.Queries.avg

Slow Query (/sec)

  • db.SQL.Slow_queries.avg

Connections

  • db.Users.Connections.avg

Dead locks (dead locks/sec)

  • db.Locks.innodb_deadlocks.avg

InnoDB rows (rows/sec)

  • db.SQL.Innodb_rows_deleted.avg
  • db.SQL.Innodb_rows_inserted.avg
  • db.SQL.Innodb_rows_read.avg
  • db.SQL.Innodb_rows_updated.avg

aurora-postgresql

Cpu (%)

  • os.cpuUtilization.total.avg
  • os.cpuUtilization.user.avg
  • os.cpuUtilization.wait.avg
  • os.cpuUtilization.guest.avg
  • os.cpuUtilization.idle.avg
  • os.cpuUtilization.irq.avg
  • os.cpuUtilization.nice.avg
  • os.cpuUtilization.steal.avg
  • os.cpuUtilization.system.avg

Memory (byte)

  • os.memory.free.avg
  • os.memory.active.avg
  • os.memory.buffers.avg
  • os.memory.db.cache.avg
  • os.memory.db.swap.avg
  • os.memory.dirty.avg

Disk Latency (millisecond)

  • os.diskIO.auroraStorage.readLatency.avg
  • os.diskIO.auroraStorage.writeLatency.avg

Query (/sec)

  • db.SQL.Queries.avg

Connections

  • db.User.numbackends.avg

Dead locks (dead locks/sec)

  • db.Concurrency.deadlocks.avg

Tuple rows (tuple/sec)

  • db.SQL.tup_deleted.avg
  • db.SQL.tup_fetched.avg
  • db.SQL.tup_inserted.avg
  • db.SQL.tup_returned.avg
  • db.SQL.tup_updated.avg

mysql

Cpu (%)

  • os.cpuUtilization.total.avg
  • os.cpuUtilization.user.avg
  • os.cpuUtilization.wait.avg
  • os.cpuUtilization.guest.avg
  • os.cpuUtilization.idle.avg
  • os.cpuUtilization.irq.avg
  • os.cpuUtilization.nice.avg
  • os.cpuUtilization.steal.avg
  • os.cpuUtilization.system.avg

Memory (byte)

  • os.memory.free.avg
  • os.memory.active.avg
  • os.memory.buffers.avg
  • os.memory.db.cache.avg
  • os.memory.db.swap.avg
  • os.memory.dirty.avg

Query (/sec)

  • db.SQL.Queries.avg

Slow Query (/sec)

  • db.SQL.Slow_queries.avg

Connections

  • db.Users.Connections.avg

Dead locks (dead locks/sec)

  • db.Locks.innodb_deadlocks.avg

InnoDB rows (rows/sec)

  • db.SQL.Innodb_rows_deleted.avg
  • db.SQL.Innodb_rows_inserted.avg
  • db.SQL.Innodb_rows_read.avg
  • db.SQL.Innodb_rows_updated.avg

mariadb

Cpu (%)

  • os.cpuUtilization.total.avg
  • os.cpuUtilization.user.avg
  • os.cpuUtilization.wait.avg
  • os.cpuUtilization.guest.avg
  • os.cpuUtilization.idle.avg
  • os.cpuUtilization.irq.avg
  • os.cpuUtilization.nice.avg
  • os.cpuUtilization.steal.avg
  • os.cpuUtilization.system.avg

Memory (byte)

  • os.memory.free.avg
  • os.memory.active.avg
  • os.memory.buffers.avg
  • os.memory.db.cache.avg
  • os.memory.db.swap.avg
  • os.memory.dirty.avg

Query (/sec)

  • db.SQL.Queries.avg

Slow Query (/sec)

  • db.SQL.Slow_queries.avg

Connections

  • db.Users.Connections.avg

Dead locks (dead locks/sec)

  • db.Locks.innodb_deadlocks.avg

postgres

Cpu (%)

  • os.cpuUtilization.total.avg
  • os.cpuUtilization.user.avg
  • os.cpuUtilization.wait.avg
  • os.cpuUtilization.guest.avg
  • os.cpuUtilization.idle.avg
  • os.cpuUtilization.irq.avg
  • os.cpuUtilization.nice.avg
  • os.cpuUtilization.steal.avg
  • os.cpuUtilization.system.avg

Memory (byte)

  • os.memory.free.avg
  • os.memory.active.avg
  • os.memory.buffers.avg
  • os.memory.db.cache.avg
  • os.memory.db.swap.avg
  • os.memory.dirty.avg

Latency (millisecond)

  • db.Checkpoint.checkpoint_write_latency.avg
  • db.IO.read_latency.avg

Query (/sec)

  • db.SQL.Queries.avg

Transactions

  • db.Transactions.active_transactions.avg
  • db.Transactions.blocked_transactions.avg

Dead locks (dead locks/sec)

  • db.Concurrency.deadlocks.avg

Tuple rows (tuple/sec)

  • db.SQL.tup_deleted.avg
  • db.SQL.tup_fetched.avg
  • db.SQL.tup_inserted.avg
  • db.SQL.tup_returned.avg
  • db.SQL.tup_updated.avg

OracleDB

Cpu (%)

  • os.cpuUtilization.total.avg
  • os.cpuUtilization.user.avg
  • os.cpuUtilization.wait.avg
  • os.cpuUtilization.guest.avg
  • os.cpuUtilization.idle.avg
  • os.cpuUtilization.irq.avg
  • os.cpuUtilization.nice.avg
  • os.cpuUtilization.steal.avg
  • os.cpuUtilization.system.avg

Memory (byte)

  • os.memory.free.avg
  • os.memory.active.avg
  • os.memory.buffers.avg
  • os.memory.db.cache.avg
  • os.memory.db.swap.avg
  • os.memory.dirty.avg

Usage of swap space (Byte)

  • os.swap.total.avg
  • os.swap.free.avg
  • os.swap.cached.avg

Swapping (Byte)

  • os.swap.in.avg
  • os.swap.out.avg

User calls (calls/sec)

  • db.User.user calls.avg

Logons cumulative (Logon/sec)

  • db.User.logons cumulative.avg

Parse count (parses/s)

  • db.SQL.parse count (total).avg
  • db.SQL.parse count (hard).avg

sqlserver

Cpu (%)

  • os.cpuUtilization.idle.avg
  • os.cpuUtilization.kern.avg
  • os.cpuUtilization.user.avg

Memory (byte)

  • os.memory.physAvailKb.avg
  • os.memory.physTotKb.avg
  • os.memory.sqlServerTotKb.avg
  • os.memory.sysCacheKb.avg

Batch Requests (/sec)

  • db.SQL Statistics.Batch Requests.avg

Connections

  • db.General Statistics.User Connections.avg

Dead locks (dead locks/sec)

  • db.Locks.Number of Deadlocks (_Total).avg