Re: mysql_query blocking
| From: | Daniel Kolbo | Date: | Sat, 27 Jun 2009 23:09:00 +0000 |
| Subject: | Re: mysql_query blocking | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-294684@lists.php.net to get a copy of this message | ||
Tom Worster wrote:
> 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?
>
>
>
it would still be possible that after checking but before issuing the
query the table's could be locked - albeit a much smaller chance.
Thanks for the input,
dK