hdi-kw Posted January 6, 2014 Report Share Posted January 6, 2014 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. Quote Link to comment Share on other sites More sharing options...
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.