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
> > www.ashleysheridan.co.uk
> I'm using InnoDB.
> But either way how do you place a time limit on mysql_query()?
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?
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php