Database Too Large, How To Reduce? How To Clean The Statistics?, Using OpenX a few years ago the database is huge. Options

[GUIA DA OBRA.NET]

I want to "clean up" my database. After several years of using OpenX, my database is already the 250Mb and I find it a lot.

How do I reduce this size dramatically? If I clear all the statistics of the past can greatly decrease the database? How do I do this?

Thank you my friends

[mediamerica]

I want to "clean up" my database. After several years of using OpenX, my database is already the 250Mb and I find it a lot.

How do I reduce this size dramatically? If I clear all the statistics of the past can greatly decrease the database? How do I do this?

Thank you my friends

Surprised nobody's responded to this for you. Well I'm mainly a novice myself, so use this advice at your own risk.

But from what I understand, consider at your own risk clearing out:

oa_data_raw_ad_impression
oa_data_raw_ad_request

After that, you could clear out SOME of your stats from:
ox_data_intermediate_ad
ox_data_summary_ad_hourly

Here's where somebody once replied to me on this:

http://forum.openx.org/index.php?showtopic=503486661

[GUIA DA OBRA.NET]

I want to "clean up" my database. After several years of using OpenX, my database is already the 250Mb and I find it a lot.

How do I reduce this size dramatically? If I clear all the statistics of the past can greatly decrease the database? How do I do this?

Thank you my friends

Surprised nobody's responded to this for you. Well I'm mainly a novice myself, so use this advice at your own risk.

But from what I understand, consider at your own risk clearing out:

oa_data_raw_ad_impression
oa_data_raw_ad_request

After that, you could clear out SOME of your stats from:
ox_data_intermediate_ad
ox_data_summary_ad_hourly

Here's where somebody once replied to me on this:

http://forum.openx.org/index.php?showtopic=503486661

Thank you my friend!

I'll try it, thank you for your attention and appreciation.

[GUIA DA OBRA.NET]

Friend, I'm not getting ... so how do you say?

[GUIA DA OBRA.NET]

Friend, I'm not getting ... so how do you say?

I got friends, I got!!!

I did here in SQL through phpMyAdmin, in OpenX database:

CODE

DELETE FROM ox_data_intermediate_ad WHERE interval_end < DATE_SUB(CURDATE(), INTERVAL 1 MONTH);
DELETE FROM ox_data_summary_ad_hourly WHERE date_time < DATE_SUB(CURDATE(), INTERVAL 1 MONTH);
DELETE FROM ox_data_summary_zone_impression_history WHERE interval_end < DATE_SUB(CURDATE(), INTERVAL 1 MONTH);

The time can be changed if desired, in my case, I did for 1 month, ie, I cleaned the statistics prior to 1 month.

Thank you and I have helped others who have the same doubt.