<!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">
MURALI V escribió:
<blockquote
cite="mid:8eeaf23a0909040852h97c91c7p43f5ad366598c7a6@mail.gmail.com"
type="cite">
<div>Hi All,</div>
<div> </div>
<div> </div>
<div> I am using asterisk-1.4.22 with mysql as my storage medium
for voice messages.Right now i am running 700+ extensions with this
setup .</div>
<div> </div>
<div><strong>System Configuration:</strong></div>
<div> </div>
<div>asterisk-1.4.22.1</div>
<div>(using odbc storage for voice messages)</div>
<div> </div>
<div>unixODBC-2.2.11-7.1<br>
mysql-connector-odbc-3.51.12-2.2<br>
mysql-server-5.0.45-7.el5<br>
CentOS-5.2 (64 bit)</div>
<div> </div>
<div> </div>
<div><strong>The following are the issues i am facing:</strong></div>
<div> </div>
<div> 1) CPU time always shows 30%-90% for mysql when asterisk
is running . The CPU time goes normal for mysql when asterisk is
stopped. <br>
</div>
</blockquote>
Obviously the MySQL CPU time droppes to near zero if the only process
who uses it stops! Check what kind of queries asterisk is making and if
that can be optimized.<br>
<blockquote
cite="mid:8eeaf23a0909040852h97c91c7p43f5ad366598c7a6@mail.gmail.com"
type="cite">
<div> </div>
<div> 2) calls are getting dropped suddenly.</div>
<div> </div>
<div> 3) Some answered calls does not hear anything at the
receiver/initiater end.</div>
<div> </div>
<div> 4) asterisk itself gets crashed at times</div>
<div> </div>
<div> 5) Core dumps are getting created.</div>
</blockquote>
Follow the guidelines for obtaining a backtrace with GDB. These can be
found in the file "asterisk/doc/backtrace.txt"<br>
<br>
Look in
<a class="moz-txt-link-freetext" href="http://www.voip-info.org/tiki-index.php?page=Asterisk%20debugging">http://www.voip-info.org/tiki-index.php?page=Asterisk%20debugging</a><br>
<br>
If you learn to read the backtrace, you can know with great detail what
is causing asterisk to crash. You may run into known bugs, so you can
check the bugtracker and/or the recent versions Changelog to see if
it's solved. Maybe you'll have to decide to upgrade it or not, or
upgrade in a separate machine and test throughoutly before putting the
new version into production.<br>
<br>
Cheers,<br>
<pre class="moz-signature" cols="72">--
Ing. Miguel Molina
Grupo de Tecnología
Millenium Phone Center
</pre>
</body>
</html>