Drahnier

Customer
not sure this is the right area but there is no area to ask about plugins in general or issues when running multiple plugins

I've recently been having trouble with having too many MySQL connections on my server and i was wondering which plugins make MySQL connections and how often and how long they maintain those connections

are there any plugins make arbitrary connections for no reason that could perhaps be optimized?

I know this issue is affected by DB plugins because disabling a few resolves it

for reference I use the following lite plugins: (all latest versions)
Advanced Post/thanks
Advanced User tagging
vBActivity & Awards
vBCredits II Deluxe
vBDonate
vBQuiz
vBShop
vBShout
vBSignatures
 
If you are on shared hosting that is probably the issue, if you are on a vps or a dedicated server I would suggest increasing the limit.

It's primarily a problem with shared hosting. When you use shared hosting, you "share" all of the resources on that server with any number of other users.

What makes shared hosting especially frustrating is that when you see that "too many connections" error message

There's really no way for you to determine if it's you and your scripts causing the problem or someone else on the same server; and
here's generally no way for you to take appropriate action, like changing the server configuration.

This isn't a vBulletin / DBTech issue or a forum issue. On shared hosting, you're likely to have this problem with any database driven site.

The only real solution is to try to find a host that doesn't oversell shared hosting (good luck!) or move to a VPS (recommended solution).
 
If you are on shared hosting that is probably the issue, if you are on a vps or a dedicated server I would suggest increasing the limit.

It's primarily a problem with shared hosting. When you use shared hosting, you "share" all of the resources on that server with any number of other users.

What makes shared hosting especially frustrating is that when you see that "too many connections" error message

There's really no way for you to determine if it's you and your scripts causing the problem or someone else on the same server; and
here's generally no way for you to take appropriate action, like changing the server configuration.

This isn't a vBulletin / DBTech issue or a forum issue. On shared hosting, you're likely to have this problem with any database driven site.

The only real solution is to try to find a host that doesn't oversell shared hosting (good luck!) or move to a VPS (recommended solution).

I know it's a shared hosting issue, I am limited to 15 MySQL connections simultaneously
I'm just looking to Optimise so that I can still run on shared hosting, I'm going to use Xcache but in addition it would be nice to know if there are any plugins that use a disproportionate amount of connections, I could easily do without Quizzes and vBsignatures for example if they use many connections
 
15 is a extremely low amount, as soon as your site get bigger, it is going to do the same thing with just vBulletin running by it's self, alot of users experience this on hostgator which has a limit of 25

I would suggest finding a different host in order to save yourself some headaches.
 
15 is a extremely low amount, as soon as your site get bigger, it is going to do the same thing with just vBulletin running by it's self, alot of users experience this on hostgator which has a limit of 25

I would suggest finding a different host in order to save yourself some headaches.

it's a pain allright, I'm Optimizing for less Database usage right now, hopefully I can make this work
 
I think it's safe to say you guys know what you're doing
I'm looking into getting a server for a forum that I expect to see have a fair bit of activity, I expect to ramp over 1000 members fairly quicky, but I also want to be able to scale to a fairly big Forum easily what sort of things should I look for in a dedicated server?
I'm currently looking at the cheapest options at these places;

Discount Rack | Discounted Dedicated Servers
Dedicated Server, Managed Hosting, VPS, Web & Colocation - Superb.net
Dedicated Server Special from Codero
 
It all depends, I have tried alot of hosts over the years and have had issues with them all, some of them fix stuff asap, some try and blame scripts. I would look at https://hivelocity.net/dedicated-servers/ that is who DragonByte Tech uses and recommends, and if you talk to them mention DragonByte Technologies and I do believe they give you something off on the initial order.

I am currently with them as well, my partner bought a server through them, and I do have to say the service is top notch.

I would say look for something that has at least 8MB of ram, and maybe a 1tb hd, and depending on what you plan on doing there, the processor speed is pretty important too.
 
Last edited:
It all depends, I have tried alot of hosts over the years and have had issues with them all, some of them fix stuff asap, some try and blame scripts. I would look at https://hivelocity.net/dedicated-servers/ that is who DragonByte Tech uses and recommends, and if you talk to them mention DragonByte Technologies and I do believe they give you something off on the initial order.

I am currently with them as well, my partner bought a server through them, and I do have to say the service is top notch.

I would say look for something that has at least 8MB of ram, and maybe a 1tb hd, and depending on what you plan on doing there, the processor speed is pretty important too.

I ended up going with Codero and I must say their service quality is top notch as well
these are the specs I got for $70 per month:

RAM 8 GB DDR2
RAM Upgradeable to 8 GB
Model Number E8400
Hard Drive 250 GB SATA2
Monthly Transfer 12 TB
IP Addresses 4
Front Side Bus Speed 1333 MHz
L2 Cache 6 MB
Uplink Port Speed 10 Mbit/s
CPU Benchmark Score * 2226


I know this isn't exactly the place to ask but I'm asking everywhere; any advice for moving servers?
 
Yeah that should do you for awhile, you mean to tell me Codero don't transfer the sites for you?
 
Yeah that should do you for awhile, you mean to tell me Codero don't transfer the sites for you?
I went the way of fully managing the server myself, costs less, also I'm now up and running on it :) so I can run a lot more of the sexy Plugins you guys have ;)
 
Going fully managed can be a big risk, if there's unexplained server issues they won't have the debug tools available to help you. You'll have to rely on them having encountered the issue before, which isn't a certainty is happening.

We have had cases of wishing we had gone managed, but to make em managed would mean a OS reload, which is way too much work.
 
Going fully managed can be a big risk, if there's unexplained server issues they won't have the debug tools available to help you. You'll have to rely on them having encountered the issue before, which isn't a certainty is happening.

We have had cases of wishing we had gone managed, but to make em managed would mean a OS reload, which is way too much work.

you gotta take risks in life :D
 
Back
Top