Page 1 of 1

Lock record

Posted: Fri 15 Jul 2011 14:52
by cybsistemas
If I try to block a record that already has been blocked the error message takes long.

How do we decrease that time?

Posted: Mon 18 Jul 2011 11:09
by AndreyZ
Hello,

You can decrease the value of the innodb_lock_wait_timeout server variable. For more information, please take a look at this article: http://dev.mysql.com/doc/refman/5.1/en/ ... it_timeout

Posted: Mon 18 Jul 2011 13:28
by cybsistemas
Thanks