Change LAN board, cable and switch port.
________________________________
From: RK Krishnas <[email protected]>
Date: January 3, 2015 12:42:14 PM
Subject: Re: How to Improve Performance of SQLBox
To: "Tenorio, Leandro" <[email protected]>
CC: spameden <[email protected]>, Aditya Khanna
<[email protected]>, "kannel [email protected]" <[email protected]>
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
<[email protected]<mailto:[email protected]>> 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:[email protected]<mailto:[email protected]>]
On Behalf Of RK Krishnas
Sent: Thursday, January 01, 2015 9:32 AM
To: spameden
Cc: Aditya Khanna; kannel [email protected]<mailto:[email protected]>
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
<[email protected]<mailto:[email protected]>> 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
<[email protected]<mailto:[email protected]>>:
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
<[email protected]<mailto:[email protected]>> wrote:
Just joke mate, I agree with you. Saw many same posts from Aditya.
On 5 Nov 2014 19:08, "spameden" <[email protected]<mailto:[email protected]>>
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
<[email protected]<mailto:[email protected]>>:
Is that really 100500 questions? LOL. Maybe he needs your guidance mate.
On 5 Nov 2014 18:16, "spameden" <[email protected]<mailto:[email protected]>>
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
<[email protected]<mailto:[email protected]>>:
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
