How to find which site is using CPU on multisite install

Events happening in the community are now at Drupal community events on www.drupal.org.
darrenlambert's picture
Posted by darrenlambert on May 24, 2012 at 11:36am

Hi Guys

I have a VPS from which I am running several sites using a single Drupal 6 multisite install.
I have 2 sites which get quite a lot of traffic, so those sites use the Boost module to server static pages.
The low traffic sites use Drupal's page cache.

As I'm using Plesk I created a dummy domain, drupal6, and installed the codebase there.
I then create a new domain for each website, setting the DocumentRoot to point to the common code base (drupal6) in the sites vhost.conf file.

I sometimes get heavy CPU usage. Using the shell top command shows me that it is the drupal6 user, but that could be any of the sites using the multisite install.

Any ideas how I can find out which site is using the CPU?

Thanks

Darren

Comments

what I do is to use multitail

Posted by hedac on May 24, 2012 at 12:51pm
hedac's picture

what I do is to use multitail to watch the logs in real time.. it can monitor various logs in different windows at the same time from the terminal screen. So if there is a site that is having a lot of requests I immediatelly see that screen log moving fast... Of course this is not a real solution, but it's enough sometimes.. A better logging and monitoring solution must be used for very high traffic sites...
I've heard of http://newrelic.com/

You could also try

Posted by pdrake on May 25, 2012 at 7:12pm
pdrake's picture

You could also try http://www.tracelytics.com. Both newrelic and tracelytics offer free trials which should be enough to locate your problem site.