Login | Forgot password | Register

X

What is OpenID?

OpenID is an Internet-wide identity system that allows you to sign in to many websites with a single account.

With OpenID, your ID becomes a URL (e.g. http://username.myopenid.com/). You can get a free OpenID for example from myopenid.com.

For more information visit the official OpenID site.

Jump to:

17478 Posts in 4473 Topics by 1972 members

Archive

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

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

Page: 1
Go to End
Author Topic: How to clear/purge statistics? 717 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
    Administrator
    594 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
    Administrator
    594 posts

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

    I was referring to the upcoming 2.3 release, not 2.2.3

    717 Views
Page: 1
Go to Top

Currently Online: mandrew, Dragon28, oldwrinkly

Welcome to our latest member: U

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

Comments on this website? Please give feedback.