<table cellspacing="0" cellpadding="0" border="0" ><tr><td valign="top" style="font: inherit;">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. <br><br>- Jason<br><br>--- On <b>Tue, 8/16/11, toolserver-l-request@lists.wikimedia.org <i><toolserver-l-request@lists.wikimedia.org></i></b> wrote:<br><blockquote style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"><br>From: toolserver-l-request@lists.wikimedia.org <toolserver-l-request@lists.wikimedia.org><br>Subject: Toolserver-l Digest, Vol 70, Issue 10<br>To: toolserver-l@lists.wikimedia.org<br>Date: Tuesday, August 16, 2011, 5:00 AM<br><br><div class="plainMail">Send Toolserver-l mailing list submissions to<br> <a ymailto="mailto:toolserver-l@lists.wikimedia.org"
href="/mc/compose?to=toolserver-l@lists.wikimedia.org">toolserver-l@lists.wikimedia.org</a><br><br>To subscribe or unsubscribe via the World Wide Web, visit<br> <a href="https://lists.wikimedia.org/mailman/listinfo/toolserver-l" target="_blank">https://lists.wikimedia.org/mailman/listinfo/toolserver-l</a><br>or, via email, send a message with subject or body 'help' to<br> <a ymailto="mailto:toolserver-l-request@lists.wikimedia.org" href="/mc/compose?to=toolserver-l-request@lists.wikimedia.org">toolserver-l-request@lists.wikimedia.org</a><br><br>You can reach the person managing the list at<br> <a ymailto="mailto:toolserver-l-owner@lists.wikimedia.org" href="/mc/compose?to=toolserver-l-owner@lists.wikimedia.org">toolserver-l-owner@lists.wikimedia.org</a><br><br>When replying, please edit your Subject line so it is more specific<br>than "Re: Contents of Toolserver-l digest..."<br><br><br>Today's
Topics:<br><br> 1. Re: [Toolserver-announce] Query-Killer is back in action<br> (Huib Laurens)<br> 2. Re: Query-Killer is back in action (Maarten Dammers)<br> 3. Re: Query-Killer is back in action (DaB.)<br> 4. Re: Query-Killer is back in action (K. Peachey)<br><br><br>----------------------------------------------------------------------<br><br>Message: 1<br>Date: Mon, 15 Aug 2011 17:43:15 +0200<br>From: Huib Laurens <<a ymailto="mailto:sterkebak@gmail.com" href="/mc/compose?to=sterkebak@gmail.com">sterkebak@gmail.com</a>><br>Subject: Re: [Toolserver-l] [Toolserver-announce] Query-Killer is back<br> in action<br>To: <a ymailto="mailto:toolserver-l@lists.wikimedia.org" href="/mc/compose?to=toolserver-l@lists.wikimedia.org">toolserver-l@lists.wikimedia.org</a><br>Message-ID:<br>
<CAGkfB_qcKj=yfB9hTn+<a ymailto="mailto:oeW1GTJcOo-_uPznmXX1fTrbDB8iCfQ@mail.gmail.com" href="/mc/compose?to=oeW1GTJcOo-_uPznmXX1fTrbDB8iCfQ@mail.gmail.com">oeW1GTJcOo-_uPznmXX1fTrbDB8iCfQ@mail.gmail.com</a>><br>Content-Type: text/plain; charset=ISO-8859-1<br><br>Is this script somewhere aivable? I would like to use it also outside<br>the toolserver.,<br><br><br>2011/8/15, Magnus Manske <<a ymailto="mailto:magnusmanske@googlemail.com" href="/mc/compose?to=magnusmanske@googlemail.com">magnusmanske@googlemail.com</a>>:<br>> On Mon, Aug 15, 2011 at 1:30 AM, DeltaQuad Wikipedia<br>> <<a ymailto="mailto:deltaquadwiki@gmail.com" href="/mc/compose?to=deltaquadwiki@gmail.com">deltaquadwiki@gmail.com</a>> wrote:<br>>> Quick question, is "Unable to run job: got no response from JSV script<br>>> "/sge62/default/common/jsv.sh" " The killer? becuase ya, I got a lot of<br>>> them, came home after about 5 hours to about 8 of
them, and my API queries<br>>> are quick...I don't get (unless it's the server) what i'm doing wrong.<br>><br>> It's not 'the killer', but it might be related, because I got those as<br>> well, first time ever:<br>><br>> Unable to run job: got no response from JSV script<br>> "/sge62/default/common/jsv.sh".<br>><br>> Magnus<br>><br>> _______________________________________________<br>> Toolserver-l mailing list (<a ymailto="mailto:Toolserver-l@lists.wikimedia.org" href="/mc/compose?to=Toolserver-l@lists.wikimedia.org">Toolserver-l@lists.wikimedia.org</a>)<br>> <a href="https://lists.wikimedia.org/mailman/listinfo/toolserver-l" target="_blank">https://lists.wikimedia.org/mailman/listinfo/toolserver-l</a><br>> Posting guidelines for this list:<br>> <a href="https://wiki.toolserver.org/view/Mailing_list_etiquette" target="_blank">https://wiki.toolserver.org/view/Mailing_list_etiquette</a><br>><br><br>--
<br>Verzonden vanaf mijn mobiele apparaat<br><br>Kind regards,<br><br>Huib Laurens<br>WickedWay.nl<br><br>Webhosting the wicked way.<br><br><br><br>------------------------------<br><br>Message: 2<br>Date: Mon, 15 Aug 2011 23:03:52 +0200<br>From: Maarten Dammers <<a ymailto="mailto:maarten@mdammers.nl" href="/mc/compose?to=maarten@mdammers.nl">maarten@mdammers.nl</a>><br>Subject: Re: [Toolserver-l] Query-Killer is back in action<br>To: <a ymailto="mailto:toolserver-l@lists.wikimedia.org" href="/mc/compose?to=toolserver-l@lists.wikimedia.org">toolserver-l@lists.wikimedia.org</a><br>Message-ID: <<a ymailto="mailto:4E4989B8.6080600@mdammers.nl" href="/mc/compose?to=4E4989B8.6080600@mdammers.nl">4E4989B8.6080600@mdammers.nl</a>><br>Content-Type: text/plain; charset=ISO-8859-1; format=flowed<br><br>Op 14-8-2011 18:42, DaB. schreef:<br>> <knip><br>><br>> [1]<br>> <a
href="https://wiki.toolserver.org/view/Database_access#Slow_queries_and_the_query_killer" target="_blank">https://wiki.toolserver.org/view/Database_access#Slow_queries_and_the_query_killer</a><br>Ah, you are the one who killed the categorization bot. Thanks for <br>announcing that beforehand (not!). It's very annoying that you suddenly <br>just decide to deploy a new toy the screws up our tools.<br><br>Maarten<br><br><br><br><br>------------------------------<br><br>Message: 3<br>Date: Mon, 15 Aug 2011 23:14:56 +0200<br>From: "DaB." <<a ymailto="mailto:WP@daniel.baur4.info" href="/mc/compose?to=WP@daniel.baur4.info">WP@daniel.baur4.info</a>><br>Subject: Re: [Toolserver-l] Query-Killer is back in action<br>To: <a ymailto="mailto:toolserver-l@lists.wikimedia.org" href="/mc/compose?to=toolserver-l@lists.wikimedia.org">toolserver-l@lists.wikimedia.org</a><br>Message-ID: <<a ymailto="mailto:201108152315.03221.WP@daniel.baur4.info"
href="/mc/compose?to=201108152315.03221.WP@daniel.baur4.info">201108152315.03221.WP@daniel.baur4.info</a>><br>Content-Type: text/plain; charset="utf-8"<br><br>Hello,<br>At Monday 15 August 2011 23:12:28 DaB. wrote:<br>> Thanks for announcing that beforehand (not!)<br><br>the linked wiki-page was updated with the information about the query-killer <br>more than 1 year ago. <br><br>Sincerly,<br>DaB.<br><br>-- <br>Userpage: [[:w:de:User:DaB.]] ? PGP: 2B255885<br>-------------- next part --------------<br>A non-text attachment was scrubbed...<br>Name: not available<br>Type: application/pgp-signature<br>Size: 198 bytes<br>Desc: This is a digitally signed message part.<br>Url : <a href="http://lists.wikimedia.org/pipermail/toolserver-l/attachments/20110815/74b9b806/attachment-0001.pgp" target="_blank">http://lists.wikimedia.org/pipermail/toolserver-l/attachments/20110815/74b9b806/attachment-0001.pgp</a>
<br><br>------------------------------<br><br>Message: 4<br>Date: Tue, 16 Aug 2011 08:39:49 +1000<br>From: "K. Peachey" <<a ymailto="mailto:p858snake@gmail.com" href="/mc/compose?to=p858snake@gmail.com">p858snake@gmail.com</a>><br>Subject: Re: [Toolserver-l] Query-Killer is back in action<br>To: <a ymailto="mailto:toolserver-l@lists.wikimedia.org" href="/mc/compose?to=toolserver-l@lists.wikimedia.org">toolserver-l@lists.wikimedia.org</a><br>Message-ID:<br> <CADnECnXP5Pn7=<a ymailto="mailto:aeFfwxDWz-tWgGbesH9Q3FgUVKRsRjV2Djxag@mail.gmail.com" href="/mc/compose?to=aeFfwxDWz-tWgGbesH9Q3FgUVKRsRjV2Djxag@mail.gmail.com">aeFfwxDWz-tWgGbesH9Q3FgUVKRsRjV2Djxag@mail.gmail.com</a>><br>Content-Type: text/plain; charset=UTF-8<br><br>On Tue, Aug 16, 2011 at 7:03 AM, Maarten Dammers <<a ymailto="mailto:maarten@mdammers.nl" href="/mc/compose?to=maarten@mdammers.nl">maarten@mdammers.nl</a>> wrote:<br>> Ah, you are the one who
killed the categorization bot. Thanks for<br>> announcing that beforehand (not!). It's very annoying that you suddenly<br>> just decide to deploy a new toy the screws up our tools.<br>><br>> Maarten<br>It was re-enabling a service that has been around for a long time that<br>[accidently] broke at one stage and because of the TS performance not<br>being degraded was never really noticed or cared about.<br><br>Recently a TS box went down and caused major issues (Replag was easily<br>over 2 days at one stage for those databases) for the backup box<br>handling the effected databases, DaB was monitoring this by hand and<br>manually killing the processes to keep this somewhat saner then<br>re-wrote and brought the tool back online to handle this when they<br>noticed it was [the tool] was not functioning.<br><br>This was a tool that was already meant to be running but by [your]<br>"luck" wasn't, and was already documented on wiki as DaB pointed
out<br>over a year ago.<br><br>Perhaps you should consider apologizing to DaB in regards to the tone<br>of your email.<br><br><br><br>------------------------------<br><br>_______________________________________________<br>Toolserver-l mailing list<br><a ymailto="mailto:Toolserver-l@lists.wikimedia.org" href="/mc/compose?to=Toolserver-l@lists.wikimedia.org">Toolserver-l@lists.wikimedia.org</a><br><a href="https://lists.wikimedia.org/mailman/listinfo/toolserver-l" target="_blank">https://lists.wikimedia.org/mailman/listinfo/toolserver-l</a><br><br><br>End of Toolserver-l Digest, Vol 70, Issue 10<br>********************************************<br></div></blockquote></td></tr></table>