<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">
<tr>
<td style="width:105px;padding-top:15px">
<a href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail" target="_blank"><img 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 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>
</table><a href="#DDB4FAA8-2DD7-40BB-A1B8-4E2AA1F9FDF2" width="1" height="1"></a></div>