<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns="http://www.w3.org/TR/REC-html40" xmlns:o =
"urn:schemas-microsoft-com:office:office" xmlns:w =
"urn:schemas-microsoft-com:office:word"><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=Word.Document name=ProgId>
<META content="MSHTML 6.00.2800.1141" name=GENERATOR>
<META content="Microsoft Word 10" name=Originator><LINK
href="cid:filelist.xml@01C2E4BF.E8C200F0" rel=File-List><!--[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 style="tab-interval: 36.0pt" vLink=blue link=blue>
<DIV><FONT face=Arial><FONT color=#000080><FONT size=2><SPAN
class=827455814-07032003>Nico,</SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT color=#000080><FONT size=2><SPAN
class=827455814-07032003></SPAN></FONT></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT color=#000080><FONT size=2><SPAN
class=827455814-07032003>you can try to increase
</SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT color=#000080><FONT size=2><SPAN
class=827455814-07032003><SPAN style="FONT-SIZE: 10pt"><FONT
face="Times New Roman" color=#000000>pool.mysql.maxConn=20</FONT></SPAN><FONT
color=#000000><FONT face="Times New Roman"><FONT size=3> <BR></FONT><SPAN
style="FONT-SIZE: 10pt"><FONT
size=2>pool.mysql.increaseRate=5</SPAN></FONT></FONT></FONT><FONT
face="Times New Roman" color=#000000 size=3>
</FONT><BR></SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT color=#000080><FONT size=2><SPAN
class=827455814-07032003>to e.g. maxConn=60 and
increaseRate=10.</SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT color=#000080><FONT size=2><SPAN
class=827455814-07032003></SPAN></FONT></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT color=#000080><FONT size=2><SPAN
class=827455814-07032003></SPAN></FONT></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT color=#000080><FONT size=2><SPAN
class=827455814-07032003>> </SPAN>For first instance<SPAN
class=GramE>..</SPAN> <SPAN class=GramE>to</SPAN> 10 minutes
..</FONT></FONT></FONT></DIV>
<DIV><SPAN class=827455814-07032003><FONT face=Arial color=#000080
size=2>Exactly, I would try 10min, if no change then 1000.</FONT></SPAN></DIV>
<DIV><FONT face=Arial color=#000080 size=2></FONT> </DIV>
<DIV><FONT face=Arial color=#000080 size=2></FONT> </DIV>
<DIV><SPAN class=827455814-07032003><FONT face=Arial color=#000080
size=2>Petr</FONT></SPAN></DIV>
<DIV><SPAN class=827455814-07032003><FONT face=Arial color=#000080
size=2></FONT></SPAN> </DIV>
<DIV><FONT face=Arial color=#000080 size=2></FONT> </DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<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:46 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>
<DIV class=Section1>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Hi
Petr,<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 36pt"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt"><o:p> </o:p></SPAN></FONT></P>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 36pt"><FONT face=Tahoma color=blue
size=2><SPAN style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Tahoma">What
did you change in the last time - MySQL version, OpenCms version, Linux
<SPAN class=GramE>version ...</SPAN> ? :-)</SPAN></FONT><FONT face=Tahoma
size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma"><o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">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 face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">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 face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 36pt"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt"> <o:p></o:p></SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 36pt"><FONT face=Tahoma color=blue
size=2><SPAN style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Tahoma">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 face="Times New Roman" color=navy size=3><SPAN
style="FONT-SIZE: 12pt; 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 face="Times New Roman" color=navy size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: navy"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Times New Roman" color=navy size=3><SPAN
style="FONT-SIZE: 12pt; 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 face="Times New Roman" color=navy size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: navy"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Times New Roman" color=navy size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: navy">But thanks for your
comment!<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Times New Roman" color=navy size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: navy"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Times New Roman" color=navy size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: navy">Nico</SPAN></FONT><FONT face=Arial
color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"><o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 36pt"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt"> <o:p></o:p></SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 36pt"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt"> <o:p></o:p></SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 36pt"><FONT face=Tahoma color=blue
size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Tahoma">Petr</SPAN></FONT><o:p></o:p></P></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 36pt"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt"> <o:p></o:p></SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 36pt"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt"> <o:p></o:p></SPAN></FONT></P></DIV>
<BLOCKQUOTE style="MARGIN-TOP: 5pt; MARGIN-BOTTOM: 5pt">
<P class=MsoNormal
style="MARGIN-BOTTOM: 12pt; MARGIN-LEFT: 36pt; MARGIN-RIGHT: 0cm; mso-margin-top-alt: 0cm"><FONT
face=Tahoma size=2><SPAN
style="FONT-SIZE: 10pt; 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: 36pt"><FONT face="Times New Roman" size=2><SPAN
style="FONT-SIZE: 10pt">Thanks.. </SPAN></FONT><o:p></o:p></P>
<P style="MARGIN-LEFT: 36pt"><FONT face="Times New Roman" size=2><SPAN
style="FONT-SIZE: 10pt">It looks like this:</SPAN></FONT> <BR><FONT
size=2><SPAN style="FONT-SIZE: 10pt">.</SPAN></FONT> <BR><FONT size=2><SPAN
style="FONT-SIZE: 10pt">.</SPAN></FONT> <BR><FONT size=2><SPAN
style="FONT-SIZE: 10pt">.</SPAN></FONT> <BR><FONT size=2><SPAN
style="FONT-SIZE: 10pt">.</SPAN></FONT> <BR><FONT size=2><SPAN
style="FONT-SIZE: 10pt">| 113 | someuser | someserver|
opencms | Sleep | 446</SPAN></FONT> <BR><FONT
size=2><SPAN
style="FONT-SIZE: 10pt"> | |
NULL
|</SPAN></FONT> <BR><FONT size=2><SPAN style="FONT-SIZE: 10pt">| 114 |
someuser | someserver| opencms | Sleep |
446</SPAN></FONT> <BR><FONT size=2><SPAN
style="FONT-SIZE: 10pt"> | |
NULL
|</SPAN></FONT> <BR><FONT size=2><SPAN style="FONT-SIZE: 10pt">| 115 |
someuser | someserver| opencms | Sleep |
44</SPAN></FONT> <BR><FONT size=2><SPAN
style="FONT-SIZE: 10pt"> | |
NULL
|</SPAN></FONT> <BR><FONT size=2><SPAN style="FONT-SIZE: 10pt">| 116 |
someuser | someserver| opencms | Sleep |
445</SPAN></FONT> <BR><FONT size=2><SPAN
style="FONT-SIZE: 10pt"> | |
NULL
|</SPAN></FONT> <BR><FONT size=2><SPAN style="FONT-SIZE: 10pt">| 117 |
someuser | someserver| opencms | Sleep |
445</SPAN></FONT> <BR><FONT size=2><SPAN
style="FONT-SIZE: 10pt"> | |
NULL
|</SPAN></FONT> <BR><FONT size=2><SPAN style="FONT-SIZE: 10pt">| 118 |
someuser | someserver| opencms | Sleep |
445</SPAN></FONT> <BR><FONT size=2><SPAN
style="FONT-SIZE: 10pt"> | |
NULL
|</SPAN></FONT> <BR><FONT size=2><SPAN style="FONT-SIZE: 10pt">| 119 |
someuser | someserver| opencms | Sleep |
445</SPAN></FONT> <BR><FONT size=2><SPAN
style="FONT-SIZE: 10pt"> | |
NULL
|</SPAN></FONT> <BR><FONT size=2><SPAN style="FONT-SIZE: 10pt">| 120 |
someuser | someserver| opencms | Sleep |
445</SPAN></FONT> <BR><FONT size=2><SPAN
style="FONT-SIZE: 10pt"> | |
NULL
|</SPAN></FONT> <BR><FONT size=2><SPAN style="FONT-SIZE: 10pt">| 121 |
someuser | someserver| opencms | Sleep |
445</SPAN></FONT> <BR><FONT size=2><SPAN
style="FONT-SIZE: 10pt"> | |
NULL
|</SPAN></FONT> <BR><FONT size=2><SPAN style="FONT-SIZE: 10pt">| 122 |
someuser | someserver| opencms | Sleep |
445</SPAN></FONT> <BR><FONT size=2><SPAN
style="FONT-SIZE: 10pt"> | |
NULL
|</SPAN></FONT> <BR><FONT size=2><SPAN style="FONT-SIZE: 10pt">| 123 |
someuser | someserver| opencms | Sleep |
445</SPAN></FONT> <BR><FONT size=2><SPAN
style="FONT-SIZE: 10pt"> | |
NULL
|</SPAN></FONT> <BR><FONT size=2><SPAN style="FONT-SIZE: 10pt">| 125 |
someuser | someserver| opencms | Sleep |
44</SPAN></FONT> <BR><FONT size=2><SPAN
style="FONT-SIZE: 10pt"> | |
NULL
|</SPAN></FONT> <BR><FONT size=2><SPAN style="FONT-SIZE: 10pt">| 126 |
someuser | opencms | Query | 0</SPAN></FONT>
<BR><FONT size=2><SPAN style="FONT-SIZE: 10pt"> | NULL | show
processlist |</SPAN></FONT> <BR><FONT size=2><SPAN
style="FONT-SIZE: 10pt">83 rows in set (0.41 sec)</SPAN></FONT>
<o:p></o:p></P>
<P style="MARGIN-LEFT: 36pt"><FONT face="Times New Roman" size=2><SPAN
style="FONT-SIZE: 10pt">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: 10pt">a productional server .. oh my good..
happy weekend. ;-)</SPAN></FONT> <o:p></o:p></P>
<P style="MARGIN-LEFT: 36pt"><FONT face="Times New Roman" size=2><SPAN
style="FONT-SIZE: 10pt">Thank you,</SPAN></FONT> <o:p></o:p></P>
<P style="MARGIN-LEFT: 36pt"><FONT face="Times New Roman" size=2><SPAN
style="FONT-SIZE: 10pt">Nico</SPAN></FONT> <o:p></o:p></P>
<P class=MsoNormal
style="MARGIN-BOTTOM: 12pt; MARGIN-LEFT: 36pt; MARGIN-RIGHT: 0cm; mso-margin-top-alt: 0cm"><FONT
face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt"><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: 36pt"><FONT face="Times New Roman" size=2><SPAN
style="FONT-SIZE: 10pt">-----Original Message-----</SPAN></FONT> <BR><FONT
size=2><SPAN style="FONT-SIZE: 10pt">From: Andras Balogh [<A
href="mailto:java@reea.net">mailto:java@reea.net</A>]
</SPAN></FONT><BR><FONT size=2><SPAN style="FONT-SIZE: 10pt">Sent: Freitag,
7. März 2003 15:12</SPAN></FONT> <BR><FONT size=2><SPAN
style="FONT-SIZE: 10pt">To: opencms-dev@www.opencms.org</SPAN></FONT>
<BR><FONT size=2><SPAN style="FONT-SIZE: 10pt">Subject: Re: [opencms-dev]
openCMS too much connections problem</SPAN></FONT> <o:p></o:p></P>
<P style="MARGIN-LEFT: 36pt"><FONT face="Times New Roman" size=2><SPAN
style="FONT-SIZE: 10pt">RE: [opencms-dev] openCMS too much connections
problemHi,</SPAN></FONT> <o:p></o:p></P>
<P style="MARGIN-LEFT: 36pt"><FONT face="Times New Roman" size=2><SPAN
style="FONT-SIZE: 10pt">I don't know how much this helps but you can execute
the query</SPAN></FONT> <BR><FONT size=2><SPAN style="FONT-SIZE: 10pt">"SHOW
PROCESSLIST" in a mysql console (or any other mysql frontend)</SPAN></FONT>
<BR><FONT size=2><SPAN style="FONT-SIZE: 10pt">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: 36pt"><FONT face="Times New Roman" size=2><SPAN
style="FONT-SIZE: 10pt">BW,</SPAN></FONT> <o:p></o:p></P>
<P style="MARGIN-LEFT: 36pt"><FONT face="Times New Roman" size=2><SPAN
style="FONT-SIZE: 10pt">Andras.</SPAN></FONT> <o:p></o:p></P>
<P class=MsoNormal style="MARGIN-LEFT: 36pt"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt"><o:p> </o:p></SPAN></FONT></P>
<P style="MARGIN-LEFT: 36pt"><FONT face="Times New Roman" size=2><SPAN
style="FONT-SIZE: 10pt">----- Original Message -----</SPAN></FONT> <BR><FONT
size=2><SPAN style="FONT-SIZE: 10pt">From: Nico Krause</SPAN></FONT>
<BR><FONT size=2><SPAN style="FONT-SIZE: 10pt">To:
'opencms-dev@www.opencms.org'</SPAN></FONT> <BR><FONT size=2><SPAN
style="FONT-SIZE: 10pt">Sent: Friday, March 07, 2003 16:03</SPAN></FONT>
<BR><FONT size=2><SPAN style="FONT-SIZE: 10pt">Subject: RE: [opencms-dev]
openCMS too much connections problem</SPAN></FONT> <o:p></o:p></P>
<P class=MsoNormal style="MARGIN-LEFT: 36pt"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt"><o:p> </o:p></SPAN></FONT></P>
<P style="MARGIN-LEFT: 36pt"><FONT face="Times New Roman" size=2><SPAN
style="FONT-SIZE: 10pt">What means:</SPAN></FONT> <BR><FONT size=2><SPAN
style="FONT-SIZE: 10pt">pool.mysqlonline.maxage=360</SPAN></FONT> <BR><FONT
size=2><SPAN style="FONT-SIZE: 10pt">6 minutes?</SPAN></FONT> <BR><FONT
size=2><SPAN style="FONT-SIZE: 10pt">Here is my configuration.. the online
and backup config is equal</SPAN></FONT> <BR><FONT size=2><SPAN
style="FONT-SIZE: 10pt">pool.mysql.driver=org.gjt.mm.mysql.Driver</SPAN></FONT>
<BR><FONT size=2><SPAN
style="FONT-SIZE: 10pt">pool.mysql.url=jdbc:mysql://localhost:3306/opencms</SPAN></FONT>
<BR><FONT size=2><SPAN
style="FONT-SIZE: 10pt">pool.mysql.user=</SPAN></FONT> <BR><FONT
size=2><SPAN style="FONT-SIZE: 10pt">pool.mysql.password=</SPAN></FONT>
<BR><FONT size=2><SPAN
style="FONT-SIZE: 10pt">pool.mysql.minConn=10</SPAN></FONT> <BR><FONT
size=2><SPAN style="FONT-SIZE: 10pt">pool.mysql.maxConn=20</SPAN></FONT>
<BR><FONT size=2><SPAN
style="FONT-SIZE: 10pt">pool.mysql.increaseRate=5</SPAN></FONT> <BR><FONT
size=2><SPAN style="FONT-SIZE: 10pt">pool.mysql.timeout=120</SPAN></FONT>
<BR><FONT size=2><SPAN
style="FONT-SIZE: 10pt">pool.mysql.maxage=360</SPAN></FONT> <BR><FONT
size=2><SPAN style="FONT-SIZE: 10pt">But the connections will not be
closed.. that's the thing it grows and</SPAN></FONT> <BR><FONT size=2><SPAN
style="FONT-SIZE: 10pt">grows..</SPAN></FONT> <BR><FONT size=2><SPAN
style="FONT-SIZE: 10pt">Thanks for any tips..</SPAN></FONT> <BR><FONT
size=2><SPAN style="FONT-SIZE: 10pt">Nico</SPAN></FONT> <o:p></o:p></P>
<P class=MsoNormal style="MARGIN-LEFT: 36pt"><FONT face="Times New Roman"
size=3><SPAN
style="FONT-SIZE: 12pt"><o:p> </o:p></SPAN></FONT></P></BLOCKQUOTE></DIV></BLOCKQUOTE></BODY></HTML>