BlockedTransaction CloudWatch alarm always in INSUFFICIENT DATA state.

0

Hi, I want to setup an alarm for AWS RDS mysql database. Whenever there is blocking in database sent a mail notification. I set-up it like below. But the alarm is always in INSUFFICIENT DATA state. i simulated blocking in database but no effect. Alarm description

Does anyone know what this BlockedTransaction metrics is evaluating?

1 Answer
0

Blockedtransactions is a cloudwatch metrics applicable for Aurora MySQL only. It gives average number of transactions in the database that are blocked per second this metric is based on innodb metric It is # of transactions currently waiting on row locks it is evaluated using

SELECT name, subsystem, status, count FROM INFORMATION_SCHEMA.INNODB_METRICS where NAME like 'LOCK_ROW_LOCK_CURRENT_WAITS';

+-----------------------------+-----------+---------+-------+
| name | subsystem | status | count |
+-----------------------------+-----------+---------+-------+
| lock_row_lock_current_waits | lock | enabled | 0 |
+-----------------------------+-----------+---------+-------+
1 row in set (0.08 sec)
AWS
answered a year 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.

Guidelines for Answering Questions