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
: Andrés Tello [mailto:mr.crip...@gmail.com]
Sent: Thursday, April 04, 2013 9:08 AM
To: mysql
Subject: Update and lock question.
I'm doing some tests, but have a questions about locking.
In a innodb table, if you issue an select for update lock for a row,
supposedly, it only locks that row
I'm doing some tests, but have a questions about locking.
In a innodb table, if you issue an select for update lock for a row,
supposedly, it only locks that row, but if you don't issue a select for
update, and trow the update... does it locks the hole table?
The update goes over an indexed
-
From: Andrés Tello [mailto:mr.crip...@gmail.com]
Sent: Thursday, April 04, 2013 9:08 AM
To: mysql
Subject: Update and lock question.
I'm doing some tests, but have a questions about locking.
In a innodb table, if you issue an select for update lock for a row,
supposedly, it only locks