Hi Owais,
It myght be something specific to your mysql setup - at least there is
nothing you can do from the OpenSIPS side. Still keep it mind that your
get the warning when preparing the statement - this is a bit of a
special DB action (it is not an actual query).
Regards,
Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
http://www.opensips-solutions.com
On 18.08.2016 16:46, Owais Ahmad wrote:
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
_______________________________________________
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
