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
質問済み 6年前534ビュー
2回答
0

Hi Numanx,

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

Cheers,

回答済み 6年前
0

Was there a solution to it? Facing similar issue.

siimk
回答済み 5年前

ログインしていません。 ログイン 回答を投稿する。

優れた回答とは、質問に明確に答え、建設的なフィードバックを提供し、質問者の専門分野におけるスキルの向上を促すものです。

質問に答えるためのガイドライン