Troy Hakala <[EMAIL PROTECTED]> wrote: > Is it possible to limit the query time in MySQL (3.x or 4.0)? For > example, I'd like to have any query that takes more than a specified > number of seconds just quit automatically. Seems dumb, but on a web > site, nobody is going to wait minutes for a query to return so they > refresh anyway. So on a busy server, MySQL ends up with several queries > running that all take a long time to finish which compound to make it > even slower. A simple time limit would solve the problem. Yes, I know > that the queries should take less time, but again, on a busy server, > sometimes the longer queries do take a long time (10 minutes or more) > to complete.
No, there is no option for limiting query time. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [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]