2 Risposte
- Più recenti
- Maggior numero di voti
- Maggior numero di commenti
2
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.
con risposta 2 anni fa
1
thanks very much. it's helpful and the issue is solved by your advice.
con risposta 2 anni fa
Contenuto pertinente
- AWS UFFICIALEAggiornata 3 anni fa
- AWS UFFICIALEAggiornata 2 anni fa
thanks Colin, your advice is very helpful for me to solve the issue. and the problem is solved.