<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<tt>Perfect !</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>
<div class="moz-cite-prefix">On 21.01.2016 21:19, Aqs Younas wrote:<br>
</div>
<blockquote
cite="mid:CAGVOjVVTj_X4JwLt8YAX+nMC1iu1GLggpXsD6m-fzk40On+WMA@mail.gmail.com"
type="cite">
<div dir="ltr">Thanks. After applying indexing on dialog table
problem was resolved. <br>
</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>
<div class="gmail_extra"><br>
<div class="gmail_quote">On 21 January 2016 at 17:57,
Bogdan-Andrei Iancu <span dir="ltr"><<a
moz-do-not-send="true" href="mailto:bogdan@opensips.org"
target="_blank"><a class="moz-txt-link-abbreviated" href="mailto:bogdan@opensips.org">bogdan@opensips.org</a></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"> <tt>Hi,<br>
<br>
That is report saying your insert took longer than the
threshold you set :<br>
<a moz-do-not-send="true"
href="http://www.opensips.org/html/docs/modules/2.1.x/db_mysql.html#id248002"
target="_blank">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 cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a moz-do-not-send="true" href="http://www.opensips-solutions.com" target="_blank">http://www.opensips-solutions.com</a></pre>
<div>
<div class="h5">
<div>On 21.01.2016 12:05, Aqs Younas wrote:<br>
</div>
</div>
</div>
<blockquote type="cite">
<div>
<div class="h5">
<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>
<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;min-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"
style="color:#4453ea" target="_blank">www.avast.com</a>
</td>
</tr>
</tbody>
</table>
</div>
<br>
<fieldset></fieldset>
<br>
</div>
</div>
<pre>_______________________________________________
Users mailing list
<a moz-do-not-send="true" href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a>
<a moz-do-not-send="true" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
<br>
</div>
</blockquote>
</div>
<br>
</div>
</blockquote>
<br>
</body>
</html>