Previous Thread
Next Thread
Print Thread
Rate Thread
Joined: Mar 2002
Posts: 193
Member
Member
Offline
Joined: Mar 2002
Posts: 193
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
Joined: Dec 2000
Posts: 1,471
Addict
Addict
Offline
Joined: Dec 2000
Posts: 1,471
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.

Joined: Mar 2002
Posts: 193
Member
Member
Offline
Joined: Mar 2002
Posts: 193
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?

Joined: Dec 2000
Posts: 1,471
Addict
Addict
Offline
Joined: Dec 2000
Posts: 1,471
[]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

Joined: Mar 2002
Posts: 193
Member
Member
Offline
Joined: Mar 2002
Posts: 193
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
Joined: Dec 2000
Posts: 1,471
Addict
Addict
Offline
Joined: Dec 2000
Posts: 1,471
No, from my experience, you can handle about 500 users online with 100 concurrent mysql connections.

Joined: Mar 2002
Posts: 193
Member
Member
Offline
Joined: Mar 2002
Posts: 193
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?

Joined: Dec 2000
Posts: 1,471
Addict
Addict
Offline
Joined: Dec 2000
Posts: 1,471
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.

Joined: Mar 2002
Posts: 193
Member
Member
Offline
Joined: Mar 2002
Posts: 193
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...


Link Copied to Clipboard
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
bluehost
InterServer
Visit us on Facebook
Member Spotlight
Bill B
Bill B
Issaquah, WA
Posts: 87
Joined: December 2001
Forum Statistics
Forums63
Topics37,574
Posts293,926
Members13,850
Most Online5,166
Sep 15th, 2019
Today's Statistics
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
Top Posters
AllenAyres 21,079
JoshPet 10,369
LK 7,394
Lord Dexter 6,708
Gizmo 5,833
Greg Hard 4,625
Top Posters(30 Days)
Top Likes Received
isaac 82
Gizmo 20
Brett 7
WebGuy 2
Morgan 2
Top Likes Received (30 Days)
None yet
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2024 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20240506)