[OpenSIPS-Users] Truncating ACC and CDRs

[David Crow]

Yes, that’s the plan long term.  For now, though I’m just wondering if deleting everything in the acc table will cause problems.   Or does anyone have any other suggestions on how to clean this up?

-David

From: users-bounces at lists.opensips.org [mailto:users-bounces at lists.opensips.org] On Behalf Of Adrian Georgescu
Sent: Friday, February 21, 2014 6:31 PM
To: OpenSIPS users mailling list
Subject: Re: [OpenSIPS-Users] Truncating ACC and CDRs

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<mailto: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<mailto:david.crow at vc3.com>| www.VC3.com<http://www.vc3.com/>
Follow us: <image001.png><http://www.facebook.com/VC3Inc><image002.png><http://twitter.com/#!/VC3Inc>


_______________________________________________
Users mailing list
Users at lists.opensips.org<mailto: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/20140224/b51fa8f9/attachment.htm>