<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 14 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal">I’ve got an opensips system that we’ve been running for about 3 years now. Recently I’ve noticed that the load average on the system has been creeping up slowly over time.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I’ve narrowed this down to the cdr generation script in the opensips-cp, which seems to be taking longer and longer to finish.
<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I was looking at the mysql database and it looks like both the acc and cdrs tables just continue to grow. I know that I can remove stuff from the CDR table, but I’m not really sure about the ACC table. Does anyone have scripts that regularly
purge old stuff from these databases? Also what do I do now with them as large as they are?<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Thanks,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><b><span style="font-size:14.0pt;color:#1F497D">David Crow</span></b><b><span style="font-size:14.0pt;color:gray">
</span></b><b><span style="color:gray">| </span></b><b><span style="font-size:10.0pt;color:gray">Senior Systems Architect</span></b><span style="font-size:10.0pt;color:gray"><o:p></o:p></span></p>
<p class="MsoNormal"><b><span style="font-size:10.0pt;color:gray">1301 Gervais Street, Suite 1800 | Columbia, SC 29201</span></b><span style="font-size:10.0pt;color:gray"><o:p></o:p></span></p>
<p class="MsoNormal"><b><span style="font-size:10.0pt;color:gray">(d) 803.978.2727
</span></b><b><span style="font-size:10.0pt;color:gray">| </span></b><b><span style="font-size:10.0pt;color:gray">(f) 803.733.5888</span></b><span style="font-size:10.0pt;color:gray"><o:p></o:p></span></p>
<p class="MsoNormal"><b><span style="font-size:10.0pt"><a href="mailto:david.crow@vc3.com"><span style="color:blue">david.crow@vc3.com</span></a><span style="color:gray">|
</span></span></b><a href="http://www.vc3.com/"><b><span style="font-size:10.0pt;color:gray">www.VC3.com</span></b></a><b><span style="font-size:10.0pt;color:gray"><o:p></o:p></span></b></p>
<p class="MsoNormal"><b><sup><span style="font-size:18.0pt;color:gray">Follow us:</span></sup></b><span style="font-size:18.0pt;color:gray">
</span><a href="http://www.facebook.com/VC3Inc"><span style="color:#1F497D;text-decoration:none"><img border="0" width="21" height="21" id="Picture_x0020_20" src="cid:image001.png@01CE23C4.0EB5A2F0" alt="Description: Description: Description: Description: Description: cid:image002.png@01CC30E6.8E093080"></span></a><a href="http://twitter.com/#!/VC3Inc"><span style="color:#1F497D;text-decoration:none"><img border="0" width="22" height="22" id="Picture_x0020_25" src="cid:image002.png@01CE23C4.0EB5A2F0" alt="Description: Description: Description: Description: Description: cid:image004.png@01CC30E6.8E093080"></span></a><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="color:#1F497D"><img border="0" width="100" height="100" id="Picture_x0020_28" src="cid:image003.jpg@01CE23C4.0EB5A2F0"></span>
<img border="0" width="192" height="102" id="Picture_x0020_1" src="cid:image006.jpg@01CE23C4.72A6CFA0"><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>