High Load Problem

[mnmhm2004]

Hi
i recently have a huge problem with high load
my normal load is < 1
but some times the load goes to 60 or 80

the ifd report is attached

What is the problem ?
is this ddos attack or huge mail sending ?

all reply appreciated

thanks in advance

 

[madaboutlinux]

Looking at the output you have forwarded, it is very clear that a database is been accessed which is using high resources and causing heavy load on your server. In order to figure out the database, execute the command when the server load is high:

watch mysqladmin proc

and you will see conntections to your databases (whether they are quering your database or updating). With 'watch' the output will be refreshed every couple of seconds.

And to make sure any specific IP or range of IPs are causing problems, use the command: netstat -alntp. You will be presented with all the connections to your server with the list of remote IPs and their port numbers as well as the server port they are connected to. If you think any specific IP or a range of IP causing problem, you can block using iptables or CSF firewall (if installed).

There are also different ways to sort such issues but it is very difficult to explain everything here in the forums.

 

[mnmhm2004]

Thanks Shekhar for your reply
i will do as you say and follow the results

thanks again

 

[mnmhm2004]

Hi
i optimized mysql
and every thing is fine now
thanks Shekhar

 

[Factorhost]

Hi, how have you optimised it exactly?
My load is ok but my server becomes unresponsive every couple of weeks, telltale is mysql at the mo.

Cheers

 

[mhkstr]

Hi
i optimized mysql
and every thing is fine now
thanks Shekhar

how you optmized mysql?

 

[mnmhm2004]

how you optmized mysql?

hi

i used MySQL Performance Tuning Primer Script

you can download it from here :

http://www.cpanelconfig.com/optimize-a-cpanel-server/install-mysql-performance-tuning-primer-script/