2:56 PM
To: Urvashi Pathak
Cc: mysql
Subject: Re: Update and lock question.
Thanks Urvashi.
Based on your answer, instead of the data I looked into the index, and
it appears that it was an index issue...
I think I have nailed the wait lock contdition due a updating indexes
unnecesarely
Hi Andrés,
Select for update makes sure that no other process can change the data between
you selected it for update and then actually changed it and commit it.
If you do not use select for update then it is possible that some other
process can change the data in the mean time between you
Thanks Urvashi.
Based on your answer, instead of the data I looked into the index, and it
appears that it was an index issue...
I think I have nailed the wait lock contdition due a updating indexes
unnecesarely...
On Thu, Apr 4, 2013 at 10:52 AM, Urvashi Pathak urvashi_pat...@symantec.com