17488 Posts in 4473 Topics by 1978 members
|
Page:
1
|
Go to End | |
| Author | Topic: | 1395 Views |
-
How to clear/purge statistics?
22 October 2008 at 7:08am
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.
-
Re: How to clear/purge statistics?
22 October 2008 at 8:08am
use phpmyadmin and delete some of the older entries SiteTree_Versions this is where the bulk of you're extra useless data is stored.
-
Re: How to clear/purge statistics?
1 November 2008 at 11:37am
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.
-
Re: How to clear/purge statistics?
2 November 2008 at 6:40am
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
-
Re: How to clear/purge statistics?
2 November 2008 at 7:27am
I was referring to the upcoming 2.3 release, not 2.2.3
| 1395 Views | ||
|
Page:
1
|
Go to Top |
