Force max query time, or max records returned

[Scott Baker]

Is there a way to tell mysqld to stop running a query if it hasn't 
completed in over 60 seconds? Or how about stop running if the 
result is greater 100,000 rows or something? I have a bone head user 
who keeps querying two tables and NOT joining them, and then 
dragging the DB server down while it crunches this useless query.

How can I prevent this?
Scott

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