Menu
Amazon Relational Database Service
User Guide (API Version 2014-10-31)

Monitoring an Amazon Aurora DB Cluster

Amazon Aurora provides a variety of Amazon CloudWatch metrics that you can monitor to determine the health and performance of your Aurora DB cluster. You can use various tools, such as the Amazon RDS console, AWS CLI, and CloudWatch API, to view Aurora metrics. For more information, see Monitoring Amazon RDS.

Aurora Metrics

The following metrics are available from Amazon Aurora.

Metric Description

ActiveTransactions

The average number of current transactions executing on a DB instance per second.

AuroraBinlogReplicaLag

The amount of time an Aurora DB cluster lags behind the source DB cluster.

This metric reports the value of the Seconds_Behind_Master field of the MySQL SHOW SLAVE STATUS command and is useful for monitoring replica lag between Aurora DB clusters that are replicating across different AWS regions. For more information, see Replicating Amazon Aurora DB Clusters Across AWS Regions.

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 instance in the DB cluster, in milliseconds.

AuroraReplicaLagMinimum

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

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.

CPUCreditBalance

The number of CPU credits that an instance has accumulated. This metric applies only to db.t2.small and db.t2.medium instances. It's used to determine how long an instance can burst beyond its baseline performance level at a given rate.

Note

CPU credit metrics are reported at 5-minute intervals.

CPUCreditUsage

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 instance.

Note

CPU credit metrics are reported at 5-minute intervals.

CPUUtilization

The percentage of CPU used by a DB instance.

DatabaseConnections

The number of connections to a DB instance.

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.

FreeableMemory

The amount of available random access memory, in bytes.

FreeLocalStorage

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

Unlike for other DB engines, for Amazon Aurora 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 (for pricing information, see the Amazon RDS product page). You can increase the amount of free storage space for an instance by choosing a larger DB instance class for your instance.

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.

NetworkReceiveThroughput

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

NetworkThroughput

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

NetworkTransmitThroughput

The amount of network throughput sent to clients by each instance in the DB cluster, in bytes per second. This throughput doesn't include network traffic between instances in the DB cluster and the cluster volume.

Queries

The average number of queries executed per second.

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.

UpdateLatency

The amount of latency for update queries, in milliseconds.

UpdateThroughput

The average number of update queries per second.

VolumeBytesUsed

The amount of storage used by your Aurora database, in bytes.

This value affects the cost of the Aurora DB cluster (for pricing information, see the Amazon RDS product page).

VolumeReadIOPS

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

Billed read operations are calculated at the cluster volume level, aggregated from all instances in the DB cluster, and then reported at 5-minute intervals. The value is calculated by taking the value of the Read operations metric over a 5-minute period. You can determine the amount of billed read operations per second by taking the value of the Billed read operations metric and dividing by 300 seconds. For example, if the Billed read operations returns 13,686, then the billed read operations per second is 45 (13,686 / 300 = 45.62).

You accrue billed read operations for queries that request database pages that are not present in the buffer cache and therefore must be loaded from storage. You might see spikes in billed read operations as query results are read from storage and then loaded into the buffer cache.

VolumeWriteIOPS

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

Viewing Aurora Metrics in the Amazon RDS Console

To monitor the health and performance of your Aurora DB cluster, you can view some, but not all, of the metrics provided by Amazon Aurora in the Amazon RDS console. For a detailed list of Aurora metrics available to the Amazon RDS console, see Aurora Metrics Available in the Amazon RDS Console.

To view Aurora metrics in the Amazon RDS console

  1. Sign in to the AWS Management Console and open the Amazon RDS console at https://console.aws.amazon.com/rds/.

  2. In the navigation pane, choose Instances.

  3. Select the check box to the left of the DB instance you need information about. For Show Monitoring, choose one of the following options for how you want to view your metrics:

    • Show Multi-Graph View – Shows a summary of Aurora metrics. Each metric includes a graph showing the metric monitored over a specific time span.

    • Show Single Graph View – Shows a single Aurora metric at a time with more detail. Each metric includes a graph showing the metric monitored over a specific time span.

    • Show Latest Metrics View – Shows a summary of Aurora metrics without graphs. You can choose an option to display this summary full-screen.

    • Enhanced Monitoring – Shows a summary of OS metrics available to an Aurora DB instance with Enhanced Monitoring enabled. Each metric includes a graph showing the metric monitored over a specific time span. For more information, see Enhanced Monitoring.

    
                                    RDS metrics viewing options
  4. If you chose Show Latest Metrics View, choose the full screen button to view only your metrics in full-screen mode.

    
                                    Latest Metrics View

Aurora Metrics Available in the Amazon RDS Console

Not all of the metrics provided by Amazon Aurora are available to you in the Amazon RDS console. You can view them using other tools, however, such as the AWS CLI and CloudWatch API. In addition, some of the metrics that are available in the Amazon RDS console are either shown only for specific instance classes, or with different names and different units of measurement.

The following Aurora metrics are not available in the Amazon RDS console:

  • AuroraBinlogReplicaLag

  • DeleteLatency

  • DeleteThroughput

  • EngineUptime

  • InsertLatency

  • InsertThroughput

  • NetworkThroughput

  • Queries

  • UpdateLatency

  • UpdateThroughput

In addition, some Aurora metrics are either shown only for specific instance classes, or with different names and different units of measurement:

  • The CPUCreditBalance and CPUCreditUsage metrics are displayed only for db.t2.small and db.t2.medium instances

  • The following metrics that are displayed with different names, as listed:

    Metric Display Name
    AuroraReplicaLagMaximum

    Replica lag maximum

    AuroraReplicaLagMinimum

    Replica lag minimum

    DDLThroughput

    DDL

    NetworkReceiveThroughput

    Network throughput

    VolumeBytesUsed

    Billed storage

    VolumeReadIOPS

    Billed read operations

    VolumeWriteIOPS

    Billed write operations

  • The following metrics are displayed in megabytes, instead of bytes, in the Amazon RDS console:

    • FreeableMemory

    • FreeLocalStorage

    • NetworkReceiveThroughput

    • NetworkTransmitThroughput

Latest Metrics View

You can view a subset of categorized Aurora metrics in the Latest Metrics view of the Amazon RDS console. The following table lists the categories and associated metrics displayed in the Amazon RDS console for an Aurora instance.

Category Metrics
SQL

ActiveTransactions

BlockedTransactions

BufferCacheHitRatio

CommitLatency

CommitThroughput

DatabaseConnections

DDLLatency

DDLThroughput

Deadlocks

DMLLatency

DMLThroughput

LoginFailures

ResultSetCacheHitRatio

SelectLatency

SelectThroughput

System

AuroraReplicaLag

AuroraReplicaLagMaximum

AuroraReplicaLagMinimum

CPUCreditBalance

CPUCreditUsage

CPUUtilization

FreeableMemory

FreeLocalStorage

NetworkReceiveThroughput

Deployment

AuroraReplicaLag

BufferCacheHitRatio

ResultSetCacheHitRatio

SelectThroughput

Note

The Failed SQL Statements metric, displayed under the SQL category of the Latest Metrics view in the Amazon RDS console, does not apply to Amazon Aurora.