Hi,
This is my kannel monitor log:
Kannel bearerbox version `1.4.4'. Build `Dec 3 2014 00:06:03', compiler
`4.4.7 20120313 (Red Hat 4.4.7-3)'. System Linux, release
2.6.18-028stab107.1, version #1 SMP Wed Apr 17 19:10:55 MSD 2013, machine
x86_64. Hostname ip-166-62-16-78.ip.secureserver.net, IP 166.62.16.78.
Libxml version 2.7.6. Using OpenSSL 1.0.0-fips 29 Mar 2010. Compiled with
MySQL 5.5.40, using MySQL 5.5.40. Using native malloc.
Status: running, uptime 0d 0h 8m 0s
WDP: received 0 (0 queued), sent 0 (0 queued)
SMS: received 0 (0 queued), sent 16650 (0 queued), store size -1
SMS: inbound (0.00,0.00,0.00) msg/sec, outbound (135.08,0.00,34.69) msg/sec
DLR: received 33300, sent 0
DLR: inbound (270.16,0.00,69.38) msg/sec, outbound (0.00,0.00,0.00) msg/sec
DLR: 13350 queued, using internal storage
Box connections:
smsbox:mysmsbox, IP 127.0.0.1 (0 queued), (on-line 0d 0h 7m 3s)
smsbox:mysqlbox, IP 127.0.0.1 (4491 queued), (on-line 0d 0h 4m 55s)
smsbox:mysqlbox1, IP 127.0.0.1 (4247 queued), (on-line 0d 0h 4m 42s)
smsbox:mysqlbox2, IP 127.0.0.1 (4678 queued), (on-line 0d 0h 4m 1s)
smsbox:mysqlbox3, IP 127.0.0.1 (3333 queued), (on-line 0d 0h 3m 44s)
smsbox:mysqlbox4, IP 127.0.0.1 (4185 queued), (on-line 0d 0h 3m 28s)
SMSC connections:
*mysmsc1*[mysmsc1] FAKE:10001 (online 368s, rcvd: sms 0
(0.00,0.00,0.00) / dlr 33300 (270.16,0.00,69.38), sent: sms 16650
(135.08,0.00,34.69) / dlr 0 (0.00,0.00,0.00), failed 0, queued 13350 msgs)
*mysmsc2*[mysmsc2] FAKE:10002 (connecting, rcvd: sms 0
(0.00,0.00,0.00) / dlr 0 (0.00,0.00,0.00), sent: sms 0 (0.00,0.00,0.00) /
dlr 0 (0.00,0.00,0.00), failed 0, queued 0 msgs)
*mysmsc3*[mysmsc3] FAKE:10003 (online 346s, rcvd: sms 0
(0.00,0.00,0.00) / dlr 0 (0.00,0.00,0.00), sent: sms 0 (0.00,0.00,0.00) /
dlr 0 (0.00,0.00,0.00), failed 0, queued 0 msgs)
*mysmsc4*[mysmsc4] FAKE:10004 (connecting, rcvd: sms 0
(0.00,0.00,0.00) / dlr 0 (0.00,0.00,0.00), sent: sms 0 (0.00,0.00,0.00) /
dlr 0 (0.00,0.00,0.00), failed 0, queued 0 msgs)
So please explain this is detail. What is the actual speed of message
sending?
Thanks
Aditya Khanna
On Fri, Dec 12, 2014 at 7:22 PM, Alvaro Cornejo <cornejo.alv...@gmail.com>
wrote:
>
> Hi
>
> That might be related to:
> - sqlbox - Here you have changed throughput from 10 to 100 so I don't
> think is the cause
> - mysql - You should optimize db parameters. Check on DB forums how to do
> it. Maybe too many connections? threads maxed out? assigned memory maxed
> out? search for optimizing/diagnostic tools for mysql.
> - hardware - Check you have enough memory and CPU is not maxed out
>
> Regards
>
> Alvaro
>
>
> |-----------------------------------------------------------------------------------------------------------------|
> Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier
> celular y Nextel
> en el Perú, México y en mas de 180 paises. Use aplicaciones 2 vias via SMS
> y GPRS online
> Visitenos en www.perusms.com
>
> On Fri, Dec 12, 2014 at 4:10 AM, Aditya Khanna <
> aditya.khanna111...@gmail.com> wrote:
>>
>> Hi,
>>
>> When I'm inserting messages into multiple sqlbox send_sms tables. Mysql
>> copies send_sms data into sent_sms table is too slow (10-20 records per
>> sec. approx.)
>>
>> So, please suggest me that how to increase this speed.
>>
>>
>>
>> Thanks,
>> Aditya Khanna
>>
>>
>>
>>
>>
>>
>> On Thu, Dec 11, 2014 at 8:28 PM, Alvaro Cornejo <cornejo.alv...@gmail.com
>> > wrote:
>>>
>>> Hi
>>>
>>> Specify where does you find the speed to be slow.
>>>
>>> Depending on where it is the solution would be different. Nevertheless,
>>> there might be multiple adjustments to be done.
>>>
>>> - hadrware cpu/memory issue
>>> - mysql configuration/optimization
>>> - network bandwidth/congestion issue
>>> - smsc configuration/contract limit/window size
>>> - kannel cconfiguration
>>> - etc etc
>>>
>>> Regards
>>>
>>> Alvaro
>>>
>>>
>>> |-----------------------------------------------------------------------------------------------------------------|
>>> Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier
>>> celular y Nextel
>>> en el Perú, México y en mas de 180 paises. Use aplicaciones 2 vias via
>>> SMS y GPRS online
>>> Visitenos en www.perusms.com
>>>
>>> On Thu, Dec 11, 2014 at 9:32 AM, Aditya Khanna <
>>> aditya.khanna111...@gmail.com> wrote:
>>>
>>>> Hello Everyone,
>>>>
>>>> I'm facing a serious problem regarding speed of sending bulk message.
>>>>
>>>> Currently, I have configured multiple SQLBoxes (10 Approx) and inserts
>>>> message into separate insert *send_sms* table. but I'm not getting
>>>> speed of sending message.
>>>>
>>>> *HTTP<==>Multiple SQLBoxes<==> BearerBox<==>Fake SMSC*
>>>>
>>>> I'm also increase the value of limit (0,1) to (0,100) in
>>>> *sqlbox_mysql.h*
>>>>
>>>> But I'm not getting speed of sending message too.
>>>>
>>>>
>>>> So, Please suggest me that how to resolve this problem.
>>>>
>>>>
>>>> Thanks,
>>>> Aditya Khanna
>>>>
>>>
>>>
