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]
