<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2653.12">
<TITLE>RE: [opencms-dev] openCMS too much connections problem</TITLE>
</HEAD>
<BODY>
<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>
</BODY>
</HTML>