High load CPU and unknown processes

[psytanium]

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

 

[keat63]

see if this helps shed any light on the issue.

Tutorial - Troubleshooting high server loads on Linux servers

Technical support analysts often receive tickets about high server loads. The cause of high server loads is very rarely attributed to defects in the cPanel software or the applications it installs. High server loads are something that should be...

forums.cpanel.net

 

[bejbi]

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]

see if this helps shed any light on the issue.

Tutorial - Troubleshooting high server loads on Linux servers

Technical support analysts often receive tickets about high server loads. The cause of high server loads is very rarely attributed to defects in the cPanel software or the applications it installs. High server loads are something that should be...

forums.cpanel.net

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 ?

 

[bejbi]

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 ?

use: htop

 

[psytanium]

use: htop

command not found

 

[bejbi]

command not found

yum install htop ?

 

[psytanium]

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]

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]

Running cat /etc/my.cnf
Results:

[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]

Hey there!

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

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:

How to diagnose high server loads

What is considered high memory, high CPU, or high I/O? You will want first to determine it is related to memory, CPU, or I/O; you can do this with the sar command. Before you understand the sar o...

support.cpanel.net

High load averages and MySQL's query cache

Symptoms MySQL is heavily using CPU time, and load averages are increasing due to MySQL's usage. Description High load averages and high MySQL's CPU time usage can occur for many different...

support.cpanel.net

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

 

[psytanium]

Hey there!

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

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:

How to diagnose high server loads

What is considered high memory, high CPU, or high I/O? You will want first to determine it is related to memory, CPU, or I/O; you can do this with the sar command. Before you understand the sar o...

support.cpanel.net

High load averages and MySQL's query cache

Symptoms MySQL is heavily using CPU time, and load averages are increasing due to MySQL's usage. Description High load averages and high MySQL's CPU time usage can occur for many different...

support.cpanel.net

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]

You can run this command to get details on just the processes in the sleep state:

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:

MySql Proccesslist filled with "Sleep" Entries leading to "Too many Connections"?

I'd like to ask your help on a longstanding issue with php/mysql connections. Every time I execute a "SHOW PROCESSLIST" command it shows me about 400 idle (Status: Sleep) connections to the database

stackoverflow.com

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]

You can run this command to get details on just the processes in the sleep state:

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:

MySql Proccesslist filled with "Sleep" Entries leading to "Too many Connections"?

I'd like to ask your help on a longstanding issue with php/mysql connections. Every time I execute a "SHOW PROCESSLIST" command it shows me about 400 idle (Status: Sleep) connections to the database

stackoverflow.com

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 ?

 

[cPRex]

That depends - can you see how old the oldest one is in the list? The "mysqladmin proc status" command gives the query time in one of the columns so you can see that.