connection simultané illimité

[hybrid56]

mysql simultaneous connection limit

Hello,

How to limit concurrent connections for some mysql package?
The default is unlimited?

 

[cPanelTristan]

Do you mean max_connections and max_user_connections variables for /etc/my.cnf file? If you set both, then MySQL will be limited for the maximum number of total MySQL connections on the server for max_connections and for the maximum number of database user connections per database for max_user_connections.

If you do revise or add those settings to /etc/my.cnf file, please ensure to restart MySQL upon changing / adding them.

 

[hybrid56]

In the file there

[mysqld]
set-variable = max_connections=500
log-slow-queries
safe-show-database

You advise which configuration for 200 accounts?
Server 4 core, 8GB ram

 

[cPanelTristan]

I would advise:

max_connections = 512
max_user_connections = 100

I'm selecting 512 if this is what you have set for WHM > Apache Configuration > Global Configuration area for the MaxClients setting there. Otherwise, you should use whatever for max_connections that would match that of MaxClients, since you cannot have more MySQL connections maximum than Apache connections maximum.

 

[hybrid56]

The following settings are invalid and were rejected:

maxclients: 512

 

[cPanelTristan]

Where did you receive this error message? MaxClients is an Apache setting rather than a MySQL setting.

 

[hybrid56]

Good evening,

I made screenshots.

http://img35.imageshack.us/img35/1130/cpanelo.jpg

http://img29.imageshack.us/img29/6749/cpanel2.jpg

 

[cPanelDon]

Good evening,

I made screenshots.

http://img35.imageshack.us/img35/1130/cpanelo.jpg

http://img29.imageshack.us/img29/6749/cpanel2.jpg

Please ensure the "ServerLimit" value is at least equal to "=" or greater than ">" the "MaxClients" value.

If you need MaxClients of 512, then please ensure that ServerLimit is 512 (or greater).