[withdrawn] Poller Performance Plugin, now at V0.32

[gandalf]

Oh damn me, should keep my eyes open when posting ...
Sorry, will have to tackle it later this week
Reinhard

[changsung]

I change the include on pollperf_parse.php and it is working.

Before
include_once("./include/config.php");

Changed to
include(dirname(__FILE__) . "/../../include/global.php");

[noflies]

I'm not 100% sure about this...but it looks like pollperf and tools plugins are using the same realm id [8]

[gandalf]

Will verify both issues tomorrow.
Thanks for the pointers
Reinhard

[gandalf]

I'm not 100% sure about this...but it looks like pollperf and tools plugins are using the same realm id [8]

This is correct. I will have to ask Jimmy for a new Realm Id.
Reinhard

[gandalf]

I change the include on pollperf_parse.php and it is working.

Before
include_once("./include/config.php");

Changed to
include(dirname(__FILE__) . "/../../include/global.php");

Next goal is to introduce 087(a) compatibility. Until that time, your workaround is ok
Reinhard

[ghoz]

Hi.
I'm using pollperf plugin on my system from time to time, as it inflates my cacti.log way too much for my taste.

Before I dig deeper into this, I was wondering if we couldn't get performance data directly from the poller_ouput table rather than parsing cacti.log ?

I'd think it would be faster to do that directly rather than parsing an ever growing log file... beside the fact that DEBUG level is... well ... realy verbose ...

On a related note, does anyone know how hard it would be to add this performance information directly at the poller level : it knows for sure the time spent on geting data for a DS, so it could add this info in a new column in poller_output ? what would be the implications ?

Thanks

Ghoz

[gandalf]

You're absolutely correct. It's an awful workaround. Data should be provided by the polling process. Unfortunately, this would have to be implemented both for cmd.php and for spine. So, as many other good ideas, it's waiting for someone to implement it
Reinhard

[rcaston]

I change the include on pollperf_parse.php and it is working.

Before
include_once("./include/config.php");

Changed to
include(dirname(__FILE__) . "/../../include/global.php");

This is the only change needed to get it working with 0.8.7a?

[gandalf]

Not yet verified on my own, but very likely that this is the only one
Reinhard

[dune]

Does this work with 0.8.7b, PA 2.0 and Spine? ... nm, it works great!

[mharald]

Hi Performance Plugin gurus

Plugin doesn't seem to work on 0.8.8a. Is this known, or am I having another problem?

Posted under Plugins:General: http://forums.cacti.net/viewtopic.php?f=14&t=47498

Thx for your help.

Rgds,

Harald

[r0bst3r]

Its not working for me either on 088a, any ideas? I did the modification a page back in this thread.

09/20/2012 01:06:00 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT host.id, host.disabled, host.status, host.hostname, host.description, plugin_pollperf_data.lstart, plugin_pollperf_data.lend, plugin_pollperf_data.ds_count, plugin_pollperf_data.diff, plugin_pollperf_data.rate, plugin_pollperf_data.ds_per_run, plugin_pollperf_data.dur_per_run FROM host LEFT JOIN plugin_pollperf_data ON (host.id = plugin_pollperf_data.id) WHERE (host.hostname LIKE '%%%%' OR host.description LIKE '%%%%') ORDER BY description ASC LIMIT 0,100"
09/20/2012 01:06:00 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1146', SQL:"select COUNT(host.id) FROM host LEFT JOIN plugin_pollperf_data ON (host.id = plugin_pollperf_data.id) WHERE (host.hostname LIKE '%%%%' OR host.description LIKE '%%%%')"
09/20/2012 01:04:34 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT host.id, host.disabled, host.status, host.hostname, host.description, plugin_pollperf_data.lstart, plugin_pollperf_data.lend, plugin_pollperf_data.ds_count, plugin_pollperf_data.diff, plugin_pollperf_data.rate, plugin_pollperf_data.ds_per_run, plugin_pollperf_data.dur_per_run FROM host LEFT JOIN plugin_pollperf_data ON (host.id = plugin_pollperf_data.id) WHERE (host.hostname LIKE '%%%%' OR host.description LIKE '%%%%') ORDER BY description ASC LIMIT 0,100"
09/20/2012 01:04:34 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1146', SQL:"select COUNT(host.id) FROM host LEFT JOIN plugin_pollperf_data ON (host.id = plugin_pollperf_data.id) WHERE (host.hostname LIKE '%%%%' OR host.description LIKE '%%%%')"

[r0bst3r]

Update: It isn't running automatically, but when I run pollperf_parse.php it does populate the statistics properly. I consider this an acceptable workaround for now, but if someone has an idea on how to fix it let me know.

[gandalf]

I do not enourage anybody to use this one any longer.
We will introduce a poller performance counter per host with next upcoming release. I have a patch at hand (for both the php code and spine) that implements a backport of this feature.
Users are encouraged to use spine --verbosity=3 to get performance data per host printed to cacti.log.
R.