For your convenience, the above video has been transcribed below.
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.
Important! We strongly recommend you to create a full database backup including system tables before MySQL Governor installation.
Installation consists of two steps - installing governor-mysql itself and switching to MySQL packages provided with CloudLinux OS:
yum install governor-mysql
/usr/share/lve/dbgovernor/mysqlgovernor.py --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.
