<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>RE: [opencms-dev] openCMS too much connections problem</TITLE>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1141" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Tahoma color=#0000ff size=2><SPAN class=701552614-07032003>What
did you change in the last time - MySQL version, OpenCms version, Linux
version ... ? :-)</SPAN></FONT></DIV>
<DIV><FONT face=Tahoma color=#0000ff size=2><SPAN
class=701552614-07032003></SPAN></FONT> </DIV>
<DIV><FONT face=Tahoma color=#0000ff size=2><SPAN class=701552614-07032003>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...</SPAN></FONT></DIV>
<DIV><FONT face=Tahoma color=#0000ff size=2><SPAN
class=701552614-07032003></SPAN></FONT> </DIV>
<DIV><FONT face=Tahoma color=#0000ff size=2><SPAN
class=701552614-07032003></SPAN></FONT> </DIV>
<DIV><FONT face=Tahoma color=#0000ff size=2><SPAN
class=701552614-07032003>Petr</SPAN></FONT></DIV>
<DIV><FONT face=Tahoma color=#0000ff size=2><SPAN
class=701552614-07032003></SPAN></FONT> </DIV>
<DIV><FONT face=Tahoma color=#0000ff size=2><SPAN
class=701552614-07032003></SPAN></FONT> </DIV>
<BLOCKQUOTE>
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B>
owner-opencms-dev@www.opencms.org
[mailto:owner-opencms-dev@www.opencms.org]<B>On Behalf Of </B>Nico
Krause<BR><B>Sent:</B> Friday, March 07, 2003 3:22 PM<BR><B>To:</B>
'opencms-dev@www.opencms.org'<BR><B>Subject:</B> RE: [opencms-dev] openCMS too
much connections problem<BR><BR></FONT></DIV>
<P><FONT size=2>Thanks.. </FONT></P>
<P><FONT size=2>It looks like this:</FONT> <BR><FONT size=2>.</FONT> <BR><FONT
size=2>.</FONT> <BR><FONT size=2>.</FONT> <BR><FONT size=2>.</FONT> <BR><FONT
size=2>| 113 | someuser | someserver| opencms |
Sleep | 446</FONT> <BR><FONT
size=2> | |
NULL
|</FONT> <BR><FONT size=2>| 114 | someuser | someserver|
opencms | Sleep | 446</FONT> <BR><FONT
size=2> | |
NULL
|</FONT> <BR><FONT size=2>| 115 | someuser | someserver|
opencms | Sleep | 44</FONT> <BR><FONT
size=2> | |
NULL
|</FONT> <BR><FONT size=2>| 116 | someuser | someserver|
opencms | Sleep | 445</FONT> <BR><FONT
size=2> | |
NULL
|</FONT> <BR><FONT size=2>| 117 | someuser | someserver|
opencms | Sleep | 445</FONT> <BR><FONT
size=2> | |
NULL
|</FONT> <BR><FONT size=2>| 118 | someuser | someserver|
opencms | Sleep | 445</FONT> <BR><FONT
size=2> | |
NULL
|</FONT> <BR><FONT size=2>| 119 | someuser | someserver|
opencms | Sleep | 445</FONT> <BR><FONT
size=2> | |
NULL
|</FONT> <BR><FONT size=2>| 120 | someuser | someserver|
opencms | Sleep | 445</FONT> <BR><FONT
size=2> | |
NULL
|</FONT> <BR><FONT size=2>| 121 | someuser | someserver|
opencms | Sleep | 445</FONT> <BR><FONT
size=2> | |
NULL
|</FONT> <BR><FONT size=2>| 122 | someuser | someserver|
opencms | Sleep | 445</FONT> <BR><FONT
size=2> | |
NULL
|</FONT> <BR><FONT size=2>| 123 | someuser | someserver|
opencms | Sleep | 445</FONT> <BR><FONT
size=2> | |
NULL
|</FONT> <BR><FONT size=2>| 125 | someuser | someserver|
opencms | Sleep | 44</FONT> <BR><FONT
size=2> | |
NULL
|</FONT> <BR><FONT size=2>| 126 | someuser | opencms |
Query | 0</FONT> <BR><FONT size=2> | NULL | show
processlist |</FONT> <BR><FONT size=2>83 rows in set (0.41 sec)</FONT> </P>
<P><FONT size=2>it seems it opens the connections again and again from alone..
by not closing old ones. very strange.. </FONT><BR><FONT size=2>a productional
server .. oh my good.. happy weekend. ;-)</FONT> </P>
<P><FONT size=2>Thank you,</FONT> </P>
<P><FONT size=2>Nico</FONT> </P><BR><BR><BR><BR><BR>
<P><FONT size=2>-----Original Message-----</FONT> <BR><FONT size=2>From:
Andras Balogh [<A href="mailto:java@reea.net">mailto:java@reea.net</A>]
</FONT><BR><FONT size=2>Sent: Freitag, 7. März 2003 15:12</FONT> <BR><FONT
size=2>To: opencms-dev@www.opencms.org</FONT> <BR><FONT size=2>Subject: Re:
[opencms-dev] openCMS too much connections problem</FONT> </P>
<P><FONT size=2>RE: [opencms-dev] openCMS too much connections
problemHi,</FONT> </P>
<P><FONT size=2>I don't know how much this helps but you can execute the
query</FONT> <BR><FONT size=2>"SHOW PROCESSLIST" in a mysql console (or any
other mysql frontend)</FONT> <BR><FONT size=2>so can see exactly how many
connections do you have at a given point.</FONT> </P>
<P><FONT size=2>BW,</FONT> </P>
<P><FONT size=2>Andras.</FONT> </P><BR>
<P><FONT size=2>----- Original Message -----</FONT> <BR><FONT size=2>From:
Nico Krause</FONT> <BR><FONT size=2>To: 'opencms-dev@www.opencms.org'</FONT>
<BR><FONT size=2>Sent: Friday, March 07, 2003 16:03</FONT> <BR><FONT
size=2>Subject: RE: [opencms-dev] openCMS too much connections problem</FONT>
</P><BR>
<P><FONT size=2>What means:</FONT> <BR><FONT
size=2>pool.mysqlonline.maxage=360</FONT> <BR><FONT size=2>6 minutes?</FONT>
<BR><FONT size=2>Here is my configuration.. the online and backup config is
equal</FONT> <BR><FONT size=2>pool.mysql.driver=org.gjt.mm.mysql.Driver</FONT>
<BR><FONT size=2>pool.mysql.url=jdbc:mysql://localhost:3306/opencms</FONT>
<BR><FONT size=2>pool.mysql.user=</FONT> <BR><FONT
size=2>pool.mysql.password=</FONT> <BR><FONT
size=2>pool.mysql.minConn=10</FONT> <BR><FONT
size=2>pool.mysql.maxConn=20</FONT> <BR><FONT
size=2>pool.mysql.increaseRate=5</FONT> <BR><FONT
size=2>pool.mysql.timeout=120</FONT> <BR><FONT
size=2>pool.mysql.maxage=360</FONT> <BR><FONT size=2>But the connections will
not be closed.. that's the thing it grows and</FONT> <BR><FONT
size=2>grows..</FONT> <BR><FONT size=2>Thanks for any tips..</FONT> <BR><FONT
size=2>Nico</FONT> </P><BR></BLOCKQUOTE></BODY></HTML>