vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   General Hosting/Server Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=197)
-   -   resellerspanel hosting (https://vborg.vbsupport.ru/showthread.php?t=174515)

MikeHolohan 03-29-2008 04:37 PM

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

any info appreciated...

Mike.

snakes1100 03-29-2008 04:53 PM

nvr heard of it.

MikeHolohan 03-29-2008 05:17 PM

I am in live chat with them and they told me
Quote:

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.

snakes1100 03-29-2008 05:40 PM

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.

MikeHolohan 03-29-2008 06:24 PM

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 [DATE]1206819874[/DATE] at [TIME]1206819874[/TIME] ---------------

Quote:

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.

snakes1100 03-29-2008 06:50 PM

Your welcome, those stats come in handy for somethings on occasion... :D

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.

MikeHolohan 03-29-2008 07:56 PM

Thanks for all your help snakes... Mike.

Marco van Herwaarden 03-30-2008 09:24 AM

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.

MikeHolohan 03-30-2008 12:49 PM

Ok thanks, is there a recommended hosting company by vbulletin?

snakes1100 03-30-2008 02:30 PM

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.

MikeHolohan 03-31-2008 01:42 PM

Snakes thanks for all your replies, I am impressed that you would take the time to answer these posts...

Mike.

snakes1100 03-31-2008 07:15 PM

your welcome and good luck

MikeHolohan 04-01-2008 04:56 AM

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...

SEOvB 04-01-2008 05:24 AM

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.

MikeHolohan 04-01-2008 05:48 AM

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...

SEOvB 04-01-2008 06:52 AM

Google will usually only send one spider thats really efficent, its probably that pesky yahoo bot which is killing you.

Use robots.txt to slow the spiders, you can see what should be in a standard vBulletin robots.txt and where to put it on your server, and then just adding something like

Code:

User-agent: *
Crawl-delay: 120

to the end of it will slow the bots. These changes probably won't take effect for 24hrs, as most spiders only download robots.txt file once a day.

MikeHolohan 04-01-2008 02:31 PM

Wow thanks for that...

is the crawl delay value in minutes like 120 minutes?

thanks again.. Mike.

--------------- Added [DATE]1207078601[/DATE] at [TIME]1207078601[/TIME] ---------------

worked a charm, I have only 8 spiders on my site now... thanks for the tip...

edgecutioner 04-10-2008 07:01 AM

Quote:

Originally Posted by MikeHolohan (Post 1478272)
Ok thanks, is there a recommended hosting company by vbulletin?

Well no.

Quote:

Originally Posted by edgecutioner's brain
Can Jelsoft run a hosting company for vB just like IPB does? I mean, that would be cool.....


Hornstar 04-15-2008 07:55 AM

Personally I would much prefer a million spiders and spend a bit more to be on a better server. Anyway to ensure all my content is being indexed at a faster speed in the hope to attract more members for the content that i'm trying to drive members to is important IMO.

As for a good host, there are many, it does not seem like your forums are that busy or large currently and you can still get away with shared hosting until you start to get quite a lot larger where you start using too many resources for that server/host where it would become unfair to the other people on the server.
Some hosts are good with their tos in this respect, others have things in place where you use x amount cpu you will be suspended and the value is not even that high sometimes.

I run a hosting company (wont release the site here) but I feel if a hosting company is ever suspending or terminating sites without giving adequate warning and advise before hand, then you should never go with that host.

Remember in most cases you are paying for what you get. In some cases you may find a golden treasure but for just how long will it last? Take a look at how long they have been around, look for reviews etc. WHT can be a good place to start looking for hosts as well.

I wish you luck in finding a good host :)


All times are GMT. The time now is 05:55 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01178 seconds
  • Memory Usage 1,755KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code_printable
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (19)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete