On Saturday, June 27, 2009, Bastien Koert <phpster@xxxxxxxxx> wrote: > 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> <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> <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 > -- Bastien Cat, the other other white meat -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
