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.inhttp://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.commailto: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.orgmailto: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.orgmailto: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.inhttp://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.commailto: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.inmailto: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