And what are the king of errors/warnings/logs (if any) from the db_mysql module when trying to do quires (while table is locked) - just to see how opensips "sees" the DB.

Regards,

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


On 12/10/2012 08:53 PM, Adam Raszynski wrote:
MySQL server is running all the time. I think that while making backups tables are blocked by LOCK TABLES statement


2012/12/10 Bogdan-Andrei Iancu <[email protected] <mailto:[email protected]>>

    Hi Adam,

    What exactly is the "experience" of OpenSIPs in regards to DB? DB
    simply blocks, so whatever query is pushed to DB, opensips will
    block in waiting ?

    Or the DB disconnescts opensips's connections ?

    You mentioned both, locking up and reconnect :)

    Regards,

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


    On 12/10/2012 05:00 PM, Adam Raszynski wrote:
    Hi

    Tried versions: 1.7.2 and 1.8

    I have problem with OpenSIPS taking 100% CPU while trying to
    reconnect on MySQL connection lost.

    I make database backups every night and then for about 15 minutes
    database is locked during backup procedure to prevent data
    corruption.

    I understand that OpenSIPS is trying to do it's best to reconnect
    to database, but how to decrease reconnect interval or make it
    less CPU intensive?

    Regards


    _______________________________________________
    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