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
>>>
>>
>>
