April 05, 2013 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
al Message-
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
vel
> locking.
>
>
> -Urvi
>
> -Original Message-
> 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.
&
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 field
