Paid affiliate hosting advertisement

Monitor server/mysql CPU usage

jennifer.chang - October 5, 2009 - 08:13

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.

For looking into CPU / memory

chrisred - October 18, 2009 - 10:38

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

njbhatt - October 31, 2009 - 02:44

Hi

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

 
 

Drupal is a registered trademark of Dries Buytaert.