Boost Plugin v1.6 Released

[Rossco]

Hi frdrk

I saw your note and had to post - I've come to more or less exactly the same conclusion. I run cacti on windows 2003, 0.8.7a with boost 1.7 and have narrowed down my gaps in graphs to..... every occasion when I actually start to look at graphs! I notice that most of yours have gaps during "normal business hours" e.g. when you would be watching them - mine as as well.

Overnight, its fine, the moment I start to look at things though, the gaps start to appear. I'm about to add the rcaston table fix "$temp_table_suffix = rand(0,10000000000);" in the hope that its related, however it seems like we are describing the same fault. This can happen with both newly created graphs and old ones.

Cheers

Rossco

[TheWitness]

Yea, it's corrected that way in SVN. Maybe a little boost release is warranted.

TheWitness

[Rossco]

Hi Witness

Which is corrected in SVN, the rcaston temp table issue, or the gaps that occur in rrd files when viewing the asociated graphs?

Disabling boost removes the gaps in graphs issue for me.

Many thanks

Rossco

[TheWitness]

If you apply the rcaston change, it fixes both. Pretty sure.

TheWitness

[Rael]

Ok, step 2 of the README for this plugin says:

2) Once you have the SQL in place, you must enable you plugin by adding
the boost plugin into cacti's <path_cacti>/include/config.php file not
unlike other plugins.


???

My config.php doesn't have anything in it for installing plugins. I installed the plugin architecture?

How do I do step 2?

[Rossco]

Try sticking this below your SQL details:

$plugins[] = 'boost';

Cheers

Rossco

[Rael]

[Rael]

Next Question:

Step 3 says to replace the cacti files with the modified files in the base directory of this plugin.

I see no modified directory in this plugin and don't know which files to replace???


eccws587:/proj/netops/cacti/cacti-0.8.6j/hosting/plugins/boost # ls -la
total 128
drwxrwx--x 2 cacti cacti 4096 Mar 5 14:05 .
drwxr-xr-x 6 cacti cacti 4096 Mar 5 14:04 ..
-rw-rw-rw- 1 cacti cacti 15515 Oct 25 04:57 LICENSE
-rw-rw-rw- 1 cacti cacti 8115 Oct 25 04:57 README
-rw-rw-rw- 1 cacti cacti 2845 Oct 25 04:57 boost_rrdupdate.php
-rw-rw-rw- 1 cacti cacti 12545 Oct 25 04:57 boost_server.php
-rw-rw-rw- 1 cacti cacti 619 Oct 25 04:57 boost_sql_memory.sql
-rw-rw-rw- 1 cacti cacti 613 Oct 25 04:57 boost_sql_myisam.sql
-rwx------ 1 cacti cacti 1180 Mar 5 14:05 cacti_rrdsvc
-rw-rw-rw- 1 cacti cacti 10991 Oct 25 04:57 poller_boost.php
-rw-rw-rw- 1 cacti cacti 48864 Oct 25 04:57 setup.php

[Rossco]

Dont take this as gospel, but I'm not too sure you have to do that anymore. I think it might be a hang over from previous versions.


Cheers

Rossco

[Rael]

Ok, so I got boost running and HOLY smokes that makes a difference.

Went from 300+ polling cycles on 10K+ datasources which is only a quarter of my required infrastructure and now I'm at 75 seconds.

IMPRESSIVE

[gandalf]

[Rael]

Hrmm.

Ok, so what is this error and how do I fix it?

03/17/2008 05:15:28 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1050', SQL:"CREATE TEMPORARY TABLE `rcaston` ( `local_data_id` mediumint( unsigned NOT NULL default '0', `rrd_name` varchar(19) NOT NULL default '', `time` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`local_data_id`,`rrd_name`,`time`)) ENGINE=MEMORY'

I edited the setup.php line 672 and added that $temp string and the error is still present?

[TheWitness]

You should be using the SVN version. Sorry, I have had not time to address this in the form of a release.

TheWitness

[Rael]

What is the SVN release? I got boost from the first page of this thread?

[Rael]

Nevermind. I figured out what an SVN release is. Only issue is im firewalled and don't have svn installed....this should be tricky.