Mackerel supports obtaining and monitoring Amazon Relational Database Service (RDS) metrics in AWS Integration. When integrating with AWS Integration, billable targets are determined using the following conversions.
- For Aurora Serverless: 1 Cluster = 1 Host
- For others: 1 Instance = 1 Host
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 pages (Aurora and otherwise).
| 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 |
| gp2 Storage Burst Balance | BurstBalance | rds.burst_balance.balance | percentage | 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 |
With Aurora Serverless clusters, in addition to the metrics that can be obtained by Aurora, the following metrics can be obtained.
| Graph name | Metric | Metric name in Mackerel | Unit | Statistics |
|---|---|---|---|---|
| Serverless Database Capacity | ServerlessDatabaseCapacity | rds.aurora.serverless_database_capacity.capacity | integer | Average |
Precautions
Among the graphs/metrics obtainable with AWS Integration, metrics included in the following graphs are usually obtained in 5 minute intervals.
- CPU Credit
- Volume IOPS
- gp2 Storage Burst Balance
This is specified by the AWS CloudWatch API.