Jump to:

22976 Posts in 11493 Topics by 2824 members

General Questions

SilverStripe Forums » General Questions » Mysql database is way too big......please help

General questions about getting started with SilverStripe that don't fit in any of the categories above.

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

Page: 1
Go to End
Author Topic: 1948 Views
  • trigger
    Avatar
    Community Member
    2 Posts

    Mysql database is way too big......please help Link to this post

    Hi,
    Firstly I should say I'm a newbie.....
    I've had SS set up for a while by someone else on for my site and think its great.

    I have a 'big 105mb' problem though and looking for SS wizards advise please

    Heres the problem:

    I moved hosting because my old host was showing ever increasing connection errors.
    I found a new host to move to.
    Downloaded my site via ftp
    Uploaded to the new host.
    but;
    The my sql data base is 105mb's and the vast majority of it is old ip addresses and mountains of other useless info.

    can someone tell me how to clean it up and stop silverstripe collecting all this data ( i'm presuming SS is the hoarder of this info?)

    I'm not far off a computer dummy so please can you reply as if you are talking to a complete jerk, that way I might just understand.

    Thanks!!!

  • banal
    Avatar
    Community Member
    901 Posts

    Re: Mysql database is way too big......please help Link to this post

    Hi there

    What version of SilverStripe are you running? Versions prior to 2.3 where storing a lot of data in the "PageView" Table for the "Site-Statistics" module. Do you have access to your Database through a tool like "phpMyAdmin"? If yes, you could simply go there and "empty" (or truncate" the PageView table. No worries, you can safely do this as it won't have any impact on your site (just the stats, if you were using these at all).

  • trigger
    Avatar
    Community Member
    2 Posts

    Re: Mysql database is way too big......please help Link to this post

    Thanks Banal....

    Logged in and seen running 2.2.1.
    can you tell me how to upgrade and will my site be safe if I do upgrade?

    thanks again, I can see some light at the end of the tunnel now.

  • sorich87
    Avatar
    Community Member
    14 Posts

    Re: Mysql database is way too big......please help Link to this post

    Take a look at the upgrade tutorial :
    http://doc.silverstripe.org/doku.php?id=upgrading

    If you upgrade, you will benefit from the newer features of the silverstripe cms.

  • banal
    Avatar
    Community Member
    901 Posts

    Re: Mysql database is way too big......please help Link to this post

    Yeah, you should be safe when you update. Nevertheless I strongly encourage you to create a backup of your existing Site (all files and a DB snapshot)!
    The upgrading won't lessen the data used by silverstripe though. You would still have to empty/truncate or even delete the "PageView" table to decrease your DB-size.

  • Willr
    Avatar
    Forum Moderator
    5462 Posts

    Re: Mysql database is way too big......please help Link to this post

    If you dont want the site statistics (and they arent all too useful anyway) you can empty the PageView table. Once you do that it should make it more managable. If you do not want to upgrade to 2.3 you can just turn off the statistics logging by editing the ContentController? file I think there is a static function in the init() statement in that file which logs all the page views (this was removed from 2.3 as it was a horrid way of doing the statistics section)

    1948 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.