Re: Polling Latency on cacti 0.8.8a

In case php path has changed, fix that under "Settings -> Paths".
Run cli/rebuild_poller_cache.php then to update the poller cache.
Reinhard
On 19.04.2013 19:18, David RIBEIRO wrote:
> Hello all,
> 
> I am facing a strange problem, this morning my time polling is mounted
> arrow(see attachement) following
> the correction of the path to a template that does not work (In the data
> input method, the path for a PHP Script Server was wrong).
> When i do a php /usr/share/cacti/poller.php i have a lot of "Waiting on 3
> of 15 pollers."
> In my cacti.log, i see in loop :
> 
> 04/19/2013 07:13:07 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select
> poller_output.output, poller_output.time,
> UNIX_TIMESTAMP(poller_output.time) as unix_time,
> poller_output.local_data_id, poller_item.rrd_path, poller_item.rrd_name,
> poller_item.rrd_num from (poller_output,poller_item) where
> (poller_output.local_data_id=poller_item.local_data_id and
> poller_output.rrd_name=poller_item.rrd_name) LIMIT 10000"   04/19/2013
> 07:13:07 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "SELECT count(*) FROM
> poller_time WHERE poller_id=0 AND end_time>'0000-00-00 00:00:00'"
> 04/19/2013 07:13:07 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select
> poller_output.output, poller_output.time,
> UNIX_TIMESTAMP(poller_output.time) as unix_time,
> poller_output.local_data_id, poller_item.rrd_path, poller_item.rrd_name,
> poller_item.rrd_num from (poller_output,poller_item) where
> (poller_output.local_data_id=poller_item.local_data_id and
> poller_output.rrd_name=poller_item.rrd_name) LIMIT 10000"   04/19/2013
> 07:13:07 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "SELECT count(*) FROM
> poller_time WHERE poller_id=0 AND end_time>'0000-00-00 00:00:00'"
> 
> My Technical info :
> 
> *Technical Support*   General Information  Date Fri, 19 Apr 2013 19:16:22
> +0200  Cacti Version 0.8.8a  Cacti OS unix  SNMP Version NET-SNMP version:
> 5.4.3  RRDTool Version RRDTool 1.4.x  Hosts 334  Graphs 2206  Data
> Sources Script/Command:
> 127
> SNMP: 1315
> SNMP Query: 628
> Script - Script Server (PHP): 456
> Total: 2526  Poller Information  Interval 300  Type SPINE 0.8.8a Copyright
> 2002-2012 by The Cacti Group  Items Action[0]: 2579
> Action[1]: 123
> Action[2]: 456
> Total: 3158  Concurrent Processes 15  Max Threads 10  PHP Servers 10  Script
> Timeout 5  Max OID 10  Last Run Statistics Time:298.0552 Method:spine
> Processes:15 Threads:10 Hosts:333 HostsPerProcess:23 DataSources:3158
> RRDsProcessed:1991  PHP Information  PHP Version 5.3.10-1ubuntu3.6  PHP OS
> Linux  PHP uname Linux cactibb-2 3.2.0-40-generic #64-Ubuntu SMP Mon Mar 25
> 21:22:10 UTC 2013 x86_64  PHP SNMP Installed  max_execution_time 30
> memory_limit 512M
> If you have idea, i really appreciate it.
> Thanks in advance and good weekend !
> 
> David
> 
> 
> 
> ------------------------------------------------------------------------------
> Precog is a next-generation analytics platform capable of advanced
> analytics on semi-structured data. The platform includes APIs for building
> apps and a phenomenal toolset for data science. Developers can use
> our toolset for easy data analysis & visualization. Get a free account!
> http://www2.precog.com/precogplatform/slashdotnewsletter
> 
> 
> 
> _______________________________________________
> cacti-user mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/cacti-user
> 

------------------------------------------------------------------------------
Precog is a next-generation analytics platform capable of advanced
analytics on semi-structured data. The platform includes APIs for building
apps and a phenomenal toolset for data science. Developers can use
our toolset for easy data analysis & visualization. Get a free account!
http://www2.precog.com/precogplatform/slashdotnewsletter