[Serusers] SER - Waiting Transaction

[Jai Rangi]

I want to add one more thing,
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.
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.

Bug: That it should reconnect mysql when it gets a new call, but that will
create other problems like too many connections for mysql.

Correct me if I am wrong.

-Jai


On Tue, Aug 19, 2008 at 12:02 AM, Atle Samuelsen <clona at cyberhouse.no>wrote:

> Hi Arun
>
> there will be alot of mysql connections. SER opens one connection per
> process meaning that if you have 30 processes, you have 30 mysql
> conections.
>
> In /etc/my.cnf you can adjust the number of connections. I dont remember
> the name of the "feature".
>
>
> - Atle
>
> * Arun Kumar <arunvoip at gmail.com> [080819 08:57]:
> > Hi,
> >
> > thanks for your reply. I'll ignore this but I see so many open connection
> to
> > MySQL from SER and they don't get close automatically also resulting in
> > denial of other service using my MySQL.
> >
> > Thanks
> > arun
> >
> > On Mon, Aug 18, 2008 at 10:12 PM, Jiri Kuthan <jiri at iptel.org> wrote:
> >
> > > ignore it
> > >
> > > Arun Kumar wrote:
> > >
> > >> Hi,
> > >>
> > >>
> > >> I'm running SER 0.96 in my production for a long but there is strange
> > >> problem , when I do serctl moni and looks for transaction it shows
> waiting
> > >> transaction in () almost 400+ can some one tell me why there are so
> many
> > >> transaction in waiting while I see processing only 10-20 transaction.
> > >>
> > >> Thanks
> > >> arun
> > >>
> > >>
> > >>
> ------------------------------------------------------------------------
> > >>
> > >> _______________________________________________
> > >> Serusers mailing list
> > >> Serusers at lists.iptel.org
> > >> http://lists.iptel.org/mailman/listinfo/serusers
> > >>
> > >
>
> > _______________________________________________
> > Serusers mailing list
> > Serusers at lists.iptel.org
> > http://lists.iptel.org/mailman/listinfo/serusers
>
> _______________________________________________
> Serusers mailing list
> Serusers at lists.iptel.org
> http://lists.iptel.org/mailman/listinfo/serusers
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20080819/4edca0a7/attachment.htm>