Hi All
Need to log CPU/Memory usage for a db server that is set up as master / slave (with mysql). Am trying to track down a load bottleneck that happens in later afternoon (peak load for our web app). Our reports are generated from the slave and data is entered into the master.
Have turned on mysql's logging to track the individual queries, but am interested in the actual load on the machines. Is the slave idling and the master being hammered etc?
Can someone give me some pointers/links/scripts to aid me in my effort? Would like to use a fixed time interval (say every 5 minutes) to monitor the situation for a week or so before analyzing the log files / data.
TIA
Bastien
I wish my computer would do what I want it to do,
instead of what I tell it to do...
Need to log CPU/Memory usage for a db server that is set up as master / slave (with mysql). Am trying to track down a load bottleneck that happens in later afternoon (peak load for our web app). Our reports are generated from the slave and data is entered into the master.
Have turned on mysql's logging to track the individual queries, but am interested in the actual load on the machines. Is the slave idling and the master being hammered etc?
Can someone give me some pointers/links/scripts to aid me in my effort? Would like to use a fixed time interval (say every 5 minutes) to monitor the situation for a week or so before analyzing the log files / data.
TIA
Bastien
I wish my computer would do what I want it to do,
instead of what I tell it to do...