Forums Archive Index > Members' Forum Related Questions > 15 the magic number?
Date: 4 Dec 2006 8:48 pm
We Hit a new high, 15 last night. (Dec 3rd 2006)
Which brings up a point.
I'm told by the tech's that run around the server room that 15 is a magic limit for the number of logins for the forum with our hosting.
After 15, comes 16 naturally.
When Ms or Mr # 16 try's to login and be number 16, they will get a plain white screen with a few lines of basic black writing that looks like code, that will say something about a mysql error about getting a connection or too many connections. I don't remember the exact phrase.
I have had no way to test this. I don't know if "guests" count. So if it happens... take note at the bottom while your not logged in to see how many are, before you get worried something is wrong and you couldn't login. Let me know about it and the numbers you saw on the bottom of the main page of the forum.
"In total there are 10 users online :: 4 Registered, 1 Hidden and 5 Guests "
Hidden and Registered add up to the total logged in members.
So 5 members and 5 guests.
We don't expect it to happen often, but we are looking at alternatives to be better positioned for more growth.
Date: 5 Dec 2006 2:00 pm
After some research and speaking with another tech,
It's not that we are limited to logins or a total number of people, but by the number of "sessions" that can go in at the same time into the database server.
Read or write.
So we can have 50 members logged in and 50 guests, if the 50 members logged in at different times and every one is doing nothing.
But as soon as they start reading, looking things up, they are sending a request into the database server. That request is a session. The click to see the contents of a thread is a session. Each action is a session. A "Post" click, a Preview" click, each one is a "session".
That request to the database server and response from the database server is a session.
If all 100 people do things a second apart, then it's one session at a time and all will get what they wanted. Up to 15 things can be done at the same EXACT same time.
It's like having 15 toll booths to go through.
The database software will throttle it and play traffic cop and only let 15 "sessions" work at the EXACT same time.
So you may see an error as mentioned if things get too out of control or just see a delay from other accounts sharing the recources on our shared server.
At this time, the delays we see every once in a while is from other traffic of other acccounts hogging resources on the same shared database server we are on.
Date: 11 Dec 2006 10:44 pm
Thanks Bob for that insight! I enjoyed the read and it makes total sence to me! I can't wait for the new server, any ideas on how long it will take to get one? If you don't mind me asking, how much revenue do you get from the ads?
Date: 11 Dec 2006 11:11 pm
Termy,
We don't have to move this second.
But our growth over the last year and this fall just tells us we have to be ready. So we've been making plans.
As we see it now, the move we are thinking about, would be within our present host.
So once things are set up, the actual move would be of the database for the forum. And it "should" take less than a day.
For the time being, the website actually doesn't move.
For the forum, most of the grunt takes place on the database server.