High Apache CPU usage and MySQL CPU usage

[DJHamil]

Hi,

Am kinda new to the Plesk area, and am struggling a little with getting the info i need to pin point
the issue causing high CPU load.

Its a DS with no Root access.
But have SSH via each domain installed.

Server Specs:


CPU GenuineIntel, Intel(R) Xeon(R) CPU E31270 @ 3.40GHz
Version Parallels Plesk Panel v11.0.9_build110120608.16 os_CentOS 6
OS CentOS 6.3 (Final)
RAM 16 GB

There is a few domains hosted, and i cannot figure out what domain is causing the Issue with High CPU Load.
and the logs am getting are only in Graph form, No use what so ever.

Load Average on CPU is around 10%
and RAM is around 2.5 - 3 GB

Was hoping for some Detailed Reports, What domain is causing the high load etc, and from there i can dig a bit deeper.

Here are some of the reports.

 

[DJHamil]

These are the logs from the Email i received.
Cut them down, but everything else on the process list has no memory or cpu usage.

Server health parameter "Services > MySQL CPU usage" changed its status from "green" to "red".

top - 11:25:48 up 11 days, 52 min, 0 users, load average: 0.15, 0.30, 0.38
Tasks: 239 total, 1 running, 238 sleeping, 0 stopped, 0 zombie
Cpu(s): 1.5%us, 0.1%sy, 0.6%ni, 97.4%id, 0.3%wa, 0.0%hi, 0.0%si, 0.0%st
Mem: 16324076k total, 15872100k used, 451976k free, 253932k buffers
Swap: 8232952k total, 1548k used, 8231404k free, 13144476k cached

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
742 equinox 30 10 188m 13m 7384 S 7.9 0.1 0:00.04 php-cgi
1910 mysql 20 0 3838m 179m 4888 S 2.0 1.1 660:24.87 mysqld
12888 apache 30 10 243m 13m 640 S 2.0 0.1 0:03.27 httpd
1 root 20 0 19356 1384 1152 S 0.0 0.0 0:01.62 init

And

Server health parameter "Services > Apache CPU usage" changed its status from "yellow" to "red".

top - 20:50:54 up 11 days, 10:17, 0 users, load average: 0.07, 0.36, 0.63
Tasks: 236 total, 1 running, 235 sleeping, 0 stopped, 0 zombie
Cpu(s): 1.4%us, 0.1%sy, 0.7%ni, 97.4%id, 0.4%wa, 0.0%hi, 0.0%si, 0.0%st
Mem: 16324076k total, 15861068k used, 463008k free, 253844k buffers
Swap: 8232952k total, 1548k used, 8231404k free, 13132732k cached

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
1910 mysql 20 0 3838m 187m 4888 S 15.9 1.2 687:32.35 mysqld
32048 premhull 30 10 190m 15m 7640 S 9.9 0.1 0:00.89 php-cgi
32046 premhull 30 10 190m 14m 7468 S 7.9 0.1 0:00.28 php-cgi
1 root 20 0 19356 1384 1152 S 0.0 0.0 0:01.62 init

 

[Kanagaraj]

We have the same problem any solution??

 

[Kanagaraj]

Mysql service take cpu high usage

Dear Friends,
the following commends take high cpu usage on our centos 6.5 server

13326 mysql 58.7 % /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --log-e ...

/usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --log-error=/var/log/mysqld.log --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/lib/mysql/mysql.sock


Please guide me to solve this error

note : this will happens on last 4 days only

Kanagaraj

http://forum.parallels.com/showthre...rvice-take-cpu-high-usage&p=724925#post724925