Upgrade Aurora from 5.6 to 5.7.mysql_aurora.2.11.1 getting tons of deadlocks and lock wait timeouts, maybe 20-30x what they were before the upgrade
0
votes
1
answer
416
views
Our application logs are showing an excessive amount of lock wait times, and deadlocks for queries that have not had issues previously after upgrading from 5.6 to 5.7 MySQL in AWS Aurora. Are there any settings that I can adjust to reduce the deadlocks and lock wait timeouts?
Variables and settings here:
https://pastebin.com/cmu11Dwh
Running on db.r5.12xlarge
Asked by user2966697
(1 rep)
Mar 21, 2023, 06:34 PM
Last activity: Apr 16, 2025, 09:05 AM
Last activity: Apr 16, 2025, 09:05 AM