Cacti (home)ForumsRepositoryDocumentation
Cacti: offical forums and support  

 FAQFAQ   SearchSearch   MemberlistMemberlist    RegisterRegister   ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in    


Multiple queries for the same data

 
Post new topic   Reply to topic    Cacti Forum Index -> Help: General
Author Message
sgarcia40



Joined: 10 Nov 2008
Posts: 4

PostPosted: Mon Nov 10, 2008 4:56 am    Post subject: Multiple queries for the same data Reply with quote

Hi,

I've managed to successfully create a cacti environment. Within this environment, I'm predominently using external scripts to query info from remote hosts. Although my scripts are fairly basic, the time it was taking to complete a 5 minute cycle wasn't long enough. I installed spine and was able to speed things up to about 240 seconds. I noticed via the logs that my data input method was being processed multiple times for the multiple graphs on a single host. I'd have thought the poller would intelligently determine if the data needed has already been received.

Let's say I have one DIM returning 7 values. Three data templates are created and use this DIM (i.e. 3 remote hosts). 4 graph templates are created per data template. When the poller runs, I notice that there are 12 queries for the same data. I'd have expected only 3, one for each remote host.

I must have configured the graphs incorrectly but I can't figure out how to create them such that only one query per remote server is necessary.

Any pointers would be appreciated.
Back to top
gandalf
Developer


Joined: 02 Dec 2004
Posts: 12642
Location: Muenster, Germany

PostPosted: Tue Nov 11, 2008 2:54 pm    Post subject: Reply with quote

This is a known drawback. It's on the todo list but yet no clue.

Here's how to workaround (already posted every other month, sigh)

Please create only the first graph "as usual". This will create the only set of rrd files and the only single poller entry required.
For all other graphs related to the same target/script, please create graphs from Graph Management, giving host and graph as input. Then select the already existing rrd file/data sources that shall be used by the graph.

Reinhard
Back to top
sgarcia40



Joined: 10 Nov 2008
Posts: 4

PostPosted: Wed Nov 12, 2008 6:44 pm    Post subject: Reply with quote

Thank you for the reply. Hope I can return the favor at some point...
Back to top
Display posts from previous:   
Post new topic   Reply to topic    Cacti Forum Index -> Help: General All times are GMT - 5 Hours
Page 1 of 1

 



Powered by phpBB © 2001, 2005 phpBB Group