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

[Mickael HUBERT]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20130308/0b17f983/attachment.htm>