Jump to:

17452 Posts in 4473 Topics by 1971 members

Archive

SilverStripe Forums » Archive » How to clear/purge statistics?

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

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

Page: 1
Go to End
Author Topic: 1531 Views
  • evren
    Avatar
    Community Member
    37 Posts

    How to clear/purge statistics? Link to this post

    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.

  • vstrazz
    Avatar
    Community Member
    63 Posts

    Re: How to clear/purge statistics? Link to this post

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

  • Ingo
    Avatar
    Forum Moderator
    801 Posts

    Re: How to clear/purge statistics? Link to this post

    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.

  • evren
    Avatar
    Community Member
    37 Posts

    Re: How to clear/purge statistics? Link to this post

    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

  • Ingo
    Avatar
    Forum Moderator
    801 Posts

    Re: How to clear/purge statistics? Link to this post

    I was referring to the upcoming 2.3 release, not 2.2.3

    1531 Views
Page: 1
Go to Top

Want to know more about the company that brought you SilverStripe? Then check out SilverStripe.com

Comments on this website? Please give feedback.