Cacti 0.8.8f which is the default version for Ubuntu 16.04 uses invalid datetime values ("0000-00-00 00:00:00"). MySQL 5.7 does not support zero-dates, this causes the Cacti poller script to run amok and execute the same SQL queries over and over. In my case this ends up with MySQL consuming about 35% CPU and php (via the poller) about 15% CPU.
This probably goes for clean installs as well (as Cacti has this invalid datetime in a number of the php-files supplied by the Cacti package)
Ubuntu 16.04 LTS
Cacti 0.8.8f which is the default version for Ubuntu 16.04 uses invalid datetime values ("0000-00-00 00:00:00"). MySQL 5.7 does not support zero-dates, this causes the Cacti poller script to run amok and execute the same SQL queries over and over. In my case this ends up with MySQL consuming about 35% CPU and php (via the poller) about 15% CPU.
This probably goes for clean installs as well (as Cacti has this invalid datetime in a number of the php-files supplied by the Cacti package)