increase polling frequency to 1 minute (maybe more)

[jacauc]

I have now started with a fresh installation and followed these steps meticilously, but still I get choppy graphs. (see my post http://forums.cacti.net/viewtopic.php?t=15977)

It's as if it's bar graphs (no sloping)
I am using version 1.2 of RRDTOOL
Running Windows
Poller.php runs every 1 minute.
all my RRAs are set up exactly as shown above.

Please help!
Thanks!
jacauc

[omairkhawaja]

Step 4. Change ALL Data Templates to use the new RRA. Go into the Data Templates page, start with the first one and work your way to the end. This is what takes the most time. I am sure there is an easier way to do this, but I don't know what it is.

The following SQL query should change all your data templates to use the new RRA:

Code: Select all

insert into data_template_data_rra(data_template_data_id, rra_id) 
(select distinct data_template_data_id, <rra_id>  from data_template_data_rra where data_template_data_id NOT IN 
   (select data_template_data_id from data_template_data_rra where rra_id = <rra_id>))

Just replace <rra_id> with the ID of the new RRA that you added

[Bruce Moose]

Step 4. Change ALL Data Templates to use the new RRA. Go into the Data Templates page, start with the first one and work your way to the end. This is what takes the most time. I am sure there is an easier way to do this, but I don't know what it is.

The following SQL query should change all your data templates to use the new RRA:

Code: Select all

insert into data_template_data_rra(data_template_data_id, rra_id) 
(select distinct data_template_data_id, <rra_id>  from data_template_data_rra where data_template_data_id NOT IN 
   (select data_template_data_id from data_template_data_rra where rra_id = <rra_id>))

Just replace <rra_id> with the ID of the new RRA that you added

How do I find the ID of the new RRA?
I tried the name

Code: Select all

"Hourly (1 minute Average)"

which didnt work.

Thanks


EDIT: OK, found it .. for anyone else wondering, just go to the Data Sources --> RRA's and when your mouse is over the required item you will see the id in the URL:

....hostname/cacti/rra.php?action=edit&id=5



BTW, well done on the great tips. The setup and also the SQL commands. Works a treat. I'm using CentOS 5.

[fxef79]

eddievenus,

I'd like to clarify one thing about your "WHY" - you mentioned you never use AVG and you always use MAX... does this mean that you actually changed ALL of the "Graph Template Items" for ALL of your Graph Templates to use MAX consolidation function? And further - for ALL of your various data types, not just specifically interface graphs?

(I know it's been a while since you posted this - but I'm just now actually switching graphing to 1 minute)

Oh also - another question. In your "HOW" post you simply said to archive all your graphs and then clear them out. Sorry to be dense, but I have to ask - did you mean to use some specific mechanism to archive and clear these? Or did you just mean to manually grab snapshots of the ones you want to keep and then just delete all graphs in the Graph Management screen?

BTW, I followed your instructions specifically, and used the two SQL queries mentioned later by zeryl and omairkhawaja and everything worked perfectly on an "out of the box" installation of CactiEZ (0.8.6i). thank you!

I have a couple of CactiEZ installs that I've bumped up to 0.8.6j - is there any reason this process shouldn't work there too? And yes, I've tried the formal pollinginterval patch for 0.8.6j and it just didn't seem to work like I expected - I didn't get 1 minute steps in my graphs. Perhaps it really was polling every 1 minute and collecting data - but if it doesn't display it I can't really prove to the "check signers" that it's doing it!

Thank you so much!