if you need table or datarow locking , why don't you use innodb table type with transactions ?
bye, thomas > 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.... --------------------------------------------------------------------- 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
