Just an update on this old thread, the 'Large-Result-Logging-Threshold' setting has finally been added to the product docs in 7.6.04 Optimizing and Troubleshooting Guide starting on pg. 100.
Jason On Wed, Aug 25, 2010 at 10:32 AM, Jason Miller <jason.mil...@gmail.com>wrote: > I was going to mention that we should start adding these things to the > Undocumented Config Settings section on ARSWiki (and was going to add it)... > and what do you know? It is already there! > > http://arswiki.org/wiki/Undocumented_Config_Settings > > Jason > > > On Wed, Aug 25, 2010 at 10:10 AM, Jason Miller <jason.mil...@gmail.com>wrote: > >> Hi Frank, >> >> Add 'Large-Result-Logging-Threshold: 1000000' to the ar.cfg/ar.conf file. >> >> I *think* the 1000000 is bytes of memory. NOTE: we added an extra zero >> from Mark Walter's suggestion (POST: "ARS 7.1 server group issue" from >> 2/25/09). >> >> You will end up with something like this in the arthread.log >> >> <THRD> /* Sun Aug 22 2010 23:25:36.6000 */ Thread Id 7984 (GLEWMSF) large >> result buffer allocation - /Length: 1081258/Entries: 9643/Client Ver: >> >=10/RPC ID: 16988634/User: <username>/ >> <THRD> /* Sun Aug 22 2010 23:25:42.4280 */ Thread Id 3828 (GLEWMSF) large >> result buffer allocation - /Length: 3350577/Entries: 31159/Client Ver: >> >=10/RPC ID: 16988666/User: <username>/ >> <THRD> /* Sun Aug 22 2010 23:55:39.0250 */ Thread Id 3996 (GLEWF) large >> result buffer allocation - /Length: 1724986/Entries: 14665/Client Ver: >> >=10/RPC ID: 16999731/User: <username>/Form: <FormName>/ >> <THRD> /* Mon Aug 23 2010 11:21:26.4610 */ Thread Id 4436 (GLEWF) large >> result buffer allocation - /Length: 3994125/Entries: 31626/Client Ver: >> >=10/RPC ID: 17364769/User: <username>/Form: <FormName>/ >> >> >> On Wed, Aug 25, 2010 at 9:46 AM, Frank Caruso <caruso.fr...@gmail.com>wrote: >> >>> ** I remember seeing a posting to the list within the last few months >>> about a ARS 6.3 setting in the conf file that would allow the logging of >>> long running queries. I believe this is an undocumented feature. >>> I have tried searching the archives but am not able to find the email. >>> >>> Anybody have or remember the posting? >>> >>> Frank Caruso >>> >>> _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ >> >> >> > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"