Re: mysql_query blocking
| From: | Tom Worster | Date: | Sat, 27 Jun 2009 20:59:50 +0000 |
| Subject: | Re: mysql_query blocking | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-294679@lists.php.net to get a copy of this message | ||
On 6/27/09 3:15 PM, "Daniel Kolbo" <kolb0057@umn.edu> wrote:
> When a MySQL table is locked a php call of mysql_query() that requires
> that table will hang as the request blocks at the MySQL server until the
> table is unlocked. Is there a way to stop a mysql_query from hanging
> (by setting a time limit)?
would it be possible to test for presence of the lock before issuing the
query that would block? if so, you could check the lock periodically until
your time limit is up. would achieve you you're looking for?