Reputation: 3165
I have designed a django app that will plot 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.
Upvotes: 1
Views: 2021
Reputation: 562651
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:
Upvotes: 1