vb.org Archive - forum is hitting query limits

Page 2 of 2

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- Forum and Server Management (https://vborg.vbsupport.ru/forumdisplay.php?f=232)

- - forum is hitting query limits (https://vborg.vbsupport.ru/showthread.php?t=193439)

Yogesh Sarkar

10-13-2008 12:52 AM

Usually it is the Yahoo spider which does this, Google Spider causes less load and their search engine sends 80-90% of the total search traffic. So it is best to enable the crawl delay only for the Yahoo bot.

barcena

10-13-2008 07:11 AM

I'm on the same page here, I've been by now w/ I don't know how many hosting companies that usually allows only 50 MySQL connections, I've been with both small and big companies and is all the same when it comes to MySQL connections, I guess they haven't realized that we, forums, needs more. My site have a lot of traffic between members, guests and robots but I cannot find a "decent" hosting plan when it comes to MySQL queries, I guess I need at least 150.

The solution is pretty much going dedicated or virtual, but not everyone can pay that much money monthly.

What to do?.

Any help? Do you guys knows any hosting plan that allows more MySQL connections?.

Thanks. :)

Marco van Herwaarden

10-13-2008 07:43 AM

A host that limits MySQL to a maximum of 10 connections, will probably never run vB without problems, not even if you have only a few visitors and disable all spiders.

SEOvB

10-13-2008 01:48 PM

Quote:

Originally Posted by barcena (Post 1643908)

I'm on the same page here, I've been by now w/ I don't know how many hosting companies that usually allows only 50 MySQL connections, I've been with both small and big companies and is all the same when it comes to MySQL connections, I guess thttp://hostingreviewshop.com/shared-hosting/url-jethey haven't realized that we, forums, needs more. My site have a lot of traffic between members, guests and robots but I cannot find a "decent" hosting plan when it comes to MySQL queries, I guess I need at least 150.

The solution is pretty much going dedicated or virtual, but not everyone can pay that much money monthly.

What to do?.

Any help? Do you guys knows any hosting plan that allows more MySQL connections?.

Thanks. :)

forums were never really designed to run on shared hosting. I know a VPS can be expensive but if you really want to run a site and not have to worry about such silly things as MySQL connections, and time outs its the only way to go.

Marco van Herwaarden

10-13-2008 05:04 PM

There are loads of shared hosts that don't have such a low limits.

Brandon Sheley

10-13-2008 05:20 PM

I would 2nd or 3rd "getting a better host"

and I'll also 2nd Marco's comment that there are many shared host that work just fine with vBulletin.
with the low limits that your current host has is ridicules, it sounds like your being hosted by a reseller :(

Yogesh Sarkar

10-13-2008 08:53 PM

Quote:

Originally Posted by barcena (Post 1643908)

My site have a lot of traffic between members, guests and robots but I cannot find a "decent" hosting plan when it comes to MySQL queries, I guess I need at least 150.

The solution is pretty much going dedicated or virtual, but not everyone can pay that much money monthly.

If your site is getting that many visitors then it can certainly earn 40-50 bucks needed for a decent managed vps. If you are not monetizing or taking donations from members, then you have to sit down and seriously think about the future of your forum because most likely it will only grow in the future.

Btw you might want to check out a reseller plan from a host that would generally allow for much more resources, that’s what I used before switching to vps.

All times are GMT. The time now is 02:18 PM.

Page 2 of 2

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01055 seconds Memory Usage 1,728KB 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 (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (7)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 pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: