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

Monitoring an Amazon Aurora DB Cluster

You can view details about your DB cluster by using the Amazon RDS console. The Amazon Aurora console provides a number of metrics for you to monitor the health and performance of your Aurora DB cluster. For a detailed list, see Aurora Metrics.

To view the details of a DB cluster using the Amazon RDS console

  1. Open the Amazon Aurora console at https://console.aws.amazon.com/rds.

  2. In the left navigation pane, click Instances.

  3. Click the check box to the left of the DB cluster you need information about. Then click the Show Monitoring drop-down menu. Select the option for how you want to view your Aurora metrics. The Aurora console provides three options for viewing metrics.

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

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

    • Show Full Monitoring View–Shows a summary of Aurora metrics without graphs. Full Monitoring View includes an option for full-screen viewing.

    
                                Amazon Aurora Launch DB Instance Wizard DB Instance
                                    Details
  4. If you selected Full Monitoring View, you can click the full screen button to view only your metrics in full-screen mode.

    
                                Show Metrics – Full Monitoring View

For more information and other options for monitoring RDS instances, see Monitoring Amazon RDS.

Aurora Metrics

Aurora provides several metrics that you can monitor to determine the health of your DB cluster. You can view these metrics in the RDS console. The following tables describe the metrics available for instances in Aurora DB clusters.

Aurora System Monitoring

Metric Description

CPU Utilization

CPUUtilization

The percentage of CPU used by a DB instance.

Freeable memory

FreeableMemory

The amount of available random access memory, in gigabytes (GB).

Network receive throughput

NetworkReceiveThroughput

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

Network transmit throughput

NetworkTransmitThroughput

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

Billed read operations

VolumeReadIOPS

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

Billed write operations

VolumeWriteIOPS

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

Replica lag

AuroraReplicaLag

For an Aurora Replica, reports the amount of lag when replicating updates from the primary instance, in ms.

Replica lag maximum

AuroraReplicaLagMaximum

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

Replica lag minimum

AuroraReplicaLagMinimum

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

Aurora binlog replica lag

AuroraBinlogReplicaLag

The amount of time an Amazon 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.

Free local storage

FreeLocalStorage

Unlike other DB engines, the Free local storage metric for Amazon Aurora reports the amount of storage available to each DB instance for temporary tables and logs, in GB. This value affects the cost of the Aurora DB cluster (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.

Free storage space

FreeStorageSpace

Does not apply to Amazon Aurora.

Swap usage

SwapUsage

Not supported for Amazon Aurora.

Binary log disk usage

BinLogDiskUsage

This metric is not supported for Amazon Aurora.

CPU credit balance

CPUCreditBalance

(Only valid for db.t2.small and db.t2.medium instances) The number of CPU credits that an instance has accumulated.

This metric is used to determine how long an instance can burst beyond its baseline performance level at a given rate.

Note

CPU Credit metrics are available at a 5 minute frequency.

CPU credit usage

CPUCreditUsage

(Only valid for db.t2.small and db.t2.medium instances) The number of CPU credits consumed during the specified period.

This metric identifies the amount of time during which physical CPUs were used for processing instructions by virtual CPUs allocated to the instance.

Note

CPU Credit metrics are available at a 5 minute frequency.

Storage usage

VolumeBytesUsed

The amount of storage in bytes used by your Aurora database. This value affects the cost of the Aurora DB cluster (for pricing information, see the Amazon RDS product page).

Aurora SQL Monitoring

Metric Description

Select throughput

SelectThroughput

The average number of select queries per second.

DML throughput

DMLThroughput

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

Commit throughput

CommitThroughput

The average number of committed transactions per second.

DDL throughput

DDLThroughput

The average number of DDL requests per second.

Select latency

SelectLatency

The amount of latency for select queries, in ms.

DML latency

DMLLatency

The amount of latency for inserts, updates, and deletes, in ms.

Commit latency

CommitLatency

The amount of latency for committed transactions, in ms.

DDL latency

DDLLatency

The amount of latency for DDL requests (create/alter/drop), in ms.

DB connections

TotalConnections

The number of active connections to a DB instance.

Active transactions

ActiveTransactions

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

Buffer cache hit ratio

BufferCacheHitRatio

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

Resultset cache hit ratio

ResultSetCacheHitRatio

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

Login failures

LoginFailures

The average number of failed login attempts per second.

Blocked transactions

BlockedTransactions

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

Failed SQL statements

FailedSqlStatements

The average number of database commands that have failed per second.

Deadlocks

Deadlocks

The average number of deadlocks in the database per second.