Re: Bad Queries

[Michael Widenius]

Hi!

>>>>> "Marc" == Marc Peiser <marc.peiser@stripped> writes:

>> you can terminate any query with mysqladmin kill ..
>> 
>> Or with mysqlgui and it's process dialogue !!

Marc> Do you know how to kill a slow query automatically after 10 seconds?

You can easily write a short perl (?) program to do this.

Just let the perl do a "show processlist' every 5'th second and if any
queries have took more than 5 seconds, you can send a kill to it.

Regards,
Monty