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
feita há 6 anos534 visualizações
2 Respostas
0

Hi Numanx,

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

Cheers,

respondido há 6 anos
0

Was there a solution to it? Facing similar issue.

siimk
respondido há 5 anos

Você não está conectado. Fazer login para postar uma resposta.

Uma boa resposta responde claramente à pergunta, dá feedback construtivo e incentiva o crescimento profissional de quem perguntou.

Diretrizes para responder a perguntas