[opencms-dev] openCMS too much connections problem

[Petr Hollay]

RE: [opencms-dev] openCMS too much connections problemWhat did you change in
the last time - MySQL version, OpenCms version, Linux version ... ? :-)

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...


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]
  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/d41e6286/attachment.htm>