Amazon CloudWatch metrics for Amazon Aurora (original) (raw)

AbortedClients

The number of client connections that have not been closed properly.

Aurora MySQL

Count

ActiveTransactions

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

By default, Aurora doesn't enable this metric. To begin measuring this value, setinnodb_monitor_enable='all' in the DB parameter group for a specific DB instance.

Aurora MySQL

Count per second

ACUUtilization

The value of the ServerlessDatabaseCapacity metric divided by the maximum ACU value of the DB cluster.

This metric is applicable only for Aurora Serverless v2.

Aurora MySQL and Aurora PostgreSQL

Percentage

AuroraBinlogReplicaLag

The amount of time that a binary log replica DB cluster running on Aurora MySQL lags behind the binary log replication source. A lag means that the source is generating records faster than the replica can apply them.

This metric reports different values depending on the engine version:

Aurora MySQL version 2

The Seconds_Behind_Master field of the MySQL SHOW SLAVE STATUS

Aurora MySQL version 3

SHOW REPLICA STATUS

You can use this metric to monitor errors and replica lag in a cluster that acts as a binary log replica. The metric value indicates the following:

A high value

The replica is lagging the replication source.

0 or a value close to 0

The replica process is active and current.

-1

Aurora can't determine the lag, which can happen during replica setup or when the replica is in an error state.

Because binary log replication only occurs on the writer instance of the cluster, we recommend using the version of this metric associated with the WRITER role.

For more information about administering replication, see Replicating Amazon Aurora MySQL DB clusters across AWS Regions. For more information about troubleshooting, see Amazon Aurora MySQL replication issues.

Primary for Aurora MySQL

Seconds

AuroraDMLRejectedMasterFull

The number of forwarded queries that are rejected because the session is full on the writer DB instance.

Primary for Aurora MySQL version 2

Count

AuroraDMLRejectedWriterFull

The number of forwarded queries that are rejected because the session is full on the writer DB instance.

Primary for Aurora MySQL version 3

Count

AuroraEstimatedSharedMemoryBytes

The estimated amount of shared buffer or buffer pool memory which was actively used during the last configured polling interval.

Aurora PostgreSQL

Bytes

AuroraMemoryHealthState

Indicates the memory health state. A value of 0 equals NORMAL. A value of 10 equalsRESERVED, which means that the server is approaching a critical level of memory usage.

For more information, see Troubleshooting out-of-memory issues for Aurora MySQL databases.

Aurora MySQL version 3.06.1 and higher

Gauge

AuroraMemoryNumDeclinedSqlTotal

The incremental number of queries declined as part of out-of-memory (OOM) avoidance.

For more information, see Troubleshooting out-of-memory issues for Aurora MySQL databases.

Aurora MySQL version 3.06.1 and higher

Count

AuroraMemoryNumKillConnTotal

The incremental number of connections closed as part of OOM avoidance.

For more information, see Troubleshooting out-of-memory issues for Aurora MySQL databases.

Aurora MySQL version 3.06.1 and higher

Count

AuroraMemoryNumKillQueryTotal

The incremental number of queries ended as part of OOM avoidance.

For more information, see Troubleshooting out-of-memory issues for Aurora MySQL databases.

Aurora MySQL version 3.06.1 and higher

Count

AuroraMillisecondsSpentInOomRecovery

The amount of time since the memory health dropped below the normal state.

For more information, see Troubleshooting out-of-memory issues for Aurora MySQL databases.

Aurora MySQL version 3.08.0 and higher

Milliseconds

AuroraNumOomRecoverySuccessful

The number of times that the memory health was restored to the normal state.

For more information, see Troubleshooting out-of-memory issues for Aurora MySQL databases.

Aurora MySQL version 3.08.0 and higher

Count

AuroraNumOomRecoveryTriggered

The number of times that the memory health dropped below the normal state.

For more information, see Troubleshooting out-of-memory issues for Aurora MySQL databases.

Aurora MySQL version 3.08.0 and higher

Count

AuroraOptimizedReadsCacheHitRatio

The percentage of requests that are served by the Optimized Reads cache.

The value is calculated using the following formula:

orcache_blks_hit/ (orcache_blks_hit + storage_blks_read)

When AuroraOptimizedReadsCacheHitRatio is 100%, it means that all pages were read from the optimized reads cache. If the AuroraOptimizedReadsCacheHitRatio is 0, it means that no pages were read from the optimized reads cache.

Primary for Aurora PostgreSQL

Percentage

AuroraReplicaLag

For an Aurora replica, the amount of lag when replicating updates from the primary instance.

Replica for Aurora MySQL and Aurora PostgreSQL

Milliseconds

AuroraReplicaLagMaximum

The maximum amount of lag between the primary instance and any of the Aurora DB instance in the DB cluster.

When read replicas are deleted or renamed, there can be a temporary spike in replication lag as the old resource undergoes a recycling process. To obtain an accurate representation of the replication lag during that period, we recommend that you monitor theAuroraReplicaLag metric on each read replica instance.

Primary for Aurora MySQL and Aurora PostgreSQL

Milliseconds

AuroraReplicaLagMinimum

The minimum amount of lag between the primary instance and any of the Aurora DB instance in the DB cluster.

Primary for Aurora MySQL and Aurora PostgreSQL

Milliseconds

AuroraSlowConnectionHandleCount

The number of connections that have waited two seconds or longer to start the handshake.

This metric applies only to Aurora MySQL version 3.

Aurora MySQL

Count

AuroraSlowHandshakeCount

The number of connections that have taken 50 milliseconds or longer to finish the handshake.

This metric applies only to Aurora MySQL version 3.

Aurora MySQL

Count

BacktrackWindowActual

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

Primary for Aurora MySQL

Minutes

BacktrackWindowAlert

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

Primary for Aurora MySQL

Count

BlockedTransactions

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

Aurora MySQL

Count per second

BufferCacheHitRatio

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

Aurora MySQL and Aurora PostgreSQL

Percentage

CommitLatency

The average duration taken by the engine and storage to complete the commit operations.

Aurora MySQL and Aurora PostgreSQL

Milliseconds

CommitThroughput

The average number of commit operations per second.

Aurora MySQL and Aurora PostgreSQL

Count per second

ConnectionAttempts

The number of attempts to connect to an instance, whether successful or not.

Aurora MySQL

Count

CPUCreditBalance

The number of CPU credits that an instance has accumulated, reported at 5-minute intervals. You can use this metric to determine how long a DB instance can burst beyond its baseline performance level at a given rate.

This metric applies only to these instance classes:

Note

We recommend using the T DB instance classes only for development and test servers, or other non-production servers. For more details on the T instance classes, see DB instance class types.

Launch credits work the same way in Amazon RDS as they do in Amazon EC2. For more information, see Launch credits in the Amazon Elastic Compute Cloud User Guide for Linux Instances.

Aurora MySQL and Aurora PostgreSQL

Count

CPUCreditUsage

The number of CPU credits consumed during the specified period, reported at 5-minute intervals. This metric measures the amount of time during which physical CPUs have been used for processing instructions by virtual CPUs allocated to the DB instance.

This metric applies only to these instance classes:

Note

We recommend using the T DB instance classes only for development and test servers, or other non-production servers. For more details on the T instance classes, see DB instance class types.

Aurora MySQL and Aurora PostgreSQL

Count

CPUSurplusCreditBalance

The number of surplus credits that have been spent by an unlimited instance when its CPUCreditBalance value is zero.

The CPUSurplusCreditBalance value is paid down by earned CPU credits. If the number of surplus credits exceeds the maximum number of credits that the instance can earn in a 24-hour period, the spent surplus credits above the maximum incur an additional charge.

CPU credit metrics are available at a 5-minute frequency only.

Aurora MySQL and Aurora PostgreSQL

Credits (vCPU-minutes)

CPUSurplusCreditsCharged

The number of spent surplus credits that are not paid down by earned CPU credits, and which thus incur an additional charge.

Spent surplus credits are charged when any of the following occurs:

CPU credit metrics are available at a 5-minute frequency only.

Aurora MySQL and Aurora PostgreSQL

Credits (vCPU-minutes)

CPUUtilization

The percentage of CPU used by an Aurora DB instance.

Aurora MySQL and Aurora PostgreSQL

Percentage

DatabaseConnections

The number of client network connections to the database instance.

The number of database sessions can be higher than the metric value because the metric value doesn't include the following:

Aurora MySQL and Aurora PostgreSQL

Count

DDLLatency

The average duration of requests such as example, create, alter, and drop requests.

Aurora MySQL

Milliseconds

DDLThroughput

The average number of DDL requests per second.

Aurora MySQL

Count per second

Deadlocks

The average number of deadlocks in the database per second.

Aurora MySQL and Aurora PostgreSQL

Count per second

DeleteLatency

The average duration of delete operations.

Aurora MySQL

Milliseconds

DeleteThroughput

The average number of delete queries per second.

Aurora MySQL

Count per second

DiskQueueDepth

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

Aurora MySQL and Aurora PostgreSQL

Count

DMLLatency

The average duration of inserts, updates, and deletes.

Aurora MySQL

Milliseconds

DMLThroughput

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

Aurora MySQL

Count per second

EngineUptime

The amount of time that the instance has been running.

Aurora MySQL and Aurora PostgreSQL

Seconds

FreeableMemory

The amount of available random access memory. For Aurora MySQL and Aurora PostgreSQL databases, this metric reports the value of the MemAvailable field of /proc/meminfo.

Aurora MySQL and Aurora PostgreSQL

Bytes

FreeEphemeralStorage

The amount of available Ephemeral NVMe storage.

Aurora PostgreSQL

Bytes

FreeLocalStorage

The amount of local storage available.

Unlike for other DB engines, for Aurora DB instances this metric reports the amount of storage available to each DB instance. This value depends on the DB instance class (for pricing information, see the Amazon RDS pricing page). You can increase the amount of free storage space for an instance by choosing a larger DB instance class for your instance.

(This doesn't apply to Aurora Serverless v2.)

Aurora MySQL and Aurora PostgreSQL

Bytes

InsertLatency

The average duration of insert operations.

Aurora MySQL

Milliseconds

InsertThroughput

The average number of insert operations per second.

Aurora MySQL

Count per second

LoginFailures

The average number of failed login attempts per second.

Aurora MySQL

Count per second

MaximumUsedTransactionIDs

The age of the oldest unvacuumed transaction ID, in transactions. 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. For more information, see Preventing transaction ID wraparound failures in the PostgreSQL documentation.

Aurora PostgreSQL

Count

NetworkReceiveThroughput

The amount of network throughput received from clients by each instance in the Aurora DB cluster. This throughput doesn't include network traffic between instances in the Aurora DB cluster and the cluster volume.

Aurora MySQL and Aurora PostgreSQL

Bytes per second (console shows Megabytes per second)

NetworkThroughput

The amount of network throughput both received from and transmitted to clients by each instance in the Aurora DB cluster. This throughput doesn't include network traffic between instances in the Aurora DB cluster and the cluster volume.

Aurora MySQL and Aurora PostgreSQL

Bytes per second

NetworkTransmitThroughput

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.

Aurora MySQL and Aurora PostgreSQL

Bytes per second (console shows Megabytes per second)

NumBinaryLogFiles

The number of binlog files generated.

Aurora MySQL

Count

OldestReplicationSlotLag

The lagging size of the replica lagging the most in terms of write-ahead log (WAL) data received.

Aurora PostgreSQL

Bytes

PurgeBoundary

Transaction number up to which InnoDB purging is allowed. If this metric doesn't advance for extended periods of time, it's a good indication that InnoDB purging is blocked by long-running transactions. To investigate, check the active transactions on your Aurora MySQL DB cluster.

Aurora MySQL version 2, versions 2.11 and higher

Aurora MySQL version 3, versions 3.08 and higher

Count

PurgeFinishedPoint

Transaction number up to which InnoDB purging is performed. This metric can help you examine how fast InnoDB purging is progressing.

Aurora MySQL version 2, versions 2.11 and higher

Aurora MySQL version 3, versions 3.08 and higher

Count

Queries

The average number of queries executed per second.

Aurora MySQL

Count per second

RDSToAuroraPostgreSQLReplicaLag

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

Replica for Aurora PostgreSQL

Seconds

ReadIOPS

The average number of disk I/O operations per second but the reports read and write separately, in 1-minute intervals.

Aurora MySQL and Aurora PostgreSQL

Count per second

ReadIOPSEphemeralStorage

The average number of disk read I/O operations to Ephemeral NVMe storage.

Aurora PostgreSQL

Count per second

ReadLatency

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

Aurora MySQL and Aurora PostgreSQL

Seconds

ReadLatencyEphemeralStorage

The average amount of time taken per disk read I/O operation for Ephemeral NVMe storage.

Aurora PostgreSQL

Milliseconds

ReadThroughput

The average number of bytes read from disk per second.

Aurora MySQL and Aurora PostgreSQL

Bytes per second

ReadThroughputEphemeralStorage

The average number of bytes read from disk per second for Ephemeral NVMe storage.

Aurora PostgreSQL

Bytes per second

ReplicationSlotDiskUsage

The amount of disk space consumed by replication slot files.

Aurora PostgreSQL

Bytes

ResultSetCacheHitRatio

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

Aurora MySQL version 2

Percentage

RollbackSegmentHistoryListLength

The undo logs that record committed transactions with delete-marked records. These records are scheduled to be processed by the InnoDB purge operation.

Aurora MySQL

Count

RowLockTime

The total time spent acquiring row locks for InnoDB tables.

Aurora MySQL

Milliseconds

SelectLatency

The average amount of time for select operations.

Aurora MySQL

Milliseconds

SelectThroughput

The average number of select queries per second.

Aurora MySQL

Count per second

ServerlessDatabaseCapacity

The current capacity of an Aurora Serverless DB cluster.

Aurora MySQL and Aurora PostgreSQL

Count

StorageNetworkReceiveThroughput

The amount of network throughput received from the Aurora storage subsystem by each instance in the DB cluster.

Aurora MySQL and Aurora PostgreSQL

Bytes per second

StorageNetworkThroughput

The amount of network throughput received from and sent to the Aurora storage subsystem by each instance in the Aurora DB cluster.

Aurora MySQL and Aurora PostgreSQL

Bytes per second

StorageNetworkTransmitThroughput

The amount of network throughput sent to the Aurora storage subsystem by each instance in the Aurora DB cluster.

Aurora MySQL and Aurora PostgreSQL

Bytes per second

SumBinaryLogSize

The total size of the binlog files.

Aurora MySQL

Bytes

SwapUsage

The amount of swap space used. This metric isn't available for the following DB instance classes:

Aurora MySQL and Aurora PostgreSQL

Bytes

TempStorageIOPS

The number of IOPS for both read and writes on local storage attached to the DB instance. This metric represents a count and is measured once per second.

This metric is applicable only for Aurora Serverless v2.

Aurora MySQL and Aurora PostgreSQL

Count per second

TempStorageThroughput

The amount of data transferred to and from local storage associated with the DB instance. This metric represents bytes and is measured once per second.

This metric is applicable only for Aurora Serverless v2.

Aurora MySQL and Aurora PostgreSQL

Bytes per second

TransactionAgeMaximum

The age of the oldest active running transaction.

Aurora MySQL version 3, versions 3.08 and higher

Seconds

TransactionLogsDiskUsage

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

This metric is generated only when Aurora PostgreSQL is using logical replication or AWS Database Migration Service. By default, Aurora PostgreSQL uses log records, not transaction logs. When transaction logs aren't in use, the value for this metric is -1.

Primary for Aurora PostgreSQL

Bytes

TruncateFinishedPoint

The transaction identifier up to which undo truncation is performed.

Aurora MySQL version 2, versions 2.11 and higher

Aurora MySQL version 3, versions 3.08 and higher

Count

UpdateLatency

The average amount of time taken for update operations.

Aurora MySQL

Milliseconds

UpdateThroughput

The average number of updates per second.

Aurora MySQL

Count per second

WriteIOPS

The number of Aurora storage write records generated per second. This is more or less the number of log records generated by the database. These do not correspond to 8K page writes, and do not correspond to network packets sent.

Aurora MySQL and Aurora PostgreSQL

Count per second

WriteIOPSEphemeralStorage

The average number of disk write I/O operations to Ephemeral NVMe storage.

Aurora PostgreSQL

Count per second

WriteLatency

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

Aurora MySQL and Aurora PostgreSQL

Seconds

WriteLatencyEphemeralStorage

The average amount of time taken per disk write I/O operation for Ephemeral NVMe storage.

Aurora PostgreSQL

Milliseconds

WriteThroughput

The average number of bytes written to persistent storage every second.

Aurora MySQL and Aurora PostgreSQL

Bytes per second

WriteThroughputEphemeralStorage

The average number of bytes written to disk per second for Ephemeral NVMe storage.

Aurora PostgreSQL

Bytes per second