🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

1 total messages Started by Brad Johnson Sat, 31 May 2003 02:23
Article on ATG Dynamo Connection Pooling Parameters That Will Prevent Downtime
#588
Author: 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
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