[OpenSIPS-Users] opensips: threshold exceeded : mysql prep stmt took too long

[Bogdan-Andrei Iancu]

Perfect !

Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
http://www.opensips-solutions.com

On 21.01.2016 21:19, Aqs Younas wrote:
> Thanks. After applying indexing on dialog table problem was resolved.
> <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> 
>
>
>
> On 21 January 2016 at 17:57, Bogdan-Andrei Iancu <bogdan at opensips.org 
> <mailto:bogdan at opensips.org>> wrote:
>
>     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
>>     Users at lists.opensips.org <mailto: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/20160122/0cd6b411/attachment.htm>