[OpenSIPS-Users] opensips: threshold exceeded : mysql prep stmt took too long

Aqs Younas aqsyounas at gmail.com
Thu Jan 21 11:05:15 CET 2016


Hi,

When my opensips recieve calls 50 calls with 5 cps i see my log file
flooded with below warning.

WARNING:db_mysql:log_expiry: threshold exceeded : mysql prep stmt took too
long - 99625 us.Source : insert into dialog
(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
,callee_ping_cseq,flags,vars,profiles,script_flags,module_flags,caller_route_set,callee_route_set,caller_contact,callee_contact
) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,
?,?,?,?,?,?,?,?,?,?,?)

./opensips -V
version: opensips 2.1.2 (x86_64/linux)

loadmodule "db_mysql.so"
modparam("db_mysql", "exec_query_threshold", 50000)

Any pointer in this regard would be much appreciated.

Best regards.

<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
This
email has been sent from a virus-free computer protected by Avast.
www.avast.com
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
<#DDB4FAA8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20160121/01f2ded5/attachment.htm>


More information about the Users mailing list