<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>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.<br>
<br>
Regards,<br>
</tt>
<pre class="moz-signature" cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a class="moz-txt-link-freetext" href="http://www.opensips-solutions.com">http://www.opensips-solutions.com</a></pre>
<br>
On 12/10/2012 08:53 PM, Adam Raszynski wrote:
<blockquote
cite="mid:CAJWEF2YovLG6Y4CkBLWTOX4kDTr0DWWS8=WGiQ0kJCrYsn1T-Q@mail.gmail.com"
type="cite">MySQL server is running all the time. I think that
while making backups tables are blocked by LOCK TABLES statement
<div><br>
<br>
<div class="gmail_quote">2012/12/10 Bogdan-Andrei Iancu <span
dir="ltr"><<a moz-do-not-send="true"
href="mailto:bogdan@opensips.org" target="_blank">bogdan@opensips.org</a>></span><br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt
0.8ex; border-left: 1px solid rgb(204, 204, 204);
padding-left: 1ex;">
<div bgcolor="#ffffff" text="#000000"> <tt>Hi Adam,<br>
<br>
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 ?<br>
<br>
Or the DB disconnescts opensips's connections ?<br>
<br>
You mentioned both, locking up and reconnect :)<br>
<br>
Regards,<br>
</tt>
<pre cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a moz-do-not-send="true" href="http://www.opensips-solutions.com" target="_blank">http://www.opensips-solutions.com</a></pre>
<div>
<div class="h5"> <br>
On 12/10/2012 05:00 PM, Adam Raszynski wrote: </div>
</div>
<blockquote type="cite">
<div>
<div class="h5">Hi
<div><br>
</div>
<div>Tried versions: 1.7.2 and 1.8</div>
<div><br>
</div>
<div>I have problem with OpenSIPS taking 100% CPU
while trying to reconnect on MySQL connection
lost.</div>
<div><br>
</div>
<div>I make database backups every night and then
for about 15 minutes database is locked during
backup procedure to prevent data corruption.</div>
<div><br>
</div>
<div>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?</div>
<div><br>
</div>
<div>Regards</div>
</div>
</div>
<pre><fieldset></fieldset>
_______________________________________________
Users mailing list
<a moz-do-not-send="true" href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a>
<a moz-do-not-send="true" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
</div>
</blockquote>
</div>
<br>
</div>
</blockquote>
</body>
</html>