Cacti

If it's v2, then keep it that way. Also, don't use cmd.php for production. Use spine.

What database?

You might want to report this on GitHub.

It's configurable to your liking. Do some reading on the topic and you will find just about every TSDB does it. I'll leave it to you to discover the clarity in that design choice.

Cool. One pull request to review before release.

Can you log this to the plugin_monitor issue tracker on GitHub?

With 1.8 Thold (still not released), you can use base lining with the daily peak values. The readme change will be extensive, but know there are 8 baseline deviation methods there. Play with them. Good luck.

Edit the remote pollers and set it's timezones from the main Cacti server. Then, maybe do a full sync to it.

You opened a bug on this right?

Ope, I see that. I e got him on speed dial. Let me buzz him.

Oh wait... Switch to Linux

Use the systemctl service instead.

Well there are a few joins

- poller_item - has the path
- data_local - maps to it on local_data_id

The snmp_index column there is the primary key that then maps to

- host_snmp_cache - where you can query by any column and find a rrdfile.

What version of MariaDB/MySQL are you using. My guess is MySQL 8.x. if so, delete all those lines at the top, and report the details to Cacti GitHub issue list.

Upgrade Cacti and drop all those tables while you do. Make sure boost runs no less than once an hour. Tune it as you go.