AWS Integration - RDS

Mackerel supports obtaining and monitoring Amazon Relational Database Service (RDS) metrics in AWS Integration.

Please refer to the following page for AWS Integration configuration methods and a list of supported AWS services.
AWS Integration

Obtaining metrics

The metrics obtainable with AWS Integration’s RDS support are as follows. For Metric explanations, refer to the AWS help page.

Graph name Metric Metric name in Mackerel Unit Statistics
CPU CPUUtilization rds.cpu.used percentage Average
CPU Credit CPUCreditUsage
CPUCreditBalance
rds.cpu_credit.used
rds.cpu_credit.balance
integer Average
Database Connections DatabaseConnections rds.database_connections.used float Average
Disk Queue DiskQueueDepth rds.disk_queue.depth float Average
BinLog Disk Usage BinLogDiskUsage rds.disk_usage.bin_log bytes Average
Memory FreeableMemory
SwapUsage
rds.memory.free
rds.memory.swap
bytes Average
Free Storage Space FreeStorageSpace rds.disk.free bytes Average
Replica Lag ReplicaLag rds.replica_lag.lag float Average
Disk IOPS ReadIOPS
WriteIOPS
rds.diskiops.read
rds.diskiops.write
iops Average
Disk Latency ReadLatency
WriteLatency
rds.latency.read
rds.latency.write
float Average
Disk Throughput ReadThroughput
WriteThroughput
rds.throughput.read
rds.throughput.write
bytes/sec Average
Network Throughput NetworkReceiveThroughput
NetworkTransmitThroughput
rds.network_throughput.read
rds.network_throughput.transmit
bytes/sec Average

In addition to the above, metrics that can be obtained with Aurora are listed below.

Graph name Metric Metric name in Mackerel Unit Statistics
Storage FreeLocalStorage rds.aurora.storage.free bytes Average
Volume Bytes Used VolumeBytesUsed rds.aurora.volume_bytes_used.used bytes Average
Volume IOPS VolumeReadIOPS
VolumeWriteIOPS
rds.aurora.volume_iops.read
rds.aurora.volume_iops.write
iops Average
BinLog Replica Lag AuroraBinLogReplicaLag rds.aurora.binlog_replica_lag.lag float Average
Replica Lag AuroraReplicaLag
AuroraReplicaLagMaximum
AuroraReplicaLagMinimum
rds.aurora.replica_lag.lag
rds.aurora.replica_lag.max_lag
rds.aurora.replica_lag.min_lag
float Average
Engine Uptime EngineUptime rds.aurora.engine_uptime.uptime float Average
Transactions ActiveTransactions
BlockedTransactions
rds.aurora.transactions.active
rds.aurora.transactions.blocked
float Average
Cache Hit Ratio BufferCacheHitRatio
ResultSetCacheHitRatio
rds.aurora.hit_ratio.buffer
rds.aurora.hit_ratio.result_set
percentage Average
DML Latency InsertLatency
UpdateLatency
DeleteLatency
DMLLatency
rds.aurora.dml_latency.insert
rds.aurora.dml_latency.update
rds.aurora.dml_latency.delete
rds.aurora.dml_latency.dml
float Average
DML throughput InsertThroughput
UpdateThroughput
DeleteThroughput
DMLThroughput
rds.aurora.dml_throughput.insert
rds.aurora.dml_throughput.update
rds.aurora.dml_throughput.delete
rds.aurora.dml_throughput.dml
float Average
Commit Latency CommitLatency rds.aurora.commit_latency.commit float Average
Commit Throughput CommitThroughput rds.aurora.commit_throughput.commit float Average
Select Latency SelectLatency rds.aurora.select_latency.select float Average
Select Throughput SelectThroughput rds.aurora.select_throughput.select float Average
DDL Latency DDLLatency rds.aurora.ddl_latency.ddl float Average
DDL Throughput DDLThroughput rds.aurora.ddl_throughput.ddl float Average
Queries Queries rds.aurora.queries.queries float Average
Login Failures LoginFailures rds.aurora.login_failures.failures float Average
Deadlocks Deadlocks rds.aurora.deadlocks.deadlocks float Average

Precautions

Among the graphs/metrics obtainable with AWS Integration, metrics included in the following graphs are usually obtained in 5 minute intervals (only when using T2 instances).

  • CPU Credit
  • Volume IOPS

This is specified by the AWS CloudWatch API.

When creating monitoring rules for metrics with a 5-minute interval, the “condition duration” can only be configured for “monitoring an average value of 1 minute” (if any other value is selected, monitoring will not be done due to insufficient data points necessary for calculating the average value).