[OpenSIPS-Users] db_mysql prep stmt took too long

Owais Ahmad millennium.bug at gmail.com
Thu Aug 18 15:46:15 CEST 2016


Hi all,

I am Currently using opensips 2.2.0 and have the following query threshold
set:

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

I am getting a lot of errors like the following even with a handful of
incoming SIP messages.

WARNING:db_mysql:log_expiry: threshold exceeded : mysql prep stmt took too
 long - 61625 us.Source

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.

Has anyone else experienced the same?
Any ideas to have this fixed?

Regards,
Owais
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20160818/6e44d067/attachment.htm>


More information about the Users mailing list