In this video, you will learn about mysql row level locking mechanism. Contact me: forms.gle/oLaJ... Connect with me: / bharathramdba Subscribe: / @executeoncommand Icons by phatplus from flaticon.com
Hi , Let me explain my scenario , I don't know why table lock is happening 1. There is only one user / One session 2. Stored Procedure is executed. With in the stored procedure , multiple insert happend in table T_TRANS. And finally one Delete is happening for the same table T_TRANS, here only am facing issue, This delete query taking too much time SOMETIME... Other time its working fine 3. Why some time only its taking too much time .? is there any lock will come within the same session? Please help
@@ExecuteonCommand No. Its not child table and there is no foreign key constraints. After deep analysis i found the root cause, there is one query taking 20 minutes and next another query trying to delete the same table . But note that long running query successfully completed. So my question is , will long running query lock the tables even after successful completion?