Portal Home > Knowledgebase > Server Administration > High Server Load
High Server Load
MySQL Load
==========
In ssh run the following commands
top (check for PID / processes causing high loads)
mysqladmin processlist
(It will show you the databases that are running queries and you can figure out the user with the help of username or database prefix and then take the necessary action)
To kill a process:
kill -9 PID (PID = pid/process number you saw when running top)
Search MySQL processes:
mysqladmin -i2 processlist status
Perl Processes
==============
ps -u nobody
(if anything other than melange, httpd are running check their /proc/PID/environ files, where PID is the process ID)
kill -9 PID
Misc Trace:
ps aux | grep -c httpd
ps aux | grep -c mysql
ps aux | grep -c perl
ps aux | grep -c exim
ps aux | grep -c spamd
ps aux | grep -c cpanel
ps aux | grep -c postgre
ps aux | grep -c bash
Add to Favourites 
Print this Article
877-LOGIC-WEB
