Results 1 to 17 of 17
-
12-27-2006, 09:14 AM #1Newbie
- Join Date
- Mar 2003
- Posts
- 24
Is having 20 max mySQL connections per user acceptable for a reseller acct??
Just wondering because I'm exceeding 20 connections and my host doesn't seem to want to increase that. I've got one site that is running vbulletin and does about 1.5GB of transfer per day w/ approx. 25-35 users on it at any given time.
Just trying to get a feel for what's the industry standard.
-
12-27-2006, 10:29 AM #2Web Hosting Master
- Join Date
- Mar 2005
- Location
- Athens, Greece
- Posts
- 1,763
For many hosts this is a standard limit... you could move your forum to a VPS for greater reliability and flexibility.
-
12-27-2006, 10:47 AM #3Web Hosting Master
- Join Date
- Apr 2004
- Location
- Singapore
- Posts
- 1,522
You can create additional user to access the DB and instruct vBulletin to connect either user during connection so you can max up your connection.
You have to check in vBulletin forums and see how this can be done.tanfwc
-
12-27-2006, 11:11 AM #4Web Hosting Master
- Join Date
- Apr 2001
- Location
- Paradise
- Posts
- 12,052
Indeed, 20 is a bit low, I think that 50 is the standard
█ Shared Web Hosting - Reseller Hosting - Semi-Dedicated Servers - SolusVM/XEN VPS
█ LiteSpeed Powered - R1Soft Continuous Data Protection - 24/7 Chat/Email/Helpdesk Support
█ Cpanel/WHM - Softaculous - R1soft Backup - Litespeed - Cloudlinux -Site Builder- SSH support - Account Migration
█ DowntownHost LLC - In Business since 2001- West/Center/East USA - Netherlands - Singapore
-
12-27-2006, 11:26 AM #5Temporarily Suspended
- Join Date
- Oct 2003
- Location
- Hanoi
- Posts
- 4,309
it depends on your host server, how they sell it... anyway, I doubt you have trouble with that limit, if you have only 25 - 35 users online at the same time
-
12-27-2006, 04:34 PM #6Web Hosting Master
- Join Date
- Dec 2003
- Posts
- 742
It depends on what you're paying as well. Mysql can put quite a load on servers, so its a resource that's typically metered tightly. A decent VB forum should be put on a vps or dedicated in the long run, especially if you plan to put some decent mods on it.
-
12-27-2006, 10:31 PM #7WHT Addict
- Join Date
- Apr 2005
- Posts
- 140
Originally Posted by JeditoThomas Brenneke | Network Redux, LLC | http://www.networkredux.com
• Proud sponsors of the SimpleMachines ImageMagick and AdiumX projects.
-
12-28-2006, 08:16 AM #8Web Hosting Evangelist
- Join Date
- Dec 2005
- Posts
- 475
You can create additional user to access the DB and instruct vBulletin to connect either user during connection so you can max up your connection.
15 connections from one user plus 6 from another user, won't surpass the limit?Two decades of web marketing experience & millions of visitors, previously a super-affiliate.
-
12-28-2006, 12:58 PM #9Everything in life is swelly
- Join Date
- Feb 2006
- Location
- Swellyville
- Posts
- 2,341
Originally Posted by tonyFF
I think that 20-25 max sql connections is pretty standard unless otherwise stated by the host.<<< Please see Forum Guidelines for signature setup. >>>
-
12-28-2006, 02:13 PM #10learning is in the doing
- Join Date
- Sep 2000
- Location
- Alberta, Canada
- Posts
- 3,146
Originally Posted by Silver740
As a Client, you may find your current Hoster is not offering the features you need. If your site gets even busier -- something we all hope for -- your site Visitors will become frustrated at the continous error msgs. they will receive; due to too many connections.• PotentProducts.com - for all your Hosting needs
• Helping people Host, Create and Maintain their Web Site
• ServerAdmin Services also available
-
12-28-2006, 02:16 PM #11WHT Addict
- Join Date
- Apr 2005
- Posts
- 140
Originally Posted by Website RobThomas Brenneke | Network Redux, LLC | http://www.networkredux.com
• Proud sponsors of the SimpleMachines ImageMagick and AdiumX projects.
-
12-28-2006, 02:39 PM #12learning is in the doing
- Join Date
- Sep 2000
- Location
- Alberta, Canada
- Posts
- 3,146
Disabling persistent connections does nothing to max. connection limit. Yes, connections will time out faster and that is good but 20 connection max. is still very limiting.
Besides, most (good?) Hosters already have persistent connections disabled at the Server level, so Clients don't have to worry about it either way.• PotentProducts.com - for all your Hosting needs
• Helping people Host, Create and Maintain their Web Site
• ServerAdmin Services also available
-
12-28-2006, 02:46 PM #13WHT Addict
- Join Date
- Apr 2005
- Posts
- 140
Originally Posted by Website Rob
I disagree that a good host could be defined as one who inherently limits the ability to use persistent connections at the server level. This should be a feature used appropriately by the customer. If the customer finds his applications leaving too many of these threads lingering around, he then can opt to move to regular connections.
The lowest we will go on busy servers is 25-35 (our default is 50). I believe this is more than enough for busy shared hosting environments. Our own internal CRM that manages our entire organizational chart on a standalone server doesn't even come close to the 50 mark. With persistent connections enabled we would see at most 15 sleeping threads.Thomas Brenneke | Network Redux, LLC | http://www.networkredux.com
• Proud sponsors of the SimpleMachines ImageMagick and AdiumX projects.
-
12-28-2006, 03:12 PM #14learning is in the doing
- Join Date
- Sep 2000
- Location
- Alberta, Canada
- Posts
- 3,146
A good Host is defined by many things. One of those things is realizing and understanding that the majority of Clients use scripts without any knowledge of programming. Thus, many mistakes and pitfalls caused by bad coding of these scripts can be easily prevented through Server settings while still allowing a script to work as desired.
Those Clients that are coders and do know what they are doing can easily ask/request about certain changes. That is what Support is all about.
Sidenote: just read the article mentioned and found this quite interesting.
"Conclusion: Instead of blindly enabling persistent connections in MySQL you may wish to benchmark your application to see if persistent connections really give you the performance benefit, and if it is large enough to justify for the limitations introduced by them."
The article also mentions that persistent connections are best suited for a slow Server. Nuff said about that.Last edited by Website Rob; 12-28-2006 at 03:16 PM.
• PotentProducts.com - for all your Hosting needs
• Helping people Host, Create and Maintain their Web Site
• ServerAdmin Services also available
-
12-28-2006, 04:01 PM #15Owner of the net for a day
- Join Date
- Jun 2002
- Location
- Waco, TX
- Posts
- 5,623
Rob do you realize that vBulletin can have over 150 users active using less than 20 connections?
-
12-28-2006, 05:04 PM #16learning is in the doing
- Join Date
- Sep 2000
- Location
- Alberta, Canada
- Posts
- 3,146
I realize any script can use whatever number of mySQL connections with not all of them being open at the same time. Rather than hijack this thread, a new thread should be started for discussing the pros & cons of persistent connections.
• PotentProducts.com - for all your Hosting needs
• Helping people Host, Create and Maintain their Web Site
• ServerAdmin Services also available
-
12-28-2006, 05:40 PM #17Workaholic
- Join Date
- Jan 2004
- Location
- New York, NY
- Posts
- 1,241
Originally Posted by Website Rob
Originally Posted by Website Rob
With that being said, for your average web hosting company that is *not* targeting advanced users (or rather, a company that is primarily targeting people that are not familiar with coding, etc.), what you have said might be very true. Sometimes it is just difficult to generalize and say that X is a sign of a good company .
Happy holidays everyone!