Register Members List Search Today's Posts Mark Forums Read

Reply
 
Mod Options
  #1  
Old 29 Mar 2008, 17:37
MikeHolohan's Avatar
MikeHolohan MikeHolohan is offline
 
Join Date: Mar 2007
resellerspanel hosting

Anyone ever heard of http://www.resellerspanel.com/

any info appreciated...

Mike.
Reply With Quote
Comments
  #2  
Old 29 Mar 2008, 17:53
snakes1100 snakes1100 is offline
 
Join Date: Dec 2001
Real name: Anthony
nvr heard of it.
Reply With Quote
  #3  
Old 29 Mar 2008, 18:17
MikeHolohan's Avatar
MikeHolohan MikeHolohan is offline
 
Join Date: Mar 2007
I am in live chat with them and they told me
currently, the limit for MySQL queries is 45,000 queries per hour
can anyone advise me on this as I have no idea what that means...

Mike.
Reply With Quote
  #4  
Old 29 Mar 2008, 18:40
snakes1100 snakes1100 is offline
 
Join Date: Dec 2001
Real name: Anthony
Thats how many queries can be called in mysql per hour, if your forum home page has 11 queries, forumdisplay has 13 queries, showthread has 13 queries and you have 200 users online, that limit might not take long to reach.

If you have stats tracking like awstats or something, you can get your page views number for the busiest hour and count up what your using per hr on a rough guess.
Reply With Quote
  #5  
Old 29 Mar 2008, 19:24
MikeHolohan's Avatar
MikeHolohan MikeHolohan is offline
 
Join Date: Mar 2007
Thanks very much snakes, that helps a lot, as my forum grows I will grow my hosting with it but that should be quite enough for now...

Mike.

--------------- Added 29 Mar 2008 at 19:44 ---------------

hour 11 pages 7204 hits 45736 bandwidth 313.46 MB

This appears to be my busiest hour but I would imagine most of the hits are from bots as I have only 200 members total (and growing)

Mike.

Last edited by MikeHolohan; 29 Mar 2008 at 19:44. Reason: Auto-Merged DoublePost
Reply With Quote
  #6  
Old 29 Mar 2008, 19:50
snakes1100 snakes1100 is offline
 
Join Date: Dec 2001
Real name: Anthony
Your welcome, those stats come in handy for somethings on occasion...

That can give you a rough estimate though, awstats also lists the actual page/file that was called as well, so you can look and see what files are being hit/used the most.
Reply With Quote
  #7  
Old 29 Mar 2008, 20:56
MikeHolohan's Avatar
MikeHolohan MikeHolohan is offline
 
Join Date: Mar 2007
Thanks for all your help snakes... Mike.
Reply With Quote
  #8  
Old 30 Mar 2008, 10:24
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
hour 11 pages 7204 hits 45736 bandwidth 313.46 MB

Let's assume a low number of queries of 10 per page (reallity will be higher!!). 7.204 * 10 = 72.040

This is already much higher then the 45.000 limit.

PS Members/Guests/Bots makes no difference they all load pages and execute queries.
__________________
Marco van Herwaarden
Ex vBulletin.org Coordinator
Reply With Quote
  #9  
Old 30 Mar 2008, 13:49
MikeHolohan's Avatar
MikeHolohan MikeHolohan is offline
 
Join Date: Mar 2007
Ok thanks, is there a recommended hosting company by vbulletin?
Reply With Quote
  #10  
Old 30 Mar 2008, 15:30
snakes1100 snakes1100 is offline
 
Join Date: Dec 2001
Real name: Anthony
I still dont think vbulletin recommends any one hosting company, its all word of mouth by members and everyone has their opinion of who they host with and their own experiences with those hosts, you could ask 10 ppl that host with hostgator, half of them might say they sook, the other half would disagree as to why and say they nvr had that issue.
Reply With Quote
  #11  
Old 31 Mar 2008, 14:42
MikeHolohan's Avatar
MikeHolohan MikeHolohan is offline
 
Join Date: Mar 2007
Snakes thanks for all your replies, I am impressed that you would take the time to answer these posts...

Mike.
Reply With Quote
  #12  
Old 31 Mar 2008, 20:15
snakes1100 snakes1100 is offline
 
Join Date: Dec 2001
Real name: Anthony
your welcome and good luck
Reply With Quote
  #13  
Old 01 Apr 2008, 05:56
MikeHolohan's Avatar
MikeHolohan MikeHolohan is offline
 
Join Date: Mar 2007
I am fed up with 50 or 60 spiders on my site using all my sql queries,

at any time, day or night I have 50-60 spiders per hour...

is there a way to limit how many spiders are crawling all over my site...
Reply With Quote
  #14  
Old 01 Apr 2008, 06:24
SEOvB's Avatar
SEOvB SEOvB is offline
 
Join Date: May 2007
Real name: Jarvis
Use a robots.txt to block all spiders from crawling your site. You won't get listed in the search engines but it'll stop your query usage. Or at the very least use a robots.txt to limit the crawl rates

But i'd suggest moving to a different host, such as ASmallOrange.com or PowerVPS if your site warrants a VPS.
__________________
vBulletin Services and vBulletin Hosting
Reply With Quote
  #15  
Old 01 Apr 2008, 06:48
MikeHolohan's Avatar
MikeHolohan MikeHolohan is offline
 
Join Date: Mar 2007
My question really is why do the spiders need to crawl it so often, of course we all want to be found in the search engines but really 50-60 spiders every hour is a bit strange, is it normal, am I have less or more than others?

I have a small non profit site that I am trying to grow and I don't want all my sql queries being used by spiders and yet I still want to be found by the search engines, i would love a vps but couldn't afford to sustain one... I have reseller hosting with Hostgator...
Reply With Quote
Reply



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

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
Forum Jump


New To Site? Need Help?

All times are GMT. The time now is 19:57.

Layout Options | Width: Wide Color: