1 個回答
- 最新
- 最多得票
- 最多評論
0
Hi,
Please check https://aws.amazon.com/blogs/database/monitor-errors-in-amazon-aurora-mysql-and-amazon-rds-for-mysql-using-amazon-cloudwatch-and-send-notifications-using-amazon-sns/. This provides an overview of how you can configure the deadlock events and alerting on Amazon RDS MySQL engine
已回答 1 年前
相關內容
- AWS 官方已更新 3 年前
- AWS 官方已更新 2 年前
- AWS 官方已更新 3 年前
Hi Arun,
I have already set-up that alert. But that can send you alert only when deadlock happens. I want to setup alerts when there are blocking sessions in database for defined interval of time.
SELECT r.trx_id waiting_trx_id, r.trx_mysql_thread_id waiting_thread, r.trx_query waiting_query, b.trx_id blocking_trx_id, b.trx_mysql_thread_id blocking_thread, b.trx_query blocking_query FROM information_schema.innodb_lock_waits w INNER JOIN information_schema.innodb_trx b ON b.trx_id = w.blocking_trx_id INNER JOIN information_schema.innodb_trx r ON r.trx_id = w.requesting_trx_id;