On 9-Jun-08, at 3:43 AM, Dott. Christian OLIVIERI wrote:
Hi, I'm a newbie and the following is my problem: I have a db
MySQL managing personal information. That I would do is: everyone
can READ single record. If someone open the record x to update/
delete no one other can do the same (edit/update) till first user
don't commit.
I was thinking Local Transaction was the answer but if user A open
a record in update then user B open the same record, B is hanged
untill timeout ends.
Which is exactly what you asked for. :)
How to alter timeout value?
It's a MySQL configuration setting (innodb_lock_wait_timeout).
--Toby
Thanks a lot.
Christian
