<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<meta name=ProgId content=Word.Document>
<meta name=Generator content="Microsoft Word 10">
<meta name=Originator content="Microsoft Word 10">
<link rel=File-List href="cid:filelist.xml@01C2E4BF.E8C200F0">
<title>RE: [opencms-dev] openCMS too much connections problem</title>
<!--[if gte mso 9]><xml>
<o:OfficeDocumentSettings>
<o:DoNotRelyOnCSS/>
</o:OfficeDocumentSettings>
</xml><![endif]--><!--[if gte mso 9]><xml>
<w:WordDocument>
<w:SpellingState>Clean</w:SpellingState>
<w:GrammarState>Clean</w:GrammarState>
<w:DocumentKind>DocumentEmail</w:DocumentKind>
<w:EnvelopeVis/>
<w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel>
</w:WordDocument>
</xml><![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;
mso-font-charset:0;
mso-generic-font-family:swiss;
mso-font-pitch:variable;
mso-font-signature:553679495 -2147483648 8 0 66047 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{mso-style-parent:"";
margin:0cm;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;
text-underline:single;}
a:visited, span.MsoHyperlinkFollowed
{color:blue;
text-decoration:underline;
text-underline:single;}
p
{mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:"Times New Roman";}
span.EmailStyle18
{mso-style-type:personal-reply;
mso-style-noshow:yes;
mso-ansi-font-size:10.0pt;
mso-bidi-font-size:10.0pt;
font-family:Arial;
mso-ascii-font-family:Arial;
mso-hansi-font-family:Arial;
mso-bidi-font-family:Arial;
color:navy;}
span.SpellE
{mso-style-name:"";
mso-spl-e:yes;}
span.GramE
{mso-style-name:"";
mso-gram-e:yes;}
@page Section1
{size:612.0pt 792.0pt;
margin:72.0pt 90.0pt 72.0pt 90.0pt;
mso-header-margin:35.4pt;
mso-footer-margin:35.4pt;
mso-paper-source:0;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 10]>
<style>
/* Style Definitions */
table.MsoNormalTable
{mso-style-name:"Table Normal";
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-parent:"";
mso-padding-alt:0cm 5.4pt 0cm 5.4pt;
mso-para-margin:0cm;
mso-para-margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:10.0pt;
font-family:"Times New Roman";}
</style>
<![endif]-->
</head>
<body lang=EN-US link=blue vlink=blue style='tab-interval:36.0pt'>
<div class=Section1>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Hi Petr,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'><o:p> </o:p></span></font></p>
<div>
<p class=MsoNormal style='margin-left:36.0pt'><font size=2 color=blue
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma;color:blue'>What
did you change in the last time - MySQL version, OpenCms version, Linux <span
class=GramE>version ...</span> ? :-)</span></font><font size=2 face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>I changed nothing<span class=GramE>..</span>
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.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Maybe I will write in the meantime a
little program which will kill the connections manually <span class=GramE>if <span
style='mso-spacerun:yes'> </span>they</span> are too old.. <span class=GramE>also</span>
I could change the 360 Minutes value. For first instance<span class=GramE>..</span>
<span class=GramE>to</span> 10 minutes .. <span class=GramE>maybe</span> this
is not bad. Are you also sure it's Minutes and not seconds? (<span
class=SpellE>pool.mysql.maxage</span>=360)<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-left:36.0pt'><font size=2 color=blue
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma;color:blue'>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><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><font size=3 color=navy face="Times New Roman"><span
style='font-size:12.0pt;color:navy'>I'm relatively sure yes. But I would
wish to upgrade to 5 RC2 - <span class=GramE>if <span
style='mso-spacerun:yes'> </span>this</span> would not so much work;) (3
concurrent projects in it<span class=GramE>..)</span> <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color=navy face="Times New Roman"><span
style='font-size:12.0pt;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 color=navy face="Times New Roman"><span
style='font-size:12.0pt;color:navy'><span style='mso-spacerun:yes'> </span>4.6.
I cannot use because of the missing JSP functionality.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color=navy face="Times New Roman"><span
style='font-size:12.0pt;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 color=navy face="Times New Roman"><span
style='font-size:12.0pt;color:navy'>But thanks for your comment!<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color=navy face="Times New Roman"><span
style='font-size:12.0pt;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 color=navy face="Times New Roman"><span
style='font-size:12.0pt;color:navy'>Nico</span></font><font size=2 color=navy
face=Arial><span style='font-size:10.0pt;font-family:Arial;color:navy'><o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-left:36.0pt'><font size=2 color=blue
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma;color:blue'>Petr</span></font><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'> <o:p></o:p></span></font></p>
</div>
<blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'>
<p class=MsoNormal style='mso-margin-top-alt:0cm;margin-right:0cm;margin-bottom:
12.0pt;margin-left:36.0pt'><font size=2 face=Tahoma><span style='font-size:
10.0pt;font-family:Tahoma'>-----Original Message-----<br>
<b><span style='font-weight:bold'>From:</span></b>
owner-opencms-dev@www.opencms.org [mailto:owner-opencms-dev@www.opencms.org]<b><span
style='font-weight:bold'>On Behalf Of </span></b>Nico Krause<br>
<b><span style='font-weight:bold'>Sent:</span></b> Friday, March 07, 2003 3:22
PM<br>
<b><span style='font-weight:bold'>To:</span></b> 'opencms-dev@www.opencms.org'<br>
<b><span style='font-weight:bold'>Subject:</span></b> RE: [opencms-dev] openCMS
too much connections problem</span></font><o:p></o:p></p>
<p style='margin-left:36.0pt'><font size=2 face="Times New Roman"><span
style='font-size:10.0pt'>Thanks.. </span></font><o:p></o:p></p>
<p style='margin-left:36.0pt'><font size=2 face="Times New Roman"><span
style='font-size:10.0pt'>It looks like this:</span></font> <br>
<font size=2><span style='font-size:10.0pt'>.</span></font> <br>
<font size=2><span style='font-size:10.0pt'>.</span></font> <br>
<font size=2><span style='font-size:10.0pt'>.</span></font> <br>
<font size=2><span style='font-size:10.0pt'>.</span></font> <br>
<font size=2><span style='font-size:10.0pt'>| 113 | someuser | someserver|
opencms | Sleep | 446</span></font> <br>
<font size=2><span style='font-size:10.0pt'> |
| NULL
|</span></font> <br>
<font size=2><span style='font-size:10.0pt'>| 114 | someuser | someserver|
opencms | Sleep | 446</span></font> <br>
<font size=2><span style='font-size:10.0pt'> |
| NULL
|</span></font> <br>
<font size=2><span style='font-size:10.0pt'>| 115 | someuser | someserver|
opencms | Sleep | 44</span></font> <br>
<font size=2><span style='font-size:10.0pt'> |
| NULL
|</span></font> <br>
<font size=2><span style='font-size:10.0pt'>| 116 | someuser | someserver|
opencms | Sleep | 445</span></font> <br>
<font size=2><span style='font-size:10.0pt'> |
| NULL
|</span></font> <br>
<font size=2><span style='font-size:10.0pt'>| 117 | someuser | someserver|
opencms | Sleep | 445</span></font> <br>
<font size=2><span style='font-size:10.0pt'> |
| NULL
|</span></font> <br>
<font size=2><span style='font-size:10.0pt'>| 118 | someuser | someserver|
opencms | Sleep | 445</span></font> <br>
<font size=2><span style='font-size:10.0pt'> |
| NULL
|</span></font> <br>
<font size=2><span style='font-size:10.0pt'>| 119 | someuser | someserver|
opencms | Sleep | 445</span></font> <br>
<font size=2><span style='font-size:10.0pt'> |
| NULL
|</span></font> <br>
<font size=2><span style='font-size:10.0pt'>| 120 | someuser | someserver|
opencms | Sleep | 445</span></font> <br>
<font size=2><span style='font-size:10.0pt'> |
| NULL
|</span></font> <br>
<font size=2><span style='font-size:10.0pt'>| 121 | someuser | someserver|
opencms | Sleep | 445</span></font> <br>
<font size=2><span style='font-size:10.0pt'> |
| NULL
|</span></font> <br>
<font size=2><span style='font-size:10.0pt'>| 122 | someuser | someserver|
opencms | Sleep | 445</span></font> <br>
<font size=2><span style='font-size:10.0pt'> |
| NULL
|</span></font> <br>
<font size=2><span style='font-size:10.0pt'>| 123 | someuser | someserver|
opencms | Sleep | 445</span></font> <br>
<font size=2><span style='font-size:10.0pt'> |
| NULL
|</span></font> <br>
<font size=2><span style='font-size:10.0pt'>| 125 | someuser | someserver|
opencms | Sleep | 44</span></font> <br>
<font size=2><span style='font-size:10.0pt'> |
| NULL
|</span></font> <br>
<font size=2><span style='font-size:10.0pt'>| 126 | someuser |
opencms | Query | 0</span></font> <br>
<font size=2><span style='font-size:10.0pt'> | NULL | show
processlist |</span></font> <br>
<font size=2><span style='font-size:10.0pt'>83 rows in set (0.41 sec)</span></font>
<o:p></o:p></p>
<p style='margin-left:36.0pt'><font size=2 face="Times New Roman"><span
style='font-size:10.0pt'>it seems it opens the connections again and again from
alone.. by not closing old ones. very strange.. </span></font><br>
<font size=2><span style='font-size:10.0pt'>a productional server .. oh my
good.. happy weekend. ;-)</span></font> <o:p></o:p></p>
<p style='margin-left:36.0pt'><font size=2 face="Times New Roman"><span
style='font-size:10.0pt'>Thank you,</span></font> <o:p></o:p></p>
<p style='margin-left:36.0pt'><font size=2 face="Times New Roman"><span
style='font-size:10.0pt'>Nico</span></font> <o:p></o:p></p>
<p class=MsoNormal style='mso-margin-top-alt:0cm;margin-right:0cm;margin-bottom:
12.0pt;margin-left:36.0pt'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'><br>
<br>
<br style='mso-special-character:line-break'>
<![if !supportLineBreakNewLine]><br style='mso-special-character:line-break'>
<![endif]><o:p></o:p></span></font></p>
<p style='margin-left:36.0pt'><font size=2 face="Times New Roman"><span
style='font-size:10.0pt'>-----Original Message-----</span></font> <br>
<font size=2><span style='font-size:10.0pt'>From: Andras Balogh [<a
href="mailto:java@reea.net">mailto:java@reea.net</a>] </span></font><br>
<font size=2><span style='font-size:10.0pt'>Sent: Freitag, 7. März 2003 15:12</span></font>
<br>
<font size=2><span style='font-size:10.0pt'>To: opencms-dev@www.opencms.org</span></font>
<br>
<font size=2><span style='font-size:10.0pt'>Subject: Re: [opencms-dev] openCMS
too much connections problem</span></font> <o:p></o:p></p>
<p style='margin-left:36.0pt'><font size=2 face="Times New Roman"><span
style='font-size:10.0pt'>RE: [opencms-dev] openCMS too much connections
problemHi,</span></font> <o:p></o:p></p>
<p style='margin-left:36.0pt'><font size=2 face="Times New Roman"><span
style='font-size:10.0pt'>I don't know how much this helps but you can execute
the query</span></font> <br>
<font size=2><span style='font-size:10.0pt'>"SHOW PROCESSLIST" in a
mysql console (or any other mysql frontend)</span></font> <br>
<font size=2><span style='font-size:10.0pt'>so can see exactly how many
connections do you have at a given point.</span></font> <o:p></o:p></p>
<p style='margin-left:36.0pt'><font size=2 face="Times New Roman"><span
style='font-size:10.0pt'>BW,</span></font> <o:p></o:p></p>
<p style='margin-left:36.0pt'><font size=2 face="Times New Roman"><span
style='font-size:10.0pt'>Andras.</span></font> <o:p></o:p></p>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'><o:p> </o:p></span></font></p>
<p style='margin-left:36.0pt'><font size=2 face="Times New Roman"><span
style='font-size:10.0pt'>----- Original Message -----</span></font> <br>
<font size=2><span style='font-size:10.0pt'>From: Nico Krause</span></font> <br>
<font size=2><span style='font-size:10.0pt'>To: 'opencms-dev@www.opencms.org'</span></font>
<br>
<font size=2><span style='font-size:10.0pt'>Sent: Friday, March 07, 2003 16:03</span></font>
<br>
<font size=2><span style='font-size:10.0pt'>Subject: RE: [opencms-dev] openCMS
too much connections problem</span></font> <o:p></o:p></p>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'><o:p> </o:p></span></font></p>
<p style='margin-left:36.0pt'><font size=2 face="Times New Roman"><span
style='font-size:10.0pt'>What means:</span></font> <br>
<font size=2><span style='font-size:10.0pt'>pool.mysqlonline.maxage=360</span></font>
<br>
<font size=2><span style='font-size:10.0pt'>6 minutes?</span></font> <br>
<font size=2><span style='font-size:10.0pt'>Here is my configuration.. the
online and backup config is equal</span></font> <br>
<font size=2><span style='font-size:10.0pt'>pool.mysql.driver=org.gjt.mm.mysql.Driver</span></font>
<br>
<font size=2><span style='font-size:10.0pt'>pool.mysql.url=jdbc:mysql://localhost:3306/opencms</span></font>
<br>
<font size=2><span style='font-size:10.0pt'>pool.mysql.user=</span></font> <br>
<font size=2><span style='font-size:10.0pt'>pool.mysql.password=</span></font> <br>
<font size=2><span style='font-size:10.0pt'>pool.mysql.minConn=10</span></font>
<br>
<font size=2><span style='font-size:10.0pt'>pool.mysql.maxConn=20</span></font>
<br>
<font size=2><span style='font-size:10.0pt'>pool.mysql.increaseRate=5</span></font>
<br>
<font size=2><span style='font-size:10.0pt'>pool.mysql.timeout=120</span></font>
<br>
<font size=2><span style='font-size:10.0pt'>pool.mysql.maxage=360</span></font>
<br>
<font size=2><span style='font-size:10.0pt'>But the connections will not be
closed.. that's the thing it grows and</span></font> <br>
<font size=2><span style='font-size:10.0pt'>grows..</span></font> <br>
<font size=2><span style='font-size:10.0pt'>Thanks for any tips..</span></font>
<br>
<font size=2><span style='font-size:10.0pt'>Nico</span></font> <o:p></o:p></p>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'><o:p> </o:p></span></font></p>
</blockquote>
</div>
</body>
</html>