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
답변함 일 년 전
관련 콘텐츠
- 질문됨 7년 전
- 질문됨 23일 전
AWS 공식업데이트됨 2년 전- AWS 공식업데이트됨 일 년 전
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;