Thread View: comp.lang.java
1 messages
1 total messages
Started by Brad Johnson
Sat, 31 May 2003 02:23
Article on ATG Dynamo Connection Pooling Parameters That Will Prevent Downtime
Author: 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
Thread Navigation
This is a paginated view of messages in the thread with full content displayed inline.
Messages are displayed in chronological order, with the original post highlighted in green.
Use pagination controls to navigate through all messages in large threads.
Back to All Threads