Better performance!

thomasN · Joined: 16 Nov 2004 Posts: 21

When you open the graph tree I can see that there is one select for every device added. We have approx 200 so this takes a while. And this doesn't seem to happen simultaneously but one at a time.

And when you have reached a host and click 'Interface - Traffic' to display all traffic graphs for one host I can see that the same number of selects are done once again.

Couldn't this be read and cached in some way? Sure takes a lot of time to browse around looking at graphs if you don't have only 5 devices.

rony · Posted: Fri Nov 19, 2004 10:02 am Post subject:

This is the way the tree works. We are re-evaluating how it works, possible options are using frames, or sub trees, etc.

TheWitness · Posted: Fri Nov 19, 2004 11:23 pm Post subject:

Tony,

I posted a fix to both MAIN (0.8.7) and BRANCH_0_8_6 CVS' tonight. It uses a session variable to hold the query results that speeds things up a bit. It times out based upon the page refresh setting in "Graph Settings". This will make it poll the MySQL server less, but it is still CPU intensive on the server.

I have close to 200 hosts at the office and when you select to "Expand Hosts" it is gruesome.

There is currently a warning message with the code. I will fix that tomorrow.

Larry

rony · Posted: Sat Nov 20, 2004 2:14 pm Post subject:

Not only can that be CPU intensive, but it can be memory intensive. I don't know if that is a good idea.

We will figure it out. Send me an email about it.

thomasN · Joined: 16 Nov 2004 Posts: 21

rony · Posted: Sat Nov 20, 2004 5:25 pm Post subject:

Me....

Lol, I should sign my real name?

TheWitness · Posted: Sat Nov 20, 2004 6:33 pm Post subject:

Tony,

The whole thing is way ugly. I have a few ideas. Will be working late tonight.

Larry

thomasN · Joined: 16 Nov 2004 Posts: 21

Just an idea... is it possible to use links/wget/whatever in some way perhaps top make a static copy of the entire graph view of cacti?

So you could point your users to that instead of the live one. That would speed thinks up. Maybe not zoom but just for viewing the graphs in it's simplest form.

TheWitness · Posted: Wed Dec 08, 2004 6:52 am Post subject:

Thomas, this may not be a feature request. Look at "Settings->Graph Export". I didn't write it, but I "think" it accomplishes what you want.

Larry

drub · Posted: Thu Dec 09, 2004 1:28 pm Post subject:

I think the Host: feature under graph tree would work best if when you submit the query to enter that as a new graph tree item it populates the graph_tree_items as it would appear in the tree view,

Basically when you use the Host: feature now everytime you load the graph_view?action=tree it has to query mysql for every item that belongs to the host rather than just read the contents of graph_tree_items, it would be great if it built these host: trees in that table.

thomasN · Joined: 16 Nov 2004 Posts: 21

Hi

Has there been any progress on this matter? With our 6929 graphs / 149 devices it takes +60 seconds for every click in the graph menu (when selecting something).

And that's on a pretty fast machine...