Skip to main content

This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.

Archive

Our old forums are still available as a read-only archive.

Moderators: martimiz, Sean, biapar, Willr, Ingo, simon_w

How to clear/purge statistics?


Reply

5 Posts   1556 Views

Avatar
evren

22 October 2008 at 7:08am Community Member, 37 Posts

My DB is bloated with statistics. It makes me lost time in backups and also makes impossible to restore directly (memory limits).

I have disabled the statistics from ContentController.php in sapphire bu how could I clean the recent records?
Please note that I'm not good at manual SQL operations :(
But if possible I can remove whole table if system creates again automaticly.

Regards.

Avatar
vstrazz

22 October 2008 at 8:08am Community Member, 63 Posts

use phpmyadmin and delete some of the older entries SiteTree_Versions this is where the bulk of you're extra useless data is stored.

Avatar
Ingo

1 November 2008 at 11:37am Forum Moderator, 801 Posts

I think he's talking about the PageView table - you can simply drop this table, it will be created with the nexty db/build call. The statistics module will not be part of the 2.3 release, and is phased over into a separate module - so unless you need this functionality, you shouldnt have these problems with our upcoming release.

Avatar
evren

2 November 2008 at 6:40am Community Member, 37 Posts

Already did it. Dropped the PageView and SiteTree_Versions tables and got about 50 MB.

But, I've patched my version to 223 but statistics still in package. Just want to ask, dosent matter anymore. I'll drop again :)

Avatar
Ingo

2 November 2008 at 7:27am Forum Moderator, 801 Posts

I was referring to the upcoming 2.3 release, not 2.2.3 :)