Re: [OpenSIPS-Users] db_mysql prep stmt took too long

2016-08-19 Thread Bogdan-Andrei Iancu 

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", 5)

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
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users


___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

[OpenSIPS-Users] db_mysql prep stmt took too long

2016-08-18 Thread Owais Ahmad 
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", 5)

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
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users