Custom max_user_connections limit not sticking!
Hello,
I would like to increase the max_user_connections on a mysql server running CloudLinux. The default limit is 30.
I found this article from cPanel.
When I run this command to set it to 50
mysql -e "ALTER USER 'the_user'@'localhost' WITH MAX_USER_CONNECTIONS 50;"
it does work because I check if the limit has changed using this command:
mysql -e "SELECT user, host, max_user_connections FROM mysql.user WHERE user = 'the_user';"
The above command shows me that the limit for the user is no longer 30 but now 50.
However, after a short while, this resets back down to 30.
So I then thought maybe the CloudLinux MySQL governer is resetting it so I logged in to WHM and went to Plugins -> CloudLinux Manager -> Options -> MySQL Governer settings
I then changed the User maximum connections to 50
I then run this command again
mysql -e "SELECT user, host, max_user_connections FROM mysql.user WHERE user = 'the_user';"
but the limit is still 30 however, the setting in CloudLinux MySQL Governer is still set to 50. So at least that sticks.
So I then proceeded to again run this command thinking maybe it won't reset this time
mysql -e "ALTER USER 'the_user'@'localhost' WITH MAX_USER_CONNECTIONS 50;"
but lo and behold, the value resets again but at least the MySQL Governer setting remains in place.
As a side note, the /etc/my.cnf file has no reference in it for the max_user_connections so I guess its not that that could be resetting it.
How do I change this limit to MAKE it stick? Any advice is welcome.
-
Hey there! I reached out to the CloudLinux team about this issue and they recommended that you create a ticket with them directly on the issue so they can look into this, as they didn't have any other testing I could recommend remotely. If you're not seeing any helpful data in /var/log/dbgovernor-restrict.log I'd make that ticket and have them take a look!
0
Please sign in to leave a comment.
Comments
1 comment