forum is hitting query limits

[Yogesh Sarkar]

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]

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]

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]

Originally Posted by barcena

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.

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]

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

[Brandon Sheley]

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]

Originally Posted by barcena

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.