Jump to content

Maintenance Pruning Dsaza Table


Recommended Posts

I wanted to try to reduce the database size a bit before doing the upgrade to Revive Adserver. Our old openX Source database was over 12GB with nearly all the size of it in the table data_summary_ad_zone_assoc.


After reading the function _pruneDataSummaryAdZoneAssocInactiveExpired() I found out I had to change some of our old campaigns that had an end date, but also still had a value in target_*. The next maintenance run dropped the table size to 5,2GB already. :)

There are still a lot of entries in this table with expired even back in 2008. Is there more that should get pruned there?

In lib/OA/Maintenance/Pruning.php there is a function _pruneDataSummaryAdZoneAssocOldData() which deletes old entries, but why only zone_id=0? What is zone_id=0 and why not the others?


Any ideas what else to do to reduce the size?


Thank you very much for your ideas.

Link to comment
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.

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...