Jump to content
matteo.rossi

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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.




×
×
  • Create New...