Use in-memory database Redis instead of MySQL. -- С уважением, Денис Давыдов
2017-12-15 10:05 GMT+03:00 Robin C <[email protected]>: > 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 >
