Limiting query time

[Troy Hakala]

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.

Thanks!

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]