Poller Cache Items huge

ottobin · Post by **ottobin** » Wed Oct 28, 2020 11:44 am

Hello, i have 970 items in my poller_item table and it's crashing my server with php processes.
How can i understand the cause of so many query?

SYSTEM STATS: Time:63.9747 Method:spine Processes:2 Threads:12 Hosts:14 HostsPerProcess:7 DataSources:970 RRDsProcessed:401

Thanks you

bmfmancini · Post by **bmfmancini** » Mon Nov 02, 2020 10:05 am

How many graphs per device do you have created?

you can see a list of data sources by going to managment >> data sources

ottobin · Post by **ottobin** » Thu Nov 05, 2020 5:10 am

seanmancini wrote: ↑Mon Nov 02, 2020 10:05 am How many graphs per device do you have created?

you can see a list of data sources by going to managment >> data sources

Sorry for being late.

Now that problem is solved (there was an error with one php script) but now i have many timeout from my db.

I think i have to set something about threads/processes:
SYSTEM STATS: Time:24.7040 Method:spine Processes:2 Threads:20 Hosts:16 HostsPerProcess:8 DataSources:813 RRDsProcessed:695

2x Intel(R) Xeon(R) Platinum 8259CL CPU @ 2.50GHz
Mem: 8GB
Cacti: 1.2.7
RRDtool: 1.4+

Every device has "Number of Collection Threads" set of 1

Cacti

Poller Cache Items huge

Poller Cache Items huge

Re: Poller Cache Items huge

Re: Poller Cache Items huge

Who is online