Problem with deadlock on AWS RDS MySQL

0

Hello,
We have an issue regarding AWS RDS MySQL.
We have migrated from an AWS EC2 MySQL to RDS MySQL for improving performance, stability and reliability but we are facing a big issue.
After we migrated the databases and started a few php crons that are inserting in MySQL various data(statistics for our application) using INSERT .. ON DUPLICATE KEYS UPDATE we are constantly receiving the following error when the cron is being executed: "Deadlock found when trying to get lock; try restarting transaction
Query: INSERT INTO.."
We are using InnoDB engine.
We have used mysql 5.6.24-log on the EC2 Instance and now on RDS we are using 5.7.21-log.
Parameter group: default.mysql5.7.

Thank you!

Edited by: numanx on Jun 13, 2018 5:29 AM

numanx
demandé il y a 6 ans534 vues
2 réponses
0

Hi Numanx,

I am sending you a message now with some more details about your instance.

Cheers,

répondu il y a 6 ans
0

Was there a solution to it? Facing similar issue.

siimk
répondu il y a 5 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