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.

We've moved the forum!

Please use for any new questions (announcement).
The forum archive will stick around, but will be read only.

You can also use our Slack channel or StackOverflow to ask for help.
Check out our community overview for more options to contribute.

General Questions /

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

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

Mysql database is way too big......please help

Go to End

6 Posts   3287 Views


Community Member, 7 Posts

13 June 2009 at 10:42am

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



Community Member, 904 Posts

13 June 2009 at 11:11am

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


Community Member, 7 Posts

13 June 2009 at 11:14am

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. :-)


Community Member, 14 Posts

14 June 2009 at 1:43am

Take a look at the upgrade tutorial :

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


Community Member, 904 Posts

14 June 2009 at 10:21am

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.


Forum Moderator, 5523 Posts

14 June 2009 at 9:42pm

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)