[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.crow at vc3.com <mailto:david.crow at vc3.com>| **www.VC3.com* 
> <http://www.vc3.com/>**
>
> *^Follow us: *Description: Description: Description: Description: 
> Description: cid:image002.png at 01CC30E6.8E093080 
> <http://www.facebook.com/VC3Inc>Description: Description: Description: 
> Description: Description: cid:image004.png at 01CC30E6.8E093080 
> <http://twitter.com/#%21/VC3Inc>
>
>
> _______________________________________________
> 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/20130319/fc8ac6cb/attachment-0001.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 1198 bytes
Desc: not available
URL: <http://lists.opensips.org/pipermail/users/attachments/20130319/fc8ac6cb/attachment-0002.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 1325 bytes
Desc: not available
URL: <http://lists.opensips.org/pipermail/users/attachments/20130319/fc8ac6cb/attachment-0003.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/jpeg
Size: 6800 bytes
Desc: not available
URL: <http://lists.opensips.org/pipermail/users/attachments/20130319/fc8ac6cb/attachment-0002.jpeg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/jpeg
Size: 5114 bytes
Desc: not available
URL: <http://lists.opensips.org/pipermail/users/attachments/20130319/fc8ac6cb/attachment-0003.jpeg>