Results 1 to 9 of 9
-
08-06-2002, 12:15 PM #1Newbie
- Join Date
- Aug 2002
- Posts
- 5
Ventures Online MYSQL connections Max=45?
Hello,
I would like to know more about the MYSQL cap, does this mean only 45 users can be connected to the database at any time? It's looking like Ventures Online is definitely where I want to host my site, but the MYSQL cap could seriously effect traffic on forums and things like that.
Anyone know how big of an impact this may have on a high-traffic forum?
-Shawn
-
08-06-2002, 12:17 PM #2Web Hosting Master
- Join Date
- Jan 2001
- Location
- Illinois, USA
- Posts
- 7,175
Re: Ventures Online MYSQL connections Max=45?
Originally posted by Gummyworms
Hello,
I would like to know more about the MYSQL cap, does this mean only 45 users can be connected to the database at any time? It's looking like Ventures Online is definitely where I want to host my site, but the MYSQL cap could seriously effect traffic on forums and things like that.
Anyone know how big of an impact this may have on a high-traffic forum?
-Shawn
-
08-06-2002, 12:22 PM #3Newbie
- Join Date
- Aug 2002
- Posts
- 5
The problem is...I run pconnect() on my php scripts, does that leave the connection open until that person leaves the website altogether? With that kind of cap, it means that only 45 people can be on the site at any given time.
What happens when this cap is exceeded?
Shawn
-
08-06-2002, 12:24 PM #4Web Hosting Master
- Join Date
- Jan 2001
- Location
- Illinois, USA
- Posts
- 7,175
Originally posted by Gummyworms
The problem is...I run pconnect() on my php scripts, does that leave the connection open until that person leaves the website altogether? With that kind of cap, it means that only 45 people can be on the site at any given time.
What happens when this cap is exceeded?
Shawn
-
08-06-2002, 01:48 PM #5Web Hosting Master
- Join Date
- Mar 2001
- Posts
- 2,057
Every host has to limit concurrent connections to mySQL on shared servers, 45 connections is generous.
-
08-06-2002, 01:54 PM #6Web Hosting Master
- Join Date
- Jan 2002
- Location
- Scotland, UK
- Posts
- 2,688
On the VO V650 Plan they allow 100 concurrent connections
-
08-06-2002, 02:49 PM #7Web Hosting Master
- Join Date
- Feb 2002
- Posts
- 2,120
go dedicated - you will have full control over how many concurrent connections can access mysql at the same time
-
08-06-2002, 03:42 PM #8Newbie
- Join Date
- Aug 2002
- Posts
- 5
lol, too bad my budget is <$15 a month, I just want to know what kind of traffic 45 concurrent connections can handle. I know it really depends on what kind of site im running and how its scripted. My site is a customizable start page, with a calender organizer, news, weather. Would 45 concurrent connections handle between 1k-10k visitors a day?
Shawn
-
08-06-2002, 03:51 PM #9Web Hosting Master
- Join Date
- Jan 2001
- Location
- Illinois, USA
- Posts
- 7,175
just make sure that you close your sql connections after the page is done loading..that's how you can max your "visitor count"