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

[Mickael HUBERT]

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/3346fd76/attachment.htm>