High CPU Usage

[vinzleon]

Hi all I have been noticing over the past several days that my server is running high cpu loads.
It seems mysql, nobody, and mailman takes a lot of resource.
Anybody help me ?

Here is my top -c

19319 mysql     20   0  567m 283m 5020 S 47.7  7.3 165:08.57 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib/mysql/plugin --user=mysql -
15801 itcindo   20   0     0    0    0 Z 26.8  0.0   0:00.81 [php] <defunct>
15830 itcindo   20   0  108m  25m 7912 R 24.5  0.6   0:00.74 /usr/bin/php /home/itcindo/public_html/index.php
15834 sumberta  20   0     0    0    0 Z  3.6  0.0   0:00.11 [php] <defunct>
15823 neutronp  20   0     0    0    0 Z  3.0  0.0   0:00.09 [php] <defunct>
15799 tokoasem  20   0     0    0    0 Z  2.0  0.0   0:00.07 [php] <defunct>
15551 mailnull  20   0 14992 5868 2948 S  1.7  0.1   0:00.05 /usr/sbin/exim -Mc 1aXhMs-0003kA-G8
14080 cpanelco  20   0  7144 4748 4348 S  1.0  0.1   7:45.26 /usr/local/cpanel/3rdparty/sbin/p0f -i any -u cpanelconnecttrack -d -s /var/cpanel/userhomes/cpanelconnect
14973 root      20   0  3124 1424  868 R  0.7  0.0   0:00.36 top -c
  913 root      20   0     0    0    0 S  0.3  0.0   0:31.21 [jbd2/sda8-8]
1521 named     20   0 96840  16m 1548 S  0.3  0.4   9:20.55 /usr/sbin/named -u named
2732 mailman   20   0 14564 8456 3136 S  0.3  0.2   0:00.29 /usr/local/cpanel/3rdparty/bin/python -S /usr/local/cpanel/3rdparty/mailman/scripts/driver subscribe
2743 mailman   20   0 14564 8452 3136 S  0.3  0.2   0:00.29 /usr/local/cpanel/3rdparty/bin/python -S /usr/local/cpanel/3rdparty/mailman/scripts/driver subscribe
5241 nobody    20   0 21944 8596 1524 S  0.3  0.2   0:00.17 /usr/local/apache/bin/httpd -k start
5664 mailman   20   0 14564 8456 3136 S  0.3  0.2   0:00.59 /usr/local/cpanel/3rdparty/bin/python -S /usr/local/cpanel/3rdparty/mailman/scripts/driver subscribe
8715 nobody    20   0 22072 8772 1512 S  0.3  0.2   0:00.14 /usr/local/apache/bin/httpd -k start
10097 nobody    20   0 21944 8568 1516 S  0.3  0.2   0:00.11 /usr/local/apache/bin/httpd -k start
12368 mailman   20   0 14564 8456 3136 S  0.3  0.2   0:00.87 /usr/local/cpanel/3rdparty/bin/python -S /usr/local/cpanel/3rdparty/mailman/scripts/driver subscribe
14563 mailnull  20   0 13920 5212 3612 S  0.3  0.1   0:00.20 /usr/sbin/exim -bd -q1h -oP /var/spool/exim/exim-daemon.pid
15197 mailman   20   0 14560 8452 3136 S  0.3  0.2   0:00.50 /usr/local/cpanel/3rdparty/bin/python -S /usr/local/cpanel/3rdparty/mailman/scripts/driver subscribe
15243 mailnull  20   0 13892 3468 2424 S  0.3  0.1   0:00.18 /usr/sbin/exim -bd -q1h -oP /var/spool/exim/exim-daemon.pid
17990 nscd      20   0  239m 2072 1008 S  0.3  0.1   0:31.54 /usr/sbin/nscd
18350 root      20   0 18288 7728 1620 S  0.3  0.2   1:06.93 lfd - sleeping
20131 mailman   20   0 14564 8456 3136 S  0.3  0.2   0:00.79 /usr/local/cpanel/3rdparty/bin/python -S /usr/local/cpanel/3rdparty/mailman/scripts/driver subscribe
25010 mailman   20   0 14556 8448 3136 S  0.3  0.2   0:00.39 /usr/local/cpanel/3rdparty/bin/python -S /usr/local/cpanel/3rdparty/mailman/scripts/driver subscribe
28481 mailman   20   0 14564 8456 3136 S  0.3  0.2   0:00.69 /usr/local/cpanel/3rdparty/bin/python -S /usr/local/cpanel/3rdparty/mailman/scripts/driver subscribe
30772 mailman   20   0 14564 8452 3136 S  0.3  0.2   0:01.06 /usr/local/cpanel/3rdparty/bin/python -S /usr/local/cpanel/3rdparty/mailman/scripts/driver subscribe

 

[SysSachin]

Hi,

You can check the MySQL process using below command so that you will get idea which database causing the high load.

[root ~ ]# mysqladmin proc

 

[syslint]

The given log doesn't show much information. can you give the following,

1) Are you on a VPS , if so what technology
2) Can you give your server hardware specifications ?
3) What is the disk I/o ?

 

[cPanelMichael]

Hello

The following thread is a good place to start:

Troubleshooting high server loads on Linux servers

Thank you.

 

[vinzleon]

The given log doesn't show much information. can you give the following,

1) Are you on a VPS , if so what technology
2) Can you give your server hardware specifications ?
3) What is the disk I/o ?

Hy sislint,
my server not on aVPS

this my server informastion

 Server Information

Processor Information
Total processors: 4
Processor #1
Vendor
GenuineIntel
Name
Intel(R) Xeon(R) CPU X3430 @ 2.40GHz
Speed
2399.712 MHz
Cache
8192 KB
Processor #2
Vendor
GenuineIntel
Name
Intel(R) Xeon(R) CPU X3430 @ 2.40GHz
Speed
2399.712 MHz
Cache
8192 KB
Processor #3
Vendor
GenuineIntel
Name
Intel(R) Xeon(R) CPU X3430 @ 2.40GHz
Speed
2399.712 MHz
Cache
8192 KB
Processor #4
Vendor
GenuineIntel
Name
Intel(R) Xeon(R) CPU X3430 @ 2.40GHz
Speed
2399.712 MHz
Cache
8192 KB

Memory Information
Memory: 3967736k/5767168k available (4368k kernel code, 186488k reserved, 2440k data, 508k init, 3248784k highmem)


Physical Disks
sd 1:0:1:0: [sdc] 976773168 512-byte logical blocks: (500 GB/465 GiB)
sd 1:0:1:0: [sdc] 4096-byte physical blocks
sd 1:0:0:0: [sdb] 1953525168 512-byte logical blocks: (1.00 TB/931 GiB)
sd 1:0:0:0: [sdb] 4096-byte physical blocks
sd 0:0:0:0: [sda] 1953525168 512-byte logical blocks: (1.00 TB/931 GiB)
sd 0:0:0:0: [sda] 4096-byte physical blocks
sd 1:0:0:0: [sdb] Write Protect is off
sd 1:0:0:0: [sdb] Mode Sense: 00 3a 00 00
sd 1:0:0:0: [sdb] Write cache: enabled, read cache: enabled, doesn't support DPO or FUA
sd 1:0:1:0: [sdc] Write Protect is off
sd 1:0:1:0: [sdc] Mode Sense: 00 3a 00 00
sd 1:0:1:0: [sdc] Write cache: enabled, read cache: enabled, doesn't support DPO or FUA
sd 0:0:0:0: [sda] Write Protect is off
sd 0:0:0:0: [sda] Mode Sense: 00 3a 00 00
sd 0:0:0:0: [sda] Write cache: enabled, read cache: enabled, doesn't support DPO or FUA
sd 1:0:1:0: [sdc] Attached SCSI disk
sd 1:0:0:0: [sdb] Attached SCSI disk
sd 0:0:0:0: [sda] Attached SCSI disk
sd 0:0:0:0: Attached scsi generic sg0 type 0
sd 1:0:0:0: Attached scsi generic sg1 type 0
sd 1:0:1:0: Attached scsi generic sg2 type 0


Current Memory Usage
             total       used       free     shared    buffers     cached
Mem:       3981284    3392284     589000         72     258164    2126872
-/+ buffers/cache:    1007248    2974036
Swap:      8191992     155448    8036544
Total:    12173276    3547732    8625544

Current Disk Usage
Filesystem      Size  Used Avail Use% Mounted on
/dev/sda5        20G  5.3G   14G  29% /
tmpfs           1.9G     0  1.9G   0% /dev/shm
/dev/sda1       194M   41M  144M  22% /boot
/dev/sda8       745G  183G  525G  26% /home
/dev/sda7       985M  502M  433M  54% /tmp
/dev/sda3        49G   12G   35G  26% /usr
/dev/sda2        97G   13G   79G  15% /var
/dev/sdb1       917G  755G  116G  87% /backup
/dev/sdc1       459G  235G  201G  54% /backup2

 

[syslint]

Vinzleon,
Looks like hardware configuration is normal. Now you need to do check the following ,
1) Mysql usage during the load time
2) apache usage during the load time
3) Disk I/o during the load time
4) Check if any backup is running on that time

 

[vinzleon]

Vinzleon,
Looks like hardware configuration is normal. Now you need to do check the following ,
1) Mysql usage during the load time
2) apache usage during the load time
3) Disk I/o during the load time
4) Check if any backup is running on that time

Can you tell me how I can check them all ?
I need the instructions.

 

[cPanelMichael]

I need the instructions.

You can review the URL that I posted in my earlier response for information on how to obtain those values.

Thank you.