[opencms-dev] openCMS too much connections problem

Nico Krause Nico.Krause at nsc.eu.com
Fri Mar 7 15:03:02 CET 2003


What means:

pool.mysqlonline.maxage=360

6 minutes? 

Here is my configuration.. the online and backup config is equal
pool.mysql.driver=org.gjt.mm.mysql.Driver
pool.mysql.url=jdbc:mysql://localhost:3306/opencms
pool.mysql.user=
pool.mysql.password=
pool.mysql.minConn=10
pool.mysql.maxConn=20
pool.mysql.increaseRate=5
pool.mysql.timeout=120
pool.mysql.maxage=360

But the connections will not be closed.. that's the thing it grows and
grows..

Thanks for any tips..

Nico



-----Original Message-----
From: Petr Hollay [mailto:ph at ethikom.de] 
Sent: Freitag, 7. März 2003 14:50
To: opencms-dev at www.opencms.org
Subject: RE: [opencms-dev] openCMS too much connections problem

Hello Nico,

did you check your opencms.properties?

pool.mysql.minConn=10
pool.mysql.maxConn=20
pool.mysql.increaseRate=5

pool.mysqlonline.minConn=5
pool.mysqlonline.maxConn=10
pool.mysqlonline.increaseRate=5


Regards
Petr

-----Original Message-----
From: owner-opencms-dev at www.opencms.org
[mailto:owner-opencms-dev at www.opencms.org]On Behalf Of Nico Krause
Sent: Friday, March 07, 2003 2:40 PM
To: opencms-dev at opencms.com
Subject: [opencms-dev] openCMS too much connections problem


Hi,

I don't know that cause, but I've a problem with my database connections to
MySQL. (OpenCMS 5.rc1 /  3.23.54-Max-log)
I close in my applications every connection (from OpenCMS Pool) with
con.close();

But OpenCMS seems to open so much connections again and again a new pool of
about 15.
Then if it's full it could be I cannot work any more clear.

Is there a way to setup the connection pool of opencms in a way?

Please help me.

Nico

____________________________________
Nico Krause
NorthStar Communications GmbH
Wallbergstr. 20-22     85221 Dachau
Telefon: +49 (0) 81 31 / 9 96 87 - 53
Fax:      +49 (0) 81 31 / 9 96 87 - 29
Mobil:    +49 (0) 1 74 / 9 89 19 49
Diese E-Mail enthält vertrauliche und/oder rechtlich geschützte
Informationen. Wenn Sie nicht der richtige Adressat sind oder diese  E-Mail
irrtümlich erhalten haben, informieren Sie bitte sofort den  Absender und
vernichten Sie diese Mail. Das unerlaubte Kopieren sowie  die unbefugte
Weitergabe dieser Mail ist nicht gestattet.
This e-mail may contain confidential and/or privileged information. If you
are not the intended recipient (or have received this e-mail in error)
please notify the sender immediately and destroy this e-mail.  Any
unauthorized copying, disclosure or distribution of the material in this
e-mail is strictly forbidden.



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20030307/d94aeb8d/attachment.htm>


More information about the opencms-dev mailing list