Previous Thread
Next Thread
Print Thread
Rate Thread
Is this limiting my MAX amount of simultaneous users? #283032
01/11/2005 9:58 AM
01/11/2005 9:58 AM
Joined: Mar 2002
Posts: 207
C
Conrad Offline OP
Member
Conrad  Offline OP
Member
C

Joined: Mar 2002
Posts: 207
The "my.cnf" file contains just 3 lines, one of them being:

set-variable = max_connections=500

Is this limiting the number of users that can simultanously access my board?

We just broke the "Max users online was..." record with 531 simultanous users, but I take it that only 500 could have been connected at any given moment, and that the 531 is a result of the "Who's Online Timeframe" set to 30 minutes. Does this explanation seem correct?

Sponsored Links
Re: Is this limiting my MAX amount of simultaneous users? [Re: CHOELIN] #283033
01/11/2005 10:05 AM
01/11/2005 10:05 AM
Joined: Dec 2000
Posts: 1,545
Germany
A
Astaran Offline
Addict
Astaran  Offline
Addict
A

Joined: Dec 2000
Posts: 1,545
Germany
No,

the value in the mysql configuration is related to the concurrent connections to the mysql server.
This number differs from the concurrent users online.
As you set, max users online uses a timeframe of x minutes while the max_connection value refers to a point of time.

So it's not limiting your max users online at the moment. If so, a mysql error will occur.

Re: Is this limiting my MAX amount of simultaneous users? [Re: -Fusion-] #283034
01/11/2005 10:44 AM
01/11/2005 10:44 AM
Joined: Mar 2002
Posts: 207
C
Conrad Offline OP
Member
Conrad  Offline OP
Member
C

Joined: Mar 2002
Posts: 207
OK, good stuff, thanks! So this isn't the setting that web hosts use to limit people's discussion forums to x amount of users at any given time?

What's the quickest way to check the max users online setting on my server?

Re: Is this limiting my MAX amount of simultaneous users? [Re: CHOELIN] #283035
01/14/2005 11:55 AM
01/14/2005 11:55 AM
Joined: Dec 2000
Posts: 1,545
Germany
A
Astaran Offline
Addict
Astaran  Offline
Addict
A

Joined: Dec 2000
Posts: 1,545
Germany
[]Conrad said:
OK, good stuff, thanks! So this isn't the setting that web hosts use to limit people's discussion forums to x amount of users at any given time?
[/]
Your web host can't restrict the number of users directly. With that limit, they can influence the number of concurrent connections to the mysql server. Other limitations are the bandwith or your account, the used hardware etc.

[]
What's the quickest way to check the max users online setting on my server? [/]
There's no quick way to do that.
There are many parameters, which influence this for example:

- CPU
- speed of hdd
- RAM
- used file system
- mysql configuration
- used webserver
- configuration of webserver
- number of mysql queries that are send by your forum software
- kind of mysql queries
- your board settings
- size of your database

Re: Is this limiting my MAX amount of simultaneous users? [Re: -Fusion-] #283036
01/16/2005 5:58 AM
01/16/2005 5:58 AM
Joined: Mar 2002
Posts: 207
C
Conrad Offline OP
Member
Conrad  Offline OP
Member
C

Joined: Mar 2002
Posts: 207
Thanks Astaran. The main thing that concerns me is a software-type of limit set on the server, like the concurrent connections limit. Mine is set to 500 which is the default, but since I'm on a dedicated server I can alter that to what I want.

Should I up this setting if I'm expecting 700+ simultaneous users online?

Sponsored Links
Re: Is this limiting my MAX amount of simultaneous users? [Re: CHOELIN] #283037
01/16/2005 6:32 AM
01/16/2005 6:32 AM
Joined: Dec 2000
Posts: 1,545
Germany
A
Astaran Offline
Addict
Astaran  Offline
Addict
A

Joined: Dec 2000
Posts: 1,545
Germany
No, from my experience, you can handle about 500 users online with 100 concurrent mysql connections.

Re: Is this limiting my MAX amount of simultaneous users? [Re: -Fusion-] #283038
01/16/2005 11:18 AM
01/16/2005 11:18 AM
Joined: Mar 2002
Posts: 207
C
Conrad Offline OP
Member
Conrad  Offline OP
Member
C

Joined: Mar 2002
Posts: 207
OK, many thanks for clearing this up. I take it this would be a problem if I had persistent connections on, right?

Speaking on this, is it worth enabling persistent connections if I have a dedicated server? Would this improve anything in any way?

Re: Is this limiting my MAX amount of simultaneous users? [Re: CHOELIN] #283039
01/16/2005 11:57 AM
01/16/2005 11:57 AM
Joined: Dec 2000
Posts: 1,545
Germany
A
Astaran Offline
Addict
Astaran  Offline
Addict
A

Joined: Dec 2000
Posts: 1,545
Germany
Unless you really know what you're doing, do not use persistant connections. There are some setups where persistant connections are useful, but in most cases, it's getting worser than better.

Re: Is this limiting my MAX amount of simultaneous users? [Re: -Fusion-] #283040
01/22/2005 7:16 AM
01/22/2005 7:16 AM
Joined: Mar 2002
Posts: 207
C
Conrad Offline OP
Member
Conrad  Offline OP
Member
C

Joined: Mar 2002
Posts: 207
Many thanks, I see that Jeremy's script also dishes out the following info: Max_used_connections

I understand this is linked to the setting "set-variable = max_connections=500" in my.cnf, right?

With 671 simultaneous users online Jeremy's script showed: Max_used_connections | 127

Guess there's no reason to bump up the 500 max connections then...


Donate Today!
Donate via PayPal

Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.

Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
Recommended Hosts
We have personally worked with, and recommend, the following Web Hosts:
· Stable Host
· Blue Host
· Interserver.net
Visit us on Facebook
Member Spotlight
Bill B
Bill B
Issaquah, WA
Posts: 84
Joined: December 2001
Show All Member Profiles 
Forum Statistics
Forums64
Topics37,467
Posts293,523
Members13,802
Most Online1,498
Mar 17th, 2017
Top Posters(All Time)
AllenAyres 25,587
JoshPet 11,330
Rick 8,373
LK 7,396
Lord Dexter 6,503
Gizmo 5,947
Greg Hard 5,533
Top Posters(30 Days)
isaac 1
Today's Statistics
Currently Online 937
Topics Created 0
Posts Made 0
Users Online 2
Birthdays 13
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2018 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 7.7.0
(Snapshot build 20181115.dev)
PHP: 5.4.45 Page Time: 0.038s Queries: 15 (0.011s) Memory: 3.2220 MB (Peak: 3.4056 MB) Data Comp: Zlib Server Time: 2018-12-14 07:48:44 UTC