Awesome discussion on a very relevant problem.
2 observations:
- Peter's original code worked and was tested
- People have much higher values in their connection pools compared to the
standard build properties.
Combined these two in a jira ticket & pull request:
https://jira.duraspace.org/browse/DS-1458
But really all kudos go to Peter for the code, André for bringing it back
up again, Hilton for the great screenshot on connection usage.
--
[image: logo]
*Bram Luyten* *@mire*
*2888 Loker Avenue East, Suite 315, Carlsbad, CA. 92010*
*Esperantolaan 4, Heverlee 3001, Belgium*
<http://www.atmire.com/>www.atmire.com<http://atmire.com/website/?q=services&utm_source=emailfooter&utm_medium=email&utm_campaign=braml>
On Mon, Jan 14, 2013 at 6:39 PM, Peter Dietz <[email protected]> wrote:
> Hi André,
>
> We've kept the WHEN_EXHAUSTED_GROW code during 1.7, and have just upgraded
> with it in 1.8, and we are not plagued by the errors and downtime. Since we
> do allow for an unlimited number of connections, there are times when the
> site can get slow (heavy load), but it will eventually respond and recover.
> We don't use Discovery, so no I have no input with regards to that.
>
> I don't know if its relevant, but we've also moved PostgreSQL off to its
> own dedicated server, so atleast the system isn't processing both
> DSpace/tomcat requests, and DB queries on the same machine.
>
> Peter Dietz
>
>
> On Mon, Jan 14, 2013 at 10:38 AM, Hilton Gibson
> <[email protected]>wrote:
>
>> You can with:
>> http://wiki.lib.sun.ac.za/index.php/SUNScholar/Disaster_Recovery/System_Monitor
>>
>> On 14 January 2013 15:07, helix84 <[email protected]> wrote:
>>
>>> Hilton, that's a wonderful graph exactly illustrating the problem (the
>>> spike in "idle in transaction" connections). I wish I had such
>>> monitoring set up :)
>>>
>>
>>
>>
>>
>> --
>> *Hilton Gibson*
>> Systems Administrator
>> JS Gericke Library
>> Room 1025D
>> Stellenbosch University
>> Private Bag X5036
>> Stellenbosch
>> 7599
>> South Africa
>>
>> Tel: +27 21 808 4100 | Cell: +27 84 646 4758
>> http://library.sun.ac.za
>> http://scholar.sun.ac.za
>> http://ar1.sun.ac.za
>> http://aj1.sun.ac.za
>>
>>
>> ------------------------------------------------------------------------------
>> Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS,
>> MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current
>> with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft
>> MVPs and experts. SALE $99.99 this month only -- learn more at:
>> http://p.sf.net/sfu/learnmore_122412
>> _______________________________________________
>> DSpace-tech mailing list
>> [email protected]
>> https://lists.sourceforge.net/lists/listinfo/dspace-tech
>> List Etiquette:
>> https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
>>
>
>
>
> ------------------------------------------------------------------------------
> Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS,
> MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current
> with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft
> MVPs and experts. SALE $99.99 this month only -- learn more at:
> http://p.sf.net/sfu/learnmore_122412
> _______________________________________________
> DSpace-tech mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/dspace-tech
> List Etiquette:
> https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
>
------------------------------------------------------------------------------
Master HTML5, CSS3, ASP.NET, MVC, AJAX, Knockout.js, Web API and
much more. Get web development skills now with LearnDevNow -
350+ hours of step-by-step video tutorials by Microsoft MVPs and experts.
SALE $99.99 this month only -- learn more at:
http://p.sf.net/sfu/learnmore_122812
_______________________________________________
DSpace-tech mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech
List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
