[opencms-dev] openCMS too much connections problem

[Nico Krause]

Thanks.. 

It looks like this:
.
.
.
.
| 113 | someuser | someserver| opencms    | Sleep   | 446
 |       | NULL             |
| 114 | someuser | someserver| opencms    | Sleep   | 446
 |       | NULL             |
| 115 | someuser | someserver| opencms    | Sleep   | 44
 |       | NULL             |
| 116 | someuser | someserver| opencms    | Sleep   | 445
 |       | NULL             |
| 117 | someuser | someserver| opencms    | Sleep   | 445
 |       | NULL             |
| 118 | someuser | someserver| opencms    | Sleep   | 445
 |       | NULL             |
| 119 | someuser | someserver| opencms    | Sleep   | 445
 |       | NULL             |
| 120 | someuser | someserver| opencms    | Sleep   | 445
 |       | NULL             |
| 121 | someuser | someserver| opencms    | Sleep   | 445
 |       | NULL             |
| 122 | someuser | someserver| opencms    | Sleep   | 445
 |       | NULL             |
| 123 | someuser | someserver| opencms    | Sleep   | 445
 |       | NULL             |
| 125 | someuser | someserver| opencms    | Sleep   | 44
 |       | NULL             |
| 126 | someuser | opencms    | Query   | 0
 | NULL  | show processlist |
83 rows in set (0.41 sec)

it seems it opens the connections again and again from alone.. by not
closing old ones. very strange.. 
a productional server .. oh my good.. happy weekend. ;-)

Thank you,

Nico






-----Original Message-----
From: Andras Balogh [mailto:java at reea.net] 
Sent: Freitag, 7. März 2003 15:12
To: opencms-dev at www.opencms.org
Subject: Re: [opencms-dev] openCMS too much connections problem

RE: [opencms-dev] openCMS too much connections problemHi,

I don't know how much this helps but you can execute the query
"SHOW PROCESSLIST" in a mysql console (or any other mysql frontend)
so can see exactly how many connections do you have at a given point.

BW,

Andras.


----- Original Message -----
From: Nico Krause
To: 'opencms-dev at www.opencms.org'
Sent: Friday, March 07, 2003 16:03
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


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