Does anyone know if there's a trick to get /* SLOW_OK */ into a stored procedure? When I create a stored procedure with a /* SLOW_OK */ comment in it, the stored procedure is saved with the comments stripped out.

- Jason

--- On Tue, 8/16/11, toolserver-l-request@lists.wikimedia.org <toolserver-l-request@lists.wikimedia.org> wrote:

From: toolserver-l-request@lists.wikimedia.org <toolserver-l-request@lists.wikimedia.org>
Subject: Toolserver-l Digest, Vol 70, Issue 10
To: toolserver-l@lists.wikimedia.org
Date: Tuesday, August 16, 2011, 5:00 AM

Send Toolserver-l mailing list submissions to
    toolserver-l@lists.wikimedia.org

To subscribe or unsubscribe via the World Wide Web, visit
    https://lists.wikimedia.org/mailman/listinfo/toolserver-l
or, via email, send a message with subject or body 'help' to
    toolserver-l-request@lists.wikimedia.org

You can reach the person managing the list at
    toolserver-l-owner@lists.wikimedia.org

When replying, please edit your Subject line so it is more specific
than "Re: Contents of Toolserver-l digest..."


Today's Topics:

   1. Re: [Toolserver-announce] Query-Killer is back in    action
      (Huib Laurens)
   2. Re: Query-Killer is back in action (Maarten Dammers)
   3. Re: Query-Killer is back in action (DaB.)
   4. Re: Query-Killer is back in action (K. Peachey)


----------------------------------------------------------------------

Message: 1
Date: Mon, 15 Aug 2011 17:43:15 +0200
From: Huib Laurens <sterkebak@gmail.com>
Subject: Re: [Toolserver-l] [Toolserver-announce] Query-Killer is back
    in    action
To: toolserver-l@lists.wikimedia.org
Message-ID:
    <CAGkfB_qcKj=yfB9hTn+oeW1GTJcOo-_uPznmXX1fTrbDB8iCfQ@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1

Is this script somewhere aivable? I would like to use it also outside
the toolserver.,


2011/8/15, Magnus Manske <magnusmanske@googlemail.com>:
> On Mon, Aug 15, 2011 at 1:30 AM, DeltaQuad Wikipedia
> <deltaquadwiki@gmail.com> wrote:
>> Quick question, is "Unable to run job: got no response from JSV script
>> "/sge62/default/common/jsv.sh" " The killer? becuase ya, I got a lot of
>> them, came home after about 5 hours to about 8 of them, and my API queries
>> are quick...I don't get (unless it's the server) what i'm doing wrong.
>
> It's not 'the killer', but it might be related, because I got those as
> well, first time ever:
>
> Unable to run job: got no response from JSV script
> "/sge62/default/common/jsv.sh".
>
> Magnus
>
> _______________________________________________
> Toolserver-l mailing list (Toolserver-l@lists.wikimedia.org)
> https://lists.wikimedia.org/mailman/listinfo/toolserver-l
> Posting guidelines for this list:
> https://wiki.toolserver.org/view/Mailing_list_etiquette
>

--
Verzonden vanaf mijn mobiele apparaat

Kind regards,

Huib Laurens
WickedWay.nl

Webhosting the wicked way.



------------------------------

Message: 2
Date: Mon, 15 Aug 2011 23:03:52 +0200
From: Maarten Dammers <maarten@mdammers.nl>
Subject: Re: [Toolserver-l] Query-Killer is back in action
To: toolserver-l@lists.wikimedia.org
Message-ID: <4E4989B8.6080600@mdammers.nl>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed

Op 14-8-2011 18:42, DaB. schreef:
> <knip>
>
> [1]
> https://wiki.toolserver.org/view/Database_access#Slow_queries_and_the_query_killer
Ah, you are the one who killed the categorization bot. Thanks for
announcing that beforehand (not!). It's very annoying that you suddenly
just decide to deploy a new toy the screws up our tools.

Maarten




------------------------------

Message: 3
Date: Mon, 15 Aug 2011 23:14:56 +0200
From: "DaB." <WP@daniel.baur4.info>
Subject: Re: [Toolserver-l] Query-Killer is back in action
To: toolserver-l@lists.wikimedia.org
Message-ID: <201108152315.03221.WP@daniel.baur4.info>
Content-Type: text/plain; charset="utf-8"

Hello,
At Monday 15 August 2011 23:12:28 DaB. wrote:
> Thanks for  announcing that beforehand (not!)

the linked wiki-page was updated with the information about the query-killer
more than 1 year ago.

Sincerly,
DaB.

--
Userpage: [[:w:de:User:DaB.]] ? PGP: 2B255885
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 198 bytes
Desc: This is a digitally signed message part.
Url : http://lists.wikimedia.org/pipermail/toolserver-l/attachments/20110815/74b9b806/attachment-0001.pgp

------------------------------

Message: 4
Date: Tue, 16 Aug 2011 08:39:49 +1000
From: "K. Peachey" <p858snake@gmail.com>
Subject: Re: [Toolserver-l] Query-Killer is back in action
To: toolserver-l@lists.wikimedia.org
Message-ID:
    <CADnECnXP5Pn7=aeFfwxDWz-tWgGbesH9Q3FgUVKRsRjV2Djxag@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8

On Tue, Aug 16, 2011 at 7:03 AM, Maarten Dammers <maarten@mdammers.nl> wrote:
> Ah, you are the one who killed the categorization bot. Thanks for
> announcing that beforehand (not!). It's very annoying that you suddenly
> just decide to deploy a new toy the screws up our tools.
>
> Maarten
It was re-enabling a service that has been around for a long time that
[accidently] broke at one stage and because of the TS performance not
being degraded was never really noticed or cared about.

Recently a TS box went down and caused major issues (Replag was easily
over 2 days at one stage for those databases) for the backup box
handling the effected databases, DaB was monitoring this by hand and
manually killing the processes to keep this somewhat saner then
re-wrote and brought the tool back online to handle this when they
noticed it was [the tool] was not functioning.

This was a tool that was already meant to be running but by [your]
"luck" wasn't, and was already documented on wiki as DaB pointed out
over a year ago.

Perhaps you should consider apologizing to DaB in regards to the tone
of your email.



------------------------------

_______________________________________________
Toolserver-l mailing list
Toolserver-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/toolserver-l


End of Toolserver-l Digest, Vol 70, Issue 10
********************************************