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]
