[Benchmarking] MapServer oracle fastcgi leaking...

[Smith, Michael ERDC-USACE-NH]

All map draws

Mike


-- 
Michael Smith
RSGIS Center
US Army Corps of Engineers




On 10/12/09 1:03 AM, "Stephen Lime" <sdlime at comcast.net> wrote:

> Do you know what types of operations are being run? All map draws or
> are there queries
> in the mix (via WFS). I can check with the contributor of much of the
> new Oracle code to see
> if he has thoughts on where to look...
> 
> Steve
> 
> On Oct 11, 2009, at 11:51 PM, Frank Warmerdam wrote:
> 
>> Guys,
>> 
>> Mike and I spent some time looking into the leak tonight to no real
>> compelling
>> effect I'm afraid.  Mike confirmed the problem is just the oracle
>> case, and
>> only occurs in 5.6, not 5.4.
>> 
>> I ran mapserv for one oracle map request under valgrind and there was
>> no
>> obvious sign of big leakage beyond the one time connection setup costs.
>> 
>> I guessed there might be problems with the connection pooling, and did
>> some
>> fastcgi debug logging, but after Mike pointed out an obvious point I
>> concluded
>> that the connection pooling did seem to be working ok and there is no
>> particular reason to believe there is a connection level leak.
>> 
>> The changes between 5.4 and 5.6 are huge.  Mike found an interesting
>> point or
>> two, but I'm out of poop for the night.
>> 
>> Best regards,
>> --  
>> ---------------------------------------
>> +--------------------------------------
>> I set the clouds in motion - turn up   | Frank Warmerdam,
>> warmerdam at pobox.com
>> light and sound - activate the windows | http://pobox.com/~warmerdam
>> and watch the world go round - Rush    | Geospatial Programmer for Rent
>> 
>> _______________________________________________
>> Benchmarking mailing list
>> Benchmarking at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/benchmarking
>> 
> 
> _______________________________________________
> Benchmarking mailing list
> Benchmarking at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/benchmarking