2015-12-07 14:03 GMT+03:00 Grant Vorenberg <gr...@saicomvoice.co.za>:
> [image: Saicom-now-offers-Cloud-PBX] > <https://branding.synaq.com/api/r/id/22451334/map/0> > Hi Guys > > I am a new to the list subscription and am looking for a little clarity on > the SQLBOX. > > I have a Debian Wheezy box running: > Kannel sqlbox version 1.4.4 > Libxml version 2.7.2 > MySQL 5.5.43 > > The front end is custom and drops message into the send_sms table. These > messages are terminated via smpp to another system of ours. We process and > clean out the sent_sms table. > > I gather stats on the performance of the system using the status page: > http://localhost:13000/status > > I am trying to understand the following output from the screen: > Box connections: > smsbox:sqlbox, IP 127.0.0.1 (2532 queued), (on-line 0d 2h 48m 19s) > This means there is a queue on sqlbox. Queue works like this: First sqlbox gets messages from DB backend, then it adds messages to own queue, then it sends message into bearerbox queue and bearerbox splits this queue over your connected SMSC/upstream operators. So if there is a huge queue on sqlbox it means there is a big amount of MTs in your send_sms table and sqlbox is still submitting those to bearerbox. To optimize sqlbox I'd recommend adding this parameter into sqlbox section (after group = sqlbox): limit-per-cycle = 50 this means sqlbox will get 50 bulk messages from DB per query at once instead of 1. > > What I noticed is when our send speeds start dipping on the smpp > connection (internal/default route), this smsbox:sql queue starts building > up. > > When the smsbox:sqlbox queue starts building up like this: > 1)What causes this? > 2) What does this signify? > > We generally don’t see this behaviour very often, but its effect is > detrimental to the performance of the system so I would like to know what > causes the growth and how to combat it so our send speed is safe-guarded. > > > Here is an excerpt from my config files: > > <smsbox conf>: > group = sqlbox > id = sqlbox-db > smsbox-id = sqlbox > #global-sender = "" > bearerbox-host = localhost > bearerbox-port = 13001 > smsbox-port = 13005 > smsbox-port-ssl = false > sql-log-table = sent_sms > sql-insert-table = send_sms > > > <kannel.conf>: > group = smsbox > bearerbox-host = 127.0.0.1 > sendsms-port = 13013 > global-sender = 13013 > smsbox-id=my_smsbox > > group=smsbox-route > smsbox-id=sqlbox > smsc-id=internal > > > Regards > > > > > > Grant Vorenberg > > Technical Manager > Office 0861 SAICOM (724 266) Direct 010 140 5012 Support 010 140 5050 > Cell - Fax 010 140 5001 Email gr...@saicomvoice.co.za Visit our website > www.saicomvoice.co.za > > [image: logo image] <http://www.saicomvoice.co.za> > >
