<div dir="ltr"><div>Hi Daniel,<br><br>thanks for the explanation and blog post. However, this is a different approach than the asynchronous sqlops function, right? In sqlops, the request is sent to an asynchronous worker in Kamailio and does the SQL operation when possible. In acc, only the request is a different one. And if the MySQL server really has a problem, it can happen that it doesn't return from the an INSERT DELAYED query immediately. If the MySQL query is not detached from the SIP worker, the problem of a blocking SIP proxy is still there. Is it possible to use the asynchronous worker for the acc requests, too?<br><br></div>Best Regards,<br>Sebastian<br><div><div class="gmail_extra"><br><div class="gmail_quote">On Tue, Oct 21, 2014 at 4:21 PM, Daniel-Constantin Mierla <span dir="ltr"><<a href="mailto:miconda@gmail.com" target="_blank">miconda@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000">
Hello,<br>
<br>
it is possible, with same limitation that the database connector
module needs to support async operation -- see db_insert_mode
parameter for acc module.<br>
<br>
And because was asked, I added it to the blogs list as well:<br>
-
<a href="http://by-miconda.blogspot.de/2014/10/kamailio-42-tips-8-asynchronous.html" target="_blank">http://by-miconda.blogspot.de/2014/10/kamailio-42-tips-8-asynchronous.html</a><br>
<br>
Cheers,<br>
Daniel<div><div class="h5"><br>
<br>
<div>On 21/10/14 11:06, Sebastian Damm
wrote:<br>
</div>
</div></div><blockquote type="cite"><div><div class="h5">
<div dir="ltr">
<div>
<div>
<div>Hi,<br>
<br>
</div>
I read the article about asynchronous sqlops:<br>
<a href="http://by-miconda.blogspot.de/2014/10/kamailio-42-tips-4-asynchronous-sql.html" target="_blank">http://by-miconda.blogspot.de/2014/10/kamailio-42-tips-4-asynchronous-sql.html</a><br>
<br>
</div>
I was wondering whether there are any plans of bringing that
feature to the acc module, too. We have seen it in the past
that a blocking database server brought our proxy to a halt
because the acc module was blocking, too. So this could help a
lot if the acc entries were written asynchronously.<br>
<br>
</div>
Best Regards,<br>
Sebastian<br>
</div>
<br>
<fieldset></fieldset>
<br>
</div></div><pre>_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
<a href="mailto:sr-users@lists.sip-router.org" target="_blank">sr-users@lists.sip-router.org</a>
<a href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users" target="_blank">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a><span class="HOEnZb"><font color="#888888">
</font></span></pre><span class="HOEnZb"><font color="#888888">
</font></span></blockquote><span class="HOEnZb"><font color="#888888">
<br>
<pre cols="72">--
Daniel-Constantin Mierla
<a href="http://twitter.com/#!/miconda" target="_blank">http://twitter.com/#!/miconda</a> - <a href="http://www.linkedin.com/in/miconda" target="_blank">http://www.linkedin.com/in/miconda</a></pre>
</font></span></div>
<br>_______________________________________________<br>
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list<br>
<a href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a><br>
<a href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users" target="_blank">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a><br>
<br></blockquote></div><br></div></div></div>