<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-1">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Hi list,<br>
I have a issue when my backend mysql (to acc's table) is slow (it's
mysql server shared between differents services).<br>
Endeed Opensips slowed too to SIP processing or if mysql crash,
Opensips crash too.<br>
My Acc's table is the only realtime table.<br>
<br>
Is there any method to improve this ? Opensips cache's service ?
external services ?<br>
<br>
my db_mysql's module conf:<br>
<br>
<i># ----------------- module db_mysql ---------------</i><i><br>
</i><i>loadmodule "db_mysql.so"</i><i><br>
</i><i># ----- db_mysql params -----</i><i><br>
</i><i>modparam("db_mysql", "ping_interval", 60)</i><i><br>
</i><i>modparam("db_mysql", "timeout_interval", 2)</i><br>
<br>
my acc's module conf:<br>
<br>
<i># ----------------- module acc ---------------</i><i><br>
</i><i>loadmodule "acc.so"</i><i><br>
</i><i># ----- acc params -----</i><i><br>
</i><i>modparam("acc", "early_media", 1)</i><i><br>
</i><i>modparam("acc", "report_cancels", 1)</i><i><br>
</i><i>modparam("acc", "detect_direction", 0)</i><i><br>
</i><i>modparam("acc", "failed_transaction_flag", '3')</i><i><br>
</i><i>modparam("acc", "log_flag", '1')</i><i><br>
</i><i>modparam("acc", "log_missed_flag", '2')</i><i><br>
</i><i>modparam("acc", "db_flag", '1')</i><i><br>
</i><i>modparam("acc", "db_missed_flag", '2')</i><i><br>
</i><i>modparam("acc", "db_url",
"mysql://u_opensips:*****@*****/hexasipbeta")</i><i><br>
</i><i>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")</i><i><br>
</i><i>modparam("acc", "log_facility", "LOG_LOCAL1")</i><br>
<br>
<br>
<br>
thanks in advance<br>
<br>
Mickael<br>
</body>
</html>