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

[Bogdan-Andrei Iancu]

Hi,

That is report saying your insert took longer than the threshold you set :
http://www.opensips.org/html/docs/modules/2.1.x/db_mysql.html#id248002

Maybe your DB is slow on inserts.

Regards,

Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
http://www.opensips-solutions.com

On 21.01.2016 12:05, Aqs Younas wrote:
> 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> 
>
>
>
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20160121/23de3e56/attachment-0001.htm>