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
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@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@lists.iptel.org <mailto:Serusers@lists.iptel.org> http://lists.iptel.org/mailman/listinfo/serusers
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
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.nowrote:
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
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@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@cyberhouse.nowrote:
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
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@cyberhouse.nowrote:
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
-
Arun Kumar -
Atle Samuelsen -
Jai Rangi -
Jiri Kuthan