How to find deadlock process in RDS My SQL and set alarm notification？

My customers encounter the problem of SQL process deadlock when using RDS MySQL, I would like to know how to find these processes in RDS MySQL and set up alarm notification when triggered？

Adam 중재자
2년 전
This appears to be a duplicate of https://repost.aws/questions/QUoUMRpvwbQbu-k-IeyiQKbQ - hiding it.

주제

데이터베이스

태그

오로라 MySQL

언어

English

rePost-User-2493645

질문됨 2년 전1730회 조회

1개 답변

최신
최다 투표
가장 많은 댓글

이 답변이 도움이 되었나요?커뮤니티가 여러분의 지식을 활용할 수 있도록 정답을 찬성하세요.

Hi, To identify deadlocks on a database, please enable the innodb_print_all_deadlock and innodb_deadlock_detect parameter in the parameter group to log all deadlocks to errorlog. The INFORMATION_SCHEMA INNODB_TRX table can be queried. This gives you precise details about every running transaction in INNODB, including waits. Next, you can get error logs through Cloudwatch log, and filter keywords for alarm notification.

Colin Tang

답변함 2년 전

How to find deadlock process in RDS My SQL and set alarm notification？

관련 콘텐츠