[OpenSIPS-Users] Truncating ACC and CDRs

[Adrian Georgescu]

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.

--
Adrian

> On 21 Feb 2014, at 16:49, David Crow <David.Crow at vc3.com> wrote:
> 
> I’ve got an opensips proxy that I just use for PSTN routing, no billing or anything is done from this system.
> I only use the cdrs to identify when provider a call went to or from. 
>  
> 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? 
>  
> Thanks,
>  
> David Crow | Senior Systems Architect
> 1301 Gervais Street, Suite 1800 | Columbia, SC 29201
> (d) 803.978.2727 | (f) 803.733.5888
> david.crow at vc3.com| www.VC3.com
> Follow us: <image001.png><image002.png>
>  
>  
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20140221/c391457f/attachment.htm>