SYSTEM DSSTATS STATS: Type:DAILY long run-time

[EBrander]

Friends,

I am investigating some CPU spikes on my Cacti system (all combined, poller, DB, and presenter) an the only thing that looks a little different is multiple entries in the log for SYSTEM DSSTATS STATS: Type:DAILY that seem to have long run-times. Examples from the log filtered just on "daily":

Code: Select all

2019/07/15 13:13:57 - SYSTEM DSSTATS STATS: Type:DAILY, Time:170.1555 RRDUser:0.0000 RRDSystem:0.0000 RRDReal:0.0000
2019/07/15 13:12:58 - SYSTEM DSSTATS STATS: Type:DAILY, Time:170.5024 RRDUser:0.0000 RRDSystem:0.0000 RRDReal:0.0000
2019/07/15 13:11:55 - SYSTEM DSSTATS STATS: Type:DAILY, Time:170.0049 RRDUser:0.0000 RRDSystem:0.0000 RRDReal:0.0000
2019/07/15 12:10:57 - SYSTEM DSSTATS STATS: Type:DAILY, Time:171.0914 RRDUser:0.0000 RRDSystem:0.0000 RRDReal:0.0000
2019/07/15 12:09:57 - SYSTEM DSSTATS STATS: Type:DAILY, Time:170.8440 RRDUser:0.0000 RRDSystem:0.0000 RRDReal:0.0000
2019/07/15 12:08:58 - SYSTEM DSSTATS STATS: Type:DAILY, Time:170.1035 RRDUser:0.0000 RRDSystem:0.0000 RRDReal:0.0000
2019/07/15 11:09:06 - SYSTEM DSSTATS STATS: Type:DAILY, Time:178.7990 RRDUser:0.0000 RRDSystem:0.0000 RRDReal:0.0000
2019/07/15 11:08:08 - SYSTEM DSSTATS STATS: Type:DAILY, Time:180.3145 RRDUser:0.0000 RRDSystem:0.0000 RRDReal:0.0000

For comparison, here are some logs from 13:23 today showing how other things are performing:

Code: Select all

2019/07/15 13:23:06 - SYSTEM THOLD STATS: Time:0.7934 Tholds:135 TotalDevices:26 DownDevices:0 NewDownDevices:0
2019/07/15 13:23:06 - SYSTEM DSSTATS STATS: Type:HOURLY, Time:0.1128 RRDUser:0.0000 RRDSystem:0.0000 RRDReal:0.0000
2019/07/15 13:23:06 - SYSTEM STATS: Time:6.2678 Method:spine Processes:1 Threads:5 Hosts:26 HostsPerProcess:26 DataSources:2720 RRDsProcessed:1419

Questions:

Is this expected behavior and performance?
What does this daily stats entry indicate?
What useful information can I glean from this DSSTATS update?
Can I turn it off if needed? (Edit: found where I can turn it off, but still not sure what the impact will be if I do)

EDIT:
Cacti: 1.2.4
Poller Information
Interval 60
Type SPINE 1.2.3 Copyright 2004-2019 by The Cacti Group (Different version of Cacti and Spine!) (not really true)
Items Action[0]: 5,231
Action[2]: 25
Total: 5,256
Concurrent Processes 1
Max Threads 2
PHP Servers 1
Script Timeout 25
Max OID 10
Last Run Statistics Time:6.3345 Method:spine Processes:1 Threads:5 Hosts:26 HostsPerProcess:26 DataSources:2720 RRDsProcessed:1419


TIA,
Eric

[netniV]

That looks like you have way to many daily ones firing off ... how many pollers do you have?

[EBrander]

Just one spine poller

[Osiris]

Settings -> Data -> Daily Update Frequency

[Osiris]

Are you running boost? It should not be running more frequently than every hour. So, very odd. Are your timezone set properly?

[EBrander]

No boost. I ~think~ the TZ is correct but will checkntomorrow

[EBrander]

Daily update frequency currently set to 1 hour. Going to set it to 2 hours interval and see if that has any impact.

Time zone appears correct in php.ini and on the OS.

[Osiris]

I suspect a small bug the poller.

[Osiris]

You should update the poller_dsstats.php from the 1.2.x branch in Cacti. This will be fixed. Just checked it.

[EBrander]

You should update the poller_dsstats.php from the 1.2.x branch in Cacti. This will be fixed. Just checked it.

I've updated to the new version of that file and will report back the results. Thank you.

[EBrander]

That indeed has solved the multiple log entries, but in reality that was just cosmetic, right? Based on my CPU utilization graphs it really was only running the single time per hour.

If so, then that brings me back to my original series of concerns:

Is this expected behavior and performance?
What does this daily stats entry indicate?
What useful information can I glean from this DSSTATS update?
Can I turn it off if needed? (Edit: found where I can turn it off, but still not sure what the impact will be if I do)

[Osiris]

DSStats was only written for plugins. Turning it off has no impact on 'normal' performance. If you don't know how to use it, then you are not using it. If a plugin does not call for it, there is no reason to have it enabled.

[EBrander]

DSStats was only written for plugins. Turning it off has no impact on 'normal' performance. If you don't know how to use it, then you are not using it. If a plugin does not call for it, there is no reason to have it enabled.

Thanks!