What if the database size is very much large?

Friends, your help is needed!

you would need to purchase more space.

1gb is a huge database though. HUGE… I wouldn’t worry until you come across the problem.

@jimmyt1988
The SQL database is nearly 950 megs and I wonder wht will happen when it reaches 1 gig, because the host (GoDaddy) has the limitation of 1GB, and I can’t purchase a dedicated server.
I heard, we can split the database.. but how?

Agh, really? Damn, it could get quite complex.. I thoroughly suggest moving to a bigger database or…

I guess see if anyone has come up with a pre-made application, if not, it could be quite a nifty program to create.

How is your wordpress running with the 1gb sql database?
I am putting something together now, but when complete we estimate the DB will be more than 4gb in size.
I am not worried about limitations on the server as we have our own, and so long as we can obtain the traffic, we should be able to upgrade the hardware. I am more concerned about the software issues related to such a large DB.
How is your site running, how many posts do you have?

9grams,

It’s very rare for a WordPress database to approach the 1GB size limit unless you’re using a plugin that stores large amounts of data in it. I’ve seen this happen with some stats plugins, but there are alternatives that don’t store the info in the database. I recommend researching WHY your database is that large and fixing the cause rather than looking for a way to store such a large DB.

For the record, there isn’t currently an option to increase the storage available for a database when using Go Daddy’s traditional hosting plans. If you’re unable to stop the database from growing beyond the allowed size, you’ll have no choice but to find another solution (like a virtual dedicated server, fully dedicated server, or virtual datacenter).

@godaddy – The size of the database is in relation to the post amount.
But I agree, if the DB is bloated and it’s not due to the amount of posts – they should use something plugin “Better Delete Revision”. It can clean out the revision on posts and pages and even run a optimize on the DB.