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