View Full Version : MySQL Connections=100 ???
sleepbirdcyp
Tue 19th Mar '02, 1:44am
I saw a plan at VO, it says MySQL Connections=100 !
what's that mean ? means the max mysql query = 100???
If I get 200 people online at the same time!
MySQL Connections=100 is enough to use ???
Help me plz!
many thx
:)
eva2000
Tue 19th Mar '02, 2:39am
max_connections is the maximum simultaneous connections to mysql server and is a server wide variable. simultaneous as in the exact same second.
VO has max_connections=1024 server wide
VO has a max_user_connections=45 or 100 (for the v650 plan) simultaneous connections specific to each user (each account you have with VO)
now vB's current active users (CAU) operates on a default 15 min timed cookie.. so what you see on CAU is total members + guests who have viewed your vB for the last 15 mins.
if you turn off pconnects in your vB config.php file you will be able to prevent the max_user_connection error message but that all depends on the activity on your forum, since CAU doesn't really reflect or equal max_connections or max_user_connections
in other words the more simultaneous/concurrent activity in a shorter time span on your forum, the more likely you'll hit the 2 max_connection and max_user_connections limit (if pconnects are off)..
sleepbirdcyp
Tue 19th Mar '02, 4:31am
Thank you eva2000 :)
but still got confused!
anyway
is the V650 plan enough for 200 member online at the same time?
thank you !
eva2000
Tue 19th Mar '02, 5:31am
Originally posted by sleepbirdcyp
Thank you eva2000 :)
but still got confused!
anyway
is the V650 plan enough for 200 member online at the same time?
thank you ! on the default 15 min cookie timeout you should be able to get 100 - 200 members online but with those numbers you should really be getting a dedicated server
vBulletin® v3.8.0 Release Candidate 1, Copyright ©2000-2008, Jelsoft Enterprises Ltd.