Multi CPU Utilization Graph

argon0 · Cacti User Joined: 12 Mar 2004 Posts: 238

Hmm, the XML doesn't seem to be easily Human parsable (I thought it might be).

I've attached a new export of the template, try this one.

joshm · Cacti User Joined: 03 Oct 2005 Posts: 62 Location: STL

Ok this one still prompts for the data input like the other one. But now it defaults to not selecting any of that processors where before it had the first 4 selected.(although they were not the right data sources)

Then I tried to select all the right data sources and it would not save what I had selected. So all the data sources show none.

RRDTool Command:

n:/rrdtool/rrdtool.exe graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title="Multi CPU Utilization on AlphaSQL (SQL3)" \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=0 \
--vertical-label="" \
--slope-mode \
--font TITLE:10:c:/winnt/fonts/timesbd.ttf \
--font AXIS:9:c:/winnt/fonts/arial.ttf \
--font LEGEND:11:c:/winnt/fonts/arial.ttf \
--font UNIT:9:c:/winnt/fonts/arial.ttf \
DEF:a="N\:/cacti/rra/alphasql_sql3_cpu0_744.rrd":cpu0:AVERAGE \
DEF:b="N\:/cacti/rra/alphasql_sql3_cpu1_745.rrd":cpu1:AVERAGE \
DEF:c="N\:/cacti/rra/alphasql_sql3_cpu2_746.rrd":cpu2:AVERAGE \
DEF:d="N\:/cacti/rra/alphasql_sql3_cpu3_747.rrd":cpu3:AVERAGE \
DEF:e="N\:/cacti/rra/alphasql_sql3_cpu_748.rrd":cpu:AVERAGE \
DEF:f="N\:/cacti/rra/alphasql_sql3_cpu_748.rrd":cpu:AVERAGE \
DEF:g="N\:/cacti/rra/alphasql_sql3_cpu_748.rrd":cpu:AVERAGE \
DEF:h="N\:/cacti/rra/alphasql_sql3_cpu_748.rrd":cpu:AVERAGE \
CDEF:cdefa=a,b,+,c,+,d,+,e,+,f,+,g,+,h,+,5,/ \
AREA:cdefa#F9FD5F:"Mean CPU\:" \
GPRINT:cdefa:LAST:"Current\:%8.2lf %%" \
GPRINT:cdefa:MIN:"Min\:%8.2lf %%" \
GPRINT:cdefa:MAX:"Max\:%8.2lf %%\n" \
LINE1:a#0000FF:"CPU0\:" \
GPRINT:a:LAST:" Current\:%8.2lf %%" \
GPRINT:a:MIN:"Min\:%8.2lf %%" \
GPRINT:a:MAX:"Max\:%8.2lf %%\n" \
LINE1:b#00A348:"CPU1\:" \
GPRINT:b:LAST:" Current\:%8.2lf %%" \
GPRINT:b:MIN:"Min\:%8.2lf %%" \
GPRINT:b:MAX:"Max\:%8.2lf %%\n" \
LINE1:c#C4FD3D:"CPU2\:" \
GPRINT:c:AVERAGE:" Current\:%8.2lf %%" \
GPRINT:c:MIN:"Min\:%8.2lf %%" \
GPRINT:c:MAX:"Max\:%8.2lf %%\n" \
LINE1:d#FF0000:"CPU3\:" \
GPRINT:d:AVERAGE:" Current\:%8.2lf %%" \
GPRINT:d:MIN:"Min\:%8.2lf %%" \
GPRINT:d:MAX:"Max\:%8.2lf %%\n" \
LINE1:h#000000:"CPU4\:" \
GPRINT:h:LAST:" Current\:%8.2lf %%" \
GPRINT:h:MIN:"Min\:%8.2lf %%" \
GPRINT:h:MAX:"Max\:%8.2lf %%\n" \
LINE1:h#00BED9:"CPU5\:" \
GPRINT:h:LAST:" Current\:%8.2lf %%" \
GPRINT:h:MIN:"Min\:%8.2lf %%" \
GPRINT:h:MAX:"Max\:%8.2lf %%\n" \
LINE1:h#FF00FF:"CPU6\:" \
GPRINT:h:LAST:" Current\:%8.2lf %%" \
GPRINT:h:MIN:"Min\:%8.2lf %%" \
GPRINT:h:MAX:"Max\:%8.2lf %%\n" \
LINE1:h#AAABA1:"CPU7\:" \
GPRINT:h:LAST:" Current\:%8.2lf %%" \
GPRINT:h:AVERAGE:"Min\:%8.2lf %%" \
GPRINT:h:MAX:"Max\:%8.2lf %%"

RRDTool Says:

ERROR: opening 'N:/cacti/rra/alphasql_sql3_cpu0_744.rrd': No such file or directory

argon0 · Cacti User Joined: 12 Mar 2004 Posts: 238

Arse just noticed an error in the cded, it divides by 5 not 8!

I'm off for a couple of days, so will try and fix it on my return, however if you wait a bit and try selecting the data sources again, it should still work, the other graphs need to create the data sources before this graph cab use them.

joshm · Cacti User Joined: 03 Oct 2005 Posts: 62 Location: STL

argon0 · Cacti User Joined: 12 Mar 2004 Posts: 238

OK, try this version out... Again you will have to have the CPUs graphed already for this graph to work...

Argon0

joshm · Cacti User Joined: 03 Oct 2005 Posts: 62 Location: STL

Still no luck. This is still the only graph out of the 2proc & 4proc that prompts me for that additional index information. I selected the sources just like I did for the 2 & 4 graph but no luck. No graph is even created and all I see is the text blurb.

RRDTool Command:

n:/rrdtool/rrdtool.exe graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title="Multi CPU Utilization on AlphaSQL (SQL3)" \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=0 \
--vertical-label="" \
--slope-mode \
--font TITLE:10:c:/winnt/fonts/timesbd.ttf \
--font AXIS:9:c:/winnt/fonts/arial.ttf \
--font LEGEND:11:c:/winnt/fonts/arial.ttf \
--font UNIT:9:c:/winnt/fonts/arial.ttf \
DEF:a="N\:/cacti/rra/alphasql_sql3_cpu_705.rrd":cpu:AVERAGE \
DEF:b="N\:/cacti/rra/alphasql_sql3_cpu_706.rrd":cpu:AVERAGE \
DEF:c="N\:/cacti/rra/alphasql_sql3_cpu_707.rrd":cpu:AVERAGE \
DEF:d="N\:/cacti/rra/alphasql_sql3_cpu_708.rrd":cpu:AVERAGE \
DEF:e="N\:/cacti/rra/alphasql_sql3_cpu_709.rrd":cpu:AVERAGE \
DEF:f="N\:/cacti/rra/alphasql_sql3_cpu_710.rrd":cpu:AVERAGE \
DEF:g="N\:/cacti/rra/alphasql_sql3_cpu_711.rrd":cpu:AVERAGE \
DEF:h="N\:/cacti/rra/alphasql_sql3_cpu_712.rrd":cpu:AVERAGE \
CDEF:cdefa=a,b,+,c,+,d,+,e,+,f,+,g,+,h,+,8,/ \
AREA:cdefa#F9FD5F:"Mean CPU\:" \
GPRINT:cdefa:LAST:"Current\:%8.2lf %%" \
GPRINT:cdefa:AVERAGE:"Mean\:%8.2lf %%" \
GPRINT:cdefa:MAX:"Max\:%8.2lf %%\n" \
LINE1:a#0000FF:"CPU0\:" \
GPRINT::LAST:" Current\:%8.2lf %%" \
GPRINT:a:AVERAGE:" Mean\:%8.2lf %%" \
GPRINT::MAX:" Max\:%8.2lf %%\n" \
LINE1:b#00A348:"CPU1\:" \
GPRINT::LAST:" Current\:%8.2lf %%" \
GPRINT:b:AVERAGE:" Mean\:%8.2lf %%" \
GPRINT::MAX:" Max\:%8.2lf %%\n" \
LINE1:c#C4FD3D:"CPU2\:" \
GPRINT:c:LAST:" Current\:%8.2lf %%" \
GPRINT:c:AVERAGE:"Mean\:%8.2lf %%" \
GPRINT::MAX:"Max\:%8.2lf %%\n" \
LINE1:d#FF0000:"CPU3\:" \
GPRINT:d:LAST:" Current\:%8.2lf %%" \
GPRINT:d:AVERAGE:"Mean\:%8.2lf %%" \
GPRINT:d:MAX:"Max\:%8.2lf %%\n" \
LINE1:e#000000:"CPU4\:" \
GPRINT:e:LAST:" Current\:%8.2lf %%" \
GPRINT:e:AVERAGE:"Mean\:%8.2lf %%" \
GPRINT:e:MAX:"Max\:%8.2lf %%\n" \
LINE1:f#00BED9:"CPU5\:" \
GPRINT:f:LAST:" Current\:%8.2lf %%" \
GPRINT:f:AVERAGE:"Mean\:%8.2lf %%" \
GPRINT:f:MAX:"Max\:%8.2lf %%\n" \
LINE1:g#FF00FF:"CPU6\:" \
GPRINT:g:LAST:" Current\:%8.2lf %%" \
GPRINT:g:AVERAGE:"Mean\:%8.2lf %%" \
GPRINT:g:MAX:"Max\:%8.2lf %%\n" \
LINE1:h#AAABA1:"CPU7\:" \
GPRINT:h:LAST:" Current\:%8.2lf %%" \
GPRINT:h:AVERAGE:"Mean\:%8.2lf %%" \
GPRINT:h:MAX:"Max\:%8.2lf %%"

RRDTool Says:

ERROR: Could not parse line 'GPRINT::LAST: Current\:%8.2lf %%'

joshm · Cacti User Joined: 03 Oct 2005 Posts: 62 Location: STL

Something I just noticed.. It appears that the 4 proc graph is using 1 data source twice

RRDTool Command:

n:/rrdtool/rrdtool.exe graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title="Multi CPU Utilization on AlphaSQL (SQL3)" \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=0 \
--vertical-label="" \
--slope-mode \
--font TITLE:10:c:/winnt/fonts/timesbd.ttf \
--font AXIS:9:c:/winnt/fonts/arial.ttf \
--font LEGEND:11:c:/winnt/fonts/arial.ttf \
--font UNIT:9:c:/winnt/fonts/arial.ttf \
DEF:a="N\:/cacti/rra/alphasql_sql3_cpu_709.rrd":cpu:AVERAGE \
DEF:b="N\:/cacti/rra/alphasql_sql3_cpu_709.rrd":cpu:AVERAGE \
DEF:c="N\:/cacti/rra/alphasql_sql3_cpu_711.rrd":cpu:AVERAGE \
DEF:d="N\:/cacti/rra/alphasql_sql3_cpu_710.rrd":cpu:AVERAGE \
DEF:e="N\:/cacti/rra/alphasql_sql3_cpu_712.rrd":cpu:AVERAGE \
CDEF:cdefa=a,b,+,c,+,d,+,4,/ \
AREA:cdefa#FAFD9E:"Mean CPU" \
GPRINT:cdefa:LAST:" Current\:%8.2lf %%" \
GPRINT:cdefa:MIN:"Min\:%8.2lf %%" \
GPRINT:cdefa:MAX:"Max\:%8.2lf %%\n" \
LINE1:b#0000FF:"CPU0" \
GPRINT:b:LAST:" Current\:%8.2lf %%" \
GPRINT:b:MIN:"Min\:%8.2lf %%" \
GPRINT:b:MAX:"Max\:%8.2lf %%\n" \
LINE1:c#00A348:"CPU1" \
GPRINT:c:LAST:" Current\:%8.2lf %%" \
GPRINT:c:MIN:"Min\:%8.2lf %%" \
GPRINT:c:MAX:"Max\:%8.2lf %%\n" \
LINE1:d#C4FD3D:"CPU2" \
GPRINT:d:AVERAGE:" Current\:%8.2lf %%" \
GPRINT:d:MIN:"Min\:%8.2lf %%" \
GPRINT:d:MAX:"Max\:%8.2lf %%\n" \
LINE1:e#FF0000:"CPU3" \
GPRINT:e:AVERAGE:" Current\:%8.2lf %%" \
GPRINT:e:MIN:"Min\:%8.2lf %%" \
GPRINT:e:MAX:"Max\:%8.2lf %%"

RRDTool Says:

OK

argon0 · Cacti User Joined: 12 Mar 2004 Posts: 238

This is where you're graph is going wrong initially:

Yours

argon0 · Cacti User Joined: 12 Mar 2004 Posts: 238

THis should be better for 4 cpu, I've given it a different name, in case it breaks your graphs then you can revert to the former template.

THe earlier graph should have given you some dodgy average data...

joshm · Cacti User Joined: 03 Oct 2005 Posts: 62 Location: STL

Well No luck with either graph.... .grrrrrrrrrrrr

The fixed 4 CPU graph doesn't seem to want to attatch to the individual CPU graphs. I click save, and go back into the graph and again nothing but 'none' is selected.

The 8cpu graph appeared OK setting wise but just won't work for me.

Are you exporting these from the latest Cacti Version? Although It doesn't make since that your 2 & 4cpu exports worked fine, but that your 8 & newest 4 are not......

Has anyone else out there tried these graphs?
-Josh

argon0 · Cacti User Joined: 12 Mar 2004 Posts: 238

One more thing to try... Delete the host and start again.. Or do it with another host...

I AM doing the export from .0.8.6h

Argon0

joshm · Cacti User Joined: 03 Oct 2005 Posts: 62 Location: STL

No Luck

I then looked under graph templates and noticed that the data sources links showed nothing checked....

So I copied off the working 4cpu graph and it started working. But it appears to still attempt to divide with 5 instead of 4.

-josh

also the data sources had 2 cpu1 instead of a cpu2. But the other 4cpu graph was setup the same.

argon0 · Cacti User Joined: 12 Mar 2004 Posts: 238

Ah... AND I am running the whole thing on Linux...

argon0 · Cacti User Joined: 12 Mar 2004 Posts: 238

The Average utilisation does not need a data source associated with it, if you DO associate a source it will LOOK as if it is working but will add an extra data source to the graph - thus it will give the wrong result for the average...

That took a bit of fiddling around to work out...

BTW I've now started using the Nagios Plugin to graph windows stuff, I'm testing it out on my desktop PC at the moment. 1st Graph is System Uptime - so I can set a threshold and get a reminder to reboot a PC every x no. of days...

If you are interested I'll post the templates I come up with here, BUT you do need to be running the Linux version of Cacti (I use CactiEZ distro from cactiusers.org). I'm thinking of writing a bit of a walkthrough as it is *slightly* complicated to get it to work (especially if you DON't realise that the check_nt plugin for linux is included with the Nsclient software!).

Argon0

joshm · Cacti User Joined: 03 Oct 2005 Posts: 62 Location: STL

Taking the steps I noticed with the 4cpu graph of not having data source boxes checked I did the same with the 8cpu.. I found some random boxes under a specific item# boxes not checked so I checked those.. At a glance it appears ok now, but the text is looking messing at the bottom of the graph.. Going to try poking at it a bit more.

As of now I run cacti on windows, and where I have the cacti box hosted currently I have no system I could load linux up on. Maybe eventually I may switch things around with a spare PC here to load up cacti on a NIX box but for now that is not possible.

-Josh