CPU Usage very high

A

Attiqfsd

Verified User
Joined
Dec 14, 2021
Messages
6
I have a personal DA License installed on a 6CPU 8GB RAM VPS, and it has been working great. Today I received a bunch of "The system load avg is 10+" emails.

When I checked the running processes using htop, I got a lot of these

Code: 
lsphp:ains/mydomain.tld/private_html/index.phto_avoid_overwrite_important_env

MySQL CPU usage is also very high with tons of same query
Code: 
SELECT post_id FROM wp_postmeta WHERE meta_key='_wp_attached_file' AND meta_value LIKE '%same-file-name-1.png%'

It's a Ubuntu 20.04 LTS Server with DirectAdmin Latest version (personal license)
Openlitespeed + lsphp 7.4

The server only has 2 simple WordPress sites without woocommerce. LSCache plugin installed and configured in both sites.
 
check access and error logs, maybe some type of primitive dDOS/flood from one IP or some bot (check useragent)
 
Check also log files as here in this topic.
I asked again to be sure for that

MYSQL high CPU usage

whats about to block 194.5.73.0/24 in CSF ? .. btw this ip seems to belong to a security company - www.divd.nl , maybe they playing with your server? I blocked that ip and seems cpu overload is gone. i should check cpu again tomorrow because highest load was on the around 10 ~12 AM
forum.directadmin.com forum.directadmin.com

And check you WP plugins, try disable short if problem still exist given link is only a example of same kind of message...
github.com

Query with meta_value slowing down database · Issue #10195 · Yoast/wordpress-seo

I've read and understood the contribution guidelines. I've searched for any related issues and avoided creating a duplicate issue. Please give us a description of what happened. We had to deactivat...
github.com github.com
 
Last edited:
ikkeben said:
Check also log files as here in this topic.
I asked again to be sure for that

MYSQL high CPU usage

whats about to block 194.5.73.0/24 in CSF ? .. btw this ip seems to belong to a security company - www.divd.nl , maybe they playing with your server? I blocked that ip and seems cpu overload is gone. i should check cpu again tomorrow because highest load was on the around 10 ~12 AM
forum.directadmin.com forum.directadmin.com

And check you WP plugins, try disable short if problem still exist given link is only a example of same kind of message...
github.com

Query with meta_value slowing down database · Issue #10195 · Yoast/wordpress-seo

I've read and understood the contribution guidelines. I've searched for any related issues and avoided creating a duplicate issue. Please give us a description of what happened. We had to deactivat...
github.com github.com
Click to expand...
Which log files should I check to find the IP address? I don't even have Yoast SEO installed on either of the sites
 
Attiqfsd said:
Which log files should I check to find the IP address? I don't even have Yoast SEO installed on either of the sites
Click to expand...
I gave the links only as example! ( So not for that ip / only that ip and also not for that one yoast problem there wich is old)
Don't know WP and don't have a cristall BaLl.

In topics of the DA forum link are examples for the log files and so on

But you posted a WP problem in start , so you have to look there i guess, and ask in WP forum, also i did mentioned plugins disable to check, if it started then you should know what has changed at that moment if possible, so a update WP , enabled or changed plugin , changed consfig / setting and so on
MySQL CPU usage is also very high with tons of same query


Code:

SELECT post_id FROM wp_postmeta WHERE meta_key='_wp_attached_file' AND meta_value LIKE '%same-file-name-1.png%'
Click to expand...
 
Last edited:
You must log in or register to reply here.
Back
Top