MySQL Governor high CPU usage
Forum
  1. Forums
  2. General
  3. General Discussion
  1. Sun Macet
  2. Monday, 25 November 2013
  3.  Subscribe via email
After a while MySQL Governor (db_governor) takes almost 100% of CPU most of the time
Rate this post:
  1. 25.11.2013 06:11:05
  2. # 1
Sun Macet Accepted Answer
Posts: 3
Joined: 25.11.2013
0
Votes
Undo
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.
  1. 25.11.2013 07:11:50
  2. # 2
Alexey Berezhok Accepted Answer
Posts: 35
Joined: 20.04.2010
0
Votes
Undo
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/
  1. 26.11.2013 05:11:50
  2. # 3
Sun Macet Accepted Answer
Posts: 3
Joined: 25.11.2013
0
Votes
Undo
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
  1. 26.11.2013 08:11:18
  2. # 4
Alexey Berezhok Accepted Answer
Posts: 35
Joined: 20.04.2010
0
Votes
Undo
Hello,

can you describe trouble in http://helpdesk.cloudlinux.com/. I need more deep investigation of the trouble.
  1. 27.11.2013 16:11:15
  2. # 5
Tony Baird Accepted Answer
Posts: 10
Joined: 25.07.2010
0
Votes
Undo
We've updated our ticket about the governor with information about this issue.  We've seen the governor when locked up like this using an entire CPU and over 1gb of memory.
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!
Guest
Submit Your Response
Upload files or images for this discussion by clicking on the upload button below. Supports gif,jpg,png,zip,rar,pdf
• Insert • Remove Upload Files (Maximum File Size: 2 MB)
Captcha
To protect the site from bots and unauthorized scripts, we require that you enter the captcha codes below before posting your question.