[Serusers] SER - Waiting Transaction

[Arun Kumar]

Hi All,

thanks for your valuable inputs will try to upgrade my SER.

@Jai Sir, In my case SER can reconnect to MySQL without restart the SER.

thanks,
arun

On Tue, Aug 19, 2008 at 11:19 AM, Jai Rangi <jprangi at gmail.com> wrote:

> 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/4e90dc68/attachment.htm>