[OpenSIPS-Users] db_mysql prep stmt took too long

Bogdan-Andrei Iancu bogdan at opensips.org
Fri Aug 19 18:32:00 CEST 2016


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
> 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/20160819/0f95e461/attachment.htm>


More information about the Users mailing list