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* >>>>>>> >>>>>> >>>>>> >>>> >> >
