Discussion:
Queue in Store
Robin C
2017-12-15 07:05:55 UTC
Permalink
Dear Team,

When we send large volume of sms the queue is building up in the store. And
it process very slowly. Only getting 16 tps. Can anyone help me to solve
this issue.?

Please find the version and configuration file below:

Kannel bearerbox version `1.4.4'. Build `Feb 10 2017 19:38:03', compiler
`4.4.7 20120313 (Red Hat 4.4.7-17)'. System Linux, release
2.6.32-696.1.1.el6.x86_64, version #1 SMP Tue Apr 11 17:13:24 UTC 2017,
machine x86_64. Hostname CentOS-67-64-minimal, .Libxml version 2.7.6. Using
OpenSSL 1.0.1e-fips 11 Feb 2013. Compiled with MySQL 5.7.17, using MySQL
5.7.18. Using native malloc.

Find my configuration below:

main conf
-------------

group = core
admin-port = 11002
admin-password = passwd
status-password = passwd
smsbox-port = 12002
store-type = spool
store-location = /kannel_spool/spool2/
log-file = /var/log/bearerbox_log.log
dlr-storage = mysql
log-level = 4
access-log = /var/log/bearerbox_log.access

group = smsbox
smsbox-id = smsbox
bearerbox-host = localhost
bearerbox-port = 13002
sendsms-port = 14002
log-level = 4
access-log = /var/log/smbx2.access

group = smsc
smsc = smpp
smsc-id = mysmsc
host = "21.x.x.x"
port = "1234"
transceiver-mode = 1
smsc-username = "username"
smsc-password = "Passwd"
source-addr-ton = 5
source-addr-npi = 0
dest-addr-ton = 1
dest-addr-npi = 1
system-type = smpp11
allowed-smsc-id = mysmsc
throughput = 150

group = mysql-connection
id = mydlr
host = localhost
username = root
password = password
database = sms_dlr
max-connections = 1

group = dlr-db
id = mydlr
table = dlr_smsc
field-smsc = smsc
field-timestamp = ts
field-destination = destination
field-source = source
field-service = service
field-url = url
field-mask = mask
field-status = status
field-boxc-id = boxc


group = sendsms-user
username = uname
password = paswd
max-messages = 10
concatenation = true


Sqlbox conf:
---------------

group = sqlbox
id = sqlbox-db
smsbox-id = smsboxid
bearerbox-port = 12002
smsbox-port = 13002
smsbox-port-ssl = false
sql-log-table = sent_log
sql-insert-table = send_log
log-file = "/var/log/sqlbx2.log"
log-level = 4

group = mysql-connection
id = sqlbox-db
host = localhost
port = 3306
username = root
password = paswd
database = sqlbox
max-connections = 10
--
Disclaimer: This message contains confidential information and is intended
only for the individual named. If you are not the named addressee you
should not disseminate, distribute or copy this e-mail. Please notify the
sender immediately by e-mail if you have received this e-mail by mistake
and delete this e-mail from your system. E-mail transmission cannot be
guaranteed to be secure or error-free as information could be intercepted,
corrupted, lost, destroyed, arrive late or incomplete, or contain
viruses. The sender therefore does not accept liability for any errors or
omissions in the contents of this message, which arise as a result of
e-mail transmission. If verification is required please request a
hard-copy version.

*7* Switch off as you go |*q *Recycle always | P Print only if absolutely
necessary
Денис Давыдов
2017-12-15 13:21:05 UTC
Permalink
Use in-memory database Redis instead of MySQL.

--
С уважеМОеЌ,
ДеМОс ДавыЎПв
Post by Robin C
Dear Team,
When we send large volume of sms the queue is building up in the store.
And it process very slowly. Only getting 16 tps. Can anyone help me to
solve this issue.?
Kannel bearerbox version `1.4.4'. Build `Feb 10 2017 19:38:03', compiler
`4.4.7 20120313 (Red Hat 4.4.7-17)'. System Linux, release
2.6.32-696.1.1.el6.x86_64, version #1 SMP Tue Apr 11 17:13:24 UTC 2017,
machine x86_64. Hostname CentOS-67-64-minimal, .Libxml version 2.7.6. Using
OpenSSL 1.0.1e-fips 11 Feb 2013. Compiled with MySQL 5.7.17, using MySQL
5.7.18. Using native malloc.
main conf
-------------
group = core
admin-port = 11002
admin-password = passwd
status-password = passwd
smsbox-port = 12002
store-type = spool
store-location = /kannel_spool/spool2/
log-file = /var/log/bearerbox_log.log
dlr-storage = mysql
log-level = 4
access-log = /var/log/bearerbox_log.access
group = smsbox
smsbox-id = smsbox
bearerbox-host = localhost
bearerbox-port = 13002
sendsms-port = 14002
log-level = 4
access-log = /var/log/smbx2.access
group = smsc
smsc = smpp
smsc-id = mysmsc
host = "21.x.x.x"
port = "1234"
transceiver-mode = 1
smsc-username = "username"
smsc-password = "Passwd"
source-addr-ton = 5
source-addr-npi = 0
dest-addr-ton = 1
dest-addr-npi = 1
system-type = smpp11
allowed-smsc-id = mysmsc
throughput = 150
group = mysql-connection
id = mydlr
host = localhost
username = root
password = password
database = sms_dlr
max-connections = 1
group = dlr-db
id = mydlr
table = dlr_smsc
field-smsc = smsc
field-timestamp = ts
field-destination = destination
field-source = source
field-service = service
field-url = url
field-mask = mask
field-status = status
field-boxc-id = boxc
group = sendsms-user
username = uname
password = paswd
max-messages = 10
concatenation = true
---------------
group = sqlbox
id = sqlbox-db
smsbox-id = smsboxid
bearerbox-port = 12002
smsbox-port = 13002
smsbox-port-ssl = false
sql-log-table = sent_log
sql-insert-table = send_log
log-file = "/var/log/sqlbx2.log"
log-level = 4
group = mysql-connection
id = sqlbox-db
host = localhost
port = 3306
username = root
password = paswd
database = sqlbox
max-connections = 10
--
Disclaimer: This message contains confidential information and is
intended only for the individual named. If you are not the named addressee
you should not disseminate, distribute or copy this e-mail. Please notify
the sender immediately by e-mail if you have received this e-mail by
mistake and delete this e-mail from your system. E-mail transmission
cannot be guaranteed to be secure or error-free as information could be
intercepted, corrupted, lost, destroyed, arrive late or incomplete, or
contain viruses. The sender therefore does not accept liability for any
errors or omissions in the contents of this message, which arise as a
result of e-mail transmission. If verification is required please request
a hard-copy version.
*7* Switch off as you go |*q *Recycle always | P Print only if absolutely
necessary
Loading...