PDA

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