« VMSTAT part 2 | Main | Plesk 8.1.1 Upgrade »

VMSTAT part 3

I just re-ran my CPU monitoring for a typical weekday. Not much different from last time. But I thought I'd include how I'm generating these charts.

I start off by exporting a day's worth of data.

SELECT * 
FROM `vm_stat` 
WHERE date( dt ) = '2007-03-27' 

Then I export that in phpMyAdmin to a CSV for MS Excel file taking care to include the field names in the first row.

Next I start OpenOffice Calc and load the data. I select the date/time cells and Format them adding a HH custom format to just display the hour.

I then select just the Date and CPU_ID columns by clicking on their column headers. Then I Insert Chart. I select First Row and First Column as labels, then select a Line chart. I then set the chart title and create the chart. The result is something like:

vmstat27.png

But I usually have to resize the chart until the X axis scale shows a full set of hours of the day.

I then do a Copy and Paste into the OpenOffice Draw application, being careful to select the whole chart and not some portion of it. From Draw you Export the file. It may help to resize the image in Draw, usually about one half page width results in an image 400 pixels wide. Your results will probably vary, try it and resize in Draw if needed and export again.

I noticed there were two CPU spikes. The 1am spike is from the Plesk backups of the various domains on our server. The 4am spike is the Apache web logs being rotated. Overall the server remains lightly loaded.


© 2016 Mike Silversides

About

This page contains a single entry from the blog posted on March 29, 2007 8:24 AM.

The previous post in this blog was VMSTAT part 2.

The next post in this blog is Plesk 8.1.1 Upgrade.

Many more can be found on the main index page or by looking through the archives.