Re: [OpenSIPS-Users] OpenSIPs Database Maintenance

[Bogdan-Andrei Iancu]

Hi David, The performance degradation of the cdr procedure (from CP) may be because:     - acc table got larger as polluted with old acc STOP/START records which never matched into a call; I suggest to move into an archive table whatever acc record is older than 2 days (you do not have calls longer than 2 days :) )     - cdr table may become large if you are continuously accumulating data inthere. Be sure you are rotating or consuming the data from the CDR table. Regards, Bogdan-Andrei Iancu OpenSIPS Founder and Developer http://www.opensips-solutions.com On 03/18/2013 04:36 PM, David Crow wrote: 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.   I’ve narrowed this down to the cdr generation script in the opensips-cp, which seems to be taking longer and longer to finish.    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?   Thanks,   David Crow | Senior Systems Architect 1301 Gervais Street, Suite 1800 | Columbia, SC 29201 (d) 803.978.2727 | (f) 803.733.5888 david.c...@vc3.com| www.VC3.com Follow us:          _______________________________________________ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users

_______________________________________________
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users