Concurrent mysql connections

[Ramon E Navas R]

I have a dedicated Cpanel server and I want to lower the number of simultaneous connections for each user to 25.

How is it done?

Thank you

 

[cPRex]

Hey there! There's no way to do this unless you're using CloudLinux with the MySQL Governor tool. Just cPanel alone doesn't have these type of limits in place.

You can read more about MySQL Governor here: CloudLinux - Restricting MySQL usage resources with MySQL Governor - CloudLinux

 

[Ramon E Navas R]

Thanks for the reply.

 

[cPRex]

You're welcome!

 

[bellwood]

Would the following not work in /etc/my.cnf:

max_connections = 500
max_user_connections = 25

...where 500 would be the maximum connection limit to the daemon (whatever you deem appropriate for your deployment) and 25 would be the max connections per user:

REF: MySQL :: MySQL 5.7 Reference Manual :: 5.1.7 Server System Variables

If you didn't need this to be ubiquitous for the entire server, you could also limit per-user:

ALTER USER 'specificUser'@'localhost' WITH MAX_USER_CONNECTIONS 25;

REF: MySQL :: MySQL 5.7 Reference Manual :: 6.2.16 Setting Account Resource Limits