CloudLinux - Restricting MySQL usage resources with MySQL Governor
Our Products


Used by more than 4,000 hosting customers and partners, and powering over 20 million websites, CloudLinux products deliver stability and profitability for your Linux servers.

Easy to Get Started

Before you buy any of our products, you can try them free for 30 days.
They are very easy to install, and you can start using them within minutes.


Click here for pricing information and to buy. Please email sales if you have any questions.




For Your Linux VPS, Dedicated, and Shared Servers



MySQL governor is software to monitor and restrict MySQL usage in shared hosting environments. The monitoring is done via resource usage statistics per each MySQL thread.

Installation consists of two steps - installing governor-mysql package and switching to MySQL packages provided with CloudLinux OS:

yum install governor-mysql
/usr/share/lve/dbgovernor/ --install

MySQL Governor has multiple modes of operation: monitor only, place all users that have reached their limits into single predefined LVE. Always place mysql queries into users LVE, or place users into their LVE only when MySQL Governor limits have been reached which is the default mode of operation.

Default settings are suitable for most servers so we recommend to leave them as they are. Use dbctl list command to check MySQL Governor limits. From there you can obtain user’s cpu, read and write limits. Each limit consists of four values for different time ranges. By default these are 1 minute, 15 minutes, 1 hour and 1 day.

You can monitor MySQL usage with dbtop utility.

The tool dbctl is used to change mysql-governor configuration, for example changing cpu and read values for cltest3 user could be done with following command:

dbctl set cltest3 --cpu=150,100,70,50 --read=2048,1500,1000,800

Now check the limits with dbctl list:

dbctl list | grep cltest3

Admin can manually force any user to be restricted with dbctl restrict username command.

Users, whose queries exceed the limits set, are restricted by MySQL Governor. The list of such users can be obtained from dbctl list-restricted command. Also, admin can unrestrict any user with dbctl unrestrict command. In addition, you may protect any user from being restricted using dbctl ignore username command. 

  • Plesk
  • DirectAdmin
  • cPanel