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 offWhat 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).