Re: Polling Latency on cacti 0.8.8a

Hello gandalf, the path of my php binary don't have change.
It's the path of my data input method who don't used the variable
<path_cacti> but the full path with one error

Until I lowered the number of php script server in Settings -> Poller ->
Number of PHP Script Servers from 10 to 5 and the problem went away alone.
Now, I have occasionally latencies unexplained for a few minutes and
everything works again properly.

David


2013/4/21 Gandalf <[email protected]>

> 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
> _______________________________________________
> 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