[withdrawn] Poller Performance Plugin, now at V0.32
Moderators: Developers, Moderators
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
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
Re: Poller Performance Plugin, now at V0.32
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
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
Re: Poller Performance Plugin, now at V0.32
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 '%%%%')"
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 '%%%%')"
Re: Poller Performance Plugin, now at V0.32
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
- Developer
- Posts: 22383
- Joined: Thu Dec 02, 2004 2:46 am
- Location: Muenster, Germany
- Contact:
Re: [withdrawn] Poller Performance Plugin, now at V0.32
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.
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.
Who is online
Users browsing this forum: No registered users and 1 guest