Monitor server/mysql CPU usage

Posted by jennifer.chang on October 5, 2009 at 8:13am

I'd like to have some stats about how much server resources my Drupal web site uses.

Is there a shell / linux tool that I could install to gather some data, to monitor how much CPU usage grows over time, as the number of registered users grows?

Can I monitor the mysql / php component usage as well?

thanks.

Comments

For looking into CPU / memory

Posted by chrisred on October 18, 2009 at 10:38am

For looking into CPU / memory usage over time you could look into Nagios or Cacti

You could also use the likes of sar to give you load/processes/queues over time which is useful for pin pointing spikes at certain times.

For monitoring MySQL a simple 'show processlist' can help identify long and problematic queries with mtop giving more specific details.

For overall system usage a simple top will allow you to quickly identify high CPU/mem from apache/php or MySQL. To get this down to specific vhost or script you can use apache mod_status

---------------------------
Managed Drupal hosting from Ixis IT

Hi You can use nagios with

Posted by njbhatt on October 31, 2009 at 2:44am

You can use nagios with customize script for mysql and php. Nagios is open source and you can customized as per your requirements.

Regards,
Niraj Bhatt

Niraj Bhatt