Jump to content

Database is getting huge - how to prune?

Recommended Posts

I bet this topic already is in a forum, but had a little trouble finding it. I apologize in advance.

Thanks to having a robust clientele and lots of advertising, our database is also getting really big.

Are there tips on how to prune the database to keep its size manageable? For example, I have emptied the _userlog table. I don't really need to see who's logged or when. It was good for about 1.5 MB. The biggest tables are data_intermediate_ad and data_summary_ad_hourly. 

Is it safe th empty those? Or, is there a recommendation on how to at least prune them?

I can run sql commands, but am only at an intermediate skill level on that. So, any help construction such commands would be appreciated.


Link to comment
Share on other sites

  • 5 months later...
  • 4 weeks later...
  • 11 months later...
On 2/9/2020 at 12:52 PM, tbobker said:

How far back does your reporting go?

It sounds like you have a few years worth of data. You could remove all hourly reporting for campaigns older than 1 year for example. 

Same issue here. How do you do this? 

Is there a way to prune old data after X years? Or at least email sponsors their stats instead of having it recorded? 

Link to comment
Share on other sites

  • 2 years later...

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