[SOLVED] Excessive resource usage: mysql (mysqld_safe)

betweenbrain
Junior Member
Posts: 8
Joined: 19 Feb 2014, 01:40
Location: United States
Contact:

[SOLVED] Excessive resource usage: mysql (mysqld_safe)

Post by betweenbrain »

Since a recent package upgrade on a Debian 7 server, I have been receiving an excessive resource usage alert from LFD.
Account: mysql
Resource: Process Time
Exceeded: 1857 > 1800 (seconds)
Executable: /bin/dash
Command Line: /bin/sh /usr/bin/mysqld_safe
PID: 28390 (Parent PID:28390)
Killed: No
I've tried killing the process, hard restarting the server and added

Code: Select all

exe:/usr/bin/mysqld_safe
to /etc/caf/csf.pignore, but the alerts continue.

It appears to be a result of the following package upgrades:

libmysqlclient18 5.6.17-1~dotdeb.1
mysql-client 5.6.17-1~dotdeb.1
mysql-client-5.6 5.6.17-1~dotdeb.1
mysql-client-core-5.6 5.6.17-1~dotdeb.1
mysql-common 5.6.17-1~dotdeb.1
mysql-server 5.6.17-1~dotdeb.1
mysql-server-5.6 5.6.17-1~dotdeb.1
mysql-server-core-5.6 5.6.17-1~dotdeb.1

Has anyone else come across this issue or have any suggestions other than adding mysql to the ignore list?

Best,
Matt
Last edited by betweenbrain on 01 May 2014, 17:51, edited 1 time in total.
Sergio
Junior Member
Posts: 1685
Joined: 12 Dec 2006, 14:56

Re: Excessive resource usage: mysql (mysqld_safe)

Post by Sergio »

in csf.pìgnore add:

user:mysql

instead of the exe that you wrote and restart LFD
betweenbrain
Junior Member
Posts: 8
Joined: 19 Feb 2014, 01:40
Location: United States
Contact:

Re: Excessive resource usage: mysql (mysqld_safe)

Post by betweenbrain »

Thanks. I was actually hoping to avoid that. Is there no way to ignore that one executable?
Sergio
Junior Member
Posts: 1685
Joined: 12 Dec 2006, 14:56

Re: Excessive resource usage: mysql (mysqld_safe)

Post by Sergio »

Then, try this:
cmd:/bin/sh /usr/bin/mysqld_safe
betweenbrain
Junior Member
Posts: 8
Joined: 19 Feb 2014, 01:40
Location: United States
Contact:

Re: Excessive resource usage: mysql (mysqld_safe)

Post by betweenbrain »

My apologies for the delayed response.

Your last suggestion worked great, thanks!
Sergio
Junior Member
Posts: 1685
Joined: 12 Dec 2006, 14:56

Re: [SOLVED] Excessive resource usage: mysql (mysqld_safe)

Post by Sergio »

Glad it worked for you.
koms
Junior Member
Posts: 3
Joined: 09 Jan 2016, 20:25

Re: [SOLVED] Excessive resource usage: mysql (mysqld_safe)

Post by koms »

Still getting alert, although I have the following lines in my csf.pignore

user:mysql
user:mysqld_safe //not sure if it make sense
cmd:/bin/sh /usr/bin/mysqld_safe

------------------------------------------------------
Time: Sat Jan 9 20:46:57 2016 +0100
Account: mysql
Resource: Process Time
Exceeded: 411454 > 1800 (seconds)
Executable: /usr/bin/bash
Command Line: /bin/sh /usr/bin/mysqld_safe
PID: 20551 (Parent PID:20551)
Killed: No
-------------------------------------------------
boristheblade
Junior Member
Posts: 4
Joined: 14 Apr 2016, 15:43

Re: [SOLVED] Excessive resource usage: mysql (mysqld_safe)

Post by boristheblade »

This issue is obviously not solved. I'm having the same issue both for mysql and libstoragemgmt.
The strange thing to me is that this number in red: "Exceeded: 91418 > 1800 (seconds)", keeps increasing. I dont understand what this means.. So stopping the messages from being send doesnt seem to be a proper solution to me.

@Koms: Do you have any updates on this issue? Did you find out what is going on? Thank you!

@Sergio: Do you have an idea of whats going on? I googled alot and I cant seem to find anything on this issue other than disabling the messages..

Thanks so much for your help
lucasdomonte
Junior Member
Posts: 6
Joined: 21 Jun 2017, 15:39

Re: [SOLVED] Excessive resource usage: mysql (mysqld_safe)

Post by lucasdomonte »

boristheblade wrote: 14 Apr 2016, 15:48 This issue is obviously not solved. I'm having the same issue both for mysql and libstoragemgmt.
The strange thing to me is that this number in red: "Exceeded: 91418 > 1800 (seconds)", keeps increasing. I dont understand what this means.. So stopping the messages from being send doesnt seem to be a proper solution to me.

@Koms: Do you have any updates on this issue? Did you find out what is going on? Thank you!

@Sergio: Do you have an idea of whats going on? I googled alot and I cant seem to find anything on this issue other than disabling the messages..

Thanks so much for your help
Did you find a solution to the excessive increase in memory usage?
vps_us
Junior Member
Posts: 4
Joined: 22 May 2018, 14:10

Re: [SOLVED] Excessive resource usage: mysql (mysqld_safe)

Post by vps_us »

Did anyone manage to find the solution of this problem? I am having the same issue. I know how to disable the alerts by adding the user to ignore file, but I want to know why this is happening and how to fix the root cause rather than hiding the alerts? Thanks.
Post Reply