High load CPU and unknown processes

psytanium

Well-Known Member
Jun 6, 2014
297
16
68
Lebanon
cPanel Access Level
Root Administrator
Hello,

My server has been spiking a lot recently, over 1 week ago, CPU usage and OOM.
I receive notifications like :

  • The process “isc-worker0003” was terminated because the system is low on memory.
  • The process “java” was terminated because the system is low on memory.
  • The process “VM Thread” was terminated because the system is low on memory.
  • The process “Log4j2-TF-3-Asy” was terminated because the system is low on memory.
  • The process “MetricsHistoryH” was terminated because the system is low on memory.
  • The process “VM Periodic Tas” was terminated because the system is low on memory.
I don't know what are those processes, I searched the internet and found only few.

Any idea what to do ? My server is running veryyyyy sloowwww. Help please !

Thank you
 
Last edited:

bejbi

Well-Known Member
PartnerNOC
Jan 20, 2006
153
27
178
Poland
cPanel Access Level
DataCenter Provider
many load problems comes from Apache and Mysql
Check apache status in WHM (maybe yoy have not enougl child or DoS attack - looking like many, hunderts of "R")
Use lsapi for Php handler, not suphp

Run mysqltuner.pl script (download separatelly).
 

psytanium

Well-Known Member
Jun 6, 2014
297
16
68
Lebanon
cPanel Access Level
Root Administrator
see if this helps shed any light on the issue.

The documentation provide commands to list, for e.g. current CPU usage. But how to know why certain user or process is consuming ? I mean how to read those stats ?
 

psytanium

Well-Known Member
Jun 6, 2014
297
16
68
Lebanon
cPanel Access Level
Root Administrator
MySQL is the top consuming, how do I know why ? It wasn't like this 1 week ago, things were running smooth, despite I deleted many heavy accounts recently, I was expecting to lower the load on the server.
 

psytanium

Well-Known Member
Jun 6, 2014
297
16
68
Lebanon
cPanel Access Level
Root Administrator
I was checking the "Background Process Killer" and found some weird processes, i don't know what are those. like :

BitchX, bnc, eggdrop, generic-sniffers, guardservices, ircd, psyBNC, ptlink, services

Should I do something regarding it ?
 

psytanium

Well-Known Member
Jun 6, 2014
297
16
68
Lebanon
cPanel Access Level
Root Administrator
Running cat /etc/my.cnf
Results:


Code:
[mysqld]
innodb_file_per_table=1
default-storage-engine=MyISAM
performance-schema=0
max_allowed_packet=268435456
open_files_limit=40000
bind-address=127.0.0.1
sql-mode=strict_trans_tables,no_zero_in_date,no_zero_date,error_for_division_by_zero,no_auto_create_user,no_engine_substitution
 

cPRex

Jurassic Moderator
Staff member
Oct 19, 2014
7,519
1,027
313
cPanel Access Level
Root Administrator
Hey there!

If you are seeing MySQL using a lot of CPU, I like to run this command:

Code:
mysqladmin proc status
as that will show the MySQL queries on the server in real-time, allowing you to see if anything out of the ordinary is happening. You might see one account making a large number of queries, or queries going into a sleep state, but it should help you get pointed in the right direction.

The following support articles may be useful for this situation:


so I'd work through those and see if that gets you better details.
 

psytanium

Well-Known Member
Jun 6, 2014
297
16
68
Lebanon
cPanel Access Level
Root Administrator
Hey there!

If you are seeing MySQL using a lot of CPU, I like to run this command:

Code:
mysqladmin proc status
as that will show the MySQL queries on the server in real-time, allowing you to see if anything out of the ordinary is happening. You might see one account making a large number of queries, or queries going into a sleep state, but it should help you get pointed in the right direction.

The following support articles may be useful for this situation:


so I'd work through those and see if that gets you better details.
The command "mysqladmin proc status" returned a table of users with statistics, many are sleep.. what should i look for to identify the problem ?
 

cPRex

Jurassic Moderator
Staff member
Oct 19, 2014
7,519
1,027
313
cPanel Access Level
Root Administrator
You can run this command to get details on just the processes in the sleep state:

Code:
mysql -e "show processlist"|grep -c Sleep
Unless there is a very large number of those sleep processes, they usually do not impact the server's performance. We have posted this link a few times in other forums posts, and it's still relevant today:


but if the queries in the sleep state do cause slowness you may want to work with a professional MySQL administrator to have them examine the code of the site to permanently resolve the issue.
 

psytanium

Well-Known Member
Jun 6, 2014
297
16
68
Lebanon
cPanel Access Level
Root Administrator
You can run this command to get details on just the processes in the sleep state:

Code:
mysql -e "show processlist"|grep -c Sleep
Unless there is a very large number of those sleep processes, they usually do not impact the server's performance. We have posted this link a few times in other forums posts, and it's still relevant today:


but if the queries in the sleep state do cause slowness you may want to work with a professional MySQL administrator to have them examine the code of the site to permanently resolve the issue.
86 sleep processes considered high number ?