19 Aug
2008
19 Aug
'08
2:56 a.m.
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(a)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(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers
19 Aug
19 Aug
3:01 a.m.
New subject: [Serusers] SER - Waiting Transaction
ignore it too :-)
the ser waiting transaction is just a bug in the historical SER version
you are using.
The mysql number of connnections is design constraint -- every single
SER process opens
up many connections to mysql server. This is descreased with new
versions of SER too,
that share those. Thus I would recommend an upgrade to you, or otherwise
increase the
number of connections the mysql server accepts. (it won't grow, so it is
okay to find
a number that will work for you)
-jiri
Arun Kumar wrote:
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(a)iptel.org
<mailto: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(a)lists.iptel.org <mailto:Serusers@lists.iptel.org>
http://lists.iptel.org/mailman/listinfo/serusers
3:02 a.m.
New subject: [Serusers] SER - Waiting Transaction
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(a)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(a)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(a)lists.iptel.org
>> http://lists.iptel.org/mailman/listinfo/serusers
>>
>
_______________________________________________
Serusers mailing list
Serusers(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers
3:19 a.m.
New subject: [Serusers] SER - Waiting Transaction
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(a)cyberhouse.no>wrote;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(a)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(a)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(a)lists.iptel.org
>> http://lists.iptel.org/mailman/listinfo/serusers
>>
>
_______________________________________________
Serusers mailing list
Serusers(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers
_______________________________________________
Serusers mailing list
Serusers(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers
3:57 a.m.
New subject: [Serusers] SER - Waiting Transaction
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(a)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(a)cyberhouse.no>wrote;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(a)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(a)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(a)lists.iptel.org
>> http://lists.iptel.org/mailman/listinfo/serusers
>>
>
_______________________________________________
Serusers mailing list
Serusers(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers
_______________________________________________
Serusers mailing list
Serusers(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers
22 Aug
22 Aug
10:29 a.m.
New subject: [Serusers] SER - Waiting Transaction
Ho do I see how many Process of SER are running ? ps aux | grep ser or
something else.
thanks
On Tue, Aug 19, 2008 at 11:02 AM, Atle Samuelsen <clona(a)cyberhouse.no>wrote;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(a)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(a)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(a)lists.iptel.org
>> http://lists.iptel.org/mailman/listinfo/serusers
>>
>
_______________________________________________
Serusers mailing list
Serusers(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers
5970
days inactive
5973
days old
5 comments
4 participants
participants (4)
-
Arun Kumar -
Atle Samuelsen -
Jai Rangi -
Jiri Kuthan