Hello,

I have discovered that one of the largest tables of my database is ad_statistics, with 25MB. I wanted to flush its content in order to free some space, but I want to keep the stats for my own knowledge and to keep stats of the value on the ads on my site. Would it be possible to export the data into a CSV file or ODS in order to free some space but not losing that valuable data?

Comments

jeremy’s picture

jeremy commented
Status: Active » Postponed (maintainer needs more info)

The data is stored in a simple SQL table. Feel free to export it any way you like. I'm not sure what you're asking? The module does not provide any mechanism for automatically exporting statistics data.

introfini’s picture

introfini commented

Hello,

Yes that is a issue for me to. My table is 300MB!

It's easy to backup the table and empty it, but I would like to keep the summarize data in the reports.

Yes there any way to do that?

Thanks,
introfini

jeremy’s picture

jeremy commented
Category: support » feature
Status: Postponed (maintainer needs more info) » Postponed

The module does not currently provide any mechanism for this, sorry. Marking as a feature request, and moving into a postponed state until someone comes along with a patch or some good ideas on how to best accomplish this.

Kirk’s picture

Kirk commented

Just noticed we had nearly 9 million rows in our table... Subscribing.

kiborg’s picture

kiborg commented

Yes, we need tools to purge it. Database bloating like crazy. Subscribing.

Bumble Beeman’s picture

Bumble Beeman commented

Table at 700mb. Subscribing.

cerup’s picture

cerup commented

I've added this issue which is indirectly related #881896: Aggregate statistics to reduce table size

john franklin’s picture

john franklin commented
Status: Postponed » Closed (won't fix)

Closing out all bugs for 5.x and older versions of Drupal. If this is still an issue, please reopen and update with 6.x details.