At 17:12 +0800 1/11/03, Clyde wrote:
Hi,
I have searched the docs but can't seem to find information on the time out value for "Lock Tables" (probably just me)
When using "Lock Tables" how long does MySql wait before giving up if it can't get a lock?
Forever.
For table-level locks such as you acquire with LOCK TABLES, there is no timeout. This differs from (implicit) page- or row-level locking such as is performed by the BDB and InnoDB handlers. For such locking levels, it's possible to get deadlock. When the handler detects a deadlock, it aborts one of the deadlocking requests.
Is there any way of changing this time out value? Thanks Clyde England
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
