• Log inStart now

Amazon RDS monitoring integration

Important

Enable the AWS CloudWatch Metric Streams integration to monitor all CloudWatch metrics from your AWS services, including custom namespaces. Individual integrations are no longer our recommended option.

New Relic infrastructure integrations include an integration for reporting your Amazon Web Services RDS data to New Relic. This document explains how to activate this integration and describes the data that can be reported.

New Relic also offers an integration for enhanced RDS monitoring.

Features

Amazon's Relational Database Service (RDS) is a web service that makes it easier to set up, operate, and scale a relational database in the cloud. It provides cost-efficient, resizable capacity for an industry-standard relational database and manages common database administration tasks.

New Relic's RDS monitoring integration gathers metric and configuration data for the relational databases associated with your Amazon RDS account. Your RDS data is available in pre-built dashboards and you can also create custom queries and charts. You can create alert conditions for RDS data, and use the reported data to plan for future RDS capacity.

Activate integration

To enable this integration follow standard procedures to Connect AWS services to New Relic.

Configuration and polling

You can change the polling frequency and filter data using configuration options.

Default polling information for the Amazon RDS integration:

  • New Relic polling interval: 5 minutes
  • Amazon CloudWatch data interval: 1 minute for RDS instances; 5 minutes for RDS clusters

Find and use data

To find your integration data, go to one.newrelic.com > Infrastructure > AWS and select one of the RDS integration links.

You can query and explore your data using the DatastoreSample event type, with a provider value of RdsDbInstance for DB instances, or RdsDbCluster for Aurora DB clusters.

For more on how to use your data, see Understand and use integration data.

Metric data

This integration collects Amazon RDS data for clusters and also for instances. Some RDS instance metrics are distinct for cluster instances and stand-alone instances.

RDS cluster metric data

Name

Description

volumeBytesUsed

Volume bytes used.

volumeReadIops

Volume read IOPs.

volumeWriteIops

Volume write IOPs.

RDS instance common metric data

Metric

Description

cpuCreditUsage

The number of CPU credits consumed during the specified period.

cpuCreditBalance

The number of CPU credits that an instance has accumulated.

cpuUtilization

The percentage of CPU used by a DB instance.

databaseConnections

The number of connections to an instance.

diskQueueDepth

The number of outstanding read/write requests waiting to access the disk.

freeableMemoryBytes

The amount of available random access memory, in bytes.

maximumUsedTransactionIDs

The age of the oldest unvacuumed transaction ID, in transactions.

networkReceiveThroughput

The amount of network throughput received from clients by each instance in the Aurora MySQL DB cluster, in bytes per second.

networkTransmitThroughput

The amount of network throughput sent to clients by each instance in the Aurora DB cluster, in bytes per second.

readLatency

The average amount of time taken per disk I/O operation, in seconds.

readThroughput

The average number of bytes read from disk per second.

swapUsageBytes

The amount of swap space used on the Aurora PostgreSQL DB instance, in bytes.

transactionLogsDiskUsageBytes

The amount of disk space occupied by transaction logs on the Aurora PostgreSQL DB instance, in bytes.

RDS cluster instance data

Metric

Description

activeTransactions

The average number of current transactions executing on an Aurora database instance per second.

auroraReplicaLag

For an Aurora Replica, the amount of lag when replicating updates from the primary instance, in milliseconds.

auroraReplicaLagMaximum

The maximum amount of lag between the primary instance and each Aurora DB instance in the DB cluster, in milliseconds.

auroraReplicaLagMinimum

The minimum amount of lag between the primary instance and each Aurora DB instance in the DB cluster, in milliseconds.

backtrackChangeRecordsCreationRate

The number of backtrack change records created over five minutes for your DB cluster.

backtrackChangeRecordsStored

The actual number of backtrack change records used by your DB cluster.

backtrackWindowActual

The difference between the target backtrack window and the actual backtrack window.

backtrackWindowAlert

The number of times that the actual backtrack window is smaller than the target backtrack window for a given period of time.

blockedTransactions

The average number of transactions in the database that are blocked per second.

bufferCacheHitRatio

The percentage of requests that are served by the buffer cache.

commitLatency

The amount of latency for commit operations, in milliseconds.

commitThroughput

The average number of commit operations per second.

ddlLatency

The amount of latency for data definition language (DDL) requests, in milliseconds—for example, create, alter, and drop requests.

ddlThroughput

The average number of DDL requests per second.

deadlocks

The average number of deadlocks in the database per second.

deleteLatency

The amount of latency for delete queries, in milliseconds.

deleteThroughput

The average number of delete queries per second.

dmlLatency

The amount of latency for inserts, updates, and deletes, in milliseconds.

dmlThroughput

The average number of inserts, updates, and deletes per second.

engineUptime

The amount of time that the instance has been running, in seconds.

failedSqlStatements

This metric, displayed under the SQL category of the latest metrics view in the Amazon RDS console, does not apply to Amazon Aurora.

freeLocalStorageBytes

The amount of storage available for temporary tables and logs, in bytes.

insertLatency

The amount of latency for insert queries, in milliseconds.

insertThroughput

The average number of insert queries per second.

loginFailures

The average number of failed login attempts per second.

networkThroughput

The amount of network throughput both received from and transmitted to clients by each instance in the Aurora MySQL DB cluster, in bytes per second.

queries

The average number of queries executed per second.

rdsToAuroraPostgreSQLReplicaLag

The amount of lag in seconds when replicating updates from the primary RDS PostgreSQL instance to other nodes in the cluster.

resultSetCacheHitRatio

The percentage of requests that are served by the Resultset cache.

selectLatency

The amount of latency for select queries, in milliseconds.

selectThroughput

The average number of select queries per second.

totalConnections

Total number of connections to the database instance.

updateLatency

The amount of latency for update queries, in milliseconds.

updateThroughput

The average number of update queries per second.

volumeReadIOPs

The number of billed read I/O operations from a cluster volume, reported at 5-minute intervals.

volumeWriteIOPs

The number of write disk I/O operations to the cluster volume, reported at 5-minute intervals.

RDS stand-alone instance data

Metric

Description

allocatedStorageBytes

Specifies the allocated storage size, in bytes. Note this data doesn't come from an AWS CloudWatch metric, but from the allocatedStorage inventory attribute.

binLogDiskUsageBytes

The amount of disk space occupied by binary logs on the master, in bytes.

diskQueueDepth

The number of outstanding read/write requests waiting to access the disk.

freeStorageSpaceBytes

The amount of storage available for tables and logs, in bytes.

maximumUsedTransactionIDs

The age of the oldest unvacuumed transaction ID, in transactions.

oldestReplicationSlotLag

Shows how far behind in seconds the most lagging replica is in terms of WAL data received.

readIops

The average number of disk I/O operations per second.

readLatency

The average amount of time taken per disk I/O operation.

readThroughput

The average number of bytes read from disk per second.

replicaLag

The amount of lag when replicating updates from the primary instance, in milliseconds.

replicationSlotDiskUsage

The amount of disk space occupied by replication slots.

swapUsageBytes

The amount of swap space used on the Aurora PostgreSQL DB instance, in bytes.

transactionLogsDiskUsage

The amount of disk space occupied by transaction logs on the Aurora PostgreSQL DB instance.

transactionLogsGeneration

How much storage is being used for WAL data.

writeIops

The average number of disk I/O operations per second.

writeLatency

The average amount of time taken per disk I/O operation.

writeThroughput

The average number of bytes written to disk per second.

Copyright © 2022 New Relic Inc.