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

Fri, 22 Jan 2016 01:26:41 -0800 

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 <[email protected] <mailto:[email protected]>> 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
    [email protected] <mailto:[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

Reply via email to