Author Topic: Excessive resource usage....  (Read 691 times)

0 Members and 1 Guest are viewing this topic.

Offline
***
Excessive resource usage....
« on: January 15, 2025, 07:43:56 AM »
Hi,

The server is running Alma Linux 9, I periodically receive a mail message with the subject - Excessive resource usage: mysql (1142 (Parent PID:114 2)), what is the problem?

Thanks in advance!

BR
Venty

Offline
***
Re: Excessive resource usage....
« Reply #1 on: January 16, 2025, 12:43:21 AM »
Hi,

Show the whole message received by you.

Offline
*****
Re: Excessive resource usage....
« Reply #2 on: January 16, 2025, 05:12:21 AM »
You can tame these notices easily -- add to /etc/csf/csf.pignore
https://www.knownhost.com/kb/common-csf-lfd-false-positives-and-how-to-stop-the-notifications/

Offline
***
Re: Excessive resource usage....
« Reply #3 on: January 16, 2025, 07:08:02 AM »
Hi,

Show the whole message received by you.

Hi,

message:

Time: Thu Jan 16 09:01:25 2025 +0200
Account: mysql
Resource: Process Time
Exceeded: 73438 > 1800 (seconds)
Executable: /usr/libexec/mariadbd
Command Line: /usr/libexec/mariadbd --basedir=/usr
PID: 1158 (Parent PID:1158)
Killed: No

I get the message periodically...

BR
Venty

Offline
***
Re: Excessive resource usage....
« Reply #4 on: January 16, 2025, 08:19:56 AM »
Is CentOS 7 installed on your server ? If so then put:
Code: [Select]
exe:/usr/libexec/mariadbd

into /etc/csf/csf.pignore and restart csf:

Code: [Select]
csf -r

Offline
***
Re: Excessive resource usage....
« Reply #5 on: January 16, 2025, 08:36:01 AM »
Is CentOS 7 installed on your server ? If so then put:
Code: [Select]
exe:/usr/libexec/mariadbd

into /etc/csf/csf.pignore and restart csf:

Code: [Select]
csf -r

Hi,

Alma linux 9?

BR
Venty

Offline
***
Re: Excessive resource usage....
« Reply #6 on: January 16, 2025, 09:18:36 AM »
I use CWP with AlmaLinux 8 on production servers only. AlmaLinux 9 with CWP is used for testing purposes only.

Anyway, make the changes as described in the previous post and see if you get new alerts.