Skip to content

What is NumUndoRowOperations RDS metric?

0

The NumUndoRowOperations RDS cloudwatch metric is shown for my 8.0.mysql_aurora.3.10.3 db instance. It is undocumented in https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.AuroraMonitoring.Metrics.html#Aurora.AuroraMySQL.Monitoring.Metrics.instances

What does this metric measure?

asked 2 months ago98 views

2 Answers
3
Accepted Answer

In Short: As to my understanding, even though this metric is currently missing from the explicit CloudWatch list in the Aurora User Guide, NumUndoRowOperations measures the number of row operations being processed inside the InnoDB Undo Logs (Rollback Segments).

In Aurora MySQL 3.x (MySQL 8.0), this metric tracks two critical database behaviors:

  1. Active Transaction Rollbacks: When a heavy DML transaction (INSERT/UPDATE/DELETE) fails or is explicitly rolled back, the InnoDB engine must undo those changes. This metric reflects the volume of rows currently being reverted using the undo logs.
  2. MVCC Generation (Multi-Version Concurrency Control): If you have long-running SELECT queries executing while concurrent write transactions are modifying the same data, Aurora has to reconstruct older versions of those rows from the undo logs to guarantee read consistency.

Why you should monitor it:

A sustained spike or high value in NumUndoRowOperations directly correlates with an increasing History List Length (HLL). If you notice performance degradation or high CPU usage along with this metric, it indicates that your database is spending significant cycles processing or purging old row versions to maintain isolation levels.

EXPERT

answered 2 months ago

  • Very helpful, thank you!

0

I don't have information about the NumUndoRowOperations metric in the sources available to me. This metric is not listed among the documented CloudWatch metrics for Amazon RDS or Aurora database instances and clusters that I can reference.

Since you've noted that this metric appears for your Aurora MySQL 8.0 instance but is undocumented in the official Aurora monitoring documentation, I cannot provide a definitive explanation of what it measures based on the information I have access to. To get accurate information about this undocumented metric, I recommend reaching out to AWS Support directly, as they would have access to detailed information about all available metrics, including those that may not yet be publicly documented.

answered 2 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.