*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:* *BBox----SQLBox----SMSBox----Fake 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/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* >> >> >> >> >> >> >> >> >> >> >> >> >> >> >
