Article View: comp.lang.java
Article #588Article on ATG Dynamo Connection Pooling Parameters That Will Prevent Downtime
From: Brad Johnson
Date: Sat, 31 May 2003 02:23
Date: Sat, 31 May 2003 02:23
24 lines
2130 bytes
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-mailShow 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