This is true.... But its still funny.... On Tue, Sep 18, 2012 at 6:41 AM, David Durling <durl...@uga.edu> wrote:
> ** > > Just to add for anyone who casually followed this & didn’t get it, John > was joking and “saying wouldn’t it be nice if there were something like > this”, but:**** > > ** ** > > There is NOT an ars_track_long_queries or > ars_track_long_queries_min_length for ar.cfg.**** > > ** ** > > Hope you don’t mind me explicitly adding that, John – but I got a little > confused in there… could imagine someone looking this up in the archives & > being frustrated when it didn’t work…**** > > ** ** > > David**** > > ** ** > > David Durling**** > > University of Georgia**** > > ** ** > > *From:* Action Request System discussion list(ARSList) [mailto: > arslist@ARSLIST.ORG] *On Behalf Of *John Sundberg > *Sent:* Monday, September 17, 2012 8:43 PM > > *To:* arslist@ARSLIST.ORG > *Subject:* Re: Querys that kill my system**** > > ** ** > > ** No - they won't work. :(**** > > ** ** > > Sorry...**** > > ** ** > > -John**** > > ** ** > > On Mon, Sep 17, 2012 at 6:05 PM, Chris Kelly <ctopke...@gmail.com> wrote:* > *** > > ** **** > > These are great suggestions But I an in 2012 and I need a solution > today.... > As you can tell I know nothing about remedy. So will adding the two lines > work?**** > > Any help is great, my future self says thanks also....**** > > Chris**** > > On Sep 17, 2012 4:26 PM, "Joe Martin D'Souza" <jdso...@shyle.net> wrote:** > ** > > ** **** > > **** > > Sweet... don’t think I knew this..**** > > **** > > New feature??**** > > **** > > Joe**** > > **** > > *From:* John Sundberg <john.sundb...@kineticdata.com> **** > > *Sent:* Monday, September 17, 2012 4:56 PM**** > > *Newsgroups:* public.remedy.arsystem.general**** > > *To:* arslist@ARSLIST.ORG **** > > *Subject:* Re: Querys that kill my system**** > > **** > > ** **** > > **** > > You could go into ar.cfg **** > > **** > > add the 2 lines :**** > > **** > > ars_track_long_queries: true**** > > ars_track_long_queries_min_length: 5000 # This is milliseconds - so all > greater than 5 seconds**** > > **** > > **** > > Then -- restart server**** > > **** > > Look for table called: "ARS_TRACK_QUERIES" (I think that is the name)…**** > > **** > > Look in there -- it will tell **** > > who**** > > when**** > > what**** > > how long it ran**** > > how many entries returned**** > > what ip address**** > > what client type and version**** > > **** > > **** > > Pretty sweet feature… (wish I would have thought of it originally)**** > > **** > > **** > > -John**** > > **** > > **** > _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"