DBClean – Retention vs. Frequency

Posted by

A side note on my series on DBClean and data pruning. There are two different things you may express in days. The first is the retention for each pruning area. Each of my posts on specific areas discusses some of the details you need to consider when selecting a retention in that specific area.

The other is how frequently you actually run DBClean or the pruning script. My recommendation is that DBClean be run daily during the low point of database volume. I suppose you could go as far apart as weekly for the smaller areas or for a very small Commerce database. But depending on volume, you may need 4 or 5 hours just to remove one day’s worth of data – so if you wait until weekly, you’re looking at DBClean running for a day and a half solid. So your choice here clearly depends on your volume, database size, and requirements. But make sure you’re not confusing retention and frequency.

Ember is always curious and thrives on change. She has built internationally recognized expertise in IBM Db2, and is now pivoting to focus on learning MySQL. Ember shares both posts about her core skill set and her journey learning MySQL. Ember lives in Denver and work from home

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.