Jump to content

Huge database data from just two tables

Recommended Posts

Hi everyone,

I'm trying to upgrade Revive AdServer and I'm stuck due to rv_dj_track_ad_requests and rv_dj_track_ad_responses, that are respectively 25GiB and 6Gib..

Is there a feature to remove data older than specific date? Isn't there an automatic purge routine? And is it safe to remove those data?

Thanks for the support

Share this post

Link to post
Share on other sites

From memory, there's no automatic purge, because Revive Adserver cannot safely tell what statistics you want to keep vs. those that you don't want to keep.

I think, though, that if you have expired campaigns that you no longer want the statistics for, then if you delete them, the statistics are also deleted...

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now