To improve performance, we recently upgraded the server from 2 core-8GB to 4 core-16GB. we increased the gunicorn workers from 5 to 9. Our App Server and DB Server are in the same EC2 Instance.
Post Upgrade, we are getting to see frequent locks in database and users are not able to complete the transaction.
Any guidance on how to approach this issues?
Any temporary fix or method to clear the deadlocks in DB so that user can continue. ?