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 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 view the RDS dashboard:

Go to one.newrelic.com > All capabilities > Infrastructure > AWS.
From the list of AWS services, scroll-down to RDS then click the RDS Dashboard link.

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.