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