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@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@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@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@lists.iptel.org
> >> http://lists.iptel.org/mailman/listinfo/serusers
> >>
> >

> _______________________________________________
> Serusers mailing list
> Serusers@lists.iptel.org
> http://lists.iptel.org/mailman/listinfo/serusers

_______________________________________________
Serusers mailing list
Serusers@lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers