Documentation forAppOptics

Relational Database Service (RDS)

Overview

Amazon Relational Database Service (Amazon RDS) makes it easy to set up, operate, and scale a relational database in the cloud.

Setup

Installation

If you haven't already, first set up the AWS CloudWatch integration. No additional steps are needed for installation.

Configuration

On the AWS CloudWatch integration page, ensure that the RDS service is selected for metric collection.

Metrics

Amazon RDS

Name Description

BinLogDiskUsage

(bytes)

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

Applies to MySQL read replicas.

BurstBalance

(percent)

The percent of General Purpose SSD (gp2) burst-bucket I/O credits available.

CPUUtilization

(percent)

The percentage of CPU utilization.

CPUCreditUsage

(count)

[T2 instances] The number of CPU credits consumed by the instance.

CPUCreditBalance

(count)

[T2 instances] The number of CPU credits available for the instance to burst beyond its base CPU utilization.

DatabaseConnections

(count)

The number of database connections in use.

DiskQueueDepth

(count)

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

FreeableMemory

(bytes)

The amount of available random access memory.

FreeStorageSpace

(bytes)

The amount of available storage space.

MaximumUsedTransactionIDs

(count)

The maximum transaction ID that has been used. Applies to PostgreSQL.

NetworkReceiveThroughput

(bytes/second)

The incoming (Receive) network traffic on the DB instance, including both customer database traffic and Amazon RDS traffic used for monitoring and replication.

NetworkTransmitThroughput

(bytes/second)

The outgoing (Transmit) network traffic on the DB instance, including both customer database traffic and Amazon RDS traffic used for monitoring and replication.

OldestReplicationSlotLag

(megabytes)

The lagging size of the replica lagging the most in terms of WAL data received. Applies to PostgreSQL.

ReadIOPS

(count/second)

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

ReadLatency

(seconds)

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

ReadThroughput

(bytes/second)

The average number of bytes read from disk per second.

ReplicaLag

(seconds)

The amount of time a Read Replica DB instance lags behind the source DB instance. Applies to MySQL, MariaDB, and PostgreSQL Read Replicas.

ReplicationSlotDiskUsage

(megabytes)

The disk space used by replication slot files. Applies to PostgreSQL.

SwapUsage

(bytes)

The amount of swap space used on the DB instance

TransactionLogsDiskUsage

(megabytes)

The disk space used by transaction logs. Applies to PostgreSQL.

TransactionLogsGeneration

(megabytes/second)

The size of transaction logs generated per second. Applies to PostgreSQL.

WriteIOPS

(count/second)

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

WriteLatency

(seconds)

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

WriteThroughput

(bytes/second)

The average number of bytes written to disk per second.

Amazon Aurora

Name Description
ActiveTransactions (count/second) The average number of current transactions executing on an Aurora database instance.
AuroraBinlogReplicaLag (seconds) The amount of time a replica DB cluster running on Aurora with MySQL compatibility lags behind the source DB cluster. This metric reports the value of the Seconds_Behind_Master field of the MySQL SHOW SLAVE STATUS command.
AuroraReplicaLag (milliseconds) The amount of lag when replicating updates from the primary instance.
AuroraReplicaLagMaximum (milliseconds) The maximum amount of lag between the primary instance and each Aurora DB instance in the DB cluster.
AuroraReplicaLagMinimum (milliseconds) The minimum amount of lag between the primary instance and each Aurora DB instance in the DB cluster.
BinLogDiskUsage (bytes) The amount of disk space occupied by binary logs on the master.
BlockedTransactions (count/second) The average number of transactions in the database that are blocked.
BufferCacheHitRatio (percent) The percentage of requests that are served by the buffer cache.
CommitLatency (milliseconds) The amount of latency for commit operations.
CommitThroughput (count/second) The average number of commit operations.
CPUCreditBalance (count) The number of CPU credits that an instance has accumulated. This metric applies only to db.t2.small and db.t2.medium instances. It is used to determine how long an Aurora MySQL DB instance can burst beyond its baseline performance level at a given rate. CPU credit metrics are reported at 5-minute intervals.
CPUCreditUsage (count) The number of CPU credits consumed during the specified period. This metric applies only to db.t2.small and db.t2.medium instances. It identifies the amount of time during which physical CPUs have been used for processing instructions by virtual CPUs allocated to the Aurora MySQL DB instance. CPU credit metrics are reported at 5-minute intervals.
CPUUtilization (percent) The percentage of CPU used by an Aurora DB instance.
DatabaseConnections (count) The number of connections to an Aurora DB instance.
DDLLatency (milliseconds) The amount of latency for data definition language (DDL) requests (for example, create, alter, and drop requests).
DDLThroughput (count/second) The average number of DDL requests.
Deadlocks (count/second) The average number of deadlocks in the database.
DeleteLatency (milliseconds) The amount of latency for delete queries.
DeleteThroughput (count/second) The average number of delete queries.
DiskQueueDepth (count) The number of outstanding read/write requests waiting to access the disk.
DMLLatency (milliseconds) The amount of latency for inserts, updates, and deletes.
DMLThroughput (count/second) The average number of inserts, updates, and deletes.
EngineUptime (seconds) The amount of time that the instance has been running.
FreeableMemory (bytes) The amount of available random access memory.
FreeLocalStorage (bytes) The amount of storage available for temporary tables and logs. Unlike for other DB engines, for Aurora DB instances this metric reports the amount of storage available to each DB instance for temporary tables and logs. This value depends on the DB instance class.
InsertLatency (milliseconds) The amount of latency for insert queries.
InsertThroughput (count/second) The average number of insert queries.
LoginFailures (count/second) The average number of failed login attempts.
MaximumUsedTransactionIDs (transactions) The age of the oldest unvacuumed transaction ID. If this value reaches 2,146,483,648 (2^31 - 1,000,000), the database is forced into read-only mode, to avoid transaction ID wraparound.
NetworkReceiveThroughput (bytes/second) The amount of network throughput received from clients by each instance in the Aurora MySQL DB cluster. This throughput doesn't include network traffic between instances in the Aurora DB cluster and the cluster volume.
NetworkThroughput (bytes/second) The amount of network throughput both received from and transmitted to clients by each instance in the Aurora MySQL DB cluster. This throughput doesn't include network traffic between instances in the DB cluster and the cluster volume.
NetworkTransmitThroughput (bytes/second) The amount of network throughput sent to clients by each instance in the Aurora DB cluster. This throughput doesn't include network traffic between instances in the DB cluster and the cluster volume.
Queries (count/second) The average number of queries executed.
ReadIOPS (count/second) The average number of disk I/O operations. Aurora with PostgreSQL compatibility reports read and write IOPS separately, on 1-minute intervals.
ReadLatency (milliseconds) The average amount of time taken per disk I/O operation.
ReadThroughput (bytes/second) The average number of bytes read from disk per second.
ResultSetCacheHitRatio (percent) The percentage of requests that are served by the Resultset cache.
SelectLatency (milliseconds) The amount of latency for select queries.
SelectThroughput (count/second) The average number of select queries per second.
SwapUsage The amount of swap space used on the Aurora PostgreSQL DB instance.
TransactionLogsDiskUsage The amount of disk space occupied by transaction logs on the Aurora PostgreSQL DB instance.
UpdateLatency (milliseconds) The amount of latency for update queries.
UpdateThroughput (count/second) The average number of update queries per second.
VolumeBytesUsed (bytes) The amount of storage used by your Aurora DB instance. This value affects the cost of the Aurora DB cluster.
VolumeReadIOPs (count) The average number of billed read I/O operations from a cluster volume, reported at 5-minute intervals.
VolumeWriteIOPs (count) The average number of write disk I/O operations to the cluster volume, reported at 5-minute intervals.
WriteIOPS (count/second) The average number of disk I/O operations per second. Aurora PostgreSQL reports read and write IOPS separately, on 1-minute intervals.
WriteLatency (milliseconds) The average amount of time taken per disk I/O operation.
WriteThroughput (bytes/second) The average number of bytes written to disk.

Available Tags

Name Description
awsaccount AWS account associated with the metrics
az Availability zone of the cluster
databaseclass Type of database class
dbclusteridentifier ID of the Aurora DB cluster
dbclusterrole The role for the Aurora DB cluster (writer or replica)
dbinstanceidentifier ID of the database instance
enginename Name of the DB engine
region Name of the region

Navigation Notice: When the APM Integrated Experience is enabled, AppOptics shares a common navigation and enhanced feature set with other integrated experience products. How you navigate AppOptics and access its features may vary from these instructions.