There is a variable called --network-timeout ! You can set it to 300 (5 minutes, etc.).
"Tony Yau" <[EMAIL PROTECTED]> wrote: >Hi Guys, > you can always set a max time out for your php script (php.ini) >Tony > >----- Original Message ----- >From: "Gleb Paharenko" <[EMAIL PROTECTED]> >To: <mysql@lists.mysql.com> >Sent: Friday, May 20, 2005 12:45 PM >Subject: Re: MySQL give up on a query after a certain length of time > > >> Hello. >> >> I don't remember such way (except your transaction could abort due to >> lock timeout). Check with SHOW PROCESSLIST in what state your query >> hangs. >> >> >> >> Jacob Friis Larsen <[EMAIL PROTECTED]> wrote: >> > Hello. >> > >> > Is there a way to have MySQL give up on a query after a certain length >of t= >> > ime? >> > I use Debian Linux Sarge, MySQL 4.1 and Php 5. >> > >> > Sometimes I have queries that take forever although the same query >> > returns fast at other times. >> > >> > Thanks, >> > Jacob >> > >> >> >> -- >> For technical support contracts, goto https://order.mysql.com/?ref=ensita >> This email is sponsored by Ensita.NET http://www.ensita.net/ >> __ ___ ___ ____ __ >> / |/ /_ __/ __/ __ \/ / Gleb Paharenko >> / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] >> /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET >> <___/ www.mysql.com >> >> >> >> >> -- >> MySQL General Mailing List >> For list archives: http://lists.mysql.com/mysql >> To unsubscribe: >http://lists.mysql.com/[EMAIL PROTECTED] > > >-- >MySQL General Mailing List >For list archives: http://lists.mysql.com/mysql >To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > __________________________________________________________________ Switch to Netscape Internet Service. As low as $9.95 a month -- Sign up today at http://isp.netscape.com/register Netscape. Just the Net You Need. New! Netscape Toolbar for Internet Explorer Search from anywhere on the Web and block those annoying pop-ups. Download now at http://channels.netscape.com/ns/search/install.jsp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
