MySQL Amazon Aurora Metrics¶
This dashboard provides metrics for analyzing Amazon Aurora instances.
Amazon Aurora Transaction Commits¶
This graph shows number of commits which the Amazon Aurora engine performed as well as the average commit latency. Graph Latency does not always correlates with number of commits performed and can quite high in certain situations.
Amazon Aurora Load¶
This graph shows what statements contribute most load on the system as well as what load corresponds to Amazon Aurora transaction commit.
- Write Transaction Commit Load: Load in Average Active Sessions per second for COMMIT operations
- UPDATE load: load in Average Active Sessions per second for UPDATE queries
- SELECT load: load in Average Active Sessions per second for SELECT queries
- DELETE load: load in Average Active Sessions per second for DELETE queries
- INSERT load: load in Average Active Sessions per second for INSERT queries
An active session is a connection that has submitted work to the database engine and is waiting for a response from it. For example, if you submit an SQL query to the database engine, the database session is active while the database engine is processing that query.
Aurora Memory Used¶
This graph shows how much memory is used by Amazon Aurora lock manager as well as amount of memory used by Amazon Aurora to store Data Dictionary.
- Aurora Lock Manager Memory: the amount of memory used by the Lock Manager, the module responsible for handling row lock requests for concurrent transactions.
- Aurora Dictionary Memory: the amount of memory used by the Dictionary, the space that contains metadata used to keep track of database objects, such as tables and indexes.
Amazon Aurora Statement Latency¶
This graph shows average latency for most important types of statements. Latency spikes are often indicative of the instance overload.
- DDL Latency: Average time to execute DDL queries
- DELETE Latency: average time to execute DELETE queries
- UPDATE Latency: average time to execute UPDATE queries
- SELECT Latency: average time to execute SELECT queries
- INSERT Latency: average time to execute INSERT queries
Amazon Aurora Special Command Counters¶
Amazon Aurora MySQL allows a number of commands which are not available from
standard MySQL. This graph shows usage of such commands. Regular
unit_test calls can be seen in default Amazon Aurora install, the rest
will depend on your workload.
- The number of executions per second of the command
SHOW VOLUME STATUS. The
SHOW VOLUME STATUSquery returns two server status variables: Disks and Nodes. These variables represent the total number of logical blocks of data and storage nodes, respectively, for the DB cluster volume.
- The number of AWS Lambda calls per second. AWS Lambda is an event-drive, serverless computing platform provided by AWS. It is a compute service that run codes in response to an event. You can run any kind of code from Aurora invoking Lambda from a stored procedure or a trigger.
- The number of executions per second of the special query ALTER SYSTEM, that is a special query to simulate an instance crash, a disk failure, a disk congestion or a replica failure. It is a useful query for testing the system.
Amazon Aurora Problems¶
This metric shows different kinds of internal Amazon Aurora MySQL problems which should be zero in case of normal operation.
- Reserved mem Exceeded Incidents
- Missing History on Replica Incidents
- Thread deadlocks: number of deadlocks per second