СloudLinux Blog

Governor Improvements for CPU calculation

Written by Nikolay Petukhov | Dec 15, 2022 5:42:00 PM

In the 1.2-81 version of  MySQL Governor we provide improvements in the algorithm of calculation user CPU usage. New behavior helps to increase precision of resource distribution between server users. By default  the new type of  CPU usage calculation is tuned on.

Server administrator can turn on / off the new type of  CPU usage calculation by using next command 

dbctl --lve-improved-accuracy off

What is the impact of improvements?

The calculation of CPU usage has become more accurate, so the dbtop utility provides more correct information to the MySQL governor and it places  user’s requests to the LVE in a proper moment. And as a result, such improvements reduce the possibility of absorbing whole server resources by one user.    

 

The next possible outcome of calculation improvements is that some server users will become in need of MySQL Governor limits reconfiguration.

 

How to view the impact of improvements?

Let’s check the CPU usage charts from CloudLinux statistics (lve-stats). 

The new type of  CPU usage calculation is turned off.

In this case CPU usage by database could be less than LVE average CPU usage (blue chart is lower than green chart).

The new type of  CPU usage calculation is turned on.

In this case CPU usage by database become more similar to  LVE average CPU usage (blue chart and green chart on the sceen).