En utilisant AWS re:Post, vous acceptez les AWS re:Post Conditions d’utilisation
AWS re:Postre:Post

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

0

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？and how to process the issue?

Sujets
Base de données
Balises
Aurora MySQL
Langue
English
rePost-User-2597396
demandé il y a 2 ans1109 vues
2 réponses
2
Réponse acceptée

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.

AWS
Colin Tang
répondu il y a 2 ans
  • rePost-User-0067846
    il y a 2 ans

    thanks Colin, your advice is very helpful for me to solve the issue. and the problem is solved.

1

thanks very much. it's helpful and the issue is solved by your advice.

AWS
rePost-User-0067846
répondu il y a 2 ans

Vous n'êtes pas connecté. Se connecter pour publier une réponse.

Une bonne réponse répond clairement à la question, contient des commentaires constructifs et encourage le développement professionnel de la personne qui pose la question.

Instructions pour répondre aux questions

Contenus pertinents