<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<tt>Hi Owais,<br>
<br>
It myght be something specific to your mysql setup - at least
there is nothing you can do from the OpenSIPS side. Still keep it
mind that your get the warning when preparing the statement - this
is a bit of a special DB action (it is not an actual query).<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 18.08.2016 16:46, Owais Ahmad wrote:<br>
</div>
<blockquote
cite="mid:CAArAGK=SNR674SYbaUkvNDSxtvqLRnsEfxD2o6sTDtsPS8CRtw@mail.gmail.com"
type="cite">
<div dir="ltr">
<div class="gmail_default" style="font-family:trebuchet
ms,sans-serif">Hi all,<br>
</div>
<div class="gmail_default" style="font-family:trebuchet
ms,sans-serif"><br>
I am Currently using opensips 2.2.0 and have the following
query threshold set:<br>
<span style="font-family:monospace,monospace"><br>
</span>
<div class="gmail_default" style="font-family:trebuchet
ms,sans-serif"><span style="font-family:monospace,monospace">loadmodule
"db_mysql.so"<br>
modparam("db_mysql", "exec_query_threshold", 50000)</span></div>
</div>
<div class="gmail_default" style="font-family:trebuchet
ms,sans-serif"><br>
I am getting a lot of errors like the following even with a
handful of incoming SIP messages. <br>
<br>
<span style="font-family:monospace,monospace">WARNING:db_mysql:log_expiry:
threshold exceeded : mysql prep stmt took too<br>
long - 61625 us.Source<br>
</span><br>
</div>
<div class="gmail_default" style="font-family:trebuchet
ms,sans-serif">The database exists on the same host as
opensips itself. The DB engine is InnoDB and its optimized
because all external queries to the same table / database
return instantly.<br>
</div>
<div class="gmail_default" style="font-family:trebuchet
ms,sans-serif"><br>
</div>
<div class="gmail_default" style="font-family:trebuchet
ms,sans-serif">Has anyone else experienced the same? <br>
</div>
<div class="gmail_default" style="font-family:trebuchet
ms,sans-serif">Any ideas to have this fixed?<br>
<br>
</div>
<div class="gmail_default" style="font-family:trebuchet
ms,sans-serif">Regards,<br>
</div>
<div class="gmail_default" style="font-family:trebuchet
ms,sans-serif">Owais<br>
</div>
</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>