| title | tags | metaDescription | redirects | |||||||
|---|---|---|---|---|---|---|---|---|---|---|
Amazon RDS monitoring integration |
|
New Relic's RDS monitoring integration: what data it reports, and how to enable it. |
|
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.
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 in New Relic One. You can create alert conditions for RDS data, and use the reported data to plan for future RDS capacity.
To enable this integration follow standard procedures to Connect AWS services to New Relic.
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
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.
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.
<th>
Description
</th>
</tr>
<td>
Volume bytes used.
</td>
</tr>
<tr>
<td>
`volumeReadIops`
</td>
<td>
Volume read IOPs.
</td>
</tr>
<tr>
<td>
`volumeWriteIops`
</td>
<td>
Volume write IOPs.
</td>
</tr>
| Name |
|---|
| `volumeBytesUsed` |
<th>
Description
</th>
</tr>
<td>
The number of CPU credits consumed during the specified period.
</td>
</tr>
<tr>
<td>
`cpuCreditBalance`
</td>
<td>
The number of CPU credits that an instance has accumulated.
</td>
</tr>
<tr>
<td>
`cpuUtilization`
</td>
<td>
The percentage of CPU used by a DB instance.
</td>
</tr>
<tr>
<td>
`databaseConnections`
</td>
<td>
The number of connections to an instance.
</td>
</tr>
<tr>
<td>
`diskQueueDepth`
</td>
<td>
The number of outstanding read/write requests waiting to access the disk.
</td>
</tr>
<tr>
<td>
`freeableMemoryBytes`
</td>
<td>
The amount of available random access memory, in bytes.
</td>
</tr>
<tr>
<td>
`maximumUsedTransactionIDs`
</td>
<td>
The age of the oldest unvacuumed transaction ID, in transactions.
</td>
</tr>
<tr>
<td>
`networkReceiveThroughput`
</td>
<td>
The amount of network throughput received from clients by each instance in the Aurora MySQL DB cluster, in bytes per second.
</td>
</tr>
<tr>
<td>
`networkTransmitThroughput`
</td>
<td>
The amount of network throughput sent to clients by each instance in the Aurora DB cluster, in bytes per second.
</td>
</tr>
<tr>
<td>
`readLatency`
</td>
<td>
The average amount of time taken per disk I/O operation, in seconds.
</td>
</tr>
<tr>
<td>
`readThroughput`
</td>
<td>
The average number of bytes read from disk per second.
</td>
</tr>
<tr>
<td>
`swapUsageBytes`
</td>
<td>
The amount of swap space used on the Aurora PostgreSQL DB instance, in bytes.
</td>
</tr>
<tr>
<td>
`transactionLogsDiskUsageBytes`
</td>
<td>
The amount of disk space occupied by transaction logs on the Aurora PostgreSQL DB instance, in bytes.
</td>
</tr>
| Metric |
|---|
| `cpuCreditUsage` |
<th>
Description
</th>
</tr>
<td>
The average number of current transactions executing on an Aurora database instance per second.
</td>
</tr>
<tr>
<td>
`auroraReplicaLag`
</td>
<td>
For an Aurora Replica, the amount of lag when replicating updates from the primary instance, in milliseconds.
</td>
</tr>
<tr>
<td>
`auroraReplicaLagMaximum`
</td>
<td>
The maximum amount of lag between the primary instance and each Aurora DB instance in the DB cluster, in milliseconds.
</td>
</tr>
<tr>
<td>
`auroraReplicaLagMinimum`
</td>
<td>
The minimum amount of lag between the primary instance and each Aurora DB instance in the DB cluster, in milliseconds.
</td>
</tr>
<tr>
<td>
`backtrackChangeRecordsCreationRate`
</td>
<td>
The number of backtrack change records created over five minutes for your DB cluster.
</td>
</tr>
<tr>
<td>
`backtrackChangeRecordsStored`
</td>
<td>
The actual number of backtrack change records used by your DB cluster.
</td>
</tr>
<tr>
<td>
`backtrackWindowActual`
</td>
<td>
The difference between the target backtrack window and the actual backtrack window.
</td>
</tr>
<tr>
<td>
`backtrackWindowAlert`
</td>
<td>
The number of times that the actual backtrack window is smaller than the target backtrack window for a given period of time.
</td>
</tr>
<tr>
<td>
`blockedTransactions`
</td>
<td>
The average number of transactions in the database that are blocked per second.
</td>
</tr>
<tr>
<td>
`bufferCacheHitRatio`
</td>
<td>
The percentage of requests that are served by the buffer cache.
</td>
</tr>
<tr>
<td>
`commitLatency`
</td>
<td>
The amount of latency for commit operations, in milliseconds.
</td>
</tr>
<tr>
<td>
`commitThroughput`
</td>
<td>
The average number of commit operations per second.
</td>
</tr>
<tr>
<td>
`ddlLatency`
</td>
<td>
The amount of latency for data definition language (DDL) requests, in milliseconds—for example, create, alter, and drop requests.
</td>
</tr>
<tr>
<td>
`ddlThroughput`
</td>
<td>
The average number of DDL requests per second.
</td>
</tr>
<tr>
<td>
`deadlocks`
</td>
<td>
The average number of deadlocks in the database per second.
</td>
</tr>
<tr>
<td>
`deleteLatency`
</td>
<td>
The amount of latency for delete queries, in milliseconds.
</td>
</tr>
<tr>
<td>
`deleteThroughput`
</td>
<td>
The average number of delete queries per second.
</td>
</tr>
<tr>
<td>
`dmlLatency`
</td>
<td>
The amount of latency for inserts, updates, and deletes, in milliseconds.
</td>
</tr>
<tr>
<td>
`dmlThroughput`
</td>
<td>
The average number of inserts, updates, and deletes per second.
</td>
</tr>
<tr>
<td>
`engineUptime`
</td>
<td>
The amount of time that the instance has been running, in seconds.
</td>
</tr>
<tr>
<td>
`failedSqlStatements`
</td>
<td>
This metric, displayed under the SQL category of the latest metrics view in the Amazon RDS console, does not apply to Amazon Aurora.
</td>
</tr>
<tr>
<td>
`freeLocalStorageBytes`
</td>
<td>
The amount of storage available for temporary tables and logs, in bytes.
</td>
</tr>
<tr>
<td>
`insertLatency`
</td>
<td>
The amount of latency for insert queries, in milliseconds.
</td>
</tr>
<tr>
<td>
`insertThroughput`
</td>
<td>
The average number of insert queries per second.
</td>
</tr>
<tr>
<td>
`loginFailures`
</td>
<td>
The average number of failed login attempts per second.
</td>
</tr>
<tr>
<td>
`networkThroughput`
</td>
<td>
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.
</td>
</tr>
<tr>
<td>
`queries`
</td>
<td>
The average number of queries executed per second.
</td>
</tr>
<tr>
<td>
`rdsToAuroraPostgreSQLReplicaLag`
</td>
<td>
The amount of lag in seconds when replicating updates from the primary RDS PostgreSQL instance to other nodes in the cluster.
</td>
</tr>
<tr>
<td>
`resultSetCacheHitRatio`
</td>
<td>
The percentage of requests that are served by the Resultset cache.
</td>
</tr>
<tr>
<td>
`selectLatency`
</td>
<td>
The amount of latency for select queries, in milliseconds.
</td>
</tr>
<tr>
<td>
`selectThroughput`
</td>
<td>
The average number of select queries per second.
</td>
</tr>
<tr>
<td>
`totalConnections`
</td>
<td>
Total number of connections to the database instance.
</td>
</tr>
<tr>
<td>
`updateLatency`
</td>
<td>
The amount of latency for update queries, in milliseconds.
</td>
</tr>
<tr>
<td>
`updateThroughput`
</td>
<td>
The average number of update queries per second.
</td>
</tr>
<tr>
<td>
`volumeReadIOPs`
</td>
<td>
The number of billed read I/O operations from a cluster volume, reported at 5-minute intervals.
</td>
</tr>
<tr>
<td>
`volumeWriteIOPs`
</td>
<td>
The number of write disk I/O operations to the cluster volume, reported at 5-minute intervals.
</td>
</tr>
| Metric |
|---|
| `activeTransactions` |
<th>
Description
</th>
</tr>
<td>
Specifies the allocated storage size, in bytes. Note this data doesn't come from an AWS CloudWatch metric, but from the `allocatedStorage` inventory attribute.
</td>
</tr>
<tr>
<td>
`binLogDiskUsageBytes`
</td>
<td>
The amount of disk space occupied by binary logs on the master, in bytes.
</td>
</tr>
<tr>
<td>
`diskQueueDepth`
</td>
<td>
The number of outstanding read/write requests waiting to access the disk.
</td>
</tr>
<tr>
<td>
`freeStorageSpaceBytes`
</td>
<td>
The amount of storage available for tables and logs, in bytes.
</td>
</tr>
<tr>
<td>
`maximumUsedTransactionIDs`
</td>
<td>
The age of the oldest unvacuumed transaction ID, in transactions.
</td>
</tr>
<tr>
<td>
`oldestReplicationSlotLag`
</td>
<td>
Shows how far behind in seconds the most lagging replica is in terms of WAL data received.
</td>
</tr>
<tr>
<td>
`readIops`
</td>
<td>
The average number of disk I/O operations per second.
</td>
</tr>
<tr>
<td>
`readLatency`
</td>
<td>
The average amount of time taken per disk I/O operation.
</td>
</tr>
<tr>
<td>
`readThroughput`
</td>
<td>
The average number of bytes read from disk per second.
</td>
</tr>
<tr>
<td>
`replicaLag`
</td>
<td>
The amount of lag when replicating updates from the primary instance, in milliseconds.
</td>
</tr>
<tr>
<td>
`replicationSlotDiskUsage`
</td>
<td>
The amount of disk space occupied by replication slots.
</td>
</tr>
<tr>
<td>
`swapUsageBytes`
</td>
<td>
The amount of swap space used on the Aurora PostgreSQL DB instance, in bytes.
</td>
</tr>
<tr>
<td>
`transactionLogsDiskUsage`
</td>
<td>
The amount of disk space occupied by transaction logs on the Aurora PostgreSQL DB instance.
</td>
</tr>
<tr>
<td>
`transactionLogsGeneration`
</td>
<td>
How much storage is being used for WAL data.
</td>
</tr>
<tr>
<td>
`writeIops`
</td>
<td>
The average number of disk I/O operations per second.
</td>
</tr>
<tr>
<td>
`writeLatency`
</td>
<td>
The average amount of time taken per disk I/O operation.
</td>
</tr>
<tr>
<td>
`writeThroughput`
</td>
<td>
The average number of bytes written to disk per second.
</td>
</tr>
| Metric |
|---|
| `allocatedStorageBytes` |
This integration supports the following RDS inventory data. For more about inventory data, see Understand integration data.
Tags (indicated with an **\***) are only fetched when [tags collection](/docs/integrations/new-relic-integrations/getting-started/configure-polling-frequency-data-collection-cloud-integrations#collect_tags) is on. <th>
Description
</th>
</tr>
<td>
The storage space allocated to this instance, in gibibytes.
</td>
</tr>
<tr>
<td>
`autoMinorVersionUpgrade`
</td>
<td>
Boolean. If `true`, indicates that minor version patches are applied to this instance automatically.
</td>
</tr>
<tr>
<td>
`availabilityZone`
</td>
<td>
The [RDS availability zone](http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Concepts.RegionsAndAvailabilityZones.html) for this instance.
</td>
</tr>
<tr>
<td>
`awsRegion`
</td>
<td>
The [RDS region](http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Concepts.RegionsAndAvailabilityZones.html) for this instance.
</td>
</tr>
<tr>
<td>
`backupRetentionPeriod`
</td>
<td>
Count of the number of days RDS preserves [automated backups](http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_WorkingWithAutomatedBackups.html) for this instance.
</td>
</tr>
<tr>
<td>
`caCertificateIdentifier`
</td>
<td>
The CA certificate for this instance.
</td>
</tr>
<tr>
<td>
`dbInstanceClass`
</td>
<td>
The [DB instance class](http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Concepts.DBInstanceClass.html) for this instance.
</td>
</tr>
<tr>
<td>
`dbInstancePort`
</td>
<td>
Integer representing the port where this instance listens for traffic. If the instance is part of a cluster, this port may not be the port assigned to the overall database cluster.
</td>
</tr>
<tr>
<td>
`dbInstanceStatus`
</td>
<td>
The [DB instance status](http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Overview.DBInstance.Status.html) for this instance.
</td>
</tr>
<tr>
<td>
`dbName`
</td>
<td>
The meaning of this configuration option depends on the database engine:
* Amazon Aurora, MariaDB, MySQL, PostgreSQL, and SQL Server: Indicates the name specified when the instance was created.
* Oracle: Indicates the Oracle System ID (SID) for this instance.
</td>
</tr>
<tr>
<td>
`dbParameterGroups`
</td>
<td>
JSON string that lists [DB parameter groups](http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_WorkingWithParamGroups.html) for this instance.
</td>
</tr>
<tr>
<td>
`dbSecurityGroups`
</td>
<td>
JSON string that lists [DB security groups](http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_WorkingWithSecurityGroups.html) for this instance. Only collects data from the `DBSecurityGroup.Name` and `DBSecurityGroup.Status` sub-elements.
</td>
</tr>
<tr>
<td>
`dbSubnetGroup`
</td>
<td>
JSON string that lists details about the instance's [DB subnet group](http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_VPC.WorkingWithRDSInstanceinaVPC.html#USER_VPC.Subnets), including the name and description for each subnet in the subnet group.
</td>
</tr>
<tr>
<td>
`engine`
</td>
<td>
The name of the database engine running on this instance.
</td>
</tr>
<tr>
<td>
`engineVersion`
</td>
<td>
The version identifier for the database engine running on this instance.
</td>
</tr>
<tr>
<td>
`licenseModel`
</td>
<td>
The license identifier for the database engine running on this instance. For example, `general-public-license`.
</td>
</tr>
<tr>
<td>
`multiAz`
</td>
<td>
Boolean. If `true`, indicates this instance is a [multi-availability-zone deployment](https://aws.amazon.com/rds/details/multi-az/).
</td>
</tr>
<tr>
<td>
`optionGroupMemberships`
</td>
<td>
JSON string that lists any [option group memberships](http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_WorkingWithOptionGroups.html) for this instance.
</td>
</tr>
<tr>
<td>
`publiclyAccessible`
</td>
<td>
Boolean. If `true`, indicates an Internet-facing instance with a publicly resolvable DNS name, which resolves to a public IP address.
If `false`, indicates an internal instance with a DNS name that resolves to a private IP address.
</td>
</tr>
<tr>
<td>
`secondaryAvailabilityZone`
</td>
<td>
If present, indicates the name of the secondary availability zone for a [multi-availability-zone deployment](https://aws.amazon.com/rds/details/multi-az/).
</td>
</tr>
<tr>
<td>
`storageEncrypted`
</td>
<td>
Boolean. If `true`, indicates that the database on this instance is encrypted.
</td>
</tr>
<tr>
<td>
`storageType`
</td>
<td>
Indicates the [RDS storage type](http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_Storage.html#Concepts.Storage) for this instance.
</td>
</tr>
<tr>
<td>
`vpcSecurityGroups`
</td>
<td>
JSON string that lists the [VPC security groups](http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Overview.RDSSecurityGroups.html#Overview.RDSSecurityGroups.VPCSec) for this instance.
</td>
</tr>
<tr>
<td>
`tags`\*
</td>
<td>
Cluster tags.
</td>
</tr>
| Name |
|---|
| `allocatedStorage` |
<th>
Description
</th>
</tr>
<td>
The AWS region that the instance was provisioned in.
</td>
</tr>
<tr>
<td>
`dbInstanceIdentifier`
</td>
<td>
Contains a user-supplied database identifier. This identifier is the unique key that identifies a DB instance.
</td>
</tr>
<tr>
<td>
`allocatedStorage`
</td>
<td>
Specifies the allocated storage size, in gibibytes.
</td>
</tr>
<tr>
<td>
`autoMinorVersionUpgrade`
</td>
<td>
Indicates that minor version patches are applied automatically.
</td>
</tr>
<tr>
<td>
`availabilityZone`
</td>
<td>
Specifies the name of the Availability Zone the DB instance is located in.
</td>
</tr>
<tr>
<td>
`backupRetentionPeriod`
</td>
<td>
Specifies the number of days for which automatic DB snapshots are retained.
</td>
</tr>
<tr>
<td>
`caCertificateIdentifier`
</td>
<td>
The identifier of the CA certificate for this DB instance.
</td>
</tr>
<tr>
<td>
`characterSetName`
</td>
<td>
If present, specifies the name of the character set that this instance is associated with.
</td>
</tr>
<tr>
<td>
`dbClusterIdentifier`
</td>
<td>
If the DB instance is a member of a DB cluster, contains the name of the DB cluster that the DB instance is member of.
</td>
</tr>
<tr>
<td>
`dbInstanceClass`
</td>
<td>
Contains the name of the compute and memory capacity class of the DB instance.
</td>
</tr>
<tr>
<td>
`dbInstancePort`
</td>
<td>
Specifies the port that the DB instance listens on. If the DB instance is part of a DB cluster, this can be a different port than the DB cluster port.
</td>
</tr>
<tr>
<td>
`dbInstanceStatus`
</td>
<td>
Specifies the current state of this database.
</td>
</tr>
<tr>
<td>
`dbName`
</td>
<td>
Contains the name of the initial database of this instance that was provided at create time, if one was specified when the DB instance was created. This same name is returned for the life of the DB instance.
</td>
</tr>
<tr>
<td>
`dbParameterGroups`
</td>
<td>
Provides the list of DB parameter groups applied to this DB instance.
</td>
</tr>
<tr>
<td>
`dbSecurityGroups`
</td>
<td>
Provides List of DB security group elements.
</td>
</tr>
<tr>
<td>
`dbParameterGroups`
</td>
<td>
Provides the list of DB parameter groups.
</td>
</tr>
<tr>
<td>
`dbSubnetGroup`
</td>
<td>
Specifies information on the subnet group associated with the DB instance, including the name, description, and subnets in the subnet group.
</td>
</tr>
<tr>
<td>
`endpoint`
</td>
<td>
Specifies the connection endpoint.
</td>
</tr>
<tr>
<td>
`engine`
</td>
<td>
Provides the name of the database engine to be used for this DB instance.
</td>
</tr>
<tr>
<td>
`engineVersion`
</td>
<td>
Indicates the database engine version.
</td>
</tr>
<tr>
<td>
`kmsKeyId`
</td>
<td>
If StorageEncrypted is true, the AWS KMS key identifier for the encrypted DB instance.
</td>
</tr>
<tr>
<td>
`licenseModel`
</td>
<td>
License model information for this DB instance.
</td>
</tr>
<tr>
<td>
`masterUsername`
</td>
<td>
Contains the master username for the DB instance.
</td>
</tr>
<tr>
<td>
`multiAz`
</td>
<td>
Specifies if the DB instance is a Multi-AZ deployment.
</td>
</tr>
<tr>
<td>
`optionGroupMemberships`
</td>
<td>
Provides the list of option group memberships for this DB instance.
</td>
</tr>
<tr>
<td>
`preferredBackupWindow`
</td>
<td>
Specifies the daily time range during which automated backups are created if automated backups are enabled, as determined by the BackupRetentionPeriod.
</td>
</tr>
<tr>
<td>
`preferredMaintenanceWindow`
</td>
<td>
Specifies the weekly time range during which system maintenance can occur, in Universal Coordinated Time (UTC).
</td>
</tr>
<tr>
<td>
`publiclyAccessible`
</td>
<td>
Specifies the accessibility options for the DB instance. A value of true specifies an Internet-facing instance with a publicly resolvable DNS name, which resolves to a public IP address. A value of false specifies an internal instance with a DNS name that resolves to a private IP address.
</td>
</tr>
<tr>
<td>
`readReplicaDdInstanceIdentifiers`
</td>
<td>
Contains one or more identifiers of the Read Replicas associated with this DB instance.
</td>
</tr>
<tr>
<td>
`readReplicaSourceDbInstanceIdentifier`
</td>
<td>
Contains the identifier of the source DB instance if this DB instance is a Read Replica.
</td>
</tr>
<tr>
<td>
`secondaryAvailabilityZone`
</td>
<td>
If present, specifies the name of the secondary Availability Zone for a DB instance with multi-AZ support.
</td>
</tr>
<tr>
<td>
`storageEncrypted`
</td>
<td>
Specifies whether the DB instance is encrypted.
</td>
</tr>
<tr>
<td>
`storageType`
</td>
<td>
Specifies the storage type associated with DB instance.
</td>
</tr>
<tr>
<td>
`tdeCredentialArn`
</td>
<td>
The ARN from the key store with which the instance is associated for TDE encryption.
</td>
</tr>
<tr>
<td>
`vpcSecurityGroups`
</td>
<td>
Provides a list of VPC security group elements that the DB instance belongs to.
</td>
</tr>
<tr>
<td>
`clusterInstance`
</td>
<td>
If the instance is a cluster or not.
</td>
</tr>
<tr>
<td>
`tags`\*
</td>
<td>
Instance tags.
</td>
</tr>
| Name |
|---|
| `awsRegion` |