Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 27 Apr 2006, 15:00
moonclamp's Avatar
moonclamp moonclamp is offline
 
Join Date: May 2004
Real name: Paul
Problems with a hosting company

I am having problems with my hosting company.

I keep suffering mySQL disconnections and the hosting company are blaming my forum rather than their server.

This was the latest email I had from them


Dear Paul,

There is not a problem with the MYSQL server, we use the latest version of MYSQL and the server is powerful enough to handle your account. The problems Lies somewhere in your coding which is causing an internal loop and not closing sessions. Hence overloading the server and causing the crash.
Can anyone explain what "internal loop" means? I have VB 3.5.0 with numerous hacks and mods including all of VBadvanced. We have 600 members with an average of 20 users online at any one given time. Is there any possibility it could be a hack causing this?

However ... I also have a similar site, not as busy, but with far more hacks ... This is on a different server with the same host but never suffers disconnections.

Any idea how to proceed? They've already suspended my account once and I really don't want them to do it again. Unfortunately the domain was registered with them as part of the package so I fear that moving will end up a bit of a pain in the backside.
Reply With Quote
  #2  
Old 27 Apr 2006, 15:33
Gio~Logist's Avatar
Gio~Logist Gio~Logist is offline
 
Join Date: Jun 2004
Location: San Francisco
Real name: Giovanni Martinez
Try disabling all products and plugins and see if this problem continues.
__________________

ModernvB.com - vBulletin Mods & Services - ModernvB.com vBulletin 3 Mods - ModernvB.com vBulletin 4 Mods - Hire ModernvB
Full-Time vB Development - If you can think it, we can build it.
Reply With Quote
  #3  
Old 27 Apr 2006, 16:00
moonclamp's Avatar
moonclamp moonclamp is offline
 
Join Date: May 2004
Real name: Paul
Originally Posted by gio~logist
Try disabling all products and plugins and see if this problem continues.
Well I could do ... but it is very intermittent.

It happens twice in one day and then it'll be fine for 2 weeks ... or it'll happen every day for a week. There's no way of knowing, so we'll have to disable everything for a month or more.

Plus, with all mods disabled there would be less queries and therefore less strain on the server anyway ... So we could still be none the wiser?
Reply With Quote
  #4  
Old 27 Apr 2006, 18:36
SixteenOhNine SixteenOhNine is offline
 
Join Date: Apr 2006
Real name: Jonathan
It is possible that one of the hacks/plugins/extentions you are using is causing the issue related to the server crash, though disabling and checking back and forth is really the only method you can take.

While it may be a pain to have them disabled, given, if you are running a clean installation with nothing enabled and 20 users online are still causing the crash, then it's obvious the server isn't as powerful as stated and probably cannot handle the load.

If that is the case, it's time to look elsewhere as 20 users online shouldn't be an issue for a shared environment.
__________________
SixteenOhNine: Free vBulletin Styles (high quality!)
Xemion.com: Web Designer Directory
DevLobby.com Web Designer Forum
Reply With Quote
  #5  
Old 28 Apr 2006, 19:44
moonclamp's Avatar
moonclamp moonclamp is offline
 
Join Date: May 2004
Real name: Paul
Well I looked at the average server loads with the all the hacks working, then disabled them for a while and took another load of averages ...

2.15 1.46 1.33 | 19 Users Online (9 members and 10 guests)
1.69 1.46 1.33 | 19 Users Online (9 members and 10 guests)
0.76 1.07 1.19 | 20 Users Online (10 members and 10 guests)
0.73 1.15 1.18 | 17 Users Online (12 members and 5 guests)
2.38 1.75 1.42 | 18 Users Online (12 members and 6 guests)
3.28 2.62 1.87 | 20 Users Online (12 members and 8 guests)

and with the plugin system disabled ...

2.99 2.68 1.96 | 20 Users Online (12 members and 8 guests)
3.19 2.84 2.11 | 22 Users Online (12 members and 10 guests)
2.48 2.70 2.08 | 22 Users Online (11 members and 11 guests)
2.21 2.61 2.06 | 22 Users Online (11 members and 11 guests)
2.27 2.50 2.07 | 20 Users Online (11 members and 9 guests)
1.80 2.25 2.04 | 18 Users Online (10 members and 8 guests)

Bear in mind that this is a shared server hosting something like 150 sites ...
Reply With Quote
  #6  
Old 28 Apr 2006, 21:42
Brad Brad is offline
 
Join Date: Nov 2001
If they've crammed that many sites onto one box the problem is on their end. I suggest you find a new host..
Reply With Quote
  #7  
Old 28 Apr 2006, 22:10
moonclamp's Avatar
moonclamp moonclamp is offline
 
Join Date: May 2004
Real name: Paul
According to domaintools.com they have 171 sites on the same server. I think many of them may be cpanel addon domains.
Reply With Quote
  #8  
Old 28 Apr 2006, 22:11
SixteenOhNine SixteenOhNine is offline
 
Join Date: Apr 2006
Real name: Jonathan
The loads seem a bit high, even on a dual processor unit unless they are simply serving quite a few smaller communities.

Not sure who you're with, but I'd consider moving to a new hosting provider if it is greatly effecting your websites uptime.

We recently moved over to Site5 and things have been great thus far.
__________________
SixteenOhNine: Free vBulletin Styles (high quality!)
Xemion.com: Web Designer Directory
DevLobby.com Web Designer Forum
Reply With Quote
  #9  
Old 28 Apr 2006, 22:32
moonclamp's Avatar
moonclamp moonclamp is offline
 
Join Date: May 2004
Real name: Paul
I just checked out the Site5 website and the prices are pretty impressive ... How many members and what sort of activity have you got on your site? I need to get serious recommendations before I move.
Reply With Quote
  #10  
Old 29 Apr 2006, 04:20
kriscad's Avatar
kriscad kriscad is offline
 
Join Date: May 2004
Originally Posted by Brad
If they've crammed that many sites onto one box the problem is on their end. I suggest you find a new host..

i agree


just get your own box
Reply With Quote
  #11  
Old 29 Apr 2006, 05:47
SixteenOhNine SixteenOhNine is offline
 
Join Date: Apr 2006
Real name: Jonathan
Originally Posted by moonclamp
I just checked out the Site5 website and the prices are pretty impressive ... How many members and what sort of activity have you got on your site? I need to get serious recommendations before I move.

We had a test run before SixteenOhNine went live of about 30 users online, though once it was launched with Site5, we've only have about 10 online at once.

Site5 rather easily handled the load and the server didn't flinch. Given, Site5 is a reputable host and if you're in the market for a new host, it wouldn't hurt to give them a shot.
__________________
SixteenOhNine: Free vBulletin Styles (high quality!)
Xemion.com: Web Designer Directory
DevLobby.com Web Designer Forum
Reply With Quote
  #12  
Old 29 Apr 2006, 12:45
moonclamp's Avatar
moonclamp moonclamp is offline
 
Join Date: May 2004
Real name: Paul
Originally Posted by kriscad
i agree


just get your own box
Easy to do if you have loads of spare cash ... alas not I.


I added the microstats hack to our forum last night ... Even with all our mods the most queries we have per page is 19 ... That isn't unduly excessive is it?

Last edited by moonclamp; 29 Apr 2006 at 15:05.
Reply With Quote
  #13  
Old 29 Apr 2006, 15:12
Zachariah's Avatar
Zachariah Zachariah is offline
 
Join Date: Feb 2002
Location: Canoga Park, CA
Originally Posted by moonclamp
Easy to do if you have loads of spare cash ... alas not I.


I added the microstats hack to our forum last night ... Even with all our mods the most queries we have per page is 19 ... That isn't unduly excessive is it?
Are you taking in to account cron jobs that do massive updates in the background ?
__________________
http://www.szone.us |

Facebook | My:Hacks @ vBulletin.org
Reply With Quote
  #14  
Old 29 Apr 2006, 15:20
moonclamp's Avatar
moonclamp moonclamp is offline
 
Join Date: May 2004
Real name: Paul
No I wasn't counting them (we have 19 scheduled tasks in total) ... I'm not sure if anything can really be done about them either can it?


Originally Posted by scheduled tasks
User Promotione,Event Reminder,Thread Views, Hourly Cleanup, Attachment Views, Restore Temporarily Banned Users, Hourly Cleanup, Gallery e-Card Cleanup, Links Directory Subscriptions, Daily Statistics Log, Gallery Subscriptions, Rules and User Agreement Hack, Happy Birthday Email, Subscriptions, Daily Digest, Activation Reminder Email, Gallery Search Cleanup, Links Search Cleanup Mon Weekly Digest

Last edited by moonclamp; 29 Apr 2006 at 15:31.
Reply With Quote
  #15  
Old 29 Apr 2006, 22:53
Zachariah's Avatar
Zachariah Zachariah is offline
 
Join Date: Feb 2002
Location: Canoga Park, CA
There may only be 1 job that is killing your server.
- What hacks have a cron job running ?

Perhaps its just 1 hack that brings the server to it's knees.
__________________
http://www.szone.us |

Facebook | My:Hacks @ vBulletin.org
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 07:58.

Layout Options | Width: Wide Color: