How to track which site is using the apache processes and causing load

If you're running apache 2.x with custombuild, then it's already in the file:

/etc/httpd/conf/extra/httpd-info.conf

Change the "Allow from" lines to include your IP (eg: 1.2.3.4), OR remove the line completely to allow from all.

        SetHandler server-status
        Order deny,allow
        Deny from all
        Allow from 1.2.3.4
OR

secret-server-status>
        SetHandler server-status
Change the /server-status to something hard-to guess if you use the 2nd method, since we don't want just anyone viewing this page.

Also change uncomment the #ExtendedStatus by removing the # character:

ExtendedStatus On

---

For apache 1.3, edit your /etc/httpd/conf/httpd.conf and add

ExtendedStatus On
SetHandler server-status
just after the code that says "ServerSignature On".   Save, exit, then restart apache.  You can access the stats page by going to http://1.2.3.4/httpd-status where 1.2.3.4 is your server's IP.