MySQL Governor and users getting limited/restricted by max_user_connections

Symptoms

When using CloudLinux with MySQL Governor installed, you notice a user's max_user_connections gets set to 30 automatically.

Cause

When a user's LVE CPU limit reaches 400, MySQL Governor tries to throttle down the user by setting a low max_user_connections setting automatically.

Resolution

You can verify the restriction was placed by checking the DB Governor logs:

1. Access your server as the root user using SSH, or the Terminal in WHM.

2. Review the last lines of the DB Governor restriction log to see if the user has been listed:

   # tail /var/log/dbgovernor-restrict.log

3. You can remove a restriction from a user temporarily with the following command:

   # dbctl unrestrict $user

   Note: Replace $user with the cPanel username you wish to restrict.

   Note: This removes the restriction temporarily. If your user is continually getting restricted, you will need to review their CPU usage and address the cause for the restrictions directly.

Additional Information

Reviewing CloudLinux LVE statistic from the command line. (lveinfo)