MySQL Forums
Forum List  »  General

Re: Mysql 5.7: Dead Lock Issue SQLSTATE[40001]
Posted by: Irfan Ahamd
Date: November 04, 2019 01:11AM

We run this command many times in a day and some time we found table dead lock in our application log. We still not able to find the actual reason of this blocking.

Is there any work around where we only update only un-locked rows and skip lock rows for update ?

Options: ReplyQuote

Written By
Re: Mysql 5.7: Dead Lock Issue SQLSTATE[40001]
November 04, 2019 01:11AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.