difference between max_connection and max_user_connection

phpasks

New Member
Messages
145
Reaction score
0
Points
0
Are there any difference between max_connection and max_user_connection?


please help me.
That's problem my server very slow.
 

marshian

New Member
Messages
526
Reaction score
9
Points
0
I'm guessing:
max_connection: maximum amount of connections to the server
max_user_connection: maximum amount of connections one user can make to the server
 

phpasks

New Member
Messages
145
Reaction score
0
Points
0
I'm guessing:
max_connection: maximum amount of connections to the server
max_user_connection: maximum amount of connections one user can make to the server


Your guessing is right. But i also know this but
Max_connection is see this link = 25
http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html#option_mysqld_max_connections
The number of simultaneous client connections allowed.

Max_user_connection = 500
http://dev.mysql.com/doc/refman/5.0...ables.html#option_mysqld_max_user_connections
The maximum number of simultaneous connections allowed to any given MySQL account


Diff. between Client Connection & mysql connection.

Suppose,
This means 25 user at time connection
& 1 user 500 number of connection DB

then this equestion is 25 * 500 or only 25 concurrent connection allowed.

Please any one know this max_connection & max_user_connection write down here.

Asif Khalyani
 
Top