Why issue/do a lock at all? Shouldn't need a large lock at read bastien On Saturday, June 27, 2009, Daniel Kolbo <kolb0057@xxxxxxx> wrote: > 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 >>>> www.ashleysheridan.co.uk <http://www.ashleysheridan.co.uk> >>>> >>>> >>> 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 >> www.ashleysheridan.co.uk <http://www.ashleysheridan.co.uk> >> >> > 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 (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- Bastien Cat, the other other white meat -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
