[Serusers] Problem with SER and Database connections

samuel samu60 at gmail.com
Wed Feb 8 09:13:16 CET 2006


You might also try to add

set-variable    = max_connections=500

In the config file of your mysql server.

Samuel.

2006/2/7, Atle Samuelsen <clona at cyberhouse.no>:
>
> Hi Again,
>
> as I said, I think this issue must be something else then SER related.
> how does the machine crash ? what is the error message?
>
> -a
>
> * mkumar at mantragroup.com <mkumar at mantragroup.com> [060207 15:48]:
> > Hi Atle,
> >
> > Thanks for the reply.
> >
> > Currently in ser.cfg I gave children count as 4 only and I think it should be
> > ok.
> >
> > Someone please help me to solve my problem.
> >
> > Thanks,
> > Manoj.
> >
> > Quoting Atle Samuelsen <clona at cyberhouse.no>:
> >
> > >Hi again,
> > >
> > >You can reduce the mysql connections with reducing how many children you
> > >are running by useing the children=something variable.
> > >
> > >But I personally doubt that this will solve your problem. and, if it
> > >does then you must be aware that if somebody connectes a few times to
> > >your webserver, your server might as well go down.
> > >
> > >-atle
> > >
> > >* mkumar at mantragroup.com <mkumar at mantragroup.com> [060207 14:52]:
> > >>Hi,
> > >>
> > >>I checked my logs and I did not find any proper reason for my crash. Actually
> > >>only after installing SER my webserver started crashing and this is the third
> > >>time in this week. If I did not start SER, things are fine. So please tell me
> > >>how can I reduce connections to Mysql from SER?
> > >>
> > >>I find one post in mailing asking to change config.c in postgres.so but I did
> > >>not load that module in ser.cfg itself.
> > >>
> > >>Any help will be sincerely appreciated.
> > >>
> > >>Thanks,
> > >>Manoj
> > >>
> > >>
> > >>Quoting Atle Samuelsen <clona at cyberhouse.no>:
> > >>
> > >>>Hi Manoj,
> > >>>
> > >>>I might be wrong, but this does NOT sound like a problem cuased by Ser
> > >>>and Mysql.
> > >>>
> > >>>I would advice you to check the system logs, and check if there is some
> > >>>logical reason there.
> > >>>
> > >>>- Atle
> > >>>
> > >>>* mkumar at mantragroup.com <mkumar at mantragroup.com> [060207 11:24]:
> > >>>>Hi All,
> > >>>>
> > >>>>  I installed SER 0.9.4 and I was able to make and receive calls. SER and Mysql
> > >>>>run on the same unix box which is located at some other place and which also
> > >>>>runs a webserver. After starting ser everything goes fine but after sometime
> > >>>>the whole system goes down and I was not even able to connect to unix box using
> > >>>>SSH or to any web page of that webserver. Does the Number of connections made
> > >>>>by SER to Mysql is causing the problem or is there anything wrong with my SER
> > >>>>configuration and Mysql? If Number of connections is the problem then please
> > >>>>tell me what must I do to reduce the number of connections to Mysql from SER.
> > >>>>
> > >>>>Also please tell me if there is any new Mysql.so module or any other module
> > >>>>which fixes this.
> > >>>>
> > >>>>Thanks,
> > >>>>Manoj
> > >>>>
> > >>>>_______________________________________________
> > >>>>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
>




More information about the sr-users mailing list