<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>Hi Mickael,<br>
<br>
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.<br>
<br>
Regards,</tt><br>
<pre class="moz-signature" cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a class="moz-txt-link-freetext" href="http://www.opensips-solutions.com">http://www.opensips-solutions.com</a></pre>
<br>
On 03/08/2013 02:39 PM, Mickael HUBERT wrote:
<blockquote cite="mid:5139DC1B.3020208@winlux.fr" type="cite">
<meta http-equiv="content-type" content="text/html;
charset=ISO-8859-1">
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>
<pre wrap="">
<fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
Users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
</body>
</html>