2015-01-17 8:49 GMT+03:00 Ammar Ali <ammarali3...@gmail.com>: > Hey, > > If mysql grows then it will be impact on mysql performance? > > Because When I'm deleting all records in mysql then the TPS increased and > reached at 500-600 messages/second. >
If you need accurate benchmark results. 1) Test kannel without any DLR reports activated, store spool in the memory (e.g. tmpfs), use internal storage for DLR. 2) Slowly increase factors (e.g. add DLR reports in internal storage, measure.. add MySQL storage .. measure). 3) In the end you'll get what's slowing down kannel. In my own experience the most slowing factor is either MySQL or sqlbox itself (if it's outdated it gets 1 message per query instead of the batch method where it gets multiple records at once). > > > > > Ammar Ali > Framp Technologies > Pune (Maharashtra) > > On Sat, Jan 17, 2015 at 10:51 AM, RK Krishnas <r...@krishnasoft.in> wrote: > >> Hi, >> use dlr-storage as mysql db. >> >> >> On 1/17/15, Ammar Ali <ammarali3...@gmail.com> wrote: >> > Hey, >> > >> > I have one more serious issue. Kannel Bearerbox consumes 28% of My total >> > RAM. >> > >> > So Can you suggest me where is actual issue in my whole setup? >> > >> > >> > >> > >> > >> > *Ammar Ali* >> > >> > *Framp Technologies* >> > *Pune (Maharashtra)* >> > >> > >> > On Fri, Jan 16, 2015 at 11:20 PM, RK Krishnas <r...@krishnasoft.in> >> wrote: >> > >> >> Hi Everyone, >> >> >> >> with 2 cores , 2 GB Ram & 20 GB H.D.D. In a virtual Machine with 512 >> Kbps >> >> ILL. >> >> I am getting 550 TPS with my Live (Mobile) Operator. 2 Sessions with >> 250+ >> >> tps each >> >> >> >> My Settings: >> >> >> >> >> >> 1. SMS APP >> SQLBOX >> Bearerbox >> >> 2. Kannel & sql box log level >=3 >> >> 3. log file is placed in a partition with ext2 >> >> 4. Dlr are placed in mysql table. >> >> 5. Spool folder is placed in ext2 >> >> 6. Mysql 5.5 >> >> 7. Centos 6.6 >> >> 8. 1 Sqlbox >> >> 9. 2 mysql connections in kannel & sqlbox >> >> >> >> >> >> With the above I am getting 550+ TPS. >> >> >> >> >> >> I want to try with 4 cores, 2+ Sqlboxes. >> >> >> >> Sqlbox performance > Smsboxes as smsboxes have to hit a webpage, open >> >> mysql ,run query & close connection. >> >> >> >> >> >> >> >> *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 16, 2015 at 7:14 PM, Ammar Ali <ammarali3...@gmail.com> >> >> wrote: >> >> >> >>> Hi David Szanto, >> >>> >> >>> I'm also testing with multiple SQLBoxes. >> >>> >> >>> This is the my configuration: >> >>> >> >>> *Application---BBox---Multiple SQLBoxes---SMSBox----Multiple SMSC >> >>> (Fake)* >> >>> >> >>> >> >>> But I'm not getting better performance. Thanks in advance. >> >>> >> >>> >> >>> *Ammar Ali* >> >>> *Framp Technology* >> >>> *Pune (Maharashtra)* >> >>> >> >>> >> >>> >> >>> On Fri, Jan 16, 2015 at 7:05 PM, David Szanto <dsza...@genasys.com> >> >>> wrote: >> >>> >> >>>> Hi Ammar! >> >>>> I suggest you check the load in the SQLBox, BearerBox, MySQL and >> >>>> SMSBox. >> >>>> Our experience is that Mysql tends to slow things down a lot. >> >>>> Another enhancement we've had success with has been having 3-6 SMSBox >> >>>> instances running and connected to the bearerbox, and HAProxy on top >> >>>> distributing messages among them. SMSBoxes are very scalable, and >> can >> >>>> even >> >>>> be set on separate machines. >> >>>> >> >>>> Ideally, something like: >> >>>> >> >>>> Application+SMSBOX ----> Bearerbox+Backends(ex:Mysql) ----> SMSC >> >>>> >> >>>> >> >>>> Yet, you must check where is the actual bottleneck. On our >> experience >> >>>> it was MySQL. >> >>>> >> >>>> Finally, and again on our experience, Bearerbox will load CPU as it >> >>>> gets >> >>>> overworked, but RAM will be consumed only as long as messages are in >> >>>> queue >> >>>> (in RAM), Ex: pending DLR without DDBB backend (managed in memory) >> >>>> >> >>>> Hope this helps >> >>>> >> >>>> Cheers, >> >>>> David Szanto >> >>>> >> >>>> El 16/01/15 a las 13:24, Ammar Ali escribió: >> >>>> >> >>>> Hello Everyone, >> >>>> >> >>>> I had started kannel sms gateway before past 2 days. When I was >> >>>> started kannel then tested my application, it shows me >> >>>> 500-800 messages second speed but now I'm getting 200-300 Max >> >>>> messages/second. And the main problem is that it is not increased >> above >> >>>> 300. >> >>>> >> >>>> Can you suggest me that what is the main bottleneck in whole system >> >>>> setup. Because currently I'm connecting Fake SMSC connections. >> >>>> >> >>>> >> >>>> Thanks in advance >> >>>> >> >>>> >> >>>> *Ammar Ali* >> >>>> *Framp Technology* >> >>>> *Pune (Maharashtra)* >> >>>> >> >>>> >> >>>> >> >>>> >> >>>> On Fri, Jan 16, 2015 at 5:29 PM, Christopher Burke < >> >>>> christopher.bu...@simulity.com> wrote: >> >>>> >> >>>>> Hey, >> >>>>> >> >>>>> If you’re attempting to optimise the solution, you’ll probably want >> >>>>> to look at a testbed. Check out >> >>>>> https://github.com/twitter/cloudhopper-smpp which is a Java SMPP >> >>>>> implementation. I use this and on my 2012 Macbook Pro (2.6ghz i7/8GB >> >>>>> RAM/512GB SSD) I get 4.8k submit/sec over 10 sessons when I use >> Netty >> >>>>> 6. >> >>>>> Perhaps you can setup another box using the ch-smpp impl for >> listening >> >>>>> (they’ve got performance code/configuration examples in the >> >>>>> test/../demo >> >>>>> dirs, and have your Kannel submit to it. >> >>>>> >> >>>>> On the configuration you currently have, you should expect 200-300 >> >>>>> msg/sec using Kannel, I’ve never seen it submit much faster than >> that >> >>>>> but >> >>>>> admittedly I find understanding Java code a bit easier so I work >> with >> >>>>> ch-smpp more now. >> >>>>> >> >>>>> Cheers, >> >>>>> >> >>>>> >> >>>>> *Christopher Burke *http://simulity.com >> >>>>> Office: +44 (0) 1248 679 281 >> >>>>> Fax: +44 (0) 1248 660 323 >> >>>>> Skype:krslynx >> >>>>> >> >>>>> >> >>>>> >> >>>>> *UK *Unit 8, Ash Court, >> >>>>> Parc Menai, Bangor, >> >>>>> Gwynedd, LL57 4DF, >> >>>>> Wales, UK >> >>>>> >> >>>>> >> >>>>> *Malaysia *Level 30, >> >>>>> The Gardens North Tower, >> >>>>> Mid Valley City, >> >>>>> Lingkaran Syed Putra, >> >>>>> 59200, Kuala Lumpur, >> >>>>> Malaysia >> >>>>> >> >>>>> NOTICE: This message contains privileged & confidential information >> >>>>> intended only for the use of the addressee named above. If you are >> not >> >>>>> the >> >>>>> intended recipient of this message, you are hereby notified that you >> >>>>> must >> >>>>> not disseminate, copy or take any action in reliance on it. If you >> >>>>> have >> >>>>> received this message in error, please notify Simulity Labs >> >>>>> immediately. >> >>>>> Any views expressed in this message are those of the individual >> sender >> >>>>> except where the sender specifically states them to be the view of >> >>>>> Simulity >> >>>>> Labs >> >>>>> >> >>>>> On 16 January 2015 at 11:13:34, Mohammed Saleem ( >> >>>>> mohammedsl...@gmail.com) wrote: >> >>>>> >> >>>>> Hi >> >>>>> >> >>>>> Then specs you have is more than enough to send even 10k SMS / >> second >> >>>>> with correct configurations. But the bottleneck is the network speed >> >>>>> and >> >>>>> the allowed TPS from the operator. >> >>>>> On Jan 16, 2015 1:40 PM, "Ammar Ali" <ammarali3...@gmail.com> >> wrote: >> >>>>> >> >>>>>> Hello >> >>>>>> >> >>>>>> Currently, I have 4 GB RAM, Intel 24 Core Processor and 120 GB HDD >> >>>>>> but I'm not getting this TPS (300-500) in a second. >> >>>>>> >> >>>>>> "Kannel bearerbox version `1.4.4'. Build `Dec 31 2014 18:29:22', >> >>>>>> compiler `4.4.7 20120313 (Red Hat 4.4.7-11)'. System Linux, release >> >>>>>> 2.6.32-042stab094.7, version #1 SMP Wed Oct 22 12:43:21 MSK 2014, >> >>>>>> machine >> >>>>>> x86_64. Hostname localhost, IP 192.168.1.1. Libxml version 2.7.6. >> >>>>>> Using >> >>>>>> OpenSSL 1.0.1e-fips 11 Feb 2013. Compiled with MySQL 5.5.40, using >> >>>>>> MySQL >> >>>>>> 5.6.22. Using native malloc." >> >>>>>> >> >>>>>> One more thing sometimes I'm getting this TPS but next time It has >> >>>>>> been decreased and reached at 100-200 TPS in a second. Can you >> suggest >> >>>>>> me >> >>>>>> where the problem in my whole system. >> >>>>>> >> >>>>>> This is my whole setup: >> >>>>>> >> >>>>>> [Bearerbox]<----->[SQLBox]<----->[SMSBox]<---->[Fake SMSC >> >>>>>> (Multiple)] >> >>>>>> >> >>>>>> *Configurations:* >> >>>>>> *Kannel.conf* >> >>>>>> >> >>>>>> # Single Group "CORE" >> >>>>>> >> >>>>>> group = core >> >>>>>> admin-port = "13000" >> >>>>>> admin-port-ssl="no" >> >>>>>> admin-password = "*******" >> >>>>>> status-password = "*******" >> >>>>>> admin-deny-ip="*.*.*.*" >> >>>>>> admin-allow-ip="*.*.*.*" >> >>>>>> smsbox-interface ="127.0.0.1" >> >>>>>> smsbox-port = "13001" >> >>>>>> smsbox-port-ssl="no" >> >>>>>> log-file = "kannel.log" >> >>>>>> log-level = "0" >> >>>>>> access-log = "access.access" >> >>>>>> dlr-storage = "internal" >> >>>>>> sms-incoming-queue-limit = "-1" >> >>>>>> sms-outgoing-queue-limit = "1000000" >> >>>>>> smsbox-max-pending = "100" >> >>>>>> sms-resend-freq = "60" >> >>>>>> sms-resend-retry = "-1" >> >>>>>> >> >>>>>> # Single Group "smsbox" >> >>>>>> >> >>>>>> group = smsbox >> >>>>>> smsbox-id = "mysmsbox" >> >>>>>> bearerbox-host = "127.0.0.1" >> >>>>>> bearerbox-port = "13001" >> >>>>>> sendsms-port = "13010" >> >>>>>> log-file = "smsbox.log" >> >>>>>> log-level = "0" >> >>>>>> access-log="saccess.access" >> >>>>>> sendsms-chars = "0123456789+ " >> >>>>>> >> >>>>>> # Multi Group "SMSC" >> >>>>>> >> >>>>>> group = smsc >> >>>>>> smsc = fake >> >>>>>> smsc-id = smsc1 >> >>>>>> host="localhost" >> >>>>>> port = 10001 >> >>>>>> throughput="1000000.00" >> >>>>>> connect-allow-ip = 127.0.0.1 >> >>>>>> reroute-dlr=true >> >>>>>> log-file="mysmsc1.log" >> >>>>>> log-level=0 >> >>>>>> allowed-smsc-id="smsc1" >> >>>>>> denied-smsc-id="smsc2" >> >>>>>> >> >>>>>> group = smsc >> >>>>>> smsc = fake >> >>>>>> smsc-id = smsc2 >> >>>>>> host="localhost" >> >>>>>> port = 10002 >> >>>>>> throughput="5000.00" >> >>>>>> connect-allow-ip = 127.0.0.1 >> >>>>>> reroute-dlr=true >> >>>>>> log-file="mysmsc2.log" >> >>>>>> log-level=0 >> >>>>>> allowed-smsc-id="smsc2" >> >>>>>> denied-smsc-id="smsc1" >> >>>>>> >> >>>>>> # Multi Group "smsbox-route" >> >>>>>> >> >>>>>> group = smsbox-route >> >>>>>> smsbox-id = "mysmsbox" >> >>>>>> smsc-id = "smsc1" >> >>>>>> >> >>>>>> group = smsbox-route >> >>>>>> smsbox-id = "mysmsbox" >> >>>>>> smsc-id = "smsc2" >> >>>>>> >> >>>>>> # Multi Group "sms-service" >> >>>>>> >> >>>>>> group = sms-service >> >>>>>> keyword = default >> >>>>>> text = "No service specified" >> >>>>>> accept-x-kannel-headers = true >> >>>>>> concatenation = true >> >>>>>> catch-all = true >> >>>>>> >> >>>>>> # Multi Group "sendsms-user" >> >>>>>> >> >>>>>> group = sendsms-user >> >>>>>> name = "mysendsmsuser1" >> >>>>>> username = "tester1" >> >>>>>> password = "tester1" >> >>>>>> max-messages="10" >> >>>>>> >> >>>>>> *sqlbox.conf* >> >>>>>> >> >>>>>> # SQLBox Configuraton >> >>>>>> >> >>>>>> group = sqlbox >> >>>>>> id = sqlbox-db >> >>>>>> smsbox-id = "mysqlbox" >> >>>>>> global-sender = "" >> >>>>>> bearerbox-host = "localhost" >> >>>>>> bearerbox-port = "13001" >> >>>>>> smsbox-port = "13002" >> >>>>>> smsbox-port-ssl = "false" >> >>>>>> sql-log-table = "sent_sms" >> >>>>>> sql-insert-table = "send_sms" >> >>>>>> log-file = "sqlbox.log" >> >>>>>> log-level = "0" >> >>>>>> >> >>>>>> # Example MYSQL Connection >> >>>>>> >> >>>>>> group = mysql-connection >> >>>>>> id = sqlbox-db >> >>>>>> host="127.0.0.1" >> >>>>>> port = "3306" >> >>>>>> username = "**********" >> >>>>>> password = "**********" >> >>>>>> database = "**********" >> >>>>>> max-connections = "10" >> >>>>>> >> >>>>>> >> >>>>>> Currently I'm connecting Fake SMSC through SSH from my computer. >> Is >> >>>>>> there any problem? Thanks in advance. >> >>>>>> >> >>>>>> >> >>>>>> >> >>>>>> Ammar Ali >> >>>>>> >> >>>>>> >> >>>>>> >> >>>>>> On Fri, Jan 16, 2015 at 3:47 PM, John alero <johnale...@gmail.com> >> >>>>>> wrote: >> >>>>>> >> >>>>>>> Dear Ammar, >> >>>>>>> >> >>>>>>> As per Kannel part you can send only 300 to 500 SMS in a second, >> if >> >>>>>>> you want to send 1000 SMS in a second use twice setup for the >> same >> >>>>>>> and >> >>>>>>> hardware case Kannel not require high configuration server. If you >> >>>>>>> have >> >>>>>>> used 4 GB RAM as well as 8 Core you will send the 300 to 500 TPS >> in >> >>>>>>> a >> >>>>>>> second. >> >>>>>>> >> >>>>>>> >> >>>>>>> >> >>>>>>> >> >>>>>>> >> >>>>>>> >> >>>>>>> On Fri, Jan 16, 2015 at 3:25 PM, Ammar Ali < >> ammarali3...@gmail.com> >> >>>>>>> wrote: >> >>>>>>> >> >>>>>>>> *Hi* *Willy Mularto,* >> >>>>>>>> >> >>>>>>>> I have so many confusion regarding this. So can you describe any >> >>>>>>>> particular hardware configuration for getting this sms traffic? >> >>>>>>>> >> >>>>>>>> >> >>>>>>>> Thanks in advance. >> >>>>>>>> >> >>>>>>>> >> >>>>>>>> Ammar Ali >> >>>>>>>> >> >>>>>>>> >> >>>>>>>> >> >>>>>>>> On Fri, Jan 16, 2015 at 2:20 PM, Murgor Bendon < >> >>>>>>>> bendonmur...@gmail.com> wrote: >> >>>>>>>> >> >>>>>>>>> Kannel can process upto 100,000 SMSes in a minute based on your >> >>>>>>>>> connection speed to the SMSC operator and your scripts. >> >>>>>>>>> Also it will depend on the allowed limit per second by the MNO. >> >>>>>>>>> >> >>>>>>>>> >> >>>>>>>>> >> >>>>>>>>> >> >>>>>>>>> Best Regards, >> >>>>>>>>> *Bendon Murgor *: Systems Engineer/IT Systems Auditor. >> >>>>>>>>> *Phone*: Kenya: +254-720529868 >> >>>>>>>>> Twitter: @bendonmurgor <http://twitter.com/bendonmurgor> >> >>>>>>>>> >> >>>>>>>>> On Fri, Jan 16, 2015 at 11:23 AM, MOSES KARIUKI < >> >>>>>>>>> kariuk...@gmail.com> wrote: >> >>>>>>>>> >> >>>>>>>>>> Hey Willy, >> >>>>>>>>>> >> >>>>>>>>>> Any entry level benchmark? >> >>>>>>>>>> >> >>>>>>>>>> >> >>>>>>>>>> >> >>>>>>>>>> On Fri, Jan 16, 2015 at 10:56 AM, Willy Mularto < >> >>>>>>>>>> sangpr...@gmail.com> wrote: >> >>>>>>>>>> >> >>>>>>>>>>> Server hardware configuration 1K message/second/SMSC? Simply >> buy >> >>>>>>>>>>> the highest configuration that your fund can buy :) >> >>>>>>>>>>> >> >>>>>>>>>>> On Fri, Jan 16, 2015 at 1:43 PM, Ammar Ali < >> >>>>>>>>>>> ammarali3...@gmail.com> wrote: >> >>>>>>>>>>> >> >>>>>>>>>>>> Hello, >> >>>>>>>>>>>> >> >>>>>>>>>>>> What will be minimum requirements for getting 1000 >> >>>>>>>>>>>> message/second transfered from kannel to particular smsc? >> What >> >>>>>>>>>>>> will be >> >>>>>>>>>>>> server hardware configuration? >> >>>>>>>>>>>> >> >>>>>>>>>>>> >> >>>>>>>>>>>> >> >>>>>>>>>>>> >> >>>>>>>>>>>> Ammar Ali >> >>>>>>>>>>>> FRAMP Technologies, >> >>>>>>>>>>>> Pune (Maharashtra) >> >>>>>>>>>>>> >> >>>>>>>>>>> >> >>>>>>>>>>> >> >>>>>>>>>> >> >>>>>>>>> >> >>>>>>>> >> >>>>>>> >> >>>>>> >> >>>> >> >>>> >> >>> >> >> >> > >> >> >> -- >> *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 >> > >
