Re: How to Improve Performance of SQLBox
*Hello RK Krishnas,* Can you describe me in details how to calculate TPS, because i have some confusion with this terminology *TPS.* Currently, I have configured Kannel with following a *rchitecure:* *BBoxSQLBoxSMSBoxFake SMSC's* *Now kannel monitor shows me this output:* SMS: received 0 (0 queued), sent 3516970 (0 queued), store size -1 SMS: inbound (0.00,0.00,0.00) msg/sec, outbound (297.90,227.73,43.20) msg/sec DLR: received 7033940, sent 0 DLR: inbound (595.81,455.46,86.40) msg/sec, outbound (0.00,0.00,0.00) msg/sec DLR: 0 queued, using internal storage *So How to calculate tps.* *Thanks in advance.* *ThanksAditya Khanna,* *Indore (M.P.)* On Tue, Jan 6, 2015 at 10:56 PM, RK Krishnas r...@krishnasoft.in wrote: Hi Leandro, Installed mysql community edition 6.5 but same result. 10 tps per session.. *Rajeev Krishna* Operations Manager Krishnas Software Technologies www.krishnasoft.in mobile :+91 888 5815 888 Sales :+91 888 5813 888 Support :+91 888 5817 888 On Mon, Jan 5, 2015 at 7:53 PM, Tenorio, Leandro lean...@fliadt.com wrote: Hi, If both are on the same physical machine its not hardware nor O.S. have you tried MySQL community repository, you can get it from http://dev.mysql.com/downloads/repo/yum/ *From:* RK Krishnas [mailto:r...@krishnasoft.in] *Sent:* Monday, January 05, 2015 12:30 AM *To:* Tenorio, Leandro *Subject:* Re: How to Improve Performance of SQLBox Hi Virtual machine is installed on the same physical system. I am getting 150 tps from virtual machine. So I think no question of Lan switch. On Jan 5, 2015 2:24 AM, Tenorio, Leandro lean...@fliadt.com wrote: Change LAN board, cable and switch port. -- *From: * RK Krishnas r...@krishnasoft.in *Date: * January 3, 2015 12:42:14 PM *Subject: * Re: How to Improve Performance of SQLBox *To: * Tenorio, Leandro lean...@fliadt.com *CC: * spameden spame...@gmail.com, Aditya Khanna aditya.khanna111...@gmail.com, kannel users@kannel.org users@kannel.org Hi Leandro, 1. My Centos is up to date. Centos 6.5 with kernel 2.6.32-431 2. Regarding Tuning: I Just Installed LAMP on a virtual machine getting 150+ tps. No tuning at all. directly it is giving 150 tps. Virtual machine config: 1ghz, 512 mb ram 8gb hdd. Physical server any config its just 15 tps only. 3. Virtual machine in the same system is giving 150+ TPS so no case of LAN. although i am using 1Gig Ethernet cards. 4. HDD.: i placed 3 different H.D.D. installed kannel in 3 different systems. All physical systems giving me same 15tps. I am using kannel from past 2 years. In VPS data centre or local virtual machines I am getting 150+ tps. In physical server i am getting 15 tps. I am not able to sleep with this issue in my brain. I dont know where I am wrong. Any one with Centos 6.5 kannel pls help me. *Rajeev Krishna* Operations Manager Krishnas Software Technologies www.krishnasoft.in mobile :+91 888 5815 888 Sales :+91 888 5813 888 Support :+91 888 5817 888 On Fri, Jan 2, 2015 at 7:16 PM, Tenorio, Leandro lean...@fliadt.com wrote: Rajeev, Looks more a HW/O.S issue than kannel. 1. Update all the CentOS to the latest yum update 2. Look for MySQL tuning like http://www.percona.com/blog/2014/01/28/10-mysql-settings-to-tune-after-installation/ 3. Update ethernet board driver according to manufacturer or change the hole board, patch cable and switch port. 4. Update HDD board driver according to manufacturer Cheers, Leandro *From:* users [mailto:users-boun...@kannel.org] *On Behalf Of *RK Krishnas *Sent:* Thursday, January 01, 2015 9:32 AM *To:* spameden *Cc:* Aditya Khanna; kannel users@kannel.org *Subject:* Re: How to Improve Performance of SQLBox Dear Friends Kannel Team, Got a serious Issue. *Server A:* Centos 6.5 Server with Kannel svn-r5122., 4 GB RAM, 1TB HDD *Server B:* Centos 6.5 with LAMP Stack , MYSQL 5.5.1, 3.2 Ghz Xeon, 8 GB, 1TD HDD *Server C: *Virtual Machine Centos 6.5 with LAMP Stack , MYSQL 5.5.1, 1 Ghz 1 GB RAM *Server D:* Windows 7 with Xampp , MYSQL 5..1 If I run Kannel on Server A with mysql db on Server B, TPS per session=15 If I run Kannel on Server A with mysql db on Server C or Server D TPS per session=90 I ran mysql benchmark also. Serverc is 5 times low on benchmark test. Still why my Physical Server is so low on T.P.S. I changed the mysql db server only. Kannel on the Server A only. Please guide me. I am struggling from past 4 months. *Rajeev Krishna* Operations Manager Krishnas Software Technologies www.krishnasoft.in mobile :+91 888 5815 888 Sales :+91 888 5813 888 Support :+91 888 5817 888 On Thu, Nov 6, 2014 at 11:00 AM, spameden spame...@gmail.com wrote: quick googling (only took me 30 seconds): http://www.kannel.org
Re: How to Improve Performance of SQLBox
Hi Leandro, Installed mysql community edition 6.5 but same result. 10 tps per session.. *Rajeev Krishna* Operations Manager Krishnas Software Technologies www.krishnasoft.in mobile :+91 888 5815 888 Sales :+91 888 5813 888 Support :+91 888 5817 888 On Mon, Jan 5, 2015 at 7:53 PM, Tenorio, Leandro lean...@fliadt.com wrote: Hi, If both are on the same physical machine its not hardware nor O.S. have you tried MySQL community repository, you can get it from http://dev.mysql.com/downloads/repo/yum/ *From:* RK Krishnas [mailto:r...@krishnasoft.in] *Sent:* Monday, January 05, 2015 12:30 AM *To:* Tenorio, Leandro *Subject:* Re: How to Improve Performance of SQLBox Hi Virtual machine is installed on the same physical system. I am getting 150 tps from virtual machine. So I think no question of Lan switch. On Jan 5, 2015 2:24 AM, Tenorio, Leandro lean...@fliadt.com wrote: Change LAN board, cable and switch port. -- *From: * RK Krishnas r...@krishnasoft.in *Date: * January 3, 2015 12:42:14 PM *Subject: * Re: How to Improve Performance of SQLBox *To: * Tenorio, Leandro lean...@fliadt.com *CC: * spameden spame...@gmail.com, Aditya Khanna aditya.khanna111...@gmail.com, kannel users@kannel.org users@kannel.org Hi Leandro, 1. My Centos is up to date. Centos 6.5 with kernel 2.6.32-431 2. Regarding Tuning: I Just Installed LAMP on a virtual machine getting 150+ tps. No tuning at all. directly it is giving 150 tps. Virtual machine config: 1ghz, 512 mb ram 8gb hdd. Physical server any config its just 15 tps only. 3. Virtual machine in the same system is giving 150+ TPS so no case of LAN. although i am using 1Gig Ethernet cards. 4. HDD.: i placed 3 different H.D.D. installed kannel in 3 different systems. All physical systems giving me same 15tps. I am using kannel from past 2 years. In VPS data centre or local virtual machines I am getting 150+ tps. In physical server i am getting 15 tps. I am not able to sleep with this issue in my brain. I dont know where I am wrong. Any one with Centos 6.5 kannel pls help me. *Rajeev Krishna* Operations Manager Krishnas Software Technologies www.krishnasoft.in mobile :+91 888 5815 888 Sales :+91 888 5813 888 Support :+91 888 5817 888 On Fri, Jan 2, 2015 at 7:16 PM, Tenorio, Leandro lean...@fliadt.com wrote: Rajeev, Looks more a HW/O.S issue than kannel. 1. Update all the CentOS to the latest yum update 2. Look for MySQL tuning like http://www.percona.com/blog/2014/01/28/10-mysql-settings-to-tune-after-installation/ 3. Update ethernet board driver according to manufacturer or change the hole board, patch cable and switch port. 4. Update HDD board driver according to manufacturer Cheers, Leandro *From:* users [mailto:users-boun...@kannel.org] *On Behalf Of *RK Krishnas *Sent:* Thursday, January 01, 2015 9:32 AM *To:* spameden *Cc:* Aditya Khanna; kannel users@kannel.org *Subject:* Re: How to Improve Performance of SQLBox Dear Friends Kannel Team, Got a serious Issue. *Server A:* Centos 6.5 Server with Kannel svn-r5122., 4 GB RAM, 1TB HDD *Server B:* Centos 6.5 with LAMP Stack , MYSQL 5.5.1, 3.2 Ghz Xeon, 8 GB, 1TD HDD *Server C: *Virtual Machine Centos 6.5 with LAMP Stack , MYSQL 5.5.1, 1 Ghz 1 GB RAM *Server D:* Windows 7 with Xampp , MYSQL 5..1 If I run Kannel on Server A with mysql db on Server B, TPS per session=15 If I run Kannel on Server A with mysql db on Server C or Server D TPS per session=90 I ran mysql benchmark also. Serverc is 5 times low on benchmark test. Still why my Physical Server is so low on T.P.S. I changed the mysql db server only. Kannel on the Server A only. Please guide me. I am struggling from past 4 months. *Rajeev Krishna* Operations Manager Krishnas Software Technologies www.krishnasoft.in mobile :+91 888 5815 888 Sales :+91 888 5813 888 Support :+91 888 5817 888 On Thu, Nov 6, 2014 at 11:00 AM, spameden spame...@gmail.com wrote: quick googling (only took me 30 seconds): http://www.kannel.org/pipermail/users/2010-January/009745.html http://www.kannel.org/pipermail/users/2013-June/019873.html http://www.kannel.org/pipermail/users/2008-March/004260.html http://www.kannel.org/pipermail/users/2007-February/001541.html http://www.kannel.org/pipermail/users/2014-June/021242.html etc... in short: 1) test with fakesmsc where no SMPP remote binds involved with memory storage and measure throughput with sqlbox or smsbox. 2) add DLR handling 3) add MySQL DLR handling and see how it goes 4) if you need additional hit-url add it and measure again 5) check mysql slow-log as well as mysql queries/sec variable via mysqladmin pr, add needed index for dlr table (discussed many times for quick ts,smsc_id matching) 6) check your connection
RE: How to Improve Performance of SQLBox
Hi, If both are on the same physical machine its not hardware nor O.S. have you tried MySQL community repository, you can get it from http://dev.mysql.com/downloads/repo/yum/ From: RK Krishnas [mailto:r...@krishnasoft.in] Sent: Monday, January 05, 2015 12:30 AM To: Tenorio, Leandro Subject: Re: How to Improve Performance of SQLBox Hi Virtual machine is installed on the same physical system. I am getting 150 tps from virtual machine. So I think no question of Lan switch. On Jan 5, 2015 2:24 AM, Tenorio, Leandro lean...@fliadt.commailto:lean...@fliadt.com wrote: Change LAN board, cable and switch port. From: RK Krishnas r...@krishnasoft.inmailto:r...@krishnasoft.in Date: January 3, 2015 12:42:14 PM Subject: Re: How to Improve Performance of SQLBox To: Tenorio, Leandro lean...@fliadt.commailto:lean...@fliadt.com CC: spameden spame...@gmail.commailto:spame...@gmail.com, Aditya Khanna aditya.khanna111...@gmail.commailto:aditya.khanna111...@gmail.com, kannel users@kannel.orgmailto:users@kannel.org users@kannel.orgmailto:users@kannel.org Hi Leandro, 1. My Centos is up to date. Centos 6.5 with kernel 2.6.32-431 2. Regarding Tuning: I Just Installed LAMP on a virtual machine getting 150+ tps. No tuning at all. directly it is giving 150 tps. Virtual machine config: 1ghz, 512 mb ram 8gb hdd. Physical server any config its just 15 tps only. 3. Virtual machine in the same system is giving 150+ TPS so no case of LAN. although i am using 1Gig Ethernet cards. 4. HDD.: i placed 3 different H.D.D. installed kannel in 3 different systems. All physical systems giving me same 15tps. I am using kannel from past 2 years. In VPS data centre or local virtual machines I am getting 150+ tps. In physical server i am getting 15 tps. I am not able to sleep with this issue in my brain. I dont know where I am wrong. Any one with Centos 6.5 kannel pls help me. Rajeev Krishna Operations Manager Krishnas Software Technologies www.krishnasoft.inhttp://www.krishnasoft.in mobile :+91 888 5815 888 Sales :+91 888 5813 888 Support :+91 888 5817 888 On Fri, Jan 2, 2015 at 7:16 PM, Tenorio, Leandro lean...@fliadt.commailto:lean...@fliadt.com wrote: Rajeev, Looks more a HW/O.S issue than kannel. 1. Update all the CentOS to the latest yum update 2. Look for MySQL tuning like http://www.percona.com/blog/2014/01/28/10-mysql-settings-to-tune-after-installation/ 3. Update ethernet board driver according to manufacturer or change the hole board, patch cable and switch port. 4. Update HDD board driver according to manufacturer Cheers, Leandro From: users [mailto:users-boun...@kannel.orgmailto:users-boun...@kannel.org] On Behalf Of RK Krishnas Sent: Thursday, January 01, 2015 9:32 AM To: spameden Cc: Aditya Khanna; kannel users@kannel.orgmailto:users@kannel.org Subject: Re: How to Improve Performance of SQLBox Dear Friends Kannel Team, Got a serious Issue. Server A: Centos 6.5 Server with Kannel svn-r5122., 4 GB RAM, 1TB HDD Server B: Centos 6.5 with LAMP Stack , MYSQL 5.5.1, 3.2 Ghz Xeon, 8 GB, 1TD HDD Server C: Virtual Machine Centos 6.5 with LAMP Stack , MYSQL 5.5.1, 1 Ghz 1 GB RAM Server D: Windows 7 with Xampp , MYSQL 5..1 If I run Kannel on Server A with mysql db on Server B, TPS per session=15 If I run Kannel on Server A with mysql db on Server C or Server D TPS per session=90 I ran mysql benchmark also. Serverc is 5 times low on benchmark test. Still why my Physical Server is so low on T.P.S. I changed the mysql db server only. Kannel on the Server A only. Please guide me. I am struggling from past 4 months. Rajeev Krishna Operations Manager Krishnas Software Technologies www.krishnasoft.inhttp://www.krishnasoft.in mobile :+91 888 5815 888 Sales :+91 888 5813 888 Support :+91 888 5817 888 On Thu, Nov 6, 2014 at 11:00 AM, spameden spame...@gmail.commailto:spame...@gmail.com wrote: quick googling (only took me 30 seconds): http://www.kannel.org/pipermail/users/2010-January/009745.html http://www.kannel.org/pipermail/users/2013-June/019873.html http://www.kannel.org/pipermail/users/2008-March/004260.html http://www.kannel.org/pipermail/users/2007-February/001541.html http://www.kannel.org/pipermail/users/2014-June/021242.html etc... in short: 1) test with fakesmsc where no SMPP remote binds involved with memory storage and measure throughput with sqlbox or smsbox. 2) add DLR handling 3) add MySQL DLR handling and see how it goes 4) if you need additional hit-url add it and measure again 5) check mysql slow-log as well as mysql queries/sec variable via mysqladmin pr, add needed index for dlr table (discussed many times for quick ts,smsc_id matching) 6) check your connection with remote binds via tcpdump/ettercap/wireshark if you're losing any packets or there are many re-transmissions going on 7) connect your remote binds and test again as said 1000 x times kannel is usually
Re: How to Improve Performance of SQLBox
Change LAN board, cable and switch port. From: RK Krishnas r...@krishnasoft.in Date: January 3, 2015 12:42:14 PM Subject:Re: How to Improve Performance of SQLBox To: Tenorio, Leandro lean...@fliadt.com CC: spameden spame...@gmail.com, Aditya Khanna aditya.khanna111...@gmail.com, kannel users@kannel.org users@kannel.org Hi Leandro, 1. My Centos is up to date. Centos 6.5 with kernel 2.6.32-431 2. Regarding Tuning: I Just Installed LAMP on a virtual machine getting 150+ tps. No tuning at all. directly it is giving 150 tps. Virtual machine config: 1ghz, 512 mb ram 8gb hdd. Physical server any config its just 15 tps only. 3. Virtual machine in the same system is giving 150+ TPS so no case of LAN. although i am using 1Gig Ethernet cards. 4. HDD.: i placed 3 different H.D.D. installed kannel in 3 different systems. All physical systems giving me same 15tps. I am using kannel from past 2 years. In VPS data centre or local virtual machines I am getting 150+ tps. In physical server i am getting 15 tps. I am not able to sleep with this issue in my brain. I dont know where I am wrong. Any one with Centos 6.5 kannel pls help me. Rajeev Krishna Operations Manager Krishnas Software Technologies www.krishnasoft.inhttp://www.krishnasoft.in mobile :+91 888 5815 888 Sales :+91 888 5813 888 Support :+91 888 5817 888 On Fri, Jan 2, 2015 at 7:16 PM, Tenorio, Leandro lean...@fliadt.commailto:lean...@fliadt.com wrote: Rajeev, Looks more a HW/O.S issue than kannel. 1. Update all the CentOS to the latest yum update 2. Look for MySQL tuning like http://www.percona.com/blog/2014/01/28/10-mysql-settings-to-tune-after-installation/ 3. Update ethernet board driver according to manufacturer or change the hole board, patch cable and switch port. 4. Update HDD board driver according to manufacturer Cheers, Leandro From: users [mailto:users-boun...@kannel.orgmailto:users-boun...@kannel.org] On Behalf Of RK Krishnas Sent: Thursday, January 01, 2015 9:32 AM To: spameden Cc: Aditya Khanna; kannel users@kannel.orgmailto:users@kannel.org Subject: Re: How to Improve Performance of SQLBox Dear Friends Kannel Team, Got a serious Issue. Server A: Centos 6.5 Server with Kannel svn-r5122., 4 GB RAM, 1TB HDD Server B: Centos 6.5 with LAMP Stack , MYSQL 5.5.1, 3.2 Ghz Xeon, 8 GB, 1TD HDD Server C: Virtual Machine Centos 6.5 with LAMP Stack , MYSQL 5.5.1, 1 Ghz 1 GB RAM Server D: Windows 7 with Xampp , MYSQL 5..1 If I run Kannel on Server A with mysql db on Server B, TPS per session=15 If I run Kannel on Server A with mysql db on Server C or Server D TPS per session=90 I ran mysql benchmark also. Serverc is 5 times low on benchmark test. Still why my Physical Server is so low on T.P.S. I changed the mysql db server only. Kannel on the Server A only. Please guide me. I am struggling from past 4 months. Rajeev Krishna Operations Manager Krishnas Software Technologies www.krishnasoft.inhttp://www.krishnasoft.in mobile :+91 888 5815 888 Sales :+91 888 5813 888 Support :+91 888 5817 888 On Thu, Nov 6, 2014 at 11:00 AM, spameden spame...@gmail.commailto:spame...@gmail.com wrote: quick googling (only took me 30 seconds): http://www.kannel.org/pipermail/users/2010-January/009745.html http://www.kannel.org/pipermail/users/2013-June/019873.html http://www.kannel.org/pipermail/users/2008-March/004260.html http://www.kannel.org/pipermail/users/2007-February/001541.html http://www.kannel.org/pipermail/users/2014-June/021242.html etc... in short: 1) test with fakesmsc where no SMPP remote binds involved with memory storage and measure throughput with sqlbox or smsbox. 2) add DLR handling 3) add MySQL DLR handling and see how it goes 4) if you need additional hit-url add it and measure again 5) check mysql slow-log as well as mysql queries/sec variable via mysqladmin pr, add needed index for dlr table (discussed many times for quick ts,smsc_id matching) 6) check your connection with remote binds via tcpdump/ettercap/wireshark if you're losing any packets or there are many re-transmissions going on 7) connect your remote binds and test again as said 1000 x times kannel is usually NOT a problem, most problems involved either with incorrect setup of middle software or your remote SMSC upstream. 2014-11-06 8:05 GMT+03:00 RK Krishnas r...@krishnasoft.inmailto:r...@krishnasoft.in: Dear Team, Please Suggest the best way or guide us for the proper approach. I saw 25 Answers saying Search in mailing List, Search In google. But I spent 2 weeks for the same no result at all. Many told to tweak sqlbox mysql. No one gave the solution. I personally mailed 5 members who said that they solved the issue. They never posted back the settings nor the steps. Problem: SQLBOX==BEARERBOX==SMSC==MOBILE. Here each session is getting an average of 10 tps only. Even the ack dlr are queued up in store. Please
Re: How to Improve Performance of SQLBox
Hi Leandro, 1. My Centos is up to date. Centos 6.5 with kernel 2.6.32-431 2. Regarding Tuning: I Just Installed LAMP on a virtual machine getting 150+ tps. No tuning at all. directly it is giving 150 tps. Virtual machine config: 1ghz, 512 mb ram 8gb hdd. Physical server any config its just 15 tps only. 3. Virtual machine in the same system is giving 150+ TPS so no case of LAN. although i am using 1Gig Ethernet cards. 4. HDD.: i placed 3 different H.D.D. installed kannel in 3 different systems. All physical systems giving me same 15tps. I am using kannel from past 2 years. In VPS data centre or local virtual machines I am getting 150+ tps. In physical server i am getting 15 tps. I am not able to sleep with this issue in my brain. I dont know where I am wrong. Any one with Centos 6.5 kannel pls help me. *Rajeev Krishna* Operations Manager Krishnas Software Technologies www.krishnasoft.in mobile :+91 888 5815 888 Sales :+91 888 5813 888 Support :+91 888 5817 888 On Fri, Jan 2, 2015 at 7:16 PM, Tenorio, Leandro lean...@fliadt.com wrote: Rajeev, Looks more a HW/O.S issue than kannel. 1. Update all the CentOS to the latest yum update 2. Look for MySQL tuning like http://www.percona.com/blog/2014/01/28/10-mysql-settings-to-tune-after-installation/ 3. Update ethernet board driver according to manufacturer or change the hole board, patch cable and switch port. 4. Update HDD board driver according to manufacturer Cheers, Leandro *From:* users [mailto:users-boun...@kannel.org] *On Behalf Of *RK Krishnas *Sent:* Thursday, January 01, 2015 9:32 AM *To:* spameden *Cc:* Aditya Khanna; kannel users@kannel.org *Subject:* Re: How to Improve Performance of SQLBox Dear Friends Kannel Team, Got a serious Issue. *Server A:* Centos 6.5 Server with Kannel svn-r5122., 4 GB RAM, 1TB HDD *Server B:* Centos 6.5 with LAMP Stack , MYSQL 5.5.1, 3.2 Ghz Xeon, 8 GB, 1TD HDD *Server C: *Virtual Machine Centos 6.5 with LAMP Stack , MYSQL 5.5.1, 1 Ghz 1 GB RAM *Server D:* Windows 7 with Xampp , MYSQL 5..1 If I run Kannel on Server A with mysql db on Server B, TPS per session=15 If I run Kannel on Server A with mysql db on Server C or Server D TPS per session=90 I ran mysql benchmark also. Serverc is 5 times low on benchmark test. Still why my Physical Server is so low on T.P.S. I changed the mysql db server only. Kannel on the Server A only. Please guide me. I am struggling from past 4 months. *Rajeev Krishna* Operations Manager Krishnas Software Technologies www.krishnasoft.in mobile :+91 888 5815 888 Sales :+91 888 5813 888 Support :+91 888 5817 888 On Thu, Nov 6, 2014 at 11:00 AM, spameden spame...@gmail.com wrote: quick googling (only took me 30 seconds): http://www.kannel.org/pipermail/users/2010-January/009745.html http://www.kannel.org/pipermail/users/2013-June/019873.html http://www.kannel.org/pipermail/users/2008-March/004260.html http://www.kannel.org/pipermail/users/2007-February/001541.html http://www.kannel.org/pipermail/users/2014-June/021242.html etc... in short: 1) test with fakesmsc where no SMPP remote binds involved with memory storage and measure throughput with sqlbox or smsbox. 2) add DLR handling 3) add MySQL DLR handling and see how it goes 4) if you need additional hit-url add it and measure again 5) check mysql slow-log as well as mysql queries/sec variable via mysqladmin pr, add needed index for dlr table (discussed many times for quick ts,smsc_id matching) 6) check your connection with remote binds via tcpdump/ettercap/wireshark if you're losing any packets or there are many re-transmissions going on 7) connect your remote binds and test again as said 1000 x times kannel is usually NOT a problem, most problems involved either with incorrect setup of middle software or your remote SMSC upstream. 2014-11-06 8:05 GMT+03:00 RK Krishnas r...@krishnasoft.in: Dear Team, Please Suggest the best way or guide us for the proper approach. I saw 25 Answers saying Search in mailing List, Search In google. But I spent 2 weeks for the same no result at all. Many told to tweak sqlbox mysql. No one gave the solution. I personally mailed 5 members who said that they solved the issue. They never posted back the settings nor the steps. Problem: SQLBOX==BEARERBOX==SMSC==MOBILE. Here each session is getting an average of 10 tps only. Even the ack dlr are queued up in store. Please provide us the solution i promise that I will reply to all users who keep asking the questions for tps sqlbox. *Rajeev Krishna* Operations Manager Krishnas Software Technologies www.krishnasoft.in mobile :+91 888 5815 888 Sales :+91 888 5813 888 Support :+91 888 5817 888 On Wed, Nov 5, 2014 at 5:41 PM, Willy Mularto sangpr...@gmail.com wrote: Just joke mate, I agree with you. Saw
RE: How to Improve Performance of SQLBox
Rajeev, Looks more a HW/O.S issue than kannel. 1. Update all the CentOS to the latest yum update 2. Look for MySQL tuning like http://www.percona.com/blog/2014/01/28/10-mysql-settings-to-tune-after-installation/ 3. Update ethernet board driver according to manufacturer or change the hole board, patch cable and switch port. 4. Update HDD board driver according to manufacturer Cheers, Leandro From: users [mailto:users-boun...@kannel.org] On Behalf Of RK Krishnas Sent: Thursday, January 01, 2015 9:32 AM To: spameden Cc: Aditya Khanna; kannel users@kannel.org Subject: Re: How to Improve Performance of SQLBox Dear Friends Kannel Team, Got a serious Issue. Server A: Centos 6.5 Server with Kannel svn-r5122., 4 GB RAM, 1TB HDD Server B: Centos 6.5 with LAMP Stack , MYSQL 5.5.1, 3.2 Ghz Xeon, 8 GB, 1TD HDD Server C: Virtual Machine Centos 6.5 with LAMP Stack , MYSQL 5.5.1, 1 Ghz 1 GB RAM Server D: Windows 7 with Xampp , MYSQL 5..1 If I run Kannel on Server A with mysql db on Server B, TPS per session=15 If I run Kannel on Server A with mysql db on Server C or Server D TPS per session=90 I ran mysql benchmark also. Serverc is 5 times low on benchmark test. Still why my Physical Server is so low on T.P.S. I changed the mysql db server only. Kannel on the Server A only. Please guide me. I am struggling from past 4 months. Rajeev Krishna Operations Manager Krishnas Software Technologies www.krishnasoft.inhttp://www.krishnasoft.in mobile :+91 888 5815 888 Sales :+91 888 5813 888 Support :+91 888 5817 888 On Thu, Nov 6, 2014 at 11:00 AM, spameden spame...@gmail.commailto:spame...@gmail.com wrote: quick googling (only took me 30 seconds): http://www.kannel.org/pipermail/users/2010-January/009745.html http://www.kannel.org/pipermail/users/2013-June/019873.html http://www.kannel.org/pipermail/users/2008-March/004260.html http://www.kannel.org/pipermail/users/2007-February/001541.html http://www.kannel.org/pipermail/users/2014-June/021242.html etc... in short: 1) test with fakesmsc where no SMPP remote binds involved with memory storage and measure throughput with sqlbox or smsbox. 2) add DLR handling 3) add MySQL DLR handling and see how it goes 4) if you need additional hit-url add it and measure again 5) check mysql slow-log as well as mysql queries/sec variable via mysqladmin pr, add needed index for dlr table (discussed many times for quick ts,smsc_id matching) 6) check your connection with remote binds via tcpdump/ettercap/wireshark if you're losing any packets or there are many re-transmissions going on 7) connect your remote binds and test again as said 1000 x times kannel is usually NOT a problem, most problems involved either with incorrect setup of middle software or your remote SMSC upstream. 2014-11-06 8:05 GMT+03:00 RK Krishnas r...@krishnasoft.inmailto:r...@krishnasoft.in: Dear Team, Please Suggest the best way or guide us for the proper approach. I saw 25 Answers saying Search in mailing List, Search In google. But I spent 2 weeks for the same no result at all. Many told to tweak sqlbox mysql. No one gave the solution. I personally mailed 5 members who said that they solved the issue. They never posted back the settings nor the steps. Problem: SQLBOX==BEARERBOX==SMSC==MOBILE. Here each session is getting an average of 10 tps only. Even the ack dlr are queued up in store. Please provide us the solution i promise that I will reply to all users who keep asking the questions for tps sqlbox. Rajeev Krishna Operations Manager Krishnas Software Technologies www.krishnasoft.inhttp://www.krishnasoft.in mobile :+91 888 5815 888 Sales :+91 888 5813 888 Support :+91 888 5817 888 On Wed, Nov 5, 2014 at 5:41 PM, Willy Mularto sangpr...@gmail.commailto:sangpr...@gmail.com wrote: Just joke mate, I agree with you. Saw many same posts from Aditya. On 5 Nov 2014 19:08, spameden spame...@gmail.commailto:spame...@gmail.com wrote: It's not the first time I see this message from Aditya. If you google a bit you'll understand what I mean. Don't get me wrong I just don't like people who can't put a bit effort into problem solving and want complete final solution from others. If you really want to solve this way -- rent a kannel specialist and pay him money for his work (hourly-based). 2014-11-05 15:01 GMT+03:00 Willy Mularto sangpr...@gmail.commailto:sangpr...@gmail.com: Is that really 100500 questions? LOL. Maybe he needs your guidance mate. On 5 Nov 2014 18:16, spameden spame...@gmail.commailto:spame...@gmail.com wrote: Can you please stop SPAMMING kannel lists? Really annoying to get 100500 questions on the same issue from you all time. You could read a bit of mailing lists, this question has been covered many times already and there were many suggestions why you might be having low performance. 2014-11-05 10:05 GMT+03:00 Aditya Khanna aditya.khanna111...@gmail.commailto:aditya.khanna111...@gmail.com: Hello
Re: How to Improve Performance of SQLBox
Dear Friends Kannel Team, Got a serious Issue. *Server A:* Centos 6.5 Server with Kannel svn-r5122., 4 GB RAM, 1TB HDD *Server B:* Centos 6.5 with LAMP Stack , MYSQL 5.5.1, 3.2 Ghz Xeon, 8 GB, 1TD HDD *Server C: *Virtual Machine Centos 6.5 with LAMP Stack , MYSQL 5.5.1, 1 Ghz 1 GB RAM *Server D:* Windows 7 with Xampp , MYSQL 5..1 If I run Kannel on Server A with mysql db on Server B, TPS per session=15 If I run Kannel on Server A with mysql db on Server C or Server D TPS per session=90 I ran mysql benchmark also. Serverc is 5 times low on benchmark test. Still why my Physical Server is so low on T.P.S. I changed the mysql db server only. Kannel on the Server A only. Please guide me. I am struggling from past 4 months. *Rajeev Krishna* Operations Manager Krishnas Software Technologies www.krishnasoft.in mobile :+91 888 5815 888 Sales :+91 888 5813 888 Support :+91 888 5817 888 On Thu, Nov 6, 2014 at 11:00 AM, spameden spame...@gmail.com wrote: quick googling (only took me 30 seconds): http://www.kannel.org/pipermail/users/2010-January/009745.html http://www.kannel.org/pipermail/users/2013-June/019873.html http://www.kannel.org/pipermail/users/2008-March/004260.html http://www.kannel.org/pipermail/users/2007-February/001541.html http://www.kannel.org/pipermail/users/2014-June/021242.html etc... in short: 1) test with fakesmsc where no SMPP remote binds involved with memory storage and measure throughput with sqlbox or smsbox. 2) add DLR handling 3) add MySQL DLR handling and see how it goes 4) if you need additional hit-url add it and measure again 5) check mysql slow-log as well as mysql queries/sec variable via mysqladmin pr, add needed index for dlr table (discussed many times for quick ts,smsc_id matching) 6) check your connection with remote binds via tcpdump/ettercap/wireshark if you're losing any packets or there are many re-transmissions going on 7) connect your remote binds and test again as said 1000 x times kannel is usually NOT a problem, most problems involved either with incorrect setup of middle software or your remote SMSC upstream. 2014-11-06 8:05 GMT+03:00 RK Krishnas r...@krishnasoft.in: Dear Team, Please Suggest the best way or guide us for the proper approach. I saw 25 Answers saying Search in mailing List, Search In google. But I spent 2 weeks for the same no result at all. Many told to tweak sqlbox mysql. No one gave the solution. I personally mailed 5 members who said that they solved the issue. They never posted back the settings nor the steps. Problem: SQLBOX==BEARERBOX==SMSC==MOBILE. Here each session is getting an average of 10 tps only. Even the ack dlr are queued up in store. Please provide us the solution i promise that I will reply to all users who keep asking the questions for tps sqlbox. *Rajeev Krishna* Operations Manager Krishnas Software Technologies www.krishnasoft.in mobile :+91 888 5815 888 Sales :+91 888 5813 888 Support :+91 888 5817 888 On Wed, Nov 5, 2014 at 5:41 PM, Willy Mularto sangpr...@gmail.com wrote: Just joke mate, I agree with you. Saw many same posts from Aditya. On 5 Nov 2014 19:08, spameden spame...@gmail.com wrote: It's not the first time I see this message from Aditya. If you google a bit you'll understand what I mean. Don't get me wrong I just don't like people who can't put a bit effort into problem solving and want complete final solution from others. If you really want to solve this way -- rent a kannel specialist and pay him money for his work (hourly-based). 2014-11-05 15:01 GMT+03:00 Willy Mularto sangpr...@gmail.com: Is that really 100500 questions? LOL. Maybe he needs your guidance mate. On 5 Nov 2014 18:16, spameden spame...@gmail.com wrote: Can you please stop SPAMMING kannel lists? Really annoying to get 100500 questions on the same issue from you all time. You could read a bit of mailing lists, this question has been covered many times already and there were many suggestions why you might be having low performance. 2014-11-05 10:05 GMT+03:00 Aditya Khanna aditya.khanna111...@gmail.com: *Hello Everyone,* I'm new with Kannel SMS Gateway. I have configured Kannel as my requirements. This is my Gateway Architecture: *HTTP Application BBox** SQLBox** SMSBox** SMSCs* * Mobile* Now, the problem is that When I'm observing send_sms table that are created by SQLBox then It sends 10 msgs/sec to particular connected SMSBox. So please suggest me that how to improve this speed in SQLBox. *Thanks,* *Aditya Khanna*
Re: How to Improve Performance of SQLBox
Can you please stop SPAMMING kannel lists? Really annoying to get 100500 questions on the same issue from you all time. You could read a bit of mailing lists, this question has been covered many times already and there were many suggestions why you might be having low performance. 2014-11-05 10:05 GMT+03:00 Aditya Khanna aditya.khanna111...@gmail.com: *Hello Everyone,* I'm new with Kannel SMS Gateway. I have configured Kannel as my requirements. This is my Gateway Architecture: *HTTP Application BBox** SQLBox** SMSBox** SMSCs* * Mobile* Now, the problem is that When I'm observing send_sms table that are created by SQLBox then It sends 10 msgs/sec to particular connected SMSBox. So please suggest me that how to improve this speed in SQLBox. *Thanks,* *Aditya Khanna*
Re: How to Improve Performance of SQLBox
Is that really 100500 questions? LOL. Maybe he needs your guidance mate. On 5 Nov 2014 18:16, spameden spame...@gmail.com wrote: Can you please stop SPAMMING kannel lists? Really annoying to get 100500 questions on the same issue from you all time. You could read a bit of mailing lists, this question has been covered many times already and there were many suggestions why you might be having low performance. 2014-11-05 10:05 GMT+03:00 Aditya Khanna aditya.khanna111...@gmail.com: *Hello Everyone,* I'm new with Kannel SMS Gateway. I have configured Kannel as my requirements. This is my Gateway Architecture: *HTTP Application BBox** SQLBox** SMSBox** SMSCs* * Mobile* Now, the problem is that When I'm observing send_sms table that are created by SQLBox then It sends 10 msgs/sec to particular connected SMSBox. So please suggest me that how to improve this speed in SQLBox. *Thanks,* *Aditya Khanna*
Re: How to Improve Performance of SQLBox
It's not the first time I see this message from Aditya. If you google a bit you'll understand what I mean. Don't get me wrong I just don't like people who can't put a bit effort into problem solving and want complete final solution from others. If you really want to solve this way -- rent a kannel specialist and pay him money for his work (hourly-based). 2014-11-05 15:01 GMT+03:00 Willy Mularto sangpr...@gmail.com: Is that really 100500 questions? LOL. Maybe he needs your guidance mate. On 5 Nov 2014 18:16, spameden spame...@gmail.com wrote: Can you please stop SPAMMING kannel lists? Really annoying to get 100500 questions on the same issue from you all time. You could read a bit of mailing lists, this question has been covered many times already and there were many suggestions why you might be having low performance. 2014-11-05 10:05 GMT+03:00 Aditya Khanna aditya.khanna111...@gmail.com: *Hello Everyone,* I'm new with Kannel SMS Gateway. I have configured Kannel as my requirements. This is my Gateway Architecture: *HTTP Application BBox** SQLBox** SMSBox** SMSCs* * Mobile* Now, the problem is that When I'm observing send_sms table that are created by SQLBox then It sends 10 msgs/sec to particular connected SMSBox. So please suggest me that how to improve this speed in SQLBox. *Thanks,* *Aditya Khanna*
Re: How to Improve Performance of SQLBox
Just joke mate, I agree with you. Saw many same posts from Aditya. On 5 Nov 2014 19:08, spameden spame...@gmail.com wrote: It's not the first time I see this message from Aditya. If you google a bit you'll understand what I mean. Don't get me wrong I just don't like people who can't put a bit effort into problem solving and want complete final solution from others. If you really want to solve this way -- rent a kannel specialist and pay him money for his work (hourly-based). 2014-11-05 15:01 GMT+03:00 Willy Mularto sangpr...@gmail.com: Is that really 100500 questions? LOL. Maybe he needs your guidance mate. On 5 Nov 2014 18:16, spameden spame...@gmail.com wrote: Can you please stop SPAMMING kannel lists? Really annoying to get 100500 questions on the same issue from you all time. You could read a bit of mailing lists, this question has been covered many times already and there were many suggestions why you might be having low performance. 2014-11-05 10:05 GMT+03:00 Aditya Khanna aditya.khanna111...@gmail.com : *Hello Everyone,* I'm new with Kannel SMS Gateway. I have configured Kannel as my requirements. This is my Gateway Architecture: *HTTP Application BBox** SQLBox** SMSBox** SMSCs* * Mobile* Now, the problem is that When I'm observing send_sms table that are created by SQLBox then It sends 10 msgs/sec to particular connected SMSBox. So please suggest me that how to improve this speed in SQLBox. *Thanks,* *Aditya Khanna*
Re: How to Improve Performance of SQLBox
Dear Team, Please Suggest the best way or guide us for the proper approach. I saw 25 Answers saying Search in mailing List, Search In google. But I spent 2 weeks for the same no result at all. Many told to tweak sqlbox mysql. No one gave the solution. I personally mailed 5 members who said that they solved the issue. They never posted back the settings nor the steps. Problem: SQLBOX==BEARERBOX==SMSC==MOBILE. Here each session is getting an average of 10 tps only. Even the ack dlr are queued up in store. Please provide us the solution i promise that I will reply to all users who keep asking the questions for tps sqlbox. *Rajeev Krishna* Operations Manager Krishnas Software Technologies www.krishnasoft.in mobile :+91 888 5815 888 Sales :+91 888 5813 888 Support :+91 888 5817 888 On Wed, Nov 5, 2014 at 5:41 PM, Willy Mularto sangpr...@gmail.com wrote: Just joke mate, I agree with you. Saw many same posts from Aditya. On 5 Nov 2014 19:08, spameden spame...@gmail.com wrote: It's not the first time I see this message from Aditya. If you google a bit you'll understand what I mean. Don't get me wrong I just don't like people who can't put a bit effort into problem solving and want complete final solution from others. If you really want to solve this way -- rent a kannel specialist and pay him money for his work (hourly-based). 2014-11-05 15:01 GMT+03:00 Willy Mularto sangpr...@gmail.com: Is that really 100500 questions? LOL. Maybe he needs your guidance mate. On 5 Nov 2014 18:16, spameden spame...@gmail.com wrote: Can you please stop SPAMMING kannel lists? Really annoying to get 100500 questions on the same issue from you all time. You could read a bit of mailing lists, this question has been covered many times already and there were many suggestions why you might be having low performance. 2014-11-05 10:05 GMT+03:00 Aditya Khanna aditya.khanna111...@gmail.com : *Hello Everyone,* I'm new with Kannel SMS Gateway. I have configured Kannel as my requirements. This is my Gateway Architecture: *HTTP Application BBox** SQLBox** SMSBox** SMSCs* * Mobile* Now, the problem is that When I'm observing send_sms table that are created by SQLBox then It sends 10 msgs/sec to particular connected SMSBox. So please suggest me that how to improve this speed in SQLBox. *Thanks,* *Aditya Khanna*
Re: How to Improve Performance of SQLBox
quick googling (only took me 30 seconds): http://www.kannel.org/pipermail/users/2010-January/009745.html http://www.kannel.org/pipermail/users/2013-June/019873.html http://www.kannel.org/pipermail/users/2008-March/004260.html http://www.kannel.org/pipermail/users/2007-February/001541.html http://www.kannel.org/pipermail/users/2014-June/021242.html etc... in short: 1) test with fakesmsc where no SMPP remote binds involved with memory storage and measure throughput with sqlbox or smsbox. 2) add DLR handling 3) add MySQL DLR handling and see how it goes 4) if you need additional hit-url add it and measure again 5) check mysql slow-log as well as mysql queries/sec variable via mysqladmin pr, add needed index for dlr table (discussed many times for quick ts,smsc_id matching) 6) check your connection with remote binds via tcpdump/ettercap/wireshark if you're losing any packets or there are many re-transmissions going on 7) connect your remote binds and test again as said 1000 x times kannel is usually NOT a problem, most problems involved either with incorrect setup of middle software or your remote SMSC upstream. 2014-11-06 8:05 GMT+03:00 RK Krishnas r...@krishnasoft.in: Dear Team, Please Suggest the best way or guide us for the proper approach. I saw 25 Answers saying Search in mailing List, Search In google. But I spent 2 weeks for the same no result at all. Many told to tweak sqlbox mysql. No one gave the solution. I personally mailed 5 members who said that they solved the issue. They never posted back the settings nor the steps. Problem: SQLBOX==BEARERBOX==SMSC==MOBILE. Here each session is getting an average of 10 tps only. Even the ack dlr are queued up in store. Please provide us the solution i promise that I will reply to all users who keep asking the questions for tps sqlbox. *Rajeev Krishna* Operations Manager Krishnas Software Technologies www.krishnasoft.in mobile :+91 888 5815 888 Sales :+91 888 5813 888 Support :+91 888 5817 888 On Wed, Nov 5, 2014 at 5:41 PM, Willy Mularto sangpr...@gmail.com wrote: Just joke mate, I agree with you. Saw many same posts from Aditya. On 5 Nov 2014 19:08, spameden spame...@gmail.com wrote: It's not the first time I see this message from Aditya. If you google a bit you'll understand what I mean. Don't get me wrong I just don't like people who can't put a bit effort into problem solving and want complete final solution from others. If you really want to solve this way -- rent a kannel specialist and pay him money for his work (hourly-based). 2014-11-05 15:01 GMT+03:00 Willy Mularto sangpr...@gmail.com: Is that really 100500 questions? LOL. Maybe he needs your guidance mate. On 5 Nov 2014 18:16, spameden spame...@gmail.com wrote: Can you please stop SPAMMING kannel lists? Really annoying to get 100500 questions on the same issue from you all time. You could read a bit of mailing lists, this question has been covered many times already and there were many suggestions why you might be having low performance. 2014-11-05 10:05 GMT+03:00 Aditya Khanna aditya.khanna111...@gmail.com: *Hello Everyone,* I'm new with Kannel SMS Gateway. I have configured Kannel as my requirements. This is my Gateway Architecture: *HTTP Application BBox** SQLBox** SMSBox** SMSCs* * Mobile* Now, the problem is that When I'm observing send_sms table that are created by SQLBox then It sends 10 msgs/sec to particular connected SMSBox. So please suggest me that how to improve this speed in SQLBox. *Thanks,* *Aditya Khanna*
How to Improve Performance of SQLBox
*Hello Everyone,* I'm new with Kannel SMS Gateway. I have configured Kannel as my requirements. This is my Gateway Architecture: *HTTP Application BBox** SQLBox** SMSBox** SMSCs* * Mobile* Now, the problem is that When I'm observing send_sms table that are created by SQLBox then It sends 10 msgs/sec to particular connected SMSBox. So please suggest me that how to improve this speed in SQLBox. *Thanks,* *Aditya Khanna*
