Measure memory usage on Apache/Mysql Servers

I have designed a django app that will plot开发者_如何学Go and export large chunks of data from a mysql/apache setup.

I don't know much about mysql or apache servers. Just enough to get my sites to run on them.

I would like to get a sense of how efficient my site is by determining how much of the apache/mysql resources it eats up with average usage.

The signals stored on the mysql server are between 1-15 MB and I am plotting multiple signals together using numpy and matplotlib. Sometimes the plots hang up on my development server (XAMPP).

Any pointers or suggestions of where to begin?

Thanks.

---

The best, most complete way to monitor resource usage for MySQL and Apache is with a monitoring tool called Cacti, with the optional mysql-cacti-templates. The latter templates include graphs for monitoring MySQL and Apache and other servers.

Here's a 2011 presentation on how to install, configure, and use Cacti and the mysql-cacti-templates:

• Using Cacti To Graph MySQL’s Metrics