[opencms-dev] openCMS too much connections problem

[Nico Krause]

Hi Petr,
 
 
 
What did you change in the last time - MySQL version, OpenCms version, Linux
version ... ? :-)
I changed nothing.. I discovered it right now. I hope it will not be a
nightmare for me this weekend. There are a lot of users more online since
yesterday at the server.
Maybe I will write in the meantime a little program which will kill the
connections manually if  they are too old.. also I could change the 360
Minutes value. For first instance.. to 10 minutes .. maybe this is not bad.
Are you also sure it's Minutes and not seconds? (pool.mysql.maxage=360)
 
 
 
Btw. are you sure it is good idea to run OpenCms 5 RC1 on production server?
I would prefer to stay with 4.6.x until OpenCms 5 Release is available and
some weeks of successful testing are done...
I'm relatively sure yes. But I would wish to upgrade to 5 RC2 - if  this
would not so much work;) (3 concurrent projects in it..) 
 
 4.6. I cannot use because of the missing JSP functionality.
 
But thanks for your comment!
 
Nico
 
 
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:22 PM
To: 'opencms-dev at www.opencms.org'
Subject: RE: [opencms-dev] openCMS too much connections problem
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 <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/8c9babc8/attachment.htm>