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
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
_______________________________________________
Users mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
