=?ISO-8859-1?Q?Andr=E9s_Tello?= Update and lock question.
Apr 04, 2013; 10:08
=?ISO-8859-1?Q?Andr=E9s_Tello?=
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, 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, or the effect of locking the hole table is due I'm updating an indexed field?
This is because I'm running into dead locks, but I know there is no select for update to the row being updated.
Thanks.
Apr 04
Urvashi Pathak RE: Update and lock question.
Apr 04, 2013; 09:52
Urvashi Pathak
RE: Update and lock question.
Apr 05
=?ISO-8859-1?Q?Andr=E9s_Tello?= Re: Update and lock question.
Apr 05, 2013; 15:56
=?ISO-8859-1?Q?Andr=E9s_Tello?=
Re: Update and lock question.
Apr 09
Rick James RE: Update and lock question.
Apr 09, 2013; 00:08
Rick James
RE: Update and lock question.
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!