I have a server with ispconfig2 Ubuntu 8.04 and suddenly I get a lot of apache2 processes that uses high processor and for a long time. I also get a lot of mysqlthreds. It is ok for some time and than it starts again. Is there a way to se which hosts the apacehe2 processes is used for? I use this to se hosts but I cant see proces pid with this: apachetop -f /var/log/httpd/ispconfig_access_log And this to see mysql (just installed this and the server is calm right now): mtop --idle
Hard to say why this happens, but I suggest you tune your Apache: http://www.howtoforge.com/configuring_apache_for_maximum_performance Lowering KeepAliveTimeout to 2 - 5 seconds should help a bit. Also, make sure you have a PHP opcode cache installed, e.g. Xcache, APC, or eAccelerator.
