Hi, I have a question regard the table locking. Let say there is a table ,mytablename type=MyISAM in my database. And lets say there are 2 users who are currently log in.
First user locks a table write: mysql> lock tables mytablename write; Query OK, 0 rows affected (0.00 sec) Then,second user wishes to query something from mytablename. mysql>select * from mytablename; ...........................(pending or in a queue)... I know that the second query will be pending untill the 1-st user issues the "unlock tables" command. So,i am wondering is it the second query will be waiting there 'forever' if the 1-st user 'never' issue the "unlock tables" command? Or is there any method maybe like 'waiting_timeout' that I can set.If the waiting time > 'variable' second,then the query will automatically be deleted.... Thanks. --------------------------------------------------------------------- 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
