Questions:
I have some issues with the database, its just growing and I have looked in admin for anyways of clearing logs etc
Here’s the 4 biggest, is it safe to empty any of these ?
ox_data_intermediate_ad 280K records
ox_data_raw_ad_impression 60K records
ox_data_summary_ad_hourly 280K records
ox_data_summary_zone_impression_history 80K records
Answer:
Yes,You can delete the records from the ox_data_summary_ad_hourly and ox_data_summary_zone_impression_history.but you will lose the statistics of the banners campaigns…If you don’t want to have the statistics then you can delete otherwise you need to keep as it is.
ox_data_raw_ad_impression and ox_data_intermediate_ad are the temporarily tables which keeps the records of the impressions and banner information temporarily.it keeps the five days of record.After that those records will move to the ox_data_summery_ad_hourly table.
Please you just check those data has been move to the above mentioned table with the help of the date and time then you can delete it from those tables if it has been moved.
