Boost Plugin v1.6 Released

Rossco · Post by **Rossco** » Tue Mar 11, 2008 6:08 am

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

Post by **TheWitness** » Sat Mar 15, 2008 4:53 pm

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

TheWitness

Rossco · Post by **Rossco** » Sat Mar 15, 2008 6:33 pm

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

Post by **TheWitness** » Sat Mar 15, 2008 7:24 pm

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

TheWitness

Rael · Post by **Rael** » Mon Mar 17, 2008 8:58 am

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 · Post by **Rossco** » Mon Mar 17, 2008 9:00 am

Try sticking this below your SQL details:

$plugins[] = 'boost';

Cheers

Rossco

Rael · Post by **Rael** » Mon Mar 17, 2008 9:05 am

Rossco wrote:Try sticking this below your SQL details:

$plugins[] = 'boost';

Cheers

Rossco

I am humbled by how stupid I feel at this very moment.

Thanks!

Rael · Post by **Rael** » Mon Mar 17, 2008 9:09 am

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 · Post by **Rossco** » Mon Mar 17, 2008 9:12 am

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 · Post by **Rael** » Mon Mar 17, 2008 9:31 am

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

Post by **gandalf** » Mon Mar 17, 2008 12:03 pm

Rael wrote: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

10k datasources is not THAT much. We do it without Boost on a dedicated Dual Xeon, 4GB RAM, quite slow local disks, in about 45 sec. without boost (mostly SNMP) for about 23k data sources, 12k RRD files. I hope to reduce by 30% using latest rrdtool
Reinhard

Rael · Post by **Rael** » Mon Mar 17, 2008 12:18 pm

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(8) 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?

Code: Select all

672        /* install the boost error handler */
673        $temp_table_suffix = rand(0,10000000000);
674        set_error_handler("boost_error_handler");

Also how do I fix this error???? It's causing my graphs not to update:

ERROR: illegal attempt to update using time 1205773802 when last update time is 1205773802 (minimum one second step)
ERROR: illegal attempt to update using time 1205773802 when last update time is 1205773802 (minimum one second step)
ERROR: illegal attempt to update using time 1205773802 when last update time is 1205773802 (minimum one second step)
ERROR: illegal attempt to update using time 1205773802 when last update time is 1205773802 (minimum one second step)

I run './plugins/boost/poller_boost.php -f -d' and let it go but it always kicks out these errors?

Post by **TheWitness** » Mon Mar 17, 2008 7:05 pm

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

TheWitness

Rael · Post by **Rael** » Mon Mar 17, 2008 9:00 pm

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

Rael · Post by **Rael** » Tue Mar 18, 2008 7:31 am

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

Cacti

Boost Plugin v1.6 Released

FRDRK - Gaps when viewing boost graphs - me too!

Who is online