MySQL Governor high CPU usage

[sunmacet]

After a while MySQL Governor (db_governor) takes almost 100% of CPU most of the time

[sunmacet]

After MySQL Governor has been running for a while it takes quickly almost 100% CPU most of the time.

From top:
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
927778 root 18 0 168m 16m 8340 S 98.2 0.1 452:23.54 db_governor

Version info:
governor-mysql-1.0-39
mysql-5.5.32-cll-lve

Is this normal and expected?

We have tried --lve-mode off,single,abuser etc. but these produces same results.

We can see that MySQL CPU usage is lower but the db_governor CPU usage negates this benefit and even make it worse.

Thank you for any help or info about this.

[alexey.com.s]

Hello,

Change please this string in /etc/container/mysql-governor.xml:
<restrict level1="60s" level2="15m" level3="1h" level4="1d" timeout="1h" log="/var/log/dbgovernor-restrict.log" user_max_connections="30"></restrict>
to
<restrict level1="60s" level2="15m" level3="1h" level4="1d" timeout="1h" log="/var/log/dbgovernor-restrict.log" user_max_connections="0"></restrict>

this is mode without "flush privileges". It should help.

and restart governor:
service db_governor restart

if this will not help, write please to our support system - http://helpdesk.cloudlinux.com/

[sunmacet]

Thank you. This has helped some but still the CPU usage is most of the time over 70%.

The db_governor seems to take even more CPU time than MySQL...

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
69846 root 20 0 179m 17m 8340 S 71.1 0.1 301:52.83 db_governor
761919 mysql 15 0 816m 440m 6564 S 16.0 2.8 245:02.21 mysqld

[alexey.com.s]

Hello,

can you describe trouble in http://helpdesk.cloudlinux.com/. I need more deep investigation of the trouble.

[tony]

Weve updated our ticket about the governor with information about this issue. Weve seen the governor when locked up like this using an entire CPU and over 1gb of memory.