Ashley Sheridan wrote:
> On Sat, 2009-06-27 at 16:03 -0400, Daniel Kolbo wrote:
>> Ashley Sheridan wrote:
>>> On Sat, 2009-06-27 at 15:15 -0400, Daniel Kolbo wrote:
>>>> Hello,
>>>> 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)?
>>>> The php.ini directive max_execution_time does not help b/c:
>>>> "Note: The set_time_limit() function and the configuration directive
>>>> max_execution_time only affect the execution time of the script itself.
>>>> Any time spent on activity that happens outside the execution of the
>>>> script such as system calls using system(), stream operations, database
>>>> queries, etc. is not included when determining the maximum time that the
>>>> script has been running."
>>>> The my.ini directive table_lock_wait_timeout does not work either b/c
>>>> from MySQL:
>>>> "This variable currently is unused. "
>>>> (I am using mysql v5.1)
>>>> I do not want to bluntly stop this from the apache level.
>>>> How does one place a time limit on the execution of mysql_query()?
>>>> Thanks for your help,
>>>> dK
>>> It depends on what type of table you have, MyISAM blocks at table level
>>> for instance, while InnoDB locks at row level.
>>> Thanks
>>> Ash
>> I'm using InnoDB.
>> But either way how do you place a time limit on mysql_query()?
>> Thanks,
>> dK
> I've not seen this done before, but it should only be row locking if
> you're using InnoDB. What queries are you running that are affecting a
> script that badly?
> Thanks
> Ash
I issue a 'lock tables tablename write' and do some work.  This is to be
expected.  I want a way that to stop mysql_query() from just waiting for
 the mysql server.

PHP General Mailing List (
To unsubscribe, visit:

Reply via email to