<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<tt>Hi,<br>
<br>
That is report saying your insert took longer than the threshold
you set :<br>
<a class="moz-txt-link-freetext" href="http://www.opensips.org/html/docs/modules/2.1.x/db_mysql.html#id248002">http://www.opensips.org/html/docs/modules/2.1.x/db_mysql.html#id248002</a><br>
<br>
Maybe your DB is slow on inserts.<br>
<br>
Regards,<br>
</tt>
<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>
<div class="moz-cite-prefix">On 21.01.2016 12:05, Aqs Younas wrote:<br>
</div>
<blockquote
cite="mid:CAGVOjVW9H42X37CBou1+fo5YaexQN0osbthhKF6AMvPFFnw2MA@mail.gmail.com"
type="cite">
<div dir="ltr">
<div>Hi, <br>
<br>
</div>
<div>When my opensips recieve calls 50 calls with 5 cps i see my
log file flooded with below warning. <br>
<br>
WARNING:db_mysql:log_expiry: threshold exceeded : mysql prep
stmt took too long - 99625 us.Source : insert into dialog<br>
(dlg_id,callid,from_uri,from_tag,to_uri,to_tag,caller_sock,callee_sock,start_time,mangled_from_uri,mangled_to_uri,state,timeout,caller_cseq,callee_cseq,caller_ping_cseq<br>
,callee_ping_cseq,flags,vars,profiles,script_flags,module_flags,caller_route_set,callee_route_set,caller_contact,callee_contact
) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,<br>
?,?,?,?,?,?,?,?,?,?,?)<br>
<br>
./opensips -V<br>
version: opensips 2.1.2 (x86_64/linux)<br>
<br>
</div>
<div>loadmodule "db_mysql.so"<br>
modparam("db_mysql", "exec_query_threshold", 50000)<br>
</div>
<div><br>
Any pointer in this regard would be much appreciated. <br>
<br>
</div>
<div>Best regards. <br>
</div>
<div><br>
</div>
</div>
<div id="DDB4FAA8-2DD7-40BB-A1B8-4E2AA1F9FDF2">
<table style="border-top:1px solid #aaabb6;margin-top:30px">
<tbody>
<tr>
<td style="width:105px;padding-top:15px"> <a
moz-do-not-send="true"
href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail"
target="_blank"><img moz-do-not-send="true"
src="https://ipmcdn.avast.com/images/logo-avast-v1.png"
style="width: 90px; height:33px;"></a> </td>
<td
style="width:470px;padding-top:20px;color:#41424e;font-size:13px;font-family:Arial,Helvetica,sans-serif;line-height:18px">This
email has been sent from a virus-free computer protected
by Avast. <br>
<a moz-do-not-send="true"
href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail"
target="_blank" style="color:#4453ea">www.avast.com</a>
</td>
</tr>
</tbody>
</table>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
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>
<br>
</body>
</html>