Re: mysql_query blocking

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




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
> 
> 

Even the apache TimeOut directive does not seem to work in this situation.

Any help would be appreciated.

Thanks,
dK

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux