<div dir="ltr">Hi All,<br><br>thanks for your valuable inputs will try to upgrade my SER.<br><br>@Jai Sir, In my case SER can reconnect to MySQL without restart the SER.<br><br>thanks,<br>arun<br><br><div class="gmail_quote">
On Tue, Aug 19, 2008 at 11:19 AM, Jai Rangi <span dir="ltr"><<a href="mailto:jprangi@gmail.com">jprangi@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div dir="ltr">I want to add one more thing, <br>Yes ser maintains one connect per ser-child. Also if you restart mysqld, all the ser connections die and ser does not reconnect to mysql, you have to restart ser to reestablish the connection. Not sure if this is feature or if this is a bug. <br>
Feature: That ser handles all the call with just few connection, think how many connections will be ther is ser establish new connection for each call. <br>Bug: That it should reconnect mysql when it gets a new call, but that will create other problems like too many connections for mysql. <br>
<br>Correct me if I am wrong. <br><font color="#888888"><br>-Jai</font><div><div></div><div class="Wj3C7c"><br><br><br><div class="gmail_quote">On Tue, Aug 19, 2008 at 12:02 AM, Atle Samuelsen <span dir="ltr"><<a href="mailto:clona@cyberhouse.no" target="_blank">clona@cyberhouse.no</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Hi Arun<br>
<br>
there will be alot of mysql connections. SER opens one connection per<br>
process meaning that if you have 30 processes, you have 30 mysql<br>
conections.<br>
<br>
In /etc/my.cnf you can adjust the number of connections. I dont remember<br>
the name of the "feature".<br>
<br>
<br>
- Atle<br>
<br>
* Arun Kumar <<a href="mailto:arunvoip@gmail.com" target="_blank">arunvoip@gmail.com</a>> [080819 08:57]:<br>
<div><div></div><div>> Hi,<br>
><br>
> thanks for your reply. I'll ignore this but I see so many open connection to<br>
> MySQL from SER and they don't get close automatically also resulting in<br>
> denial of other service using my MySQL.<br>
><br>
> Thanks<br>
> arun<br>
><br>
> On Mon, Aug 18, 2008 at 10:12 PM, Jiri Kuthan <<a href="mailto:jiri@iptel.org" target="_blank">jiri@iptel.org</a>> wrote:<br>
><br>
> > ignore it<br>
> ><br>
> > Arun Kumar wrote:<br>
> ><br>
> >> Hi,<br>
> >><br>
> >><br>
> >> I'm running SER 0.96 in my production for a long but there is strange<br>
> >> problem , when I do serctl moni and looks for transaction it shows waiting<br>
> >> transaction in () almost 400+ can some one tell me why there are so many<br>
> >> transaction in waiting while I see processing only 10-20 transaction.<br>
> >><br>
> >> Thanks<br>
> >> arun<br>
> >><br>
> >><br>
> >> ------------------------------------------------------------------------<br>
> >><br>
> >> _______________________________________________<br>
> >> Serusers mailing list<br>
> >> <a href="mailto:Serusers@lists.iptel.org" target="_blank">Serusers@lists.iptel.org</a><br>
> >> <a href="http://lists.iptel.org/mailman/listinfo/serusers" target="_blank">http://lists.iptel.org/mailman/listinfo/serusers</a><br>
> >><br>
> ><br>
<br>
> _______________________________________________<br>
> Serusers mailing list<br>
> <a href="mailto:Serusers@lists.iptel.org" target="_blank">Serusers@lists.iptel.org</a><br>
> <a href="http://lists.iptel.org/mailman/listinfo/serusers" target="_blank">http://lists.iptel.org/mailman/listinfo/serusers</a><br>
<br>
_______________________________________________<br>
Serusers mailing list<br>
<a href="mailto:Serusers@lists.iptel.org" target="_blank">Serusers@lists.iptel.org</a><br>
<a href="http://lists.iptel.org/mailman/listinfo/serusers" target="_blank">http://lists.iptel.org/mailman/listinfo/serusers</a><br>
</div></div></blockquote></div><br></div></div></div>
</blockquote></div><br></div>