Graph Query Language

jfarese · Joined: 06 Dec 2006 Posts: 22

It would be amazing if there was a way to query on demand the vast information inside of cacti. For instance if you wanted to do some trend analysis or find problems in real time it would be amazing to write a query to look for any traffic graph over X percent utilized. I know there are report plugins available but the ability to query in real time and correlate data would be outstanding. Many of have extended Cacti beyond interface graphs and would love to be able to use Cacti for planning, anomaly detection, trending etc. Unfortunately ferreting this information out of Cacti is very difficult.

Thank you
Jeff

gandalf · Posted: Fri Nov 14, 2008 1:16 pm Post subject:

This is mainly due to the architectural decision on rrdtool as a storage for performance data. So you will have to query all those rrd files to get "an overview". THOLD comes close to what you are searching, I suppose
Reinhard

Howie · Posted: Fri Nov 14, 2008 2:48 pm Post subject:

You might find the Transporter plugin to be a useful starting point: http://forums.cacti.net/viewtopic.php?t=28428

This can allow you to keep a 'copy' of the last n results for each data source, allowing something else to just hit the database to find those results.