🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: comp.lang.java
Article #588

Article on ATG Dynamo Connection Pooling Parameters That Will Prevent Downtime

#588
From: Brad Johnson
Date: Sat, 31 May 2003 02:23
24 lines
2130 bytes
I hope this document is a help to someone. We were having problems
with our Dynamo servers grinding to a halt with over 40 threads per
CPU or DRP. In addition thread deaths were out of control. I was
unable to find a centralized summary of our particular problem and
wrote up this document which contains the sum of my findings. The root
cause was traced back to the DB connection pool and the overuse of
blocking=true.

Let me know if this helps you out in any way or if you find errors or
additions that can be made.

This document will describe the uses of parameters used to control the
Dynamo database pool. Using these parameters in conjunction should be
able to handle the issue of a slow database, a database down, a
database that went down and came back up leaving invalid connections
in the pool, a table lock, heavy traffic on the application or a slow
down in the network. They have been tested in a production environment
against Oracle, Sybase and MS SQL-Server.

http://job.wowak.com/dynamodbpool.html

Thanks
brad johnson
http://wowak.com
Technical Details
Message-ID: <a0f01011.0305301823.4182481e@posting.google.com>
Path: arc1-ca.pugleaf.net!archiver1.google.com!postnews1.google.com!not-for-mail

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: f9a23,77b81ca550ba6bc9,start
X-Google-Attributes: gidf9a23,public
X-Google-Thread: f5d71,77b81ca550ba6bc9,start
X-Google-Attributes: gidf5d71,public
X-Google-Thread: 11648c,77b81ca550ba6bc9,start
X-Google-Attributes: gid11648c,public
X-Google-ArrivalTime: 2003-05-30 19:23:13 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!postnews1.google.com!not-for-mail
From: bradleyjohnson@hotmail.com (Brad Johnson)
Newsgroups: comp.lang.java,dk.edb.programmering.java,fj.comp.lang.java
Subject: Article on ATG Dynamo Connection Pooling Parameters That Will Prevent Downtime
Date: 30 May 2003 19:23:12 -0700
Organization: http://groups.google.com/
Lines: 24
Message-ID: <a0f01011.0305301823.4182481e@posting.google.com>
NNTP-Posting-Host: 12.252.237.184
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1054347793 18832 127.0.0.1 (31 May 2003 02:23:13 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 31 May 2003 02:23:13 GMT