Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 15 Jan 2009, 00:49
MetalMilitia's Avatar
MetalMilitia MetalMilitia is offline
 
Join Date: Mar 2004
Real name: Matt
Host shutdown : Database too large

my post is 194 megs, post index is 206. The database alltogether is ~500.

bluehost.com, despite having helped me upload the database (470 megs) about 3 months ago, is now telling me they won't restore my site unless its smaller.

A) what can I do to decrease the db (without pruning half the goddamn forums)

b) anyone know a good RELIABLE host? They were awesome til this happened.... recently my site was linked to from yahoo news, we got mega traffic.... but they managed to keep it online. This was on saturday. Now, being wednesday - traffic levels are re-settling themselves.... and they decide to shut me down today of all times? They cite that "Your web hosting account for armageddononline.org has been deactivated (reason: site causing performance problems)."

Did I just outgrow them... like literally with 1 link from yahoo? seems kind of irrational to shut somone down 4 days after the boom. Seems to me like I'm being targeted.

I know it's shared hosting, but they advertise UNLIMITED RESOURCES and UNLIMITED SPACE.... and never once brought up my DB size til I started generating decent traffic.

HELP
__________________
Discussion on Armageddon, Politics, Religion, History, Science, & Philosophy. Please help build our community!

Armageddon Online : http://www.armageddononline.org

Armageddon Online Forums : http://forums.armageddononline.org
Reply With Quote
  #2  
Old 15 Jan 2009, 01:20
Bellardia Bellardia is offline
 
Join Date: Jul 2007
Did they say it was purely the database size?
Performance issues could also be server load (perhaps you have a bunch of inefficient mods or plugins that are hammering your server down. If this is the case consider removing some of the less important ones.

Your database size is pretty much relational to the amount of posts you have..if you're not willing to prune those then you won't see major differences. You could clear adminlog and moderator log if that data isn't of particular use to you. They can grow pretty large in size.
Reply With Quote
  #3  
Old 15 Jan 2009, 01:25
nexialys
Guest
 
1- ANY host offering unlimited hosting is just bullshit, you have to understand that... the universe itself is not unlimited, so why would be a hosting service...

2- switch to a Dedicated server on a SERIOUS host... stop searching for rebates.

3- use FullText instead of default setting of your old engine... FullText will be smaller, and faster.
Reply With Quote
  #4  
Old 15 Jan 2009, 01:29
MetalMilitia's Avatar
MetalMilitia MetalMilitia is offline
 
Join Date: Mar 2004
Real name: Matt
overuse of resources, based primarily on forums loads. Like i said, we had a direct link form news.yahoo.com on saturday.... but didnt get axed til today.

Aside from pruning stuff I don't see an option, and thats not what I want to do.

I dont use to many hacks/plugins/mods... they are worried about the size of post and post index..... which I guess, there is no work around for?

Also i read a FAQ on here about setting up vbulletin for larger amounts of traffic, and subsequently changed all those settings.

Do you really thing I need dedicated hosting? The site is based on DISASTERS. So if nothing is happening around the world.... traffic is fairly flatline / unspectacular. It's preparing for them that is the pain in the ass, cause we can go from 5000 unique hits a day to 50,000+... it normally levels back out within a week.....
__________________
Discussion on Armageddon, Politics, Religion, History, Science, & Philosophy. Please help build our community!

Armageddon Online : http://www.armageddononline.org

Armageddon Online Forums : http://forums.armageddononline.org

Last edited by MetalMilitia; 15 Jan 2009 at 01:33. Reason: Auto-Merged DoublePost
Reply With Quote
  #5  
Old 15 Jan 2009, 01:34
SEOvB's Avatar
SEOvB SEOvB is offline
 
Join Date: May 2007
Real name: Jarvis
make sure your attachments aren't in the database, along with signature pics, avatars, and profile pics.

Check out the modification called vBOptimize here at vB.org it seems to save a few queries per page.

Also, yes it does sound like you've out grown shared hosting, at the very least you need a VPS to ensure fast loading pages and not have to worry about getting shut down if your linked to from a popular site.
__________________
vBulletin Services and vBulletin Hosting
Reply With Quote
  #6  
Old 15 Jan 2009, 02:01
Bellardia Bellardia is offline
 
Join Date: Jul 2007
Originally Posted by MetalMilitia View Post
they are worried about the size of post and post index..... which I guess, there is no work around for?
Post table contains post information. I don't see how there would be any workaround for this. Simple, to make this smaller, delete posts.
Reply With Quote
  #7  
Old 15 Jan 2009, 02:30
BunnyCates BunnyCates is offline
 
Join Date: Oct 2008
I am with bluehost too. Actually I signed on with Hostmonster, and Bluehost bought them out. I NEVER had problems with hostmonster. 4 years of flawless website upage. Bluehost bought them out then it was ALL downhill after that, and my sites not even that big.

I originally had phpbb and coppermine, with ONLY 300+ members and they killed my site with the same reason. site causing performance issues.

So I purchased vbulletin and photopost, and after we hit like 40 members I got shut down again, some reason stating the slow database queries were causing bad system performance and they wouldnt turn it back on.

I ended up buying ANOTHER account JUST FOR The forum/gallery and leaving my store on its own account. Crappy solution but it works so far. Granted my site is TINY....

My dads webdesign company exclusively uses jumpline because they have EXCELLANT service, but they are pricey.

Have you looked into getting a host that offers TRUE dedicated servers?

moral of my story --- BLUEHOST BLOWS!
Reply With Quote
  #8  
Old 15 Jan 2009, 03:17
Brandon Sheley's Avatar
Brandon Sheley Brandon Sheley is offline
 
Join Date: Mar 2005
Real name: Brandon
I've been very happy with fluidhosting, you might check them out.
It sounds like you just need to upgrade your hosting
__________________

Email me for website help: brandon[at]sheley[dot]org
Reply With Quote
  #9  
Old 15 Jan 2009, 05:40
Dismounted's Avatar
Dismounted Dismounted is offline
 
Join Date: Jun 2005
Real name: Hanson
Please use vBulletin.com for discussion on hosting companies or server suggestions: vBulletin Hosting Options.
__________________
Former vBulletin.org Staff Member

View My Modifications
29 Releases and Counting... Latest Modification: dmActivityStream - vBookie Integration (4.x)

Please do not PM me to ask for support - please use the relevant thread or forum.
Reply With Quote
  #10  
Old 15 Jan 2009, 06:54
MetalMilitia's Avatar
MetalMilitia MetalMilitia is offline
 
Join Date: Mar 2004
Real name: Matt
Yes sir Plz move if need be since I'm gonna ask a follow up.

But I will point out that this website of mine is somewhat.... 'unique' if you will. I know sites go like roller coasters sometimes and can spike traffic.... but it's always that way for my site.

I can go from an average 3-6000 unique hits on a monday, to server max outs and crashes wednesday, with like 50,000-80,000+ uniques easy. The site follows disasters... if not much is happening, the traffic levels off... but as soon as something sparks it, it gets outta control.

Problem is this - It can go a month or 3 or more with flat out leveled off traffic. It averages out, it always has... the problem is the spark. Should I just pay for more expensive hosting as a backup? I don't think I've outgrown 'em... they ran really good since i signed up in october.

Is a site with 3-6,000 uniques per day and like 10-15k page loads maxed out horribly on a shared server? Or did yahoo just PWN bluehost so bad they had no choice?

Also - I was offered the bluehost HIGH CPU server - anyone got any advice on this?
__________________
Discussion on Armageddon, Politics, Religion, History, Science, & Philosophy. Please help build our community!

Armageddon Online : http://www.armageddononline.org

Armageddon Online Forums : http://forums.armageddononline.org

Last edited by MetalMilitia; 15 Jan 2009 at 07:01.
Reply With Quote
  #11  
Old 15 Jan 2009, 08:09
Dismounted's Avatar
Dismounted Dismounted is offline
 
Join Date: Jun 2005
Real name: Hanson
Originally Posted by MetalMilitia View Post
Yes sir Plz move if need be since I'm gonna ask a follow up.
I can't move threads to the vB.com forum. Please just post there for hosting suggestions.
__________________
Former vBulletin.org Staff Member

View My Modifications
29 Releases and Counting... Latest Modification: dmActivityStream - vBookie Integration (4.x)

Please do not PM me to ask for support - please use the relevant thread or forum.
Reply With Quote
  #12  
Old 15 Jan 2009, 14:55
SEOvB's Avatar
SEOvB SEOvB is offline
 
Join Date: May 2007
Real name: Jarvis
Originally Posted by MetalMilitia View Post
Yes sir Plz move if need be since I'm gonna ask a follow up.

But I will point out that this website of mine is somewhat.... 'unique' if you will. I know sites go like roller coasters sometimes and can spike traffic.... but it's always that way for my site.

I can go from an average 3-6000 unique hits on a monday, to server max outs and crashes wednesday, with like 50,000-80,000+ uniques easy. The site follows disasters... if not much is happening, the traffic levels off... but as soon as something sparks it, it gets outta control.

Problem is this - It can go a month or 3 or more with flat out leveled off traffic. It averages out, it always has... the problem is the spark. Should I just pay for more expensive hosting as a backup? I don't think I've outgrown 'em... they ran really good since i signed up in october.

Is a site with 3-6,000 uniques per day and like 10-15k page loads maxed out horribly on a shared server? Or did yahoo just PWN bluehost so bad they had no choice?

Also - I was offered the bluehost HIGH CPU server - anyone got any advice on this?
You've out grown and reliable shared hosting and should count your lucky stars that you've lasted that long
__________________
vBulletin Services and vBulletin Hosting
Reply With Quote
  #13  
Old 15 Jan 2009, 22:41
Videx's Avatar
Videx Videx is offline
 
Join Date: Feb 2007
I just wish we could offload all those old inactive threads instead of only being able to delete them when pruning.
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 17:49.

Layout Options | Width: Wide Color: