With MySQL governor we can set the limits of LVE for MySQL users and its provided by CloudLinux.
You can use below command to install MySQL governor package:
Now we have to select the MySQL version and version should be one of the below:
MariaDB:
mariadb100, mariadb101, mariadb102, mariadb103
MySQL:
mysql56, mysql57, mysql80
Now you have to install MySQL version with below command:
After selecting the version you can install MySQL Governor:
You can use below command to install MySQL governor package:
Code:
yum install governor-mysql
Code:
/usr/share/lve/dbgovernor/mysqlgovernor.py --mysql-version=$MYSQL_VERSIONmariadb100, mariadb101, mariadb102, mariadb103
MySQL:
mysql56, mysql57, mysql80
Now you have to install MySQL version with below command:
After selecting the version you can install MySQL Governor:
Code:
/usr/share/lve/dbgovernor/mysqlgovernor.py –install