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<mailto: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<mailto:jdso...@shyle.net>> wrote: ** Sweet... don't think I knew this.. New feature?? Joe From: John Sundberg<mailto:john.sundb...@kineticdata.com> Sent: Monday, September 17, 2012 4:56 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG<mailto: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 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"