[Toolserver-l] Query-Killer is back in action

[Hersfold Wikipedia]

It might be best to turn this off until server 3 no longer thinks
it's *8 months* behind.

----
User:Hersfold
hersfoldwiki at gmail.com

Sent from my Windows Phone From: Magnus Manske
Sent: Sunday, August 14, 2011 13:51
To: toolserver-l at lists.wikimedia.org
Subject: Re: [Toolserver-l] Query-Killer is back in action
On Sun, Aug 14, 2011 at 5:42 PM, DaB. <WP at daniel.baur4.info> wrote:
> Hello all,
>
> during the last week I kept an eye on the database-servers and killed queries
> which had run for too long. In the past we had a programm for that, but
> somewhen it stoped working and nobody fixed it AFAIK.
>
> Because watching the mytop is a boring thing and I have to sleep too, I used
> the last 2-3 days to write a substitute of the old query-kiler. This program
> is working now. It does more or less the same as I did, but it send you an
> eMail when it killed one of your query. I think that is an improvment and I
> can spend my time with other things.
>
> You can find the parameters of when and if the killer works at [1]. Of corse
> there is always the possiblity of adjustments. Feel free to open bugs at JIRA
> or discuss on teh mailinglist.

So the max run-time is dependent on replag. But, considering this:
Replag s3	6050h 10m 44s

I currently get bombarded with killed-query-mails :-(

Magnus

_______________________________________________
Toolserver-l mailing list (Toolserver-l at lists.wikimedia.org)
https://lists.wikimedia.org/mailman/listinfo/toolserver-l
Posting guidelines for this list:
https://wiki.toolserver.org/view/Mailing_list_etiquette