Excellent advise from Rene. One more thing i used to face with that is mysql performance. By mysql default of configuration, the sqlbox can serve only 30-40 messages per seconds. After changing some mysql parameters, it can reach 300 - 400 MPS.
Lamnt. From: rene.klu...@chimit.nl To: alok...@gmail.com; users@kannel.org Subject: RE: kannel responding very slow when submit 5000 or more sms to kannel via sqlbox Date: Fri, 26 Sep 2014 13:25:12 +0200 Sqlbox submits messages to bearerbox very fast.So upon submitting that many messages, bearerbox has problems delivering all of those to your smsc. It becomes your bottleneck, because your smsc queue will grow fast.So try to fix (increase) the throughput of bearerbox to your smsc. If you search the mailinglist, you will find some pointers. If you don’t succeed in that, a workaround is to submit your messages in batches to sqlbox. For instance, let’s say, insert 500 at a time. And after most of them are sent, insert the next batch. == Rene From: users [mailto:users-boun...@kannel.org] On Behalf Of Alok Srivastava Sent: vrijdag 26 september 2014 6:53 To: users@kannel.org Subject: kannel responding very slow when submit 5000 or more sms to kannel via sqlbox dear listwhen i submit thousand of sms or more to send_sms table simultaneously, kannel becomes very slow, most of the time sms stuck into queue plz help, how should i tune my mysql or kannel...................i am using sqlbox with kannel. thanksAbhi