[cpuwatchcheck] Cpu/Server Overload

[Divvy]

Lock Down, thank you for your reply mate! Very good information!

Can someone help me read my server stats?

WHM Service Status:
http://screensnapr.com/e/xcw0GJ.jpg

ssh top command:
http://screensnapr.com/e/fjajSL.jpg

ssh top -c command:
http://screensnapr.com/e/JrVFLi.jpg

Thank you!

[XSLTel]

I think that gzip is causing high CPU load.

I guess there is backup is running in background

[Divvy]

Process Manager:
http://screensnapr.com/e/ncwwtj.jpg

[l0calh0st]

Screenshot of Daily Process Log please.

[Divvy]

XSLTel, thank you for your reply.

Yes, It looks like gzip is using 33.6% of CPU
And MySQL 31.4%

How can I fix this?

[Divvy]

l0calh0st, thank you for your reply!

Here It is:
http://screensnapr.com/e/HF8GoI.jpg
http://screensnapr.com/e/Ws4nb1.jpg

[l0calh0st]

Your MySQL is using way too much resources. Also gzip may be stuck, to optimize MySQL first kill gzip from using the resources one time.

Execute the following in SSH:
pidof gzip
kill -9 PIDHERE

Then try this to optimize your MySQL:
http://www.besthostingforums.com/13-...ysqltuner.html

[Divvy]

Thank you for your reply mate!

I dont know what to do now:
http://screensnapr.com/e/DfxCLC.jpg

Can you give me exactly commands?

[Lock Down]

I think the mysql is high for the same reason gzip is high.

You have have a scheduled backup of your database and it is passing the information directly to gzip.

Never do it that way. First create the mysql backup to a file and then run the gzip to compress it.

That way only one is eating cpu not both.

Do you have auto backups set up in whm or in a cron added by someone on your staff or at your host??

Try using a simple command like
mysqldump -u YourUser -pYourPassword YourDB > YourDB.sql;
then run
gzip -9 YourDB.sql;

By the way you are welcome for the info.

[Divvy]

Lock Down, thank you very much for that good information that you posted.

I don't think that I have any cron to auto backups... this is a dedicated server and only I have access to him. But I pay for someone to config my server... How can I see If I have any cron to auto backup?

Btw, this is my WHM Configure Backup:
http://screensnapr.com/e/krTHUG.jpg

Can you please help me fix this issue?