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
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
