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

[Bogdan-Andrei Iancu]

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/060238b3/attachment.htm>