[OpenSIPS-Users] crash opensis when mysql backend is slow

[Bogdan-Andrei Iancu]

See that the flatstore module has its own "rotate" function via MI - 
this will simplify things for you.

Regards,

Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
http://www.opensips-solutions.com


On 03/08/2013 05:19 PM, Mickael HUBERT wrote:
> Thanks,
> it's good solution.
>
> My billing solution collect acc table each one hour. I will write 
> other script to puch flatstore's file in acc DB each one hour or other 
> frequencies.
> In "harmony" with billing team ;)
>
> bye
>
>
> Le 08/03/2013 15:47, Bogdan-Andrei Iancu a écrit :
>> Hi Mickael,
>>
>> Use the db_flatstore engine for acc (as SQL backend) to write Acc 
>> data on files on disk. You can later import this files into DB 
>> without affecting or slowing down opensips.
>>
>> Regards,
>> Bogdan-Andrei Iancu
>> OpenSIPS Founder and Developer
>> http://www.opensips-solutions.com
>>
>> On 03/08/2013 02:39 PM, Mickael HUBERT wrote:
>>> Hi list,
>>> I have a issue when my backend mysql (to acc's table) is slow (it's 
>>> mysql server shared between differents services).
>>> Endeed Opensips slowed too to SIP processing or if mysql crash, 
>>> Opensips crash too.
>>> My Acc's table is the only realtime table.
>>>
>>> Is there any method to improve this ? Opensips cache's service ? 
>>> external services ?
>>>
>>> my db_mysql's module conf:
>>>
>>> /# ----------------- module db_mysql ---------------//
>>> //loadmodule "db_mysql.so"//
>>> //# ----- db_mysql params -----//
>>> //modparam("db_mysql", "ping_interval", 60)//
>>> //modparam("db_mysql", "timeout_interval", 2)/
>>>
>>> my acc's module conf:
>>>
>>> /# ----------------- module acc ---------------//
>>> //loadmodule "acc.so"//
>>> //# ----- acc params -----//
>>> //modparam("acc", "early_media", 1)//
>>> //modparam("acc", "report_cancels", 1)//
>>> //modparam("acc", "detect_direction", 0)//
>>> //modparam("acc", "failed_transaction_flag", '3')//
>>> //modparam("acc", "log_flag", '1')//
>>> //modparam("acc", "log_missed_flag", '2')//
>>> //modparam("acc", "db_flag", '1')//
>>> //modparam("acc", "db_missed_flag", '2')//
>>> //modparam("acc", "db_url", 
>>> "mysql://u_opensips:*****@*****/hexasipbeta")//
>>> //modparam("acc", "db_extra", "caller_id=$fu; callee_id=$rU; 
>>> source_ip=$avp(sourceip); ai=$avp(userai); pu=$pU; 
>>> provider_id=$avp(providerid); reason=$avp(reason); display_name=$fn")//
>>> //modparam("acc", "log_facility", "LOG_LOCAL1")/
>>>
>>>
>>>
>>> thanks in advance
>>>
>>> Mickael
>>>
>>>
>>> _______________________________________________
>>> Users mailing list
>>> Users at lists.opensips.org
>>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20130308/de8ce299/attachment.htm>