Calendar
Members
Search
Help
RSS Feed 
 Pruning Statistics |
  |
 May 8 2012, 09:48 PM
Post
#1
|
|
|
Beginner  Group: Members Posts: 7 Joined: 15-November 11 Member No.: 170,763  |
How does one prune the impression and click data that is stored in openX tables? I have data that is years old and want to significantly reduce the disk space that my database consumes.
|
 |
 
|
|
May 9 2012, 09:05 PM
Post
#2
|
|
|
Beginner Group: Members Posts: 7 Joined: 15-November 11 Member No.: 170,763 |
Here's what I'm getting at...
I have the following tables which are big and I believe are not being pruned: data_summary_ad_hourly data_intermediate_ad I have following configs in the conf.php file [maintenance] autoMaintenance= autoMaintenanceDelay=5 timeLimitScripts=300 operationInterval=60 compactStats=1 compactStatsGrace=604800 channelForecasting= blockAdImpressions=0 blockAdClicks=0 pruneCompletedCampaignsSummaryData= pruneDataTables=1 ecpmCampaignLevels="9|8|7|6" That appears it should prune anything older than 7 days. ads/scripts/maintenance/maintenance.php runs hourly via cron. Some tables appear to be getting pruned based on code I am seeing in: OA/Permission.php, OA/Maintenance/Pruning.php and OX/Maintenance.php I'm searching for code that would appear to be pruning tables: data_summary_ad_hourly data_intermediate_ad But, I don't see any from my greps. I'm running openX 2.8.8 What am I missing, overlooking or not understanding in order to prune these tables? |
|
|
|
|
Jun 8 2012, 06:41 PM
Post
#3
|
|
|
Beginner Group: Members Posts: 2 Joined: 21-July 09 Member No.: 29,433 |
Same problem here. No pruning happening and I have the same settings as you.
|
|
|
|
 Sep 27 2012, 06:50 AM
Post
#4
|
|
|
Beginner Group: Members Posts: 3 Joined: 10-August 05 Member No.: 6,829 |
I've got the same problem.
How can i flush old statistic? I've got default zones from a couple years and old statistic only slowing down database engine ;( I've got near billion impressions per day !!! |
|
|
|
|