[opencms-dev] meaning of database parameters in opencms.properties

[Thomas, Cord]

To add to this, there are practical implications of each - see below

-----Original Message-----
From: opencms-dev-admin at opencms.org
[mailto:opencms-dev-admin at opencms.org] On Behalf Of tol
Sent: Thursday, January 15, 2004 4:24 PM
To: opencms-dev at opencms.org
Subject: Re: [opencms-dev] meaning of database parameters in
opencms.properties

Hi,

the first question is, are you familar with the idea of a connection
pool?

> What's the meaning of this parameters in opencms.properties?
I assume the following - if I'm not right please, please correct me! :-)

> pool.mysql.minConn=10
the count of min. simultaneous open connection to the mysqldatabase.  

This means the connection pool object will maintain at all times at
least 10 connection threads (?) to the database which can be used by any
request.  The pool monitors if this is enough given the load - if it is
not enough, it will raise the number of connections to the maxConn value
at an increment of increaseRate - reducing the number of times it has to
change it's pool connection count (I believe then it also releases
connections at this rate if it finds it can)

> pool.mysql.maxConn=20
the count of max. simultaneous open connection to the mysqldatabase

> pool.mysql.increaseRate=5
if the current opened connection are all in use and a new connection is 
necessary then 5 new one are open a the same time.

> pool.mysql.timeout=120
the idletime for an used connection

If a request does not properly close it's connection that it is using
from the pool, the pool will close the connection in timeout seconds


> pool.mysql.maxage=360
the max.time a connection can be used.

If a request uses a connection for a 'long transaction' or the request
causes excessive time load on the connection, the pool will force a
closure in maxage seconds...

Tol
-- 
independent internet radio berlin
http://www.recordcaster.de


_______________________________________________
This mail is send to you from the opencms-dev mailing list
To change your list options, or to unsubscribe from the list, please
visit
http://mail.opencms.org/mailman/listinfo/opencms-dev