[opencms-dev] openCMS too much connections problem

[Petr Hollay]

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

you can try to increase
pool.mysql.maxConn=20
pool.mysql.increaseRate=5

to e.g. maxConn=60 and increaseRate=10.


> For first instance.. to 10 minutes ..
Exactly, I would try 10min, if no change then 1000.


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


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