[opencms-dev] openCMS too much connections problem

[Petr Hollay]

> What means:
> pool.mysqlonline.maxage=360
> 6 minutes?

It seems (from Java sources) that 360 minutes. CmsPool destroys (closes)
connection, if it is older than this interval, when putting back to pool.

I would try to use MySQL Standard, not Max,
and then latest version 3.23.55. And then OpenCms 5 RC2 :-)

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 3:03 PM
To: 'opencms-dev at www.opencms.org'
Subject: RE: [opencms-dev] openCMS too much connections problem


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.