[split] Decrease database size?

Get help with installation and running phpBB 3.1.x here. Please do not post bug reports, feature requests, or extension related questions here.
Ideas Centre
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

NOTE: phpBB 3.1.x is at its End of Life stage and support will NOT be provided after July 1st, 2018.
Locked
User avatar
gussie
Registered User
Posts: 92
Joined: Wed Nov 27, 2002 1:26 am

[split] Decrease database size?

Post by gussie »

Like the OP, I have a recent, but not latest, version of phpBB running. Mine is 3.0.10. The database size is 2.87GB and my install is pretty heavily modified (there are a few mods that I found here and elsewhere, and a couple of custom modifications)
Lumpy Burgertushie wrote:... if you are going to upgrade to 3.1 then do not worry about it as those tables will not be moved over to the new board...
I want to check if my understanding is correct, because I would also like to upgrade the forum to the latest version of 3.1. Does the following sound right:
- running the STK cleaner will remove the tables of modifications that were made
- when I upgrade to 3.1.x, the search tables will not be used, so the actual database size could be as little as 1/3 of the database size displayed in my ACP (so from 2.87GB, only 700k or so will be used)
- after the upgrade, 3.1.x will rebuild whatever search tables or infrastructure it needs

Is there are recommended minimum spec for a new webhost? Would 2 CPU Cores, 50GB SSD Storage, and 3GB Dedicated RAM be enough for a phpBB 3.1.2 install and a 2.87GB or so database?
Res tantum valet quantum vendi potest
Do not hire Christian Bullock - he will not finish the job and he will not return your money.
User avatar
darcie
Community Team Member
Community Team Member
Posts: 5543
Joined: Thu Jul 27, 2006 9:52 am
Location: Davis, California
Name: Darcie Griffin
Contact:

Re: [split] Decrease database size?

Post by darcie »

I've split this to a new topic from viewtopic.php?f=46&t=2284981 and moved it to the 3.1.x Support forum to get more dedicated answers to your specific questions than you'd get by tacking these questions onto another user's topic. Hopefully this helps!
phpBB on Facebook | Site Rules | Former Community Team leader
Locked

Return to “[3.1.x] Support Forum”