Higher DB Limit
Does anyone know some hosts with unlimited DB space and decent file and bandwidth limits?
I am hosting a couple forum sites using Invision. I never realized that hosts have DB space limits! I am nowhere close to even 2% of my file space or bandwudth limits yet I was at my DB space limit earlier apparently?
My sites are almost dead they are so inactive. Yet my DB size was over 80 MB for a site that has only 11,000 posts.
I went through and deleted 100,000 rows of logs I didn't need so I bet I have lowered the size considerably. (havent checked it yet). However I never imagined I could run into this issue with so few posts.
I would prefer a site with at least 1 or 2 GB disc space, just decent bandwidth or even pretty low if necessary, and then as close to unlimited db space as possible.
I only need 2 mysql databases, but high space limits on them. The site would need to have php 5+ and mysql 5+. Hopefully very recent versions, at that.
I currently use midphase. They have been good, but now they have this limit and I so happen to be having my renewal for next year coming up in less than 3 weeks, so it was perfect timing finding out about this limit.
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.
Thanks
pr0gr4mm3r posted this at 17:24 — 2nd December 2008.
He has: 1,502 posts
Joined: Sep 2006
*braces for all the self-promoters*
Several members offer hosting here (including me), so I sure you will be bombarded with offers.
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.
pr0gr4mm3r posted this at 17:53 — 2nd December 2008.
He has: 1,502 posts
Joined: Sep 2006
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?
decibel.places posted this at 13:55 — 8th December 2008.
He has: 1,494 posts
Joined: Jun 2008
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
greg posted this at 15:13 — 8th December 2008.
He has: 1,581 posts
Joined: Nov 2005
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..
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)
Shaggy posted this at 02:54 — 13th December 2008.
They have: 121 posts
Joined: Dec 2008
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.
Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.