On Tue, May 24, 2005 at 11:35:22AM +0800, Vernon Everett wrote:
In hobbitgraph.cfg, I have the following definition, and it produces
wonderful, but somewhat cluttered graphs.
---snip---
[ora9-sga]
FNPATTERN tablespace.rrd
TITLE TableSpace Utilization
YAXIS % Full
DEF:xdb at RRDIDX@=@RRDFN@:siebprd_XDB:AVERAGE
DEF:whsidx at RRDIDX@=@RRDFN@:siebprd_WHS_INDEX:AVERAGE
DEF:whsdata at RRDIDX@=@RRDFN@:siebprd_WHS_DATA:AVERAGE
DEF:users at RRDIDX@=@RRDFN@:siebprd_USERS:AVERAGE
DEF:undotbs1 at RRDIDX@=@RRDFN@:siebprd_UNDOTBS1:AVERAGE
DEF:tools at RRDIDX@=@RRDFN@:siebprd_TOOLS:AVERAGE
DEF:system at RRDIDX@=@RRDFN@:siebprd_SYSTEM:AVERAGE
DEF:siebind at RRDIDX@=@RRDFN@:siebprd_SIEB_INDEX:AVERAGE
DEF:siebdata at RRDIDX@=@RRDFN@:siebprd_SIEB_DATA:AVERAGE
DEF:loader at RRDIDX@=@RRDFN@:siebprd_LOADER_DATA:AVERAGE
LINE2:xdb at RRDIDX@#@COLOR@:XDB
LINE2:whsidx at RRDIDX@#@COLOR@:WHS_INDEX
LINE2:whsdata at RRDIDX@#@COLOR@:WHS_DATA
LINE2:users at RRDIDX@#@COLOR@:USERS
LINE2:undotbs1 at RRDIDX@#@COLOR@:UNDO
LINE2:tools at RRDIDX@#@COLOR@:TOOLS
LINE2:system at RRDIDX@#@COLOR@:SYSTEM
LINE2:siebind at RRDIDX@#@COLOR@:SIEB_INDEX
LINE2:siebdata at RRDIDX@#@COLOR@:SIEB_DATA
LINE2:loader at RRDIDX@#@COLOR@:LOADER
-u 100
-l 0
---snip---
Minor nit: Since you only have one input file, the "@RRDIDX@" in all of
the DEF and LINE definitions is ignored.
How do I get it to split this across 2 or even 3 graphs, like the disk
utilisation graphs.
You'll need to split them into multiple graph definitions. E.g. define
two graphs:
[ora9-sga]
FNPATTERN tablespace.rrd
TITLE TableSpace Utilization
YAXIS % Full
DEF:xdb=@RRDFN@:siebprd_XDB:AVERAGE
DEF:whsidx=@RRDFN@:siebprd_WHS_INDEX:AVERAGE
DEF:whsdata=@RRDFN@:siebprd_WHS_DATA:AVERAGE
DEF:users=@RRDFN@:siebprd_USERS:AVERAGE
DEF:undotbs1=@RRDFN@:siebprd_UNDOTBS1:AVERAGE
LINE2:xdb#@COLOR@:XDB
LINE2:whsidx#@COLOR@:WHS_INDEX
LINE2:whsdata#@COLOR@:WHS_DATA
LINE2:users#@COLOR@:USERS
LINE2:undotbs1#@COLOR@:UNDO
-u 100
-l 0
[ora9-sga1]
FNPATTERN tablespace.rrd
TITLE TableSpace Utilization
YAXIS % Full
DEF:tools=@RRDFN@:siebprd_TOOLS:AVERAGE
DEF:system=@RRDFN@:siebprd_SYSTEM:AVERAGE
DEF:siebind=@RRDFN@:siebprd_SIEB_INDEX:AVERAGE
DEF:siebdata=@RRDFN@:siebprd_SIEB_DATA:AVERAGE
DEF:loader=@RRDFN@:siebprd_LOADER_DATA:AVERAGE
LINE2:tools#@COLOR@:TOOLS
LINE2:system#@COLOR@:SYSTEM
LINE2:siebind#@COLOR@:SIEB_INDEX
LINE2:siebdata#@COLOR@:SIEB_DATA
LINE2:loader#@COLOR@:LOADER
-u 100
-l 0
Then to have them both displayed on the "ora9-sga" column, add a LARRD
tag to the host, like this:
1.2.3.4 db1.foo.com # LARRD:*,ora9-sga:ora9-sga|ora9-sga1
Henrik