Facebook
TwitterI have continuously alerts from Server for MySql Service usage...even if CPU load is 0,16 or less but I'm not understanding how to fix it.
I increased alert from 25% (red) to 95% (95% of what? 1 cpu? 4 cpu? it's not clear) but nothing changed
.... any suggestion?
Thank you
health-config.xml
<service name="MySql" dbname="processes-MySql" monitor="true" maxvalue="1000000">
<alarm level="red" threshold="95" type="percent"/>
<alarm level="yellow" threshold="75" type="percent"/>
</service>
TOP (same as log)
Server health parameter "Services > MySQL CPU usage" changed its status from "green" to "red".
top - 18:49:16 up 4 days, 9:37, 1 user, load average: 0.16, 0.30, 0.28
Tasks: 163 total, 1 running, 161 sleeping, 0 stopped, 1 zombie
Cpu(s): 4.4%us, 1.2%sy, 0.3%ni, 91.7%id, 2.4%wa, 0.0%hi, 0.0%si, 0.0%st
Mem: 8067556k total, 7441728k used, 625828k free, 255856k buffers
Swap: 4193276k total, 50292k used, 4142984k free, 6051636k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
18931 mysql 20 0 1431m 233m 7508 S 20.3 3.0 155:53.66 mysqld
19569 apache 20 0 346m 23m 3768 S 3.3 0.3 0:49.69 httpd
21007 admin2 20 0 193m 13m 8840 S 0.3 0.2 0:00.03 php-cgi
1 root 20 0 19280 1120 900 S 0.0 0.0 0:01.50 init
2 root 20 0 0 0 0 S 0.0 0.0 0:00.08 kthreadd
3 root 20 0 0 0 0 S 0.0 0.0 0:03.90 ksoftirqd/0
5 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kworker/0:0H
7 root RT 0 0 0 0 S 0.0 0.0 0:00.27 migration/0
8 root 20 0 0 0 0 S 0.0 0.0 0:00.00 rcu_bh
9 root 20 0 0 0 0 S 0.0 0.0 1:08.77 rcu_sched
10 root RT 0 0 0 0 S 0.0 0.0 0:00.29 migration/1
11 root 20 0 0 0 0 S 0.0 0.0 0:02.92 ksoftirqd/1
13 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kworker/1:0H
...
I increased alert from 25% (red) to 95% (95% of what? 1 cpu? 4 cpu? it's not clear) but nothing changed
.... any suggestion?
Thank you
health-config.xml
<service name="MySql" dbname="processes-MySql" monitor="true" maxvalue="1000000">
<alarm level="red" threshold="95" type="percent"/>
<alarm level="yellow" threshold="75" type="percent"/>
</service>
TOP (same as log)
Server health parameter "Services > MySQL CPU usage" changed its status from "green" to "red".
top - 18:49:16 up 4 days, 9:37, 1 user, load average: 0.16, 0.30, 0.28
Tasks: 163 total, 1 running, 161 sleeping, 0 stopped, 1 zombie
Cpu(s): 4.4%us, 1.2%sy, 0.3%ni, 91.7%id, 2.4%wa, 0.0%hi, 0.0%si, 0.0%st
Mem: 8067556k total, 7441728k used, 625828k free, 255856k buffers
Swap: 4193276k total, 50292k used, 4142984k free, 6051636k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
18931 mysql 20 0 1431m 233m 7508 S 20.3 3.0 155:53.66 mysqld
19569 apache 20 0 346m 23m 3768 S 3.3 0.3 0:49.69 httpd
21007 admin2 20 0 193m 13m 8840 S 0.3 0.2 0:00.03 php-cgi
1 root 20 0 19280 1120 900 S 0.0 0.0 0:01.50 init
2 root 20 0 0 0 0 S 0.0 0.0 0:00.08 kthreadd
3 root 20 0 0 0 0 S 0.0 0.0 0:03.90 ksoftirqd/0
5 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kworker/0:0H
7 root RT 0 0 0 0 S 0.0 0.0 0:00.27 migration/0
8 root 20 0 0 0 0 S 0.0 0.0 0:00.00 rcu_bh
9 root 20 0 0 0 0 S 0.0 0.0 1:08.77 rcu_sched
10 root RT 0 0 0 0 S 0.0 0.0 0:00.29 migration/1
11 root 20 0 0 0 0 S 0.0 0.0 0:02.92 ksoftirqd/1
13 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kworker/1:0H
...
