List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:February 9 2000 1:09pm
Subject:Re: Bad Queries
View as plain text  
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
Thread
Bad QueriesDannie M Stanley1 Feb
  • Re: Bad Queriessasha1 Feb
    • Re: Bad QueriesMarc Peiser3 Feb
      • Re: Bad Queriessasha3 Feb
        • Re: Bad QueriesMichael Widenius8 Feb
          • Re: Bad QueriesMarc Peiser8 Feb
            • Re: Bad Queriessinisa8 Feb
              • Re: Bad QueriesMarc Peiser8 Feb
                • Re: Bad Queriessinisa8 Feb
                • Re: Bad QueriesMichael Widenius9 Feb
                  • Re: Bad QueriesMatthias Urlichs9 Feb
                    • Re: Bad QueriesMichael Widenius10 Feb
  • Re: Bad QueriesDannie M Stanley1 Feb
  • Re: Bad Queriessasha2 Feb
  • Re: Bad QueriesDannie M Stanley3 Feb
  • Re: Bad QueriesDannie M Stanley3 Feb
    • Re: Bad QueriesThimble Smith3 Feb