1 Answer
- Newest
- Most votes
- Most comments
0
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.
answered 2 years ago
Relevant content
- Accepted Answerasked 2 years ago
- asked 6 years ago
- asked a year ago
- AWS OFFICIALUpdated 4 years ago
- AWS OFFICIALUpdated 3 years ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 16 days ago
This appears to be a duplicate of https://repost.aws/questions/QUoUMRpvwbQbu-k-IeyiQKbQ - hiding it.