<html><head><meta http-equiv="content-type" content="text/html; charset=utf-8"></head><body dir="auto"><div>Any operation that writes to your MySQL database for any great length of time like trimming your table will block anything else accesing the same database. You should auto rotate tables and use non transactional table storage to be able to trim older tables without impacting the active ones.<br><br>--<div>Adrian</div></div><div><br>On 21 Feb 2014, at 16:49, David Crow <<a href="mailto:David.Crow@vc3.com">David.Crow@vc3.com</a>> wrote:<br><br></div><div><span></span></div><blockquote type="cite"><div>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 15 (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:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 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:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.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]-->
<div class="WordSection1">
<p class="MsoNormal">I’ve got an opensips proxy that I just use for PSTN routing, no billing or anything is done from this system.<o:p></o:p></p>
<p class="MsoNormal">I only use the cdrs to identify when provider a call went to or from.
<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Both the ACC and CDRs table have just been growing and I haven’t done anything with them and now the acc table has gotten to over 4.6 GB and it’s almost impossible to search through. I have stopped generating the CDRs for now. I would
like to just purge these tables and start over but I wasn’t sure if I would break anything if I run a truncate on the acc table. Does anything read from the ACC table other than the CDR generation script? Would it be ok to run a TRUNCATE on this table?
<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 | (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"><image001.png></span></a><a href="http://twitter.com/#!/VC3Inc"><span style="color:#1F497D;text-decoration:none"><image002.png></span></a><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div></blockquote><blockquote type="cite"><div><span>_______________________________________________</span><br><span>Users mailing list</span><br><span><a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a></span><br><span><a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a></span><br></div></blockquote></body></html>