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
On Friday 30 December 2005 3:31 pm, Scott Baker wrote:
How can I prevent this?
Scott
You know when I deal with users like this, I like to think about what Dennis
Leary said about spanking children; I don't need to spank them, I find that
waving the gun around works just as well.
--
At 04:31 PM 12/30/2005, Scott Baker wrote:
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,
Scott Baker wrote:
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