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.

主題

資料庫

標籤

Aurora 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？

相關內容