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.

General Questions /

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

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


Reply


6 Posts   2167 Views

Avatar
trigger

Community Member, 3 Posts

13 June 2009 at 10:42am

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

Avatar
banal

Community Member, 901 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).

Avatar
trigger

Community Member, 3 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. :-)

Avatar
sorich87

Community Member, 14 Posts

14 June 2009 at 1:43am

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.

Avatar
banal

Community Member, 901 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.

Avatar
Willr

Forum Moderator, 5513 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)