Linux Whm Cpu Load very high

csofts

I need help how should i resolve this issue.I d'nt know why Cpu Load is coming very high. What should i do now.Check these Process are running on server.

Pid Owner Priority CPU % Memory % Command
1109 (Trace) (Kill) mysql 0 33.5 1.9 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --log-error=/var/lib/mysql/fastest.csofts.net.err --open-files-limit=19450 --pid-file=/var/lib/mysql/fastest.csofts.net.pid
15696 (Trace) (Kill) root 0 4.0 1.0 whostmgr2 - top ./top
1149 (Trace) (Kill) root 0 0.6 4.3 /usr/local/cpanel/3rdparty/bin/clamd
1194 (Trace) (Kill) root 0 0.1 0.8 /usr/local/cpanel/3rdparty/perl/514/bin/spamd -d --allowed-ips=127.0.0.1 --pidfile=/var/run/spamd.pid --max-children=3 --max-spare=1
2275 (Trace) (Kill) root 0 0.1 0.1 tailwatchd
1499 (Trace) (Kill) root 0 0.0 0.7 spamd child
576 (Trace) (Kill) named 0 0.0 0.3 /usr/sbin/named -u named
995 (Trace) (Kill) root 0 0.0 0.2 lfd - sleeping
1806 (Trace) (Kill) root 0 0.0 0.2 cpsrvd (SSL) - waiting for connections
1863 (Trace) (Kill) root 0 0.0 0.2 cpdavd - accepting connections on 2077 and 2078
13658 (Trace) (Kill) root 0 0.0 0.2 whostmgrd - serving 119.154.87.211
15324 (Trace) (Kill) root 0 0.0 0.2 whostmgrd - serving 119.154.87.211
15325 (Trace) (Kill) root 0 0.0 0.2 whostmgrd - serving 119.154.87.211
1248 (Trace) (Kill) root 0 0.0 0.1 /usr/local/apache/bin/httpd -k start -DSSL
1284 (Trace) (Kill) root 0 0.0 0.1 /usr/local/cpanel/3rdparty/perl/514/sbin/munin-node
1300 (Trace) (Kill) root 0 0.0 0.1 /usr/local/cpanel/3rdparty/bin/perl /usr/local/cpanel/bin/leechprotect
1966 (Trace) (Kill) root 0 0.0 0.1 queueprocd - wait to process a task
12282 (Trace) (Kill) nobody 0 0.0 0.1 /usr/local/apache/bin/httpd -k start -DSSL
12316 (Trace) (Kill) nobody 0 0.0 0.1 /usr/local/apache/bin/httpd -k start -DSSL
12362 (Trace) (Kill) nobody 0 0.0 0.1 /usr/local/apache/bin/httpd -k start -DSSL
12419 (Trace) (Kill) nobody 0 0.0 0.1 /usr/local/apache/bin/httpd -k start -DSSL
12439 (Trace) (Kill) nobody 0 0.0 0.1 /usr/local/apache/bin/httpd -k start -DSSL
12440 (Trace) (Kill) nobody 0 0.0 0.1 /usr/local/apache/bin/httpd -k start -DSSL
12491 (Trace) (Kill) nobody 0 0.0 0.1 /usr/local/apache/bin/httpd -k start -DSSL
12513 (Trace) (Kill) nobody 0 0.0 0.1 /usr/local/apache/bin/httpd -k start -DSSL
12627 (Trace) (Kill) nobody 0 0.0 0.1 /usr/local/apache/bin/httpd -k start -DSSL
12711 (Trace) (Kill) nobody 0 0.0 0.1 /usr/local/apache/bin/httpd -k start -DSSL
15316 (Trace) (Kill) nobody 0 0.0 0.1 /usr/local/apache/bin/httpd -k start -DSSL
15336 (Trace) (Kill) nobody 0 0.0 0.1 /usr/local/apache/bin/httpd -k start -DSSL
15337 (Trace) (Kill) nobody 0 0.0 0.1 /usr/local/apache/bin/httpd -k start -DSSL
15358 (Trace) (Kill) nobody 0 0.0 0.1 /usr/local/apache/bin/httpd -k start -DSSL
15359 (Trace) (Kill) nobody 0 0.0 0.1 /usr/local/apache/bin/httpd -k start -DSSL
15390 (Trace) (Kill) nobody 0 0.0 0.1 /usr/local/apache/bin/httpd -k start -DSSL
1 (Trace) (Kill) root 0 0.0 0.0 init
2 (Trace) (Kill) root 0 0.0 0.0 [kthreadd/102]
3 (Trace) (Kill) root 0 0.0 0.0 [khelper/102]
129 (Trace) (Kill) root -4 0.0 0.0 /sbin/udevd -d
563 (Trace) (Kill) root 0 0.0 0.0 /sbin/rsyslogd -i /var/run/syslogd.pid -c 5
1011 (Trace) (Kill) root 0 0.0 0.0 /usr/sbin/sshd
1026 (Trace) (Kill) root 0 0.0 0.0 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/fastest.csofts.net.pid
1132 (Trace) (Kill) root 0 0.0 0.0 /usr/sbin/dovecot
1140 (Trace) (Kill) dovenull 0 0.0 0.0 dovecot/pop3-login
1141 (Trace) (Kill) dovenull 0 0.0 0.0 dovecot/imap-login
1142 (Trace) (Kill) dovecot 0 0.0 0.0 dovecot/anvil
1143 (Trace) (Kill) root 0 0.0 0.0 dovecot/log
1145 (Trace) (Kill) dovenull 0 0.0 0.0 dovecot/pop3-login
1146 (Trace) (Kill) dovenull 0 0.0 0.0 dovecot/imap-login
1147 (Trace) (Kill) root 0 0.0 0.0 dovecot/config
1148 (Trace) (Kill) dovecot 0 0.0 0.0 dovecot/auth
1156 (Trace) (Kill) mailnull 0 0.0 0.0 /usr/sbin/exim -bd -q60m
1255 (Trace) (Kill) root 0 0.0 0.0 pure-ftpd (SERVER)
1257 (Trace) (Kill) root 0 0.0 0.0 /usr/sbin/pure-authd -s /var/run/ftpd.sock -r /usr/local/cpanel/bin/pureauth
1266 (Trace) (Kill) root 0 0.0 0.0 crond
1351 (Trace) (Kill) root 0 0.0 0.0 /usr/sbin/atd
1741 (Trace) (Kill) root 0 0.0 0.0 cPhulkd - processor
2536 (Trace) (Kill) root 18 0.0 0.0 cpanellogd - sleeping for logs
2610 (Trace) (Kill) root 0 0.0 0.0 /sbin/mingetty console
2614 (Trace) (Kill) root 0 0.0 0.0 /sbin/mingetty tty2
12588 (Trace) (Kill) uniquewa 0 0.0 0.0 [php]
12597 (Trace) (Kill) nobody 0 0.0 0.0 [httpd]
14193 (Trace) (Kill) root 0 0.0 0.0 pure-ftpd (IDLE)
14194 (Trace) (Kill) root 0 0.0 0.0 pure-ftpd (PRIV)
15379 (Trace) (Kill) socialhi 0 0.0 0.0 [php]
15697 (Trace) (Kill) root 0 0.0 0.0 /bin/ps -ewwo pid,uid,user,nice,pmem,pcpu,command

How can i resolve this issue i am waiting.

serverian

Run top -n1 and paste the output between tags < pre> and < /pre> (remove the space)

noosVPS

Wow.. too much garbled text to understand.. can you please reformat it properly or use pastebin or something?

csofts

@serverian said:
Run top -n1 and paste the output between tags < pre> and < /pre> (remove the space)

  PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND
 1109 mysql     20   0 2179m 127m 5640 S 57.8  2.1   8:23.73 mysqld
23018 uniquewa  20   0  203m  11m 7196 S  2.0  0.2   0:00.01 php
23022 uniquewa  20   0  203m  11m 7200 S  2.0  0.2   0:00.01 php
23027 uniquewa  20   0     0    0    0 Z  2.0  0.0   0:00.01 php 
    1 root      20   0 19236 1452 1212 S  0.0  0.0   0:00.03 init
    2 root      20   0     0    0    0 S  0.0  0.0   0:00.00 kthreadd/102
    3 root      20   0     0    0    0 S  0.0  0.0   0:00.00 khelper/102
  129 root      16  -4 10644  564  296 S  0.0  0.0   0:00.00 udevd
  563 root      20   0  243m 1468 1044 S  0.0  0.0   0:00.01 rsyslogd
  576 named     20   0  382m  19m 2592 S  0.0  0.3   0:00.38 named
  995 root      20   0 55244  12m 1372 S  0.0  0.2   0:00.82 lfd - sleeping
 1011 root      20   0 66620 1224  508 S  0.0  0.0   0:00.00 sshd
 1026 root      20   0 11308 1484 1224 S  0.0  0.0   0:00.00 mysqld_safe
 1132 root      20   0 19604 1112  824 S  0.0  0.0   0:00.00 dovecot
 1140 dovenull  20   0 42220 3156 2436 S  0.0  0.1   0:00.00 pop3-login
 1141 dovenull  20   0 42224 3228 2488 S  0.0  0.1   0:00.00 imap-login
 1142 dovecot   20   0 13308 1132  940 S  0.0  0.0   0:00.00 anvil

nexmark

When you login to WHM, Click Load Averages near the build number
Take a screenshot of that and share it with us

ErawanArifNugroho

Try to stop mysql+clamd+spamd for a moment, did the load reduced?

MSPNick

@csofts said:

MySQL is the one that's using most it looks like. Try and optimise the database?

Here are some tips.

http://www.openlogic.com/wazi/bid/195905/Tips-and-Tricks-to-Optimize-MySQL

csofts

I restart the Server Now load is coming low after some time this will increase automatic.after restart this is showing Load Averages: 3.76 3.67 5.07
When this will take some this will near by Load Averages: 76.4 67.4 50.07

noosVPS

1. Find out which table(s) are being accessed, and whether any of them are crashed or not
2. Optimize mysql (use any tuning script like mysqltuner or mysql primer if you are not pro with that)
3. Switch over to mariadb if not yet
4. Use SSD storage for /var/lib/mysql

serverian

You didn't paste the full output from top. Your wa% is probably around 20-30%. You are experiencing the high load because of the lack of IO. If this is a VPS, contact your host. If it's a dedicated, your drive maybe dying. Run smartctl reports and see.

csofts

@noosVPS said:
1. Find out which table(s) are being accessed, and whether any of them are crashed or not
2. Optimize mysql (use any tuning script like mysqltuner or mysql primer if you are not pro with that)
3. Switch over to mariadb if not yet
4. Use SSD storage for /var/lib/mysql

I install mysqltuner and mysql primer.let's see what's happened.

csofts

@serverian said:
You didn't paste the full output from top. Your wa% is probably around 20-30%. You are experiencing the high load because of the lack of IO. If this is a VPS, contact your host. If it's a dedicated, your drive maybe dying. Run smartctl reports and see.

OK i am using Dedicated Server But this is one Vps from dedicated.

csofts

@csofts said:
OK i am using Dedicated Server But this is one Vps from dedicated.

and one more thing also running other vps whm and cpanel on this dedicated server.but problem is creating only this server.

nexmark

It does to seem as if it's a Layer 7 flood on a single PHP File that's using MySQL


Provide us the screenshot of Process Manager under system health


Or just click load average near the top of WHM


Something like this isn't good (Customer of mine)



For that customer, I've installed Nginx on his VPS and did some rate limiting and rules on nginx to solve it


CloudLinux also helps in a shared hosting environment with other customers.

csofts

@nexmark said:
It does to seem as if it's a Layer 7 flood on a single PHP File that's using MySQL


Provide us the screenshot of Process Manager under system health


Or just click load average near the top of WHM


Something like this isn't good (Customer of mine)



For that customer, I've installed Nginx on his VPS and did some rate limiting and rules on nginx to solve it


CloudLinux also helps in a shared hosting environment with other customers.

i am sending you screenshot links.
1- http://prntscr.com/4a5w4k
2-http://prntscr.com/4a5wii
3-http://prntscr.com/4a5wo6

Check this and tell me solid solution

noosVPS

csofts said: i am sending you screenshot links. 1- http://prntscr.com/4a5w4k 2-http://prntscr.com/4a5wii 3-http://prntscr.com/4a5wo6

Check this and tell me solid solution

MySQL is responsible for the entire mess. Run the tuning scripts and implement the proposed changes in my.cnf values. Also like I said, check if you have any crashed db which might be resulting in heavy usage.

tomsfarm

The image indicates above that you are experiencing a Resource Shortage (Lack of CPU Resources)

Are you running this on a VPS?