vinzleon

Registered
Feb 21, 2016
4
0
1
Indonesia
cPanel Access Level
Root Administrator
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
Code:
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

Well-Known Member
Aug 23, 2015
604
48
28
India
cPanel Access Level
Root Administrator
Twitter
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

Well-Known Member
Verifed Vendor
Oct 9, 2006
268
7
168
India
cPanel Access Level
Root Administrator
Twitter
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 ?
 

vinzleon

Registered
Feb 21, 2016
4
0
1
Indonesia
cPanel Access Level
Root Administrator
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
Code:
 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
 
Last edited by a moderator:

syslint

Well-Known Member
Verifed Vendor
Oct 9, 2006
268
7
168
India
cPanel Access Level
Root Administrator
Twitter
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

Registered
Feb 21, 2016
4
0
1
Indonesia
cPanel Access Level
Root Administrator
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.