Have you cleaned up your

Shaggy — Sat, 13 Dec 2008 02:54:53 +0000

Have you cleaned up your table spaces lately? I'm not all that familiar with MySQL, but most databases need a periodic file/table space cleanup operation to be performed on tables that get frequent updates/deletes. You'll also find the same operation re-computes statistics on your tables/indexes so it may better compute optimal plans for data selection, etc.

Hope this helps.
Cheers,
Shaggy.

BASHERS33 wrote: Does

greg — Mon, 08 Dec 2008 15:13:00 +0000

BASHERS33 wrote:

Does anyone know some hosts with unlimited DB space and decent file and bandwidth limits?

For a relatively decent price, most hosting services offer packages with huge disk space now, and monthly bandwidth also pretty high.

As for unlimited DB space, why do you specifically need to get that? You say..

BASHERS33 wrote:

Yet my DB size was over 80 MB for a site that has only 11,000 posts

So you have a requirement of 80MB so far, perhaps you could decide on a figure such as 150MB?
Rather than trying to get unlimited, which you will never use.

And as has been said, you might want to do some further investigating to the size of that DB. 80MB isn't particularly a huge DB, but for 11,000 posts is a lot (for text only anyway).
And having an unlimited space might stop you from bothering to tweak it for best usage. If you are limited to size, you will HAVE to ensure it is running to best possible performance and isn;t getting flled with unnecessary data

Our cluster's system db is 30GB (7 server cluster), but that's another story as it stores data for all the vhosts on the serves, images and hashes for every table (etc)

I manage a ratings site with

decibel.places — Mon, 08 Dec 2008 13:55:00 +0000

I manage a ratings site with a 175MB database hosted at RackSpace - they offer excellent support, but I don't like using the Plesk CP.

SELF PROMOTION

My hosting plans offer up to 250MB MySQL storage

One other thing I forgot to

pr0gr4mm3r — Tue, 02 Dec 2008 17:53:14 +0000

One other thing I forgot to mention, if you just throw unlimited space at your databases that are growing out of control, you might hit other bottlenecks, such as MySQL lag as it tries to query the large database, and you may hit CPU limitations on a shared hosting account.

Do you know what information your site is logging?

Does anyone know some hosts

pr0gr4mm3r — Tue, 02 Dec 2008 17:24:00 +0000

Does anyone know some hosts with unlimited DB space and decent file and bandwidth limits?

*braces for all the self-promoters*

Several members offer hosting here (including me), so I sure you will be bombarded with offers.

I thought of using Invision's hosting itself, but although it has unlimited DB space, it has low limits on file space and transfer AND it costs even triple of my current hosting for those low limits.

You get what you pay for. You can't expect to get more for nothing. If you want the space, you need to pay for it. Other companies that claim to offer more space for less sacrifices other things, like customer service, uptime, etc.

An 80MB database is quite huge, probably bigger than it should be. Would Megan or Liam (forum owners) be willing to disclose the DB size of this site? I'm curious what a DB size for a decent-sized form would be. The largest database I manage is 130MB, and that's MaxMind's IP Gelocation Database.