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 Micro Host
- For others: 1 Instance = 1 Micro Host
In addition to this, depending on the number of metrics retrieved, you may be charged for exceeding the maximum number of metrics per micro 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).
The maximum number of metrics obtainable is 52 with Aurora, 51 with Aurora Serverless, and 24 for anything else.
| 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 |
float | 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 |
| Maximum Used Transaction IDs | MaximumUsedTransactionIDs *1 | rds.maximum_used_transaction_ids.count | integer | Average |
| Disk Usage | ReplicationSlotDiskUsage *1 TransactionLogsDiskUsage *1 |
rds.postgres_disk_usage.replication_slot rds.postgres_disk_usage.transaction_logs |
bytes | Average |
| Oldest Replication Slot Lag | OldestReplicationSlotLag *1 | rds.oldest_replication_slot_lag.slot_lag | bytes | Average |
| Transaction Logs Generation | TransactionLogsGeneration *1 | rds.transaction_logs_generation.transaction_log | bytes/sec | Average |
| Failed SQL Server Agent Jobs | FailedSQLServerAgentJobsCount *2 | rds.failed_sql_server_agent_jobs.failed | integer | 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 |
| 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 |
| Backtrack Window Difference | BacktrackWindowActual *3 | rds.aurora.backtrack_window_difference.minutes | integer | Average |
| Backtrack Window Alert | BacktrackWindowAlert *3 | rds.aurora.backtrack_window_alert.alert | integer | Sum |
| Aurora Volume Bytes Left Total | AuroraVolumeBytesLeftTotal *3 | rds.aurora.aurora_volume_bytes_left_total.total | bytes | 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 | float | 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
- gp2 Storage Burst Balance
This is specified by the AWS CloudWatch API.