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<mailto:lean...@fliadt.com>> wrote: Change LAN board, cable and switch port. ________________________________ From: RK Krishnas <r...@krishnasoft.in<mailto: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<mailto:lean...@fliadt.com>> CC: spameden <spame...@gmail.com<mailto:spame...@gmail.com>>, Aditya Khanna <aditya.khanna111...@gmail.com<mailto:aditya.khanna111...@gmail.com>>, "kannel users@kannel.org<mailto:users@kannel.org>" <users@kannel.org<mailto: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<http://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<mailto: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<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<mailto: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<http://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<mailto: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<mailto: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<http://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<mailto: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<mailto: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<mailto: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<mailto: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<mailto: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
