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